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
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;