Magento – Magento 2 Add Column To Sales Order Grid Issue

gridmagento-2.1sales-orderuicomponent

I am facing layout issue when I added new column in sales order Grid. For some reason filter and options are displaying below grid.

Please Refer Screenshot

My Code How I added the column.

etc/module.xml

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
    <module name="Namespace_Modulename" setup_version="1.0.0"/>
    <sequence>
        <module name="Magento_Sales" />
    </sequence>
</config>

view/adminhtml/ui_component/sales_order_grid.xml

<?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="my_custom_column">
            <argument name="data" xsi:type="array">
                <item name="config" xsi:type="array">
                    <item name="filter" xsi:type="string">text</item>
                    <item name="sorting" xsi:type="string">desc</item>                    
                    <item name="label" xsi:type="string" translate="true">My Custom Column</item>
                </item>
            </argument>
        </column>
    </columns>
</listing>

etc/di.xml

<virtualType name="Magento\Sales\Model\ResourceModel\Order\Grid">
    <arguments>
        <argument name="columns" xsi:type="array">
            <item name="my_custom_column" xsi:type="string">sales_order.my_custom_column</item>
        </argument>
    </arguments>
</virtualType>

My column was added but now I am facing this layout issue.

Best Answer

I also faced same issue. After adding sequence in module.xml

<sequence>
    <module name="Magento_Sales" />
</sequence>

I upgrade the Magento.

php bin/magento setup:upgrade

And issue is resolved.

Related Solutions

Magento – Magento 2.1 Create a filter in the product grid by new attribute

No need to add any custom code. In magento2.x available default setting under the attribute

Go admin side Stores -> Attributes -> Product and open your created attribute

After click Advanced Attribute Properties tab under the Properties tab and set Yes below two fields

Use in Filter Options: Yes (Select "Yes" to add this attribute to the list of filter options in the product grid.)
Add to Column Options: Yes (Select "Yes" to add this attribute to the list of column options in the product grid. )

After saving attribute and check product grid.

Please see the attached screenshot.

Magento 2 – Fix Custom Column Export CSV Issue in Sales Order Grid

join is happening twice in process of exporting, to avoid it, add checking in registry:

use Magento\Framework\Message\ManagerInterface as MessageManager;
use Magento\Framework\Registry;
use Magento\Sales\Model\ResourceModel\Order\Grid\Collection as SalesOrderGridCollection;


    class AddColumnsSalesOrderGridCollection
    {
        private $messageManager;
        private $collection;
        private $registry;

        public function __construct(MessageManager $messageManager,
                                    SalesOrderGridCollection $collection,
                                    Registry $registry
        )
        {

            $this->messageManager = $messageManager;
            $this->collection = $collection;
            $this->registry = $registry;
        }

        public function aroundGetReport(
            \Magento\Framework\View\Element\UiComponent\DataProvider\CollectionFactory $subject,
            \Closure $proceed,
            $requestName
        )
        {
            $result = $proceed($requestName);
            if ($requestName == 'sales_order_grid_data_source') {
                if ($result instanceof $this->collection
                ) {
                    if (is_null($this->registry->registry('shipment_joined'))) {
                        $select = $this->collection->getSelect();
                        $select->join(
                            ["sst" => "sales_shipment_track"],
                            'main_table.entity_id = sst.entity_id',
                            'sst.track_number'
                        )
                            ->distinct();
                        $this->registry->register('shipment_joined', true);
                    }
                }

            }
            return $this->collection;
        }
    }

Related Topic