Any way to delete multiple products at one time?

[gheffron]

Does anyone know a way to do this. I have about 40 products that need to be deleted and I'm hoping to avoid going through and deleting them one by one.

Cheers,
Greg

[michael_s]

Using a mysql front end like phpmyadmin or sqlyog, or the command line from your server you can empty the products table, or you can export the table data to a CSV excel file, open it in excel, delete the products you want gone, then save it, empty the product table and re-import the CSV file to the database...

[gheffron]

Okay, I can use phpMyAdmin, but if I erase products from the middle of the products table, won't that screw up the alignment of my product_attributes table, products_categories table, etc.

[michael_s]

gheffron, no. They are separate. If you have attributes assigned to the products you are deleteing, then you also need to remove the attributes. If you are doing it manually, you will have to remove all data related to the products in question.

[gheffron]

Dang, that's a lot of work in the end. Probably better to take twenty minutes to wade through all the clicks and refreshes in the regular catalog interface. Shame. Seems like someone could write a module for that (anyone? anyone?)

[gheffron]

Hey, I remembered that all the products I wanted to delete were under one manufacturer (which the shop no longer carries). I was able to delete the manufacturer and choose to delete all the related products with one click! Hurray!