coolmagic Posted August 4, 2013 Share Posted August 4, 2013 (edited) Hi All Presta is taking days to delete my products (Just 200 products) if I delete using admin section. Please is there any way to delete products in a quick way. Please as we have 10000 products on store and its very time consuming deleting products using interface. Waiting for easiest way to delete product. Please suggest a SQL to do that. My products ID and Reference are starting with "ETH-" which means, easily to identify Edited August 4, 2013 by coolmagic (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted August 4, 2013 Share Posted August 4, 2013 product id starting with eth- ? how it's possible? ID field is a INT which mean that only numbers are available there... anyway, here is the sql query: solution for prestashop 1.5 DELETE FROM ps_product WHERE reference LIKE 'ETH-%' make sure that you've got backup of the whole database Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now