michal95nh Posted January 18, 2017 Share Posted January 18, 2017 Hello, How I can set example ten quantity in stock for all products, using sql. I use UPDATE `ps stock available` SET `quantity`= 10 bad doesn't work. A lot of products has quantity -- Prestshop 1.6.10 Link to comment Share on other sites More sharing options...
joseantgv Posted January 18, 2017 Share Posted January 18, 2017 Hello, How I can set example ten quantity in stock for all products, using sql. I use UPDATE `ps stock available` SET `quantity`= 10 bad doesn't work. A lot of products has quantity -- Prestshop 1.6.10 I think that this should have worked. Now all records in ps_stock_available database has 10 as quantity? You also have a "quantity" attribute in ps_product table, check if it's this field. 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