new store clear catalog

[coolman]

Hello,

I am setting up a new store and I have been using my old store as a template. I would like to reset/empty the Catalog and product ids.

Thank you for your time!

[jonski]

Exactly my problem. And the customers as well. I just want to clear everything out so I can use it for another site. I'll let you know if I find anything.

[coolman]

I know it is posible becuse I have done it be for using a tutorial, but I lost the bookmark!

[jonski]

I deleted the Categories from Admin, which also deletes the products, then I ran this SQL in phpMyAdmin


DELETE FROM zen_address_book;

DELETE FROM zen_customers;
DELETE FROM zen_customers_basket;
DELETE FROM zen_customers_basket_attributes;
DELETE FROM zen_customers_info;
DELETE FROM zen_customers_wishlist;

DELETE FROM zen_orders;
DELETE FROM zen_orders_products;
DELETE FROM zen_orders_products_attributes;
DELETE FROM zen_orders_products_download;
DELETE FROM zen_orders_status;
DELETE FROM zen_orders_status_history;


It seems to work with no problems.

[coolman]

Does it reset the category ids too?