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


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 '15 at 19:15
  • #1054 - Unknown column '1' in 'field list' msg comes out. – hooai12 Apr 20 '15 at 21:51
  • Did you reindex all your tables and flush all cache? – eetzen Apr 21 '15 at 15:37
  • Yes. I did reindex all my tables but I only refresh the cache instead of flush it. – hooai12 Apr 21 '15 at 15:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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