Jump to content

Bulk delete of products


macgillivray
 Share

Recommended Posts

  • 4 months later...

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

Link to comment
Share on other sites

...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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...