Skip to main content
🎁 Exclusive Launch Deal: Premium Themes Available FREE — Grab Yours Now!
Back to Blog
General

Include Discount Column in admin sales order grid without adding field in sales_order_grid table

admin 4 min readPublished Aug 11, 2016Updated Jul 16, 2026
Include Discount Column in admin sales order grid without adding field in sales_order_grid table

Hello Friends

Today I am going to explain how you can include discount columns in admin order grid without adding field in sales_order_table

If you are learner and want to learn magento in depth you can join my youtube channel.

                                 

First of all you need to create Module , I hope you know how to create module if you don't know you can

visit my blog Create Module in Magento2

Now create app/code/Mageacademy/Sales/Model/ResourceModel/Order/Grid/Collection.php File

and include below code

 

namespace Mageacademy\Sales\Model\ResourceModel\Order\Grid;

 

use Magento\Framework\Data\Collection\Db\FetchStrategyInterface as FetchStrategy;

use Magento\Framework\Data\Collection\EntityFactoryInterface as EntityFactory;

use Magento\Framework\Event\ManagerInterface as EventManager;

use Magento\Sales\Model\ResourceModel\Order\Grid\Collection as OriginalCollection;

use Psr\Log\LoggerInterface as Logger;

 

/**

* Order grid extended collection

*/

class Collection extends OriginalCollection

{

protected $helper;

 

public function __construct(

EntityFactory $entityFactory,

Logger $logger,

FetchStrategy $fetchStrategy,

EventManager $eventManager,

$mainTable = 'sales_order_grid',

$resourceModel = \Magento\Sales\Model\ResourceModel\Order::class

)

{

parent::__construct($entityFactory, $logger, $fetchStrategy, $eventManager, $mainTable, $resourceModel);

}

 

protected function _renderFiltersBefore()

{

$joinTable = $this->getTable('sales_order');

$this->getSelect()->joinLeft($joinTable, 'main_table.entity_id = sales_order.entity_id', ['tax_amount', 'discount_amount']);

parent::_renderFiltersBefore();

}

}

Now Create app/code/Mageacademy/Sales/etc/di.xml

and add below code

<type name="Magento\Framework\View\Element\UiComponent\DataProvider\CollectionFactory">

<arguments>

<argument name="collections" xsi:type="array">

<item name="sales_order_grid_data_source" xsi:type="string">Mageacademy\Sales\Model\ResourceModel\Order\Grid\Collectionitem>

argument>

arguments>

type>

<type name="Mageacademy\Sales\Model\ResourceModel\Order\Grid\Collection">

<arguments>

<argument name="mainTable" xsi:type="string">sales_order_gridargument>

<argument name="resourceModel" xsi:type="string">Magento\Sales\Model\ResourceModel\Orderargument>

arguments>

type>

 

Now create app/code/Mageacademy/Sales/view/adminhtml/ui_component/sales_order_grid.xml

and add below code

 

xml version="1.0" encoding="UTF-8"?>

<listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:module:Magento_Ui:etc/ui_configuration.xsd">

<columns name="sales_order_columns">

<column name="tax_amount" class="Magento\Sales\Ui\Component\Listing\Column\PurchasedPrice">

<argument name="data" xsi:type="array">

<item name="config" xsi:type="array">

<item name="filter" xsi:type="string">textRangeitem>

<item name="label" xsi:type="string" translate="true">Taxitem>

item>

argument>

column>

<column name="discount_amount" class="Magento\Sales\Ui\Component\Listing\Column\PurchasedPrice">

<argument name="data" xsi:type="array">

<item name="config" xsi:type="array">

<item name="filter" xsi:type="string">textRangeitem>

<item name="label" xsi:type="string" translate="true">Discountitem>

item>

argument>

column>

columns>

listing>       

 

Now run php bin/magento setup:upgrade command to activate your module and check in admin

you willl see discount column as below

Visit our blog for Magento Extension (Schedule Deliver) 

Happy Coding!