how can i change all products's inventory setting to "config settings"

I want all my product to have same setting for Inventory section which is same as config settings. After I made a database backup to my new magento, all of my products didn't have any "check" on the "config settings" in "inventory" section.

I wanted set my setting same as config settings which is for

Manage Stock: Use Config Settings

Enable Qty Increments: Use Config Settings
Qty Increments: Use Config Settings

1 Answer 1


Fastest way to do this is in the backend/PhpMyAdmin via mysql.

Manage Stock

UPDATE `cataloginventory_stock_item` SET `use_config_manage_stock` = '1'

Enable Qty Increments

UPDATE `cataloginventory_stock_item` SET `use_config_enable_qty_inc` = '1'

Qty Increments

UPDATE `cataloginventory_stock_item` SET `use_config_qty_increments` = '1' 
  • Hi, Thank you! but it does not work. it keeps on giving me a error. And on the in product->inventory nothing has been changed.
    – hooai12
    Apr 20, 2015 at 19:15
  • #1054 - Unknown column '1' in 'field list' msg comes out.
    – hooai12
    Apr 20, 2015 at 21:51
  • Did you reindex all your tables and flush all cache?
    – eetzen
    Apr 21, 2015 at 15:37
  • Yes. I did reindex all my tables but I only refresh the cache instead of flush it.
    – hooai12
    Apr 21, 2015 at 15:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.