Magento – Get product collection based on custom attribute (drop down attribute value)

attributesmagento2product-collectionproducts

I created a custom drop down attribute in Magento2 from admin. I tried to collect all associated products by using filters. I am able to filter product collection based on text field attributes, for example

$productcollection = $this->_productCollection
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('sku', '24-MB01')
    ->load();

But when I try to filter using dropdown custom attribute value I'm getting an empty array

$productcollection = $this->_productCollection
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('tag', 'popular')
    ->load();

How am I supposed to filter product collection using a dropdown attribute. Can someone help with this?

Best Answer

For dropdown attribute, We can filter using dropdown option ID instead of Label.

So your code is like below.

$productcollection = $this->_productCollection
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('tag', 28)
    ->load();

Above 28 is the ID of the popular option of tag dropdown attribute.

Related Solutions

Magento – Set default value to custom attribute for all products

You could try something like this. I believe the below method is quite efficient.

$attrData = array(
    'attribute_code_here'=> 'Default Value Here',
);
$storeId = 0;
$productIds = Mage::getModel('catalog/product')->getCollection()->getAllIds();
Mage::getModel("catalog/product_action")->updateAttributes(
    $productIds, 
    $attrData, 
    $storeId
);

Magento – Drop Down Filter by Attribute in Products List Toolbar

i found the solution.

Adding <block type="catalog/category_view" name="category.products" template="catalog/category/view.phtml"> inside <catalog_category_layered> in catalog.xml :

<!--Category layered Navigation Layout-->
<catalog_category_layered>
    <reference name="content">
        <block type="catalog/category_view" name="category.products" template="catalog/category/view.phtml">
            <block type="catalog/product_list" name="product_list" template="catalog/product/list.phtml">
                <block type="catalog/layer_view" name="filter_by_attributes" template="catalog/layer/view.phtml"/>                    
                <block type="catalog/product_list_ctoolbar" name="product_list_ctoolbar" template="catalog/product/list/ctoolbar.phtml">                                              
                </block>
                <action method="setToolbarBlockName"><name>product_list_toolbar</name></action>
            </block>
        </block>
    </reference>
</catalog_category_layered>

adding javascript in catalog\layer\view.phtml :

<button onclick="showAttribute()"><?php echo $this->__('Filter') ?></button>
<?php if($this->canShowBlock()): ?>
<div class="block-layered-nav" style="display: none;">
<dl id="narrow-by-list">
    <?php $_filters = $this->getFilters() ?>
    <?php foreach ($_filters as $_filter): ?>
            <?php echo $_filter->setTitle($_filter->getName())->getHtml() ?>
    <?php endforeach; ?>
</dl>
<script type="text/javascript">decorateDataList('narrow-by-list')</script>
</div>
<script type="text/javascript">
 //<![CDATA[
  var _used_filter = [];
  <?php foreach ($_filters as $_filter): ?>
   _used_filter.push('<?php echo $_filter->getRequestVar() ?>');
  <?php endforeach; ?>

  function showAttribute() {
    if(jQuery(".block-layered-nav").is(":visible"))
        jQuery(".block-layered-nav").hide(); 
    else
        jQuery(".block-layered-nav").show();
   }
//]]>
</script>
<?php endif; ?>

modify template\catalog\layer\attribute.phtml :

<div class="filter-box-container">
<select class="filter-atts" id="filter-atts" name="<?php echo $this->getRequestVar()?>[]">
    <option><?php echo $this->__('%s', $this->getTitle()) ?></option>
    <?php foreach ($this->getItems() as $_item):?>
        <option onchange="doFilter()" value="<?php echo $_item->getValue()?>" <?php echo $_item->getIsSelected() ? 'selected':''?>>
            <?php echo $_item->getLabel() ?>        
        </option>
    <?php endforeach ?>
</select>

and the rest is resolved with css

Best Answer

Related Solutions

Magento – Set default value to custom attribute for all products

Magento – Drop Down Filter by Attribute in Products List Toolbar

Related Topic