Bulk delete of products

[macgillivray]

I have looked and can't find an easy way to delete several products at one time from the products list, rather than going through them individually. Is there a way other than downloading and re-uploading the database - the thought of that scares me a little??

Thanks

Margaret

[Guest sheik]

Can anyone help with this old support request please?

I've just accidentally imported 1000+ products before uploading their images first (doh!) so I need to delete them all and then reimport.

It will take me ages to manually click the "delete" icon next to each one .

What is the fastest way of deleting all product in a particular category? I don't mind using phpMyAdmin, provided you are sure your solution will delete any linked entries in the DB.

Thank you,

/dam

[Guest sheik]

...I should add, I've only imported basic products, there are no options or anything complex, other than each one had an image field.

Given that I know my first new product ID is 20950, I'm thinking of doing:

DELETE FROM CubeCart_inventory WHERE `product_id` >= 20950;

DELETE FROM CubeCart_image_index WHERE `product_id` >= 20950;

DELETE FROM CubeCart_seo_urls WHERE `item_id` >= 20950;

Have I missed any tables?

Cheers,

/dam