Jump to content

Enable Advanced Stock Management from MySQL


Recommended Posts



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






Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...