Magento Product Quantity Uses Decimals – How to Manage

inventorymagento-1.7product

I know that there is an option to use decimals for product quantity for every product. But is there an option to change this globally?

I am using Magento CE 1.7.

Many thanks.

Best Answer

In order to change this for the products that are already in your catalog runt this query on your database:

UPDATE `cataloginventory_stock_item` SET `is_qty_decimal` = 1;

And rebuild your stock index.
I know...I know ...'don't edit the DB directly'. Well...I do it often because it solves the problems easily, and (I like to think) I know what I'm doing.

For the new added products just set the field Qty Uses Decimals to Yes.