Magento – Magento 2: How to get product custom attribute in product grid

custom-attributesmagento2product-attributeproduct-collectionproduct-grid

How to get product custom attribute in product grid. I have create product attribute as "qty_per_box". But it is not showing in collection.

The following code is not getting custom product attribue.

  /**
    * @return Grid
    */
        protected function _prepareCollection()
        {
            $collection = $this->productFactory->create()->getCollection()->addAttributeToSelect("*");
            $this->setCollection($collection);
            return parent::_prepareCollection();
        }

Best Answer

1/ Magento Admin > Stores > Attributes / Product > Click on your custom attribute > Advanced Attribute Properties > Set "Add to Column Options" to "Yes" and click on "Save attribute" button

2/ Magento Admin > Products > Inventory / Catalog > Select your custom attribute on "Columns box"

Related Solutions

Magento 1.9.2 – How to Add Custom Attribute on Product Grid

Yeah, this is a common problem.

So the problem here is that, as your custom grid extends the original grid class Mage_Adminhtml_Block_Catalog_Product_Grid, when you call the following code:

return parent::_prepareColumns();

It goes to the original _prepareColumns method and thus, overwrite your custom columns.

To fix that you need to call the parent's parent method:

return Mage_Adminhtml_Block_Widget_Grid::_prepareColumns();

Same goes for the _prepareCollection method.

To avoid that kind of problems, I also sugget that you use event observers instead of rewriting blocks: https://magento.stackexchange.com/a/5986/2380

Magento 2 – Custom Attribute Source Model Not Showing in Product Collection

Before addAttributeToFilter Function You Must Select All Attribute Using addAttributeToSelect Function

$collection = $productCollection->create()
->addAttributeToSelect('*')
->addAttributeToFilter('awa_brand',array('eq' => $_product->getAwaBrand()))
->setPageSize(3);

Best Answer

Related Solutions

Magento 1.9.2 – How to Add Custom Attribute on Product Grid

Magento 2 – Custom Attribute Source Model Not Showing in Product Collection

Related Topic