juanmlg Posted February 22, 2014 Share Posted February 22, 2014 I am trying to disable all out of stock products in a 1.4 prestashop store. I have tried with SQL buy I cant do it. Anyone have a correct SQL query for 1.4.3 to disable all out of stock products? Thanks! Link to comment Share on other sites More sharing options...
NemoPS Posted February 24, 2014 Share Posted February 24, 2014 Are you using combinations? If not, what about UPDATE ps_product SET active = 0 WHERE quantity = 0 ? Link to comment Share on other sites More sharing options...
juanmlg Posted February 28, 2014 Author Share Posted February 28, 2014 Are you using combinations? If not, what about UPDATE ps_product SET active = 0 WHERE quantity = 0 ? Thanks but I am using some combinations I remember that some time ago I found a valid query at this forum, but now I cant find it. Link to comment Share on other sites More sharing options...
NemoPS Posted February 28, 2014 Share Posted February 28, 2014 So you want to disable a product if all the combinations are 0 quantity? 1 Link to comment Share on other sites More sharing options...
juanmlg Posted March 2, 2014 Author Share Posted March 2, 2014 So you want to disable a product if all the combinations are 0 quantity? yeah, all products with all combinations 0, and the products without combinations too. Link to comment Share on other sites More sharing options...
NemoPS Posted March 3, 2014 Share Posted March 3, 2014 I think you need php to elaborate a sql query result; I can't think of anything doable in a single query (but I'm no sql master ). 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