Zen Cart Logo
Forums / General Questions / new store clear catalog

new store clear catalog

Locked

Views: 925

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
21 Nov 2008, 4:13 PM
#1
coolman avatar

coolman

New Zenner

Join Date:
Jun 2008
Posts:
35
Plugin Contributions:
0

new store clear catalog

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!

21 Nov 2008, 6:36 PM
#2
jonski avatar

jonski

New Zenner

Join Date:
Apr 2005
Location:
UK
Posts:
20
Plugin Contributions:
0

Re: new store clear catalog

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.

21 Nov 2008, 7:42 PM
#3
coolman avatar

coolman

New Zenner

Join Date:
Jun 2008
Posts:
35
Plugin Contributions:
0

Re: new store clear catalog

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

21 Nov 2008, 10:41 PM
#4
jonski avatar

jonski

New Zenner

Join Date:
Apr 2005
Location:
UK
Posts:
20
Plugin Contributions:
0

Re: new store clear catalog

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.

22 Nov 2008, 3:32 AM
#5
coolman avatar

coolman

New Zenner

Join Date:
Jun 2008
Posts:
35
Plugin Contributions:
0

Re: new store clear catalog

Does it reset the category ids too?