magento weight attribute without decimal points

magento weight attribute without decimal points

October 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
magento weight attribute without decimal points

Removing Decimal Points from Magento Product Weight Attribute

Magento provides a lot of flexibility for managing product attributes, including weight. However, by default, it enforces a precision level that may not always be necessary. If you find that your site admin is frustrated with the extra decimal points required in the attribute value, here’s how to remove them.

Understanding the Current Setup

The weight attribute is defined in the eav_attribute table. You can check its current setup using the following query:

SELECT * FROM eav_attribute WHERE attribute_code = 'weight';

You’ll notice that the precision field is set to 12, which means Magento expects a value with up to 12 digits after the decimal point.

Changing the Precision Level

To remove the decimal points from the admin’s perspective, you need to update this precision level. However, be cautious—this change will affect both the admin and the front-end display of the weight attribute everywhere it is used.

Here’s how to do it:

  1. Open your MySQL database in a client like phpMyAdmin or Navicat.
  2. Locate the eav_attribute table.
  3. Find the row where attribute_code = 'weight'.
  4. Change the precision value from 12 to 0.

Impact on Front-End Display

While this change will remove decimal points from the admin’s input field, it doesn’t automatically update the front-end display. By default, Magento still rounds the weight to two decimals when rendering product details or cart contents.

To ensure a consistent presentation across your entire site:

  1. Open your theme’s catalog_product_view.xml layout file.
  2. Find the container responsible for displaying the weight (it might be under a block like catalog.product.attribute.weight).

Add this code inside that container:

<action method="setNoEscaping">
    <argument name="value" xsi:type="string">1</argument>
</action>
  1. Save and clear your cache.

Database Changes vs. Configuration

Some developers prefer to handle such changes through the Magento configuration rather than directly modifying the database. This approach is more adaptable and doesn’t require direct SQL access.

You can create a new config setting for the weight precision level:

  1. In your module’s etc/config.xml file, add this under <config>:
<config>
    <default>
        <magento_weight_precision>
            <field name="weight">
                <value>0</value>
            </field>
        </magento_weight_precision>
    </default>
</config>
  1. Then, in your module’s controller or helper, you can retrieve this value and use it to set the precision level for new attributes.

Conclusion

Removing decimal points from the Magento weight attribute is a straightforward process that involves updating the database directly or adjusting the configuration settings. Remember, this change affects both admin input AND front-end display sites wide.

Before proceeding, always back up your data and test in a development environment first to ensure no unexpected side effects. If you’re looking for professional assistance in managing Magento customizations like these, feel free to reach out to our team at Laravel Company.

Catalog Database Admin CLI

Our network