{"id":1246,"date":"2024-03-12T19:20:10","date_gmt":"2024-03-12T13:50:10","guid":{"rendered":"https:\/\/magecurious.com\/blog\/?p=1246"},"modified":"2025-01-11T22:53:14","modified_gmt":"2025-01-11T17:23:14","slug":"how-to-add-discount-tax-column-in-order-grid-in-magento-2","status":"publish","type":"post","link":"https:\/\/magecurious.com\/blog\/how-to-add-discount-tax-column-in-order-grid-in-magento-2\/","title":{"rendered":"How To Add Discount & Tax Column In Order Grid In Magento 2"},"content":{"rendered":"\n

Hello Everyone,<\/p>\n\n\n\n

In this blog, we will learn about how to Add Tax and Discount Columns in Order Grid in Magento 2.<\/p>\n\n\n\n

Order grid is used to display order data like id, purchase date, total, subtotal etc.<\/p>\n\n\n\n

However sometimes we require to display some more information about order, one such information is a discount given to the customer. <\/p>\n\n\n\n

Without wasting your time, let us guide you straight away. Follow the easy step given below to Add Column like Discount and Tax in Sales Order Grid in Magento 2.<\/p>\n\n\n\n

STEPS FOR ADD DISCOUNT AND TAX COLUMN IN ORDER GRID IN MAGENTO 2<\/strong><\/p>\n\n\n\n

Step 1: Create Collection.php file<\/strong><\/p>\n\n\n\n

app\/code\/Vendor\/Extension\/Model\/ResourceModel\/Order\/Grid\/Collection.php<\/strong><\/p>\n\n\n

\n<?php\n\nnamespace Vendor\\Extension\\Model\\ResourceModel\\Order\\Grid;\n\nuse Magento\\Framework\\Data\\Collection\\Db\\FetchStrategyInterface as FetchStrategy;\n\nuse Magento\\Framework\\Data\\Collection\\EntityFactoryInterface as EntityFactory;\n\nuse Magento\\Framework\\Event\\ManagerInterface as EventManager;\n\nuse Magento\\Sales\\Model\\ResourceModel\\Order\\Grid\\Collection as OriginalCollection;\n\nuse Psr\\Log\\LoggerInterface as Logger;\n\n\/**\n\n\u00a0* Order grid extended collection\n\n\u00a0*\/\n\nclass Collection extends OriginalCollection\n\n{\n\n\u00a0\u00a0\u00a0\u00a0protected $helper;\n\n\u00a0\u00a0\u00a0\u00a0public function __construct(\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0EntityFactory $entityFactory,\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Logger $logger,\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0FetchStrategy $fetchStrategy,\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0EventManager $eventManager,\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$mainTable = 'sales_order_grid',\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$resourceModel = \\Magento\\Sales\\Model\\ResourceModel\\Order::class\n\n\u00a0\u00a0\u00a0\u00a0)\n\n\u00a0\u00a0\u00a0\u00a0{\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0parent::__construct($entityFactory, $logger, $fetchStrategy, $eventManager, $mainTable, $resourceModel);\n\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0protected function _renderFiltersBefore()\n\n\u00a0\u00a0\u00a0\u00a0{\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$joinTable = $this->getTable('sales_order');\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$this->getSelect()->joinLeft($joinTable, 'main_table.entity_id = sales_order.entity_id', ['tax_amount', 'discount_amount']);\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0parent::_renderFiltersBefore();\n\n\u00a0\u00a0\u00a0\u00a0}\n\n}\n<\/pre><\/div>\n\n\n
Step 2: Create di.xml file<\/strong><\/p>\n\n\n\n
app\/code\/Vendor\/Extension\/etc\/di.xml<\/strong><\/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\n\u00a0\u00a0\u00a0\u00a0<type name="Magento\\Framework\\View\\Element\\UiComponent\\DataProvider\\CollectionFactory">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<arguments>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<argument name="collections" xsi:type="array">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<item name="sales_order_grid_data_source" xsi:type="string">Vendor\\Extension\\Model\\ResourceModel\\Order\\Grid\\Collection<\/item>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/argument>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/arguments>\n\n\u00a0\u00a0\u00a0\u00a0<\/type>\n\n\u00a0\u00a0\u00a0\u00a0<type name="Vendor\\Extension\\Model\\ResourceModel\\Order\\Grid\\Collection">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<arguments>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<argument name="mainTable" xsi:type="string">sales_order_grid<\/argument>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<argument name="resourceModel" xsi:type="string">Magento\\Sales\\Model\\ResourceModel\\Order<\/argument>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/arguments>\n\n\u00a0\u00a0\u00a0\u00a0<\/type>\n\n<\/config>\n<\/pre><\/div>\n\n\n
Step 3: Create sales_order_grid.xml file<\/strong><\/p>\n\n\n\n
app\/code\/Vendor\/Extension\/view\/adminhtml\/ui_component\/sales_order_grid.xml<\/strong><\/p>\n\n\n
\n<?xml version="1.0" encoding="UTF-8"?>\n\n<listing xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc\/ui_configuration.xsd">\n\n\u00a0\u00a0\u00a0\u00a0<columns name="sales_order_columns">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<column name="tax_amount" class="Magento\\Sales\\Ui\\Component\\Listing\\Column\\PurchasedPrice">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<argument name="data" xsi:type="array">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<item name="config" xsi:type="array">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<item name="filter" xsi:type="string">textRange<\/item>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<item name="label" xsi:type="string" translate="true">Tax<\/item>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/item>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/argument>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/column>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<column name="discount_amount" class="Magento\\Sales\\Ui\\Component\\Listing\\Column\\PurchasedPrice">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<argument name="data" xsi:type="array">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<item name="config" xsi:type="array">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<item name="filter" xsi:type="string">textRange<\/item>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<item name="label" xsi:type="string" translate="true">Discount<\/item>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/item>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/argument>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/column>\n\n\u00a0\u00a0\u00a0\u00a0<\/columns>\n\n<\/listing>\n<\/pre><\/div>\n\n\n
Step 4: Finally run the below commands<\/strong><\/p>\n\n\n
\n$ php bin\/magento cache:clean\n\n$ php bin\/magento cache:flush\n<\/pre><\/div>\n\n\n
Step 5: Output:<\/strong><\/p>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n
<\/div>\n\n\n\n
Final Thoughts:<\/strong><\/h2>\n\n\n\n
So this was the easiest way which we have told you in this blog. This is how you can Add Discount and Tax Column in Sales Order Grid in Magento 2. Hope you liked the blog.<\/p>\n\n\n\n
So quickly go to the comment box and tell me how you like this blog?<\/p>\n\n\n\n
Stay tuned with us on our site to get new updates of Magento.<\/strong><\/p>\n\n\n\n
Thanks for reading and visiting our site.<\/p>\n\n\n
      
          
        How useful was this post?      <\/p>              
        Click on a star to rate it!      <\/p>        
      
                      
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>              <\/ul>    <\/div>    
    <\/p>