macgillivray Posted July 18, 2012 Share Posted July 18, 2012 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 Quote Link to comment Share on other sites More sharing options...
Guest sheik Posted November 29, 2012 Share Posted November 29, 2012 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 Quote Link to comment Share on other sites More sharing options...
Guest sheik Posted November 29, 2012 Share Posted November 29, 2012 ...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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.