Inventory is not reducing after a sale

[QNP]

Hi, I am having a problem in prestashop 1.7.3.2

When a customer complete its purchase and the status of order changed to shipped, then reserved items are added to inventory instead of reducing it from total quantity. 

There is no reduction of stock quantity upon any sale.

 

[marksull]

Did you find a solution to this? Hitting the same issue in 1.7.6.3....after upgrading from 1.6

[JerseyG]

Hi I am not sure if this helps you but it looks as if it worked for me. Unfortunately no one replied to assist me in doing a bulk change so I did it line by line for 1.5k products. It looks to have been my solution. This was my request:-

When a new order is placed the stock does not decrease, this is only on some products. When I investigate on the database it looks as if the working stock items have "depends_on_stock" set to zero and the stock that is not moving have "depends_on_stock" set to 1

Any new product created has "depends_on_stock" set to zero and give no problems.

As I said,I have gone into the database and set "depends_on_stock" to zero

 

[ecentury]

For anyone that needs this in the future the query you need to update is the following

(First backup and make duplicate of ps_stock_available table just in case.)

UPDATE ps_stock_available SET depends_on_stock = 0;

You might have to change the 'ps_' to whatever your tables are called if you changed them at install

I think this problem starts if you migrate data from 1.6 to 1.7 and it migrates with this field set to 1, whenever i update a product manually in the backend, it always updates this field to 0

I think the ps_stock_available field relates back to the advanced stock management features of prestashop 1.5 / 1.6?

 

 

Edited March 26, 2021 by ecentury (see edit history)

[Lesielle]

works for me too. Migrated with module from 1.6 to PS8