Magento – How to change all product inventory options to config settings

configurationinventorymagento-1.8magento-1.9

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

Best Answer

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'
Related Topic