I'm using the following to filter my collection:

                $collection = Mage::getModel('catalog/product')
                ->addAttributeToFilter('status', array('eq' => 1))
                ->addAttributeToFilter('sepdate', array('eq' => 'Yes'))

The attribute 'sepdate' is a yes/no attribute and it is added to the product list eav.

My problem is that the above doesn't work. When removing the:

->addAttributeToFilter('sepdate', array('eq' => 'Yes'))

The collection works fine, but when that is added nothing gets selected.

I have checked that there actually are products with the attribute set for 'Yes' and I have also tested with 1 instead of 'Yes'.

Can anyone help me with what i'm doing wrong here?


Okay, looked at the sql it made and think I found the culprit. The sql looks like this:

SELECT `e`.*, `at_sepdate`.`value` AS `sepdate` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_sepdate` ON (`at_sepdate`.`entity_id` = `e`.`entity_id`) AND (`at_sepdate`.`attribute_id` = '144') AND (`at_sepdate`.`store_id` = 0) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = '1' WHERE (at_sepdate.value = 1)

Where this is causing the trouble:

AND (`at_sepdate`.`store_id` = 0)

The store_id should be 1 and I can't quite understand why it isn't since i'm setting both setStoreID() and addStoreFilter(). ?

  • yes/no values are kept in the db as 1 and 0. Use 1 instead of yes and make sure the indexes are rebuilt. – Marius Jan 29 '15 at 13:54
  • @Marius Thanks, but as I wrote in the question I have already tested with 1 instead of 'Yes' without any luck. – dannevang Jan 29 '15 at 13:58
  • I saw that. That's why I suggested to change it back to 1 and rebuild your indexes. – Marius Jan 29 '15 at 14:08
  • You should check the backend type of your attribute first. Look for it in database (by its code in eav_attribute table) or in browser with Admin panel + Firebug/Developer tools (open product page, right click - examine). – Amberta Jan 29 '15 at 14:10
  • @Marius Sorry, misunderstood then. Changed it back to 1 and rebuild indexes. Still no luck. – dannevang Jan 29 '15 at 14:29

The culprit is probably the ->addStoreFilter($storeId) because it adds the website_id as a filtering condition, instead of the store_id. See Mage_Catalog_Model_Resource_Product_Collection->addStoreFilter() and trace through ->_applyProductLimitations() and finally ->_productLimitationJoinWebsite() where it decides to join the website around line 1652 (in version 1.8):

$joinWebsite = true;
$websiteId = Mage::app()->getStore($filters['store_id'])->getWebsiteId();
$conditions[] = $this->getConnection()
    ->quoteInto('product_website.website_id = ?', $websiteId);

I encountered this problem when trying to use addStoreFilter() on a Resource Model Product Collection instead of the full Model. My solution was to change the store before instantiating the collection.

$collection = Mage::getModel('catalog/product')
                ->addAttributeToSelect('sepdate')  /* I think this line is not necessary because the ->addAttributeToFilter('sepdate', 1) will add the attribute as well. */
                ->addAttributeToFilter('status', array('eq' => 1))
                ->addAttributeToFilter('sepdate', array('eq' => 'Yes'))

I hope this helps. Good luck!

  • @7ochem: Thanks for dotting the i's and crossing the t's! – Vincent_v_E Apr 29 '15 at 13:19

You might try something like this...


Sometimes addFieldToFilter works when addattributetofilter is not working as you expect it to.

  • Thank you for your answer, sadly that doesn't work either. The sql still contain the store_id = 0 part. – dannevang Jan 29 '15 at 16:37
  • are you trying to get a selection for a specific store? If not, just omit that part. It is generating the query based on what you add to ->addattributetofilter. This will result in a query against all available products. – CarComp Jan 29 '15 at 19:19
  • I am going for a specific store. It is part of a cron going through multiple stores from specific criteria. – dannevang Jan 29 '15 at 19:54

Try this code.


        $attr = $productModel->getResource()->getAttribute('sepdate');
            if ($attr) {

         $filter_id = $attr->getSource()->getOptionId('yes');

            $collection = Mage::getModel('catalog/product')
            ->addAttributeToFilter('status', array('eq' => 1))

You Can use this code

$productAttrCode = 'show_on_home';
$productAttrValue = 'yes';
$products = Mage::getModel('catalog/product')->getCollection()
            'eq' => Mage::getResourceModel('catalog/product')

foreach ($products as $product) {
    echo $product->getName() . "<br>";

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.