ferreira.wcy Posted September 4, 2015 Share Posted September 4, 2015 (edited) Hello! Two questions. Where can I find the database field that allow me to change the "When out of stock" field for the products? And where can I find the database with the product quantity for every product? I don't know what appened but all the products changed to allow when out of stock, and I can't find the correct location of the field, I've tried almost everywhere. I am using Prestashop 1.6.0.9 Edit:I don't know if it does matter, but I have advanced managment disabled. Thank you guys. Edited September 4, 2015 by ferreira.wcy (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted September 5, 2015 Share Posted September 5, 2015 Quantity should be set in ps_stock_availableAre products set to use the default behavior? If so, there is a setting in the Preferences > products page Link to comment Share on other sites More sharing options...
ferreira.wcy Posted September 7, 2015 Author Share Posted September 7, 2015 Quantity should be set in ps_stock_available Are products set to use the default behavior? If so, there is a setting in the Preferences > products page Thank you, but that doesn't help me. About the "When out of stock" I don't know what happened, but we had a problem that changed every single item to "Allow orders", if I knew where to find that specific field in the database I could run a query and change every item at once. About the quantity, I have seen other users saying that the quantity is in ps_stock, but I don't have that table in my database, it only goes to ps_specific_price. Thank you once again. Link to comment Share on other sites More sharing options...
NemoPS Posted September 7, 2015 Share Posted September 7, 2015 It's odd, ps_stock should be there even if advanced stock management is disabled, as far as I know. Is this prestashop an upgrade or a clean one?As for the allow oos orders for each product should be in ps_product, out_of_stock column. The default setting should be 2 Link to comment Share on other sites More sharing options...
ferreira.wcy Posted September 7, 2015 Author Share Posted September 7, 2015 (edited) Yes Nemo, really odd, the information that I have is that it is a clean install. Thank you very much for your help. Well, I have all my products on the table ps_products with the value 2 in the out_of_stock field, and when I go to the backoffice I still get products with the option "allow orders" in the "When out of stock" option. I don't understand what is the problem Edited September 7, 2015 by ferreira.wcy (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted September 9, 2015 Share Posted September 9, 2015 Odd, it's the only entry for it at a product level. Are you 100% that is the correct database? Link to comment Share on other sites More sharing options...
Recommended Posts