Don’t you just hate it when you realise you need to clear out all your old products and categories froma ZenCart install and start again? Particularly if you have done an import using EasyPopulate and the client(ahem) has given you a spreadsheet of duff data?!
Simply login to phpMyAdmin and run these statements on your database.
WARNING: This will delete ALL your product data!
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;
robjson says
Thanks Laura,
Exactly what I was looking for!
Rob