deleting all products

[Guest on_way_to_fame]

Hi,

I just wanted to know, is there an easy way of deleteing all your products at one go? I do not want to re-install, as i want to leave my categories and other things as they are, but I just want to delete all the products?

Any help would be greatly appreciated.

Thanks

Ash

[Guest estelle]

Use phpMyAdmin and run the following two SQL commands:

TRUNCATE TABLE CubeCart_inventory;

TRUNCATE TABLE CubeCart_cats_idx;

But check the names of your tables first, because if you setup a "table prefix" when you installed cubecart your tables might be named differently, e.g. test1_CubeCart_inventory

This will not delete any of you images.

Estelle.

[Guest on_way_to_fame]

Thanks Estelle,

That was quick

Ash

[Guest estelle]

Yeh... I'm subscribed to the forum so I'm notified by email of all new topics. What an idiot I am :w00t:

[Guest]

B) Your subscribed I remember those days well ha ha ha <<<not no more just sit in here 12 hours a day now watching come to think of it ....DOH! ;)

[Guest sunshine]

How do you subscribe and don't see the button.

[Guest jbdancer]

Waaaay left of the Add Reply Button , you have an other button , click on it and there you can subscribe to parts off the forum :w00t:

[Guest]

To get everything, you'd need to do 4 SQL statements:

TRUNCATE TABLE CubeCart_inventory;

TRUNCATE TABLE CubeCart_inv_lang; 

TRUNCATE TABLE CubeCart_cats_idx; 

TRUNCATE TABLE CubeCart_img_idx;

If you want to clear all your categories as well, there are 2 SQL statements:

TRUNCATE TABLE CubeCart_category; 

TRUNCATE TABLE CubeCart_cats_lang;

Of course if you have a database prefix, you'll need to add that in. :homestar: