Sandip Kumbhar Sandip Kumbhar - 10 months ago 83
PHP Question

increase weight precision in magento backend

Hello StackOverflow world,

I have one problem in magento weight attribute.

Magento uses 4 decimal places for weight attribute which I wish to use it up-to 6 decimal places for weight calculation in shipping rates in the back-end only.

Please let me now how to increase the decimal precision for weight in magento CE 1.9.


Answer Source

So the reason that the attribute is 4 decimal places is because the table is set as such. All decimal attributes are stored in the table catalog_category_entity_decimal and if you look at the fields you will see that the value has the type "decimal(12,4)".

What you can do is update this table to use decimal(12,6) but then this will have an effect on all decimal attributes stored in Magento.