(Solved) Stock not always updating V 1.7

[JerseyG]

Hi, Just a question to anyone who understands the stock system in version 1.7

I have installed a fresh version of Prestashop and imported a 1.6 database.

I have two problems but I think that I have narrowed my main one down. 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. Can anyone tell me if I am correct and that "depends_on_stock" should be zero and if so how can I do a mass change.

Edited August 5, 2020 by JerseyG
Solved (see edit history)

[JerseyG]

Sadly I got no assistance on this one so I changed each line individually within the database. Inventory / Stock now functions correctly. Seeing  others who have had this problem it appears to be after an upgrade from 1.6 to 1.7.