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

product-collection

I have a product with 3 attributes(color,size,brand) and some other attributes.

I need to display above 3 attributes in a table with unique rows.

For example product1 values: green,12,samsung

product2 values :yellow,12,samsung

product3 vaules:green,12,samsung.

So I need to get only (product1 or product3 ) & product2 from collection.

(because product1 & product3 all values are same.So i want to avoid duplicate rows)

and my sample code:

$collection=Mage::getResourceModel('catalog/product_collection')->distinct(true);

How to write query to get above one.
Can any one help this ?
Thanks in advance.

Best Answer

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.

Related Solutions

Product Collection – Filter by Stores

A little more about the concept: A product does not "belong to a store". If you want to exclude it from display in a store view, the most common method imho is to set its visibility in this store scope to "Not visible individually"

If you don't have flat catalogs enabled and don't need to support this functionality, you can simply use:

$collection = Mage::getModel('catalog/product')->getCollection()
                ->setStoreId($myStoreId)
                ->addAttributeToFilter('visibility', array(
                    'neq' => Mage_Catalog_Model_Product_Visibility::VISIBILITY_NOT_VISIBLE
                ));

Or, if you use different root categories for your store, you could simply set a category filter:

$rootCatId = Mage::app()->getStore($myStoreId)->getRootCategoryId();
$rootCat = Mage::getModel('catalog/category')->load($rootCatId);
$collection = Mage::getModel('catalog/product')->getCollection()
                    ->setCategoryFilter($rootCat);

If you use flat catalogs, a detailed explanation of the problem and maybe a solution can be found here: How to set a store ID on Mage_Catalog_Model_Resource_Product_Collection?

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

Product Collection – Filter by Stores

Magento – How to Filter Product Collection with Configurable Product Attributes

Related Topic