{"id":205,"date":"2022-07-26T11:14:42","date_gmt":"2022-07-26T05:44:42","guid":{"rendered":"https:\/\/magecurious.com\/blog\/?p=205"},"modified":"2026-02-28T16:05:59","modified_gmt":"2026-02-28T10:35:59","slug":"magento-2-how-to-add-a-new-column-to-admin-orders-grid-view-page","status":"publish","type":"post","link":"https:\/\/magecurious.com\/blog\/magento-2-how-to-add-a-new-column-to-admin-orders-grid-view-page\/","title":{"rendered":"Magento 2 How to Add a New Column to Admin Orders Grid View Page"},"content":{"rendered":"\n

Hello Guys! \ud83d\udc4b<\/p>\n\n\n\n

In this blog, we are going to learn how we can add new column to admin orders grid view page.<\/p>\n\n\n\n

Step 1: Create a sales_order_grid.xml file as given below path<\/code><\/pre>\n\n\n\n
<\/div>\n\n\n\n
               app\\code\\Vendor\\Extension\\view\\adminhtml\\ui_component\\<\/p>\n\n\n\n
<\/div>\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="coupon_code" class="Vendor\\Extension\\Ui\\Component\\Listing\\Column\\Couponcode">\n            <argument name="data" xsi:type="array">\n                <item name="config" xsi:type="array">\n                    <item name="filter" xsi:type="string">text<\/item>\n                    <item name="label" xsi:type="string" translate="true">Coupon Code<\/item>\n                <\/item>\n            <\/argument>\n        <\/column>\n    <\/columns>\n<\/listing>\n<\/pre><\/div>\n\n\n
Step 2: Create a Couponcode.php file as given below path.<\/code><\/pre>\n\n\n\n
<\/div>\n\n\n\n
     app\\code\\Vendor\\Extension\\Ui\\Component\\Listing\\Column\\<\/p>\n\n\n\n
<\/div>\n\n\n
\n<?php\nnamespace Vendor\\Extension\\Ui\\Component\\Listing\\Column;\n\nuse Magento\\Sales\\Api\\OrderRepositoryInterface;\nuse Magento\\Framework\\View\\Element\\UiComponent\\ContextInterface;\nuse Magento\\Framework\\View\\Element\\UiComponentFactory;\nuse Magento\\Ui\\Component\\Listing\\Columns\\Column;\nuse Magento\\Framework\\Api\\SearchCriteriaBuilder;\n\nclass Couponcode extends Column\n{\n    protected $_orderRepository;\n    protected $_searchCriteria;\n\n    public function __construct(\n        ContextInterface $context,\n        UiComponentFactory $uiComponentFactory,\n        OrderRepositoryInterface $orderRepository,\n        SearchCriteriaBuilder $criteria,\n        array $components = [],\n        array $data = []\n    ) \n    {\n        $this->_orderRepository = $orderRepository;\n        $this->_searchCriteria  = $criteria;\n        parent::__construct($context, $uiComponentFactory, $components, $data);\n    }\n\n    public function prepareDataSource(array $dataSource)\n    {\n        if (isset($dataSource['data']['items'])) {\n            foreach ($dataSource['data']['items'] as & $item) {\n\n                $order  = $this->_orderRepository->get($item["entity_id"]);\n                $coupon_code = $order->getData("coupon_code"); \/\/ replace your order custom column to show data on grid.\n\n                $item[$this->getData('name')] = $coupon_code;\n            }\n        }\n        \n        return $dataSource;\n    }\n\n}\n<\/pre><\/div>\n\n\n
Hope! It will help you<\/p>\n\n\n\n
Thank you \ud83d\ude0a<\/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>