Jump to content

How to enable Advanced stock Management in PS 1.6.1 via database/SQL Query


Recommended Posts

Hello everyone,

How does one programmatically enable ASM with SQL query?

Our store has 50k+ products and the ASM has stopped functioning.



1. I disabled ASM temporarily in order to delete a product from BO.

2. When ASM was re-enabled later, all products did not update accordingly. (I activated it in BO via Preferences>>Products)

3. ASM is now enabled but not reflecting in database and in Product Settingst, see **********Image1.********************'



4. We run sql query:

SELECT COUNT(`id_product`) FROM `ps_product` WHERE `advanced_stock_management`=0

And output for all products matched 0 which means deactivated.





Question is:

1.How do we mass edit db & BO so that all products are ACTIVATED for ASM? 

2.. Which database tables are related to ASM?




We need the settings to be like this.




Thanks in advance.





Edited by Azi (see edit history)
Link to comment
Share on other sites

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...