I have added sku column on sales order grid using following steps,
Package\Company\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="sku" class="Krish\Customerabandoned\Ui\Component\Listing\Column\Sku">
<argument name="data" xsi:type="array">
<item name="config" xsi:type="array">
<item name="visible" xsi:type="boolean">true</item>
<item name="label" xsi:type="string" translate="true">Sku</item>
</item>
</argument>
</column>
</columns>
</listing>
Package\Company\Ui\Component\Listing\Column\Sku.php
public function prepareDataSource(array $dataSource)
{
if (isset($dataSource['data']['items'])) {
foreach ($dataSource['data']['items'] as & $item) {
$order1 = $this->_orderRepository->get($item["entity_id"]);
$items123 = $order1->getAllItems();
$skuArray = [];
foreach ($items123 as $key => $item1) {
$skuArray[] = $item1->getSku();}
$export_status = implode (", ", $skuArray);
$item[$this->getData('name')] = $export_status;
}
}
return $dataSource;
}
}
The sku field displaying in order grid but not showing when I export file to csv.
Best Answer
To add SKUs Column in order Ui grid. You need to modify below files.
TO add column, add below code in your module
and then Create a plugin file.