Out of stock / Csv import status

[FredoGT]

Hi, 

 

i configured my prestashop to accept order when a product is out of stock.

 

But, since i import my CSV all my products, in the stock tab, are on the option : Do not accept.

 

I add the value into the CSV and tried all the case (0, 1, 2) and this is always the same result.

 

The only method is to change it by hand... but i have 3000 products.

 

This is a bug ? How can i solve him ? 

 

My PS is 1.6.1.4

 

Thanks !

 

Fred

[shokinro]

This seems a bug, I have confirmed the same issue on PrestaShop 1.6.1.4.

It is better to post this forum (bug-reports) to get more attention.

 

https://www.prestashop.com/forums/forum/23-bug-reports/

[V82]

Same problems with 1.6.1.4, no solutions  ?

[musicmaster]

When this applies to all your products you should be able to solve this with a single Mysql command: 

update ps_stock_available SET out_of_stock=2

 

Note: valid values for this field are: 0="Deny orders"; 1="Allow orders"; 2="Default";

[V82]

Thanks you very much.

 

My problem is solved, it's not a bug, it's ok by CSV importation, I was using the wrong field...

 

The good field is : "Action when "out of stock". My mistake.

[zod]

It seems that out_of_stock in product table doesn't apply, there is another out_of_stock in table stock_available that is the one used by Prestashop.

I lost a lot of time to figure out this. Even modifying via Back Office, that is not clear, because the value never changes in product table.

I cleared all and reimported using out_of_stock value 2, and all is fine now.

Edited March 9, 2021 by zod
found the solution (see edit history)