Products -> Quantities - Deny Orders, where is that in the DB?

[peskywinnets]

Catalog -> Products -> Quantities - Deny Orders ...where is that in the DB?

 

At the moment it seems randomly set across the product portfolia, I don't fancy having to edit one by one ...if I could locate the field in the database I can update using SQL, any ideas (see attachment for a screenscrape of the parameter I'm referring to)...

 

 

[Razi]

This is in ps_stock_available table , column name is out_of_stock. default values are (0,1,2)

0 = Deny orders
1 = Allow orders
2 = Use default behavior

Here is Query if we want to change the id_product=1 and out_of_stock=2

UPDATE `ps_stock_available` SET `out_of_stock` = '2' WHERE `ps_stock_available`.`id_stock_available` = 1;

[Guest]

Or my free module for PS 1.6 > 1.7:

 

[peskywinnets]

Thank you very much - that sorted it (& saved me a whole heap of time)