Magento 1.9 – Can’t Filter Collection by Custom Attribute

collection;custom-attributesmagento-1.9product-collection

I have a custom attribute called parent_sku, I setted it to yes in Product Listing from the backend menu, and almost all the products have a value in this attribute.

I tried:

$subCollection = Mage::getModel('catalog/product')
        ->getCollection()
        ->addAttributeToSelect(array('id','parent_sku'))
        ->addAttributeToFilter('parent_sku', array('eq' => $parent_sku));

I also tried (I know it is the same):

$subCollection = Mage::getModel('catalog/product')
        ->getCollection()
        ->addAttributeToSelect(array('id','parent_sku'))
        ->addAttributeToFilter('parent_sku', $parent_sku));

$parent_sku has a valid value, that is the same of the value that have some of the products in parent_sku attribute.

But I get always $subCollection empty.

count($subCollection)  // this is always zero

Best Answer

After adding your attribute, you should to reindexAll

Try this:

$subCollection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToSelect(array('name', 'price', 'parent_sku'));

Clear your browser and Magento cache.

Related Solutions

Magento – Product collection Sort by Custom attribute with yes/no Option

Make sure the archive attribute is added to the flat product data by setting Used in Product Listing to yes. Also it's probably better to load the product collection via the catalog/category model instead of joining another table.

Also, to have yes come as last make the order ascending instead of descending

$category = Mage::getModel('catalog/category')->load(37);
$collection = $category->getProductCollection()
   ->addStoreFilter(Mage::app()->getStore()->getId())
   ->addAttributeToFilter('type_id', 'configurable')
   ->addAttributeToSort('archive', 'asc');

Magento 1.9 Adminhtml – Use iso3_code in Country List

There may be a better way, but adding a helper method to your form like this should work.

protected function _getCountryOptions() {
    $sort = array();
    $collection = Mage::getModel('directory/country')->getCollection();
    foreach($collection as $country) {
        $name = Mage::app()->getLocale()->getCountryTranslation($country->getData('iso2_code'));
        if (!empty($name)) {
            $sort[$name] = $country->getData('iso3_code');
        }
    }
    Mage::helper('core/string')->ksortMultibyte($sort);
    $options = array();
    foreach ($sort as $label=>$value) {
        $options[] = array(
           'value' => $value,
           'label' => $label
        );
    }

    return $options;
}

And then:

$fieldset->addField('country', 'select', array(
    'name'     => 'country',
    'class'    => 'required-entry',
    'required' => true,
    'label'    => 'Country',
    'values'   => $this->_getCountryOptions(),
));

Best Answer

Related Solutions

Magento – Product collection Sort by Custom attribute with yes/no Option

Magento 1.9 Adminhtml – Use iso3_code in Country List

Related Topic