how to delete all catagories in one operation?

[minshop.no]

is there a way to delete all categories in one operation, i do not want to click the red x, then confirm on many many categories ;)

please advise ;P

[Get Em Fast]

Log into your cPanel, click on phpMyAdmin. Once there, select the database your ZC installation is in, click on it. That will show you all the tables both on the left and more detailed on the right.

Now, click (on the left side) Categories. That will change your view on the right. Now click on "Browse". You will, then see all your categories listed (and man, what a list you have). Go to the bottom of that page, click on "check/uncheck all". Checkmarks will appear in all of the boxes beside each category listing......click on (on the bottom.....right beside "check/unckeck all") the little red "X". It will then ask you if you really want to delete.....it should look something like this (maybe without the 'zen' prefix):

Do you really want to :     DELETE FROM `zen_categories` WHERE `zen_categories`.`categories_id` = 2 LIMIT 1;
DELETE FROM `zen_categories` WHERE `zen_categories`.`categories_id` = 3 LIMIT 1;
DELETE FROM `zen_categories` WHERE `zen_categories`.`categories_id` = 4 LIMIT 1;

Click on "yes". Done.

You will have to do the same for the table "categories_description", also.

You seem to have no products (done delete all of them?), so you shouldn't have to worry about the products tables.

BE VERY CAREFUL NOT TO DELETE THE WHOLE TABLE, JUST THE CATEGORY ENTRIES!! Don't think ZC will rebuild it.

Hope this helps.

[minshop.no]

thanks alot, i will try this.

yes, i deleted my 12k products through EP, just downloaded the complete liste, and used status 9, uploaded and ran it. worked fine.
Could not find a solution for categories in EP.

Thx again ;)

[minshop.no]

worked like a charm :)

[Get Em Fast]

worked like a charm :)

As I knew it would. Glad I could help.

[timdwyer42]

Hi if I use this method to delete catagories does it also delete all the productrs in the catagories, and the prices and images ect.?

If not does anyone knowe of a method to delete all the products and catagories off of zencart, other than deleting the individual catagories via the admin panel in zencart?

Thanks.

[DrByte]

Deleting a category also deletes the products in that category.