In this article, we will Update Categories in Product Grid in Magento 2.
We will also add a filter for this column.
For the sake of this article, we will add a “Categories” column to product grid.
That will show which categories the product belongs to, but you can add any column you want.
You just need to populate the column with relevant data.
Now we have successfully added “Categories” column to product grid and also this column is filterable.
Creating a New Module
First thing’s first, create a new module.
For this tutorial, we will create a module named RLTS_Helloworld.
Then create the file app/code/RLTS/Helloworld/view/adminhtml/ui_component/product_listing.xml.
Put the following code in this file:
And the following line specifies the unique id for the column, in this case, category_id. It also specifies a Category class that will populate this column.
The following line specifies a CategoryList class which will populate the filter for this column. In Magento 2, filters are shown separately at top of product grid.
RLTS\Helloworld\Model\Category\Categorylist
The following line specifies that in filters, the field will appear as a dropdown (select input).
select
The following line determines the label of the field in the product grid.
Categories
Creating New Files
The following file will have the code that will actually populate the column with data.
app/code/RLTS/Helloworld/Ui/Component/Listing/Column/Category.php
In our case, we are creating categories. You can populate with any data you want.
Simply put in the following code in this file.
if (isset($dataSource['data']['items'])) {
foreach ($dataSource['data']['items'] as & $item) {
//print_r($item);die;
$productId=$item['entity_id'];
//$product=$this->_productloader->create()->load($p_id);
//$product = $objectManager->get('Magento\Catalog\Model\Product')->load($p_id);
//$productId = $p_id;
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$product = $objectManager->create('Magento\Catalog\Model\Product')->load($productId);
$cats = $product->getCategoryIds();
//$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$categories=array();
if(count($cats) ){
foreach($cats as $cat){
$category = $objectManager->create('Magento\Catalog\Model\Category')->load($cat);
$categories[]=$category->getName();
}
}
$item[$fieldName]=implode(',',$categories);
}
}
return $dataSource;
}
}
Now create the following file app/code/RLTS/Helloworld/Model/Category/Categorylist.php.
This file will have the code that will fill Categories dropdown in filters.
Put the following code in this file:
public function toOptionArray($addEmpty = true)
{
/** @var \Magento\Catalog\Model\ResourceModel\Category\Collection $collection */
$collection = $this->_categoryCollectionFactory->create();
$collection->addAttributeToSelect(‘name’);//->addRootLevelFilter()->load();
$options = [];
if ($addEmpty) {
$options[] = [‘label’ => __(‘– Please Select a Category –‘), ‘value’ => ”];
}
foreach ($collection as $category) {
$options[] = [‘label’ => $category->getName(), ‘value’ => $category->getId()];
}
return $options;
}
}
Finally, we need to override a UI Data provider.
Create the following file app/code/RLTS/Helloworld/etc/di.xml
And put the following code:
Also, create the following file app/code/RLTS/Helloworld/Ui/DataProvider/Product/ProductDataProvider.php.
Put the following code in this file:
$this->getCollection()->addCategoriesFilter(array('in' => $filter->getValue()));
}
elseif (isset($this->addFilterStrategies[$filter->getField()])) {
$this->addFilterStrategies[$filter->getField()]
->addFilter(
$this->getCollection(),
$filter->getField(),
[$filter->getConditionType() => $filter->getValue()]
);
} else {
parent::addFilter($filter);
}
}
}
Finally, we have successfully added Magento Categories column to the product grid and also this column is filterable.
