Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    178
    Plugin Contributions
    0

    Default Delete all products and categories after using EasyPopulate incorrectly?

    I'm moving a site from 1.38 to 1.5.1. Doing some trial/error with Easy Populate 4. I think I did the import to the new site wrong and it didn't bring all the category info over correctly. It is missing all the image info for all categories. I'd like to just start over with the import process. Is there an easy way to delete all categories and products? Maybe an install sql patch or query I can run directly in my database?

    Thanks for any/all help!

    Rick

  2. #2
    Join Date
    Sep 2007
    Posts
    178
    Plugin Contributions
    0

    Default Re: Delete all products and categories after using EasyPopulate incorrectly?

    I found what I needed.
    Here it is in case someone else has a need for it.

    Code:
    DELETE FROM zen_customers;
    DELETE FROM zen_customers_info;
    DELETE FROM categories;
    DELETE FROM categories_description;
    DELETE FROM group_pricing;
    DELETE FROM manufacturers;
    DELETE FROM manufacturers_info;
    DELETE FROM products;
    DELETE FROM products_attributes;
    DELETE FROM products_attributes_download;
    DELETE FROM products_description;
    DELETE FROM products_discount_quantity;
    DELETE FROM products_options;
    DELETE FROM products_options_values;
    DELETE FROM products_options_values_to_products_options;
    DELETE FROM products_to_categories;

 

 

Similar Threads

  1. Delete all products but keep categories
    By evil_grrrl666 in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 9 Nov 2011, 01:02 PM
  2. Replies: 1
    Last Post: 18 Aug 2009, 08:26 PM
  3. Delete all Product and Categories
    By selangk in forum Customization from the Admin
    Replies: 3
    Last Post: 27 Mar 2009, 03:24 AM
  4. Delete all products/categories
    By KenBarlow in forum General Questions
    Replies: 1
    Last Post: 4 Sep 2007, 07:22 PM
  5. easypopulate: setting up categories and products in 2 languages
    By plichel in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 28 Nov 2006, 09:47 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