How to update Default: Allow orders

[cktoh]

Hi , 

 

I would like set Default: Allow orders  as selected value for all the products in my online shop. I just enable the stock management in prestashop, and found that half of my products is defaulted to "deny order" and another half is defaulted to Default: Allow orders . 

 

Is there any way to update the table column to solve this issue?

kindly please provide guidance sql guidance update these column.

 

version : PrestaShop™ 1.5.6.0

[bellini13]

in ps_product table, the column name is out_of_stock.  The values can be 0, 1 or 2.

0=deny

1=allow

2=use global default

 

You can use this command to update all products to '2' or '1' or '0'

UPDATE `ps_product` SET `out_of_stock` = '2'

[cktoh]

Hi bellini13,

 

Thanks for you reply, i updated the out_of_stock column already still cannot solve the problem. It still show "Deny Orders"..

Is it because of version?

[bellini13]

if you updated the value to 0, then it would say deny,

if you updated the value to 2, then it will say whatever your default stock setting is.

 

if you want to allow all of your products to be allowed, then change your global setting

[HaCos]

Hello, i have been dealing with this issue for almost a month. Does anyone know if there any functionality somewhere that would trigger a product to switch value for out_of_stock from 2 to 0 ?

[lumedevikeira]

Hello, i have been dealing with this issue for almost a month. Does anyone know if there any functionality somewhere that would trigger a product to switch value for out_of_stock from 2 to 0 ?

 

There are two tables, I spent a lot of time with this issue

 

UPDATE `ps_product`

SET `out_of_stock` = 2;

UPDATE `ps_stock_available`

SET `out_of_stock` = 2;

[Szymik]

There are two tables, I spent a lot of time with this issue

 

UPDATE `ps_product`

SET `out_of_stock` = 2;

UPDATE `ps_stock_available`

SET `out_of_stock` = 2;

Thanks a lot! You saved me a lot of time

[kaferklaus]

Hi,

I set "out of stock"= "2" (on "ps_stock_available" and "ps_product") but, on "ps_stock_avalable", it automatically turns on "0" when a customer makes an order.

 

How to solve it?

Thanks a lot.

[20bekhar]

Hi

As you can see when I add a discount price, the UI to understand the real price is not well.

Is there anyone to help me to change the codes of showing the price like attachment??

please help me