Allow/Disallow ordering products out of stock

[azmaer]

Prestashop: 1.7.6.2

My shop had Allow ordering of out-of-stock products set to YES, but now, i wanted to change it to NO so in:

Preferences -> Products -> Product Stock -> Allow ordering of out-of-stock products ------ i've changed it to 'NO' 

and it was working for about 4 minutes and after that it still have option turned to 'NO' but it doesn't work. I've tried with dev/prod mod and it always revert my changes. Had someone issue like this? I was removing caches, overwrite src and classes directories with new ones, yet still it is wrong.

I also did:

UPDATE `ps_product` SET `out_of_stock` = 1;
UPDATE `ps_stock_available` SET `out_of_stock` = 1;

which also was working.... but after few minutes again, everyone can order products that are out of stock. Any idea why it doesn't keep changes (but it keep in BO)?

 

[PrestaHeroes USA]

check that you do not have duplicate fields names in  configuration table as this can lead to wack results like this.

[azmaer]

it was pre-order module and not working prestashop option which mislead me (deactivate non prestashop modules)