Filter collection by attribute Set


Question

How would one filter collection by attribute set name

I am trying as following, but its not working

$collection->addAttributeToFilter('attribute_set_name',"Quantity Television Parts");

Thank You

1
5
10/5/2017 9:38:18 AM

Accepted Answer

This is how i end up doing.

I looked up id of the attribute-set-name in the table "eav_attribute_set" table and used following filter:

$products->addAttributeToFilter('attribute_set_id','33');
13
10/5/2017 9:38:01 AM

We can filter the collection by attribute set using:

addAttributeToFilter('attribute_set_id','attribute set id here');

suppose your attribute set id is 10.

For example

$collection = Mage::getModel('catalog/product')->getCollection();

$collection->addAttributeToFilter('status', array('eq' =>1))

           ->addAttributeToFilter('attribute_set_id','10')
           ->addAttributeToSelect('*');

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Icon