Jump to content
cktoh

How to update Default: Allow orders

Recommended Posts

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.denyorder.png

 

version : PrestaShop™ 1.5.6.0

Share this post


Link to post
Share on other sites

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'

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 ?

Share this post


Link to post
Share on other sites

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;

  • Like 2

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

1.JPG

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More