Delete Multiple Categories

[RibeZoo]

Hi

 

 

Sitting here with a giant flue, trying to make our shop finish to Monday next week.

 

I was going to read in a CSV database, but sat the "Categorie 1" as "Modelnumber" = 670 New Categories! DUH!

 

 

Someone know how I can delete these easylie? I can't with multiple Product manager.

 

 

I don't wanna delete All Categories, that to much work on the other side!

 

 

 

Please help me :)

[TeganRose]

Hi

Sitting here with a giant flue, trying to make our shop finish to Monday next week.

 

I was going to read in a CSV database, but sat the "Categorie 1" as "Modelnumber" = 670 New Categories! DUH!

Someone know how I can delete these easylie? I can't with multiple Product manager.

I don't wanna delete All Categories, that to much work on the other side!

Please help me :)

 

Hi!

 

If I understand you correctly, you want to get rid of all your categories. If this is what you want, then placing the following:

TRUNCATE `categories`;
TRUNCATE `categories_description`;
TRUNCATE `products`;
TRUNCATE `products_attributes`;
TRUNCATE `products_attributes_download`;
TRUNCATE `products_description`;
TRUNCATE `products_notifications`;
TRUNCATE `products_options`;
TRUNCATE `products_options_values`;
TRUNCATE `products_options_values_to_products_options`;
TRUNCATE `products_to_categories`;

into a .sql file, and running it through phpMyAdmin - shold do it for you.

 

TR

[RibeZoo]

Hi!

 

If I understand you correctly, you want to get rid of all your categories. If this is what you want, then placing the following:

TRUNCATE `categories`;
TRUNCATE `categories_description`;
TRUNCATE `products`;
TRUNCATE `products_attributes`;
TRUNCATE `products_attributes_download`;
TRUNCATE `products_description`;
TRUNCATE `products_notifications`;
TRUNCATE `products_options`;
TRUNCATE `products_options_values`;
TRUNCATE `products_options_values_to_products_options`;
TRUNCATE `products_to_categories`;

into a .sql file, and running it through phpMyAdmin - shold do it for you.

 

TR

 

Not all, only some of them!

 

Right now im trying to do it by deleting the categories in my sql database.