Magento 1.9 – How to Get All Values of a Custom Attribute

collection;magento-1.9product-attributeproduct-collection

I have a custom product attribute test_id which is a text field. I want to get all the values assigned to this attribute within a given product collection.

I found the following way of doing it. But I need to know if there is a better solution.

public function getAllTestIds() {
    $allValues = array();
    $collection = Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect('*');
    foreach($collection as $product) {
        $data = $product->getData();
        if(trim($data['test_id']) != '') {
            $allValues[] = $data['test_id'];
       }
   }
return $allValues;
}

Best Answer

@Sukeshini,add groupByAttribute() to get data of unique data and remove null .

public function getAllTestIds() {
    $allValues = array();
    $collection = Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect('*')->addAttributeToFilter('test_id', array(
    'notnull' => true,
    ))->groupByAttribute('test_id');

    foreach($collection as $product) {
        $data = $product->getData();
            $allValues[] = $data['test_id'];
       }
   }
return $allValues;
}

Code

$attributeCode = 'color';

$attribute = Mage::getModel('eav/entity_attribute')->loadByCode(Mage_Catalog_Model_Product::ENTITY, $attributeCode);
$productResource = Mage::getResourceModel('catalog/product');

// Use collection only to prepare query
$valuesCollection = Mage::getResourceModel('eav/entity_attribute_option_collection')
    ->setStoreFilter(0, false);

// Now refine query
$valuesCollection->getSelect()
    ->joinLeft(
        array('value_table' => $productResource->getTable(array('catalog/product', 'int'))),
        'main_table.option_id=value_table.value AND main_table.attribute_id=value_table.attribute_id', 'entity_id')
    ->reset(Zend_Db_Select::COLUMNS)
    ->columns(array('main_table.option_id', new Zend_Db_Expr('COUNT(value_table.entity_id)')))
    ->where('main_table.attribute_id=:attribute_id')
    ->group('main_table.option_id');

// ...and fetch data
$result = $productResource->getReadConnection()->fetchPairs(
    $valuesCollection->getSelect(), array('attribute_id' => $attribute->getId()));

Result now contains an array in the form [option_id => number of products]

Magento – Bad performance looping through all products

Product Collection from Category

// Step 1
$category = Mage::getModel('catalog/category')->load($category_id);

// Step 2
$productCollection = Mage::getModel('catalog/product')->getCollection();

// Step 3
$productCollection->addCategoryFilter($category);

// Step 4
$productCollection
    ->addAttributeToSelect('sku')
    ->addAttributeToSelect('another_attribute')
    ->addAttributeToFilter('type_id', 'simple')
    ->addAttributeToFilter('status', 1);

// Now you can loop through your collection
foreach($productCollection as $product) {
    $product->getSku();
    $product->getAnotherAttribute();
    // and so on...
}

So what's going on?

We loaded a category model. We will use that in the product collection.
We instantiated the product collection model.
We added the category for filtering.
We added the appropriate attributes for selection and filtering.

NOTE: Do not use the asterisk unless you plan on using every attribute being returned. Just like you shouldn't use the asterisk in a MySQL query unless you plan on getting everything from that table.

Once I have all my attributes and filters in place, I can loop through my collection. I do not need to call the load() method because lazy loading does that for me.

Once I'm in the loop, I have access to the product object Mage_Catalog_Model_Product. I do not need to instantiate another model inside the loop. The collection does this for me.

Best Answer

Related Solutions

Magento – How to get a collection of attribute values and products that use them

Code

Magento – Bad performance looping through all products

Product Collection from Category

So what's going on?

Related Topic