{"id":1794,"date":"2021-05-31T10:26:45","date_gmt":"2021-05-31T10:26:45","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/remove-decimal-from-quantity-in-magento-2-admin-product-grid\/"},"modified":"2025-07-16T17:44:44","modified_gmt":"2025-07-16T12:14:44","slug":"remove-decimal-from-quantity-in-magento-2-admin-product-grid","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/remove-decimal-from-quantity-in-magento-2-admin-product-grid\/","title":{"rendered":"How to Remove Decimal From Quantity in Magento 2 Admin Product Grid"},"content":{"rendered":"\n

Magento 2\u00a0CMS offers grids in the admin panel for easy data management. It offers the Products, Customers, Orders, etc. grids to manage the data of products, customers, and orders.<\/p>\n\n\n\n

Today, I\u2019ll talk about the products grid, and particularly the product quantity column in the products grid.<\/p>\n\n\n\n

The Products grid in Magento 2<\/a> displays product information like product ID, thumbnail, name, product type, attribute set, SKU, price, quantity, status, etc.<\/p>\n\n\n\n

Now, in the default Magento 2 CMS, the product quantity is displayed in decimal format up to 4 decimals. For example, it shows 100.0000 quantity for products with 100 quantity.<\/p>\n\n\n\n

The below image shows the default format of how the product quantity is displayed in the admin product grid in Magento 2:<\/p>\n\n\n

\n
\"How<\/figure>\n<\/div>\n\n\n

However, in most cases, the product quantity is always in the whole number. The integer value of the product quantity makes little sense.<\/p>\n\n\n\n

Therefore, you may want to remove this unnecessary format of quantity and simply display it as 100 on the products grid in the admin panel of Magento 2.<\/p>\n\n\n\n

You can remove decimals from quantity in Magento 2 admin product grid<\/strong><\/em> using the below code.<\/p>\n\n\n\n

Programmatic Method to Remove Decimal From Quantity in Magento 2 Admin Product Grid:<\/h2>\n\n\n\n

1. Create product_listing.xml<\/strong> file at app\/code\/Vendor\/Module\/view\/adminhtml\/ui_component<\/strong><\/p>\n\n\n\n

<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<listing xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n         xsi:noNamespaceSchemaLocation=\"urn:magento:module:Magento_Ui:etc\/ui_configuration.xsd\">\n    <columns name=\"product_columns\" class=\"Magento\\Catalog\\Ui\\Component\\Listing\\Columns\">\n        <column name=\"qty\" class=\"Vendor\\Module\\Ui\\Component\\Listing\\Columns\\QtyColumn\">\n            <argument name=\"data\" xsi:type=\"array\">\n                <item name=\"config\" xsi:type=\"array\">\n                    <item name=\"filter\" xsi:type=\"string\">textRange<\/item>\n                    <item name=\"add_field\" xsi:type=\"boolean\">true<\/item>\n                    <item name=\"label\" xsi:type=\"string\" translate=\"true\">Quantity<\/item>\n                    <item name=\"sortOrder\" xsi:type=\"number\">75<\/item>\n                <\/item>\n            <\/argument>\n        <\/column>\n    <\/columns>\n<\/listing><\/pre>\n\n\n\n
2. Create QtyColumn.php<\/strong> file at app\/code\/Vendor\/Module\/Ui\/Component\/Listing\/Columns\/<\/strong><\/strong><\/p>\n\n\n\n
<?php\n\nnamespace Vendor\\Module\\Ui\\Component\\Listing\\Columns;\n\nuse Magento\\Ui\\Component\\Listing\\Columns\\Column;\n\nclass QtyColumn extends Column\n{\n    const NAME = 'column.qty';\n\n    public function prepareDataSource(array $dataSource)\n    {\n        if (isset($dataSource['data']['items'])) {\n            $fieldName = $this->getData('name');\n            foreach ($dataSource['data']['items'] as & $item) {\n                if (isset($item[$fieldName])) {\n                    $item[$fieldName] = (int)$item[$fieldName];\n                }\n            }\n        }\n        return $dataSource;\n    }\n}<\/pre>\n\n\n\n
That\u2019s it.<\/p>\n\n\n\n
Once implemented, the product quantity will be displayed as shown below:<\/p>\n\n\n
\n
\"How<\/figure>\n<\/div>\n\n\n
Use the above code and improve the product grid for a simpler understanding!<\/p>\n\n\n\n
Also, do share the post with Magento Community via social media.<\/p>\n\n\n\n
Thank you.<\/p>\n\n\n\n
Also read:<\/strong><\/p>\n\n\n\n