Magento 2 – Filter Product Collection by Multiple Attributes

attributesfiltermagento2.2.2product-collection

In Magento 2.2.2, How Can Filter Product Collection by Multiple Attributes.

I have the attribute_code with array values.

attribute_code: my_attribute_code

attribute_code values:

Array
(
  [0] => 12
  [1] => 10
);

Best Answer

Try this Code :

class HelloWorld extends \Magento\Framework\View\Element\Template
{    
    protected $_productCollectionFactory;

    public function __construct(
        \Magento\Backend\Block\Template\Context $context,        
        \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory,        
        array $data = []
    )
    {    
        $this->_productCollectionFactory = $productCollectionFactory;    
        parent::__construct($context, $data);
    }

    public function getProductCollection()
    {
        $collection = $this->_productCollectionFactory->create();
        $collection->addAttributeToSelect('*');
        $collection->addFieldToFilter('my_attribute_code', array('in' => array(12,10)));
        return $collection;
    }
}

Related Solutions

Magento – How to filter product collection with 3 attributes (distinct rows)

Using this resource you can see that the method ->addAttributeToFilter(AttributeCode, Value) is what you need to apply to a collection to filter products.

So something along these lines should work for you:

$collection=Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToFilter('brand', array('eq'=>'samsung'))
    ->addAttributeToFilter('size', array('eq'=>'12'))
    ->addAttributeToSelect('*')
    ->distinct(TRUE);

Depending on your setup you may need to find the ID of those values instead of the text that the customer sees. Also it still may not help you get just the two you are looking for since they have other fields or attributes that make them unique.

Magento – How to Filter Product Collection with Configurable Product Attributes

Figured it out by myself.

Above code returns nothing because attribute (size) is assigned only to simple products (associated products) and all simple product's visibility is set to 1 i.e, not visible individually.

Step 1 : Remove visibility to 1, now i can get list of all simple products (associated products) which is assigned to size 3.

Step 2 : Join table catalog_product_super_link to get parent product associated with it.

Complete code is,

    $collection = Mage::getModel('catalog/product')->getCollection()
        ->addAttributeToFilter(
            array(
            array('attribute'=> 'color','like' => '12')
            )
        )
        // multiple filters can be achieved by adding another filterattribute
        ->addAttributeToFilter(
            array(
            array('attribute'=> 'size','like' => '3')
            )
        );

   $collection->getSelect()->joinLeft(array('link_table' => 'catalog_product_super_link'),'link_table.product_id = e.entity_id',
            array('product_id','parent_id')
        );

   $collection->getSelect()->group('link_table.parent_id');

   foreach($collection as $product) {
        $ids[] = $product->getParentId();
       }

    $collection->load();

    echo json_encode($ids);

Hope this may help to someone.

Best Answer

Related Solutions

Magento – How to filter product collection with 3 attributes (distinct rows)

Magento – How to Filter Product Collection with Configurable Product Attributes

Related Topic