1.7 [SOLVED] Out of stock behaviour ignored in CSV import

[Aurélien Lecour]

Hello,

My shop is using Prestashop 1.7.6.5

Sorry for the french language on my screenshots, but I'm sure you'll recognize the interface.

I have set the default behaviour for out of stock products as "Allow order for out of stock products"

 

In my CSV file for product import, in the "Available for order (0 = No, 1 = Yes)" column, I have set every products with a "1"

 

But on my product edit page, for every single product, it is neither the default behaviour, nore the behaviour set in the CSV file that is active, but instead, orders for out-of-stock products are not allowed :

 

I have nearly 3000 products in my store and I cannot possibly edit every single one of them manually.

 

Does anyone knows why the standard behaviour is not the default choice, and why the behaviour set in the CSV file is ignored ? Or how to mass edit those settings for all my products.

This has been making me crazy for a while now and I haven't been able to solve it yet.

 

Thanks a lot in advance.

Aurélien

[Aurélien Lecour]

Hello,

I have still not been able to solve this issue and I was really hoping for some assistance with that. Thanks a lot if you can help me in any way.

[Bewitching]

Quick question to clarify:
Are you listing ALL of your products as 0 quantity, but allowing people to order them?

If that's the case, try turning off "Enable stock management", the second "OUI" in you first picture.

 

Let me know if this helps, or if I misunderstood.

 

Kathleen

 

[Aurélien Lecour]

About 40% of my products have a quantity of 0. They are rarely sold items so it doesn't make sense to me to have them in stock but it is important that I still list them and let them available for order.

The stock management feature is important for all the other products.

What I find most puzzling is that the CSV import ignores my instruction to allow order.

[Bewitching]

Maybe try:
In you CSV file, under"Out of stock" enter 2.

I created a product that allowed out of stock ordering and downloaded the CSV, and the number 2 is in that column.

Try importing just one product with the 2 added and see if that fixes it

Edited September 22, 2020 by Bewitching
updated for better answer (see edit history)

[Aurélien Lecour]

Thank you for your suggestion.

I have tried, but it didn't yield any result. The product still has backorder not allowed.

I really wonder what causes the import function to ignore the content of the backorder column.

[Bewitching]

Hello again,

Did you try adding 2 to your csv, or my original suggestion of updating the label?
The label thing was a bust, I tried it. But adding the 2 seemed to work for me.

[Aurélien Lecour]

I have just tried with your suggestion. The import has failed because it was expecting either a 0 or a 1 in that field.

[Bewitching]

No, not there:)

HERE: In you CSV file, under"Out of stock" enter 2.

 

Available for order: 1

Out of stock: 2

Edited September 22, 2020 by Bewitching (see edit history)

[Aurélien Lecour]

Ah ! Yes, it seemed to have worked. The field was called "Action when out of stock" in my backoffice, and it worked when I filled it with "2".

I will now do a full catalog import and let you know if it worked (I don't see why it wouldn't but, black magic sometimes happens with databases).

Thanks a lot for the guidance.

[Bewitching]

1 minute ago, Aurélien Lecour said:

Ah ! Yes, it seemed to have worked. The field was called "Action when out of stock" in my backoffice, and it worked when I filled it with "2".

I will now do a full catalog import and let you know if it worked (I don't see why it wouldn't but, black magic sometimes happens with databases).

Thanks a lot for the guidance.

SO happy I could help you !

A little "white" magck helped LOL

[Aurélien Lecour]

I implemented the solution in the full catalog and it now works just fine. Thanks a lot for the help.

 

[zod]

I was going crazy with this, also the out_of_stock column in product table is useless, it never changes and it is not the correct parameter. In fact, out_of_stock is in the stock_available table!!! DAAAMN!!!

[qq2kk]

On 3/10/2021 at 6:41 AM, zod said:

I was going crazy with this, also the out_of_stock column in product table is useless, it never changes and it is not the correct parameter. In fact, out_of_stock is in the stock_available table!!! DAAAMN!!!

What is the usage of the out_of_stock field in ps_product? It is a confusing.

I thought i was doing something wrong and lucky i see your reply that this field is stored in stock_available instead. Thank you.