Enable Advanced Stock Management from MySQL

[sttaq]

Hi

 

I want to enable "Advanced Stock Management" for all the products in my shop. Ideally, I was trying to find a way to do it from the database.

 

I have looked at the product table and have found this column "advanced_stock_management". I have run a query to uptdate its value to 1 but it does not seem to have any effect on the product. Also, the check box  "I want to specify available quantities manually" remained checked in the back office.

 

I would appreciate if you can direct me to the tables I need to update in order to enable the advanced stock management for all my products.Specifically I want the following fields to be set from the database and if there are any other fields that need to be update:

 

1. I want to use the advanced stock management system for this product.
2. Available quantities for current product and its combinations are based on warehouse stock

 

 

 

Thanks

 

[CSEpe]

UPDATE `ps_product` SET `advanced_stock_management`=0
UPDATE `ps_product_shop` SET `advanced_stock_management`=0

Edited June 22, 2015 by CSEpe (see edit history)