{"id":1178,"date":"2020-08-15T03:30:05","date_gmt":"2020-08-15T03:30:05","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/2020\/08\/15\/include-discount-column-in-admin-order-grid-in-magento-2\/"},"modified":"2025-05-22T12:01:42","modified_gmt":"2025-05-22T06:31:42","slug":"include-discount-column-in-admin-order-grid-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/include-discount-column-in-admin-order-grid-in-magento-2\/","title":{"rendered":"How to Include Discount Column in Admin Order Grid without Adding Field in sales_order_grid table in Magento 2"},"content":{"rendered":"\n

Order grid in Magento 2<\/a> displays the order data. The order grid lists the order data like order ID, purchase date, order amount, customer name who placed the order, grand total, subtotal, payment method, etc.<\/p>\n\n\n\n

The order data in grid format makes it easy for the admin to process every order, manage the delivery, and smoothly fulfil each order.<\/p>\n\n\n\n

The default sales order grid in the backend facilitates the option to show the selected columns among the default options.<\/p>\n\n\n\n

However, owing to modern business requirements, the admin may require to add a custom column in order grid in Magento 2<\/a> for better order processing.<\/p>\n\n\n\n

Faster and smoother order processing gives a delightful shopping experience. It also reduces the admin\u2019s workload.<\/p>\n\n\n\n

One such instance is to add the custom discount column in admin order grid. The admin can easily manage the discounts assigned with each order, analyze the benefits of offering discounts, etc.<\/p>\n\n\n\n

The programmatic method to add discount column in admin order grid without adding field in sales_order_grid table in Magento 2 is easy, as shown below:<\/p>\n\n\n\n

Method to Include Discount Column in Admin Order Grid Without Adding Field in sales_order_grid Table in Magento 2:<\/h2>\n\n\n\n

1. Create,<\/p>\n\n\n\n

app\/code\/Meetanshi\/DiscountColumn\/Model\/ResourceModel\/Order\/Grid\/Collection.php<\/strong><\/em><\/p>\n\n\n\n

<?php\n\nnamespace Meetanshi\\DiscountColumn\\Model\\ResourceModel\\Order\\Grid;\n\nuse Magento\\Framework\\Data\\Collection\\Db\\FetchStrategyInterface as FetchStrategy;\nuse Magento\\Framework\\Data\\Collection\\EntityFactoryInterface as EntityFactory;\nuse Magento\\Framework\\Event\\ManagerInterface as EventManager;\nuse Magento\\Sales\\Model\\ResourceModel\\Order\\Grid\\Collection as OriginalCollection;\nuse Psr\\Log\\LoggerInterface as Logger;\n\n\/**\n * Order grid extended collection\n *\/\nclass Collection extends OriginalCollection\n{\n    protected $helper;\n\n    public function __construct(\n        EntityFactory $entityFactory,\n        Logger $logger,\n        FetchStrategy $fetchStrategy,\n        EventManager $eventManager,\n        $mainTable = 'sales_order_grid',\n        $resourceModel = \\Magento\\Sales\\Model\\ResourceModel\\Order::class\n    )\n    {\n        parent::__construct($entityFactory, $logger, $fetchStrategy, $eventManager, $mainTable, $resourceModel);\n    }\n\n    protected function _renderFiltersBefore()\n    {\n        $joinTable = $this->getTable('sales_order');\n        $this->getSelect()->joinLeft($joinTable, 'main_table.entity_id = sales_order.entity_id', ['tax_amount', 'discount_amount']);\n        parent::_renderFiltersBefore();\n    }\n}<\/pre>\n\n\n\n
2. Create,<\/p>\n\n\n\n
\/app\/code\/Meetanshi\/DiscountColumn\/etc\/di.xml<\/strong><\/em><\/p>\n\n\n\n
<?xml version=\"1.0\"?>\n\n<config xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xsi:noNamespaceSchemaLocation=\"urn:magento:framework:ObjectManager\/etc\/config.xsd\">\n    <type name=\"Magento\\Framework\\View\\Element\\UiComponent\\DataProvider\\CollectionFactory\">\n        <arguments>\n            <argument name=\"collections\" xsi:type=\"array\">\n                <item name=\"sales_order_grid_data_source\" xsi:type=\"string\">Meetanshi\\DiscountColumn\\Model\\ResourceModel\\Order\\Grid\\Collection<\/item>\n            <\/argument>\n        <\/arguments>\n    <\/type>\n    <type name=\"Meetanshi\\DiscountColumn\\Model\\ResourceModel\\Order\\Grid\\Collection\">\n        <arguments>\n            <argument name=\"mainTable\" xsi:type=\"string\">sales_order_grid<\/argument>\n            <argument name=\"resourceModel\" xsi:type=\"string\">Magento\\Sales\\Model\\ResourceModel\\Order<\/argument>\n        <\/arguments>\n    <\/type>\n<\/config><\/pre>\n\n\n\n
3. Create,<\/p>\n\n\n\n
\/app\/code\/Meetanshi\/DiscountColumn\/etc\/module.xml<\/strong><\/em><\/p>\n\n\n\n
<?xml version=\"1.0\"?>\n<config xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n        xsi:noNamespaceSchemaLocation=\"urn:magento:framework:Module\/etc\/module.xsd\">\n    <module name=\"Meetanshi_DiscountColumn\" setup_version=\"1.0.0\"\/>\n<\/config><\/pre>\n\n\n\n
4. Create,<\/p>\n\n\n\n
\/app\/code\/Meetanshi\/DiscountColumn\/view\/adminhtml\/ui_component\/sales_order_grid.xml<\/strong><\/em><\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<listing xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xsi:noNamespaceSchemaLocation=\"urn:magento:module:Magento_Ui:etc\/ui_configuration.xsd\">\n    <columns name=\"sales_order_columns\">\n        <column name=\"tax_amount\" class=\"Magento\\Sales\\Ui\\Component\\Listing\\Column\\PurchasedPrice\">\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=\"label\" xsi:type=\"string\" translate=\"true\">Tax<\/item>\n                <\/item>\n            <\/argument>\n        <\/column>\n        <column name=\"discount_amount\" class=\"Magento\\Sales\\Ui\\Component\\Listing\\Column\\PurchasedPrice\">\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=\"label\" xsi:type=\"string\" translate=\"true\">Discount<\/item>\n                <\/item>\n            <\/argument>\n        <\/column>\n    <\/columns>\n<\/listing><\/pre>\n\n\n\n
5. Create,<\/p>\n\n\n\n
app\/code\/Meetanshi\/DiscountColumn\/registration.php\/<\/strong><\/em><\/p>\n\n\n\n
<?php\nuse \\Magento\\Framework\\Component\\ComponentRegistrar;\n\nComponentRegistrar::register(ComponentRegistrar::MODULE, 'Meetanshi_DiscountColumn', __DIR__);<\/pre>\n\n\n\n
You can download the extension from our Github<\/a> or implement the steps as below:<\/p>\n\n\n\n
That\u2019s it.<\/p>\n\n\n\n
Once done, you can see the discount column in order grid:<\/p>\n\n\n
\n
\"Discount<\/figure>\n<\/div>\n\n\n
Also, do share the post with the Magento community via social media.<\/p>\n\n\n\n
Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"
Order grid in Magento 2 displays the order data. The order grid lists the order data like order ID, purchase date, order amount, customer name who placed…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1178","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1178"}],"version-history":[{"count":4,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1178\/revisions"}],"predecessor-version":[{"id":14740,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1178\/revisions\/14740"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}