Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    103
    Plugin Contributions
    0

    Default Delete products based on a CSV file

    Hello

    Is there a module available that can delete products from the site based on the CSV file ( item number)?

    Thanks

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,684
    Plugin Contributions
    123

    Default Re: Delete products based on a CSV file

    I don't believe so. Perhaps you could create one?

    In 1.5.7, look at category_product_listing.php lines 255-259; that's what you need to do for the removal.
    To learn how to process a csv, look at the CSV model update plugin: https://www.zen-cart.com/downloads.php?do=file&id=2213
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,477
    Plugin Contributions
    88

    Default Re: Delete products based on a CSV file

    Actually, the Database I/O Manager (https://www.zen-cart.com/downloads.php?do=file&id=2091) enables you to first export your products to a CSV and then selectively delete them.

    So does EZ Populate, but I can never find the link to its current download. Perhaps @mc12345678 can step in?

  4. #4
    Join Date
    Jul 2012
    Posts
    16,732
    Plugin Contributions
    17

    Default Re: Delete products based on a CSV file

    Quote Originally Posted by lat9 View Post
    Actually, the Database I/O Manager (https://www.zen-cart.com/downloads.php?do=file&id=2091) enables you to first export your products to a CSV and then selectively delete them.

    So does EZ Populate, but I can never find the link to its current download. Perhaps @mc12345678 can step in?
    Although the "recent" plugin's name has been Easypopulate V4, it is locatable by searching the plugins by any of many names: EZ Populate, Easy Populate, Easypopulate, or even just Populate.

    The location from which to download, access GitHub, and read the Forum thread is found at: https://www.zen-cart.com/downloads.php?do=file&id=2069

    Also can export a CSV file via export and update data via upload followed by import.

    Product deletion is through setting the v_status field to 9 for the product to delete. The product is identified through use of a primary key. By default the primary key is the product's model (v_products_model field). Changing a configuration setting offers the use of the product's id (v_products_id field), and through an observer another primary key could be set/created.

    The import file to do deletions should be as simple as having the primary key field and the v_status field for the product to be delete with the v_status field set to 9.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    May 2009
    Posts
    103
    Plugin Contributions
    0

    Default Re: Delete products based on a CSV file

    Thank you all

 

 

Similar Threads

  1. v139h Urgent Help!! Facing Problem in updating products via CSV file?
    By davidmiller in forum General Questions
    Replies: 0
    Last Post: 28 Jun 2012, 12:20 PM
  2. Replies: 1
    Last Post: 3 Mar 2011, 07:34 AM
  3. Export products as CSV file?
    By gabenn2 in forum General Questions
    Replies: 8
    Last Post: 21 Nov 2009, 11:34 PM
  4. Export products to a csv file
    By bebijuteria in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 4 Nov 2007, 11:45 AM
  5. Replies: 1
    Last Post: 11 Sep 2007, 04:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR