Magento – Get product attributes in collection

magento-1product-attributeproduct-collection

I've got a big product collection about 68.000 items, when I loop through
the collection I'm trying to get all attributes by using $collection->getAttributes() but it returns nothing.

When I load the products attributes like

$catId=604;
$collection = Mage::getModel('catalog/category')->load($catId)
    ->getProductCollection()
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('category_id', $catId)
    ->addAttributeToFilter('type_id', 'simple')
    ->addAttributeToFilter('status', 1)->load();

foreach($collection as $col) {
    $prod = Mage::getModel('catalog/product')->load($col->getId());
    $prod->getAttributes();
}

the performance is horrible so I want to get the attributes by using the collection but it doesn't work at all.

Any suggestions ?

Best Answer

You cannot call getAttributes() on $collection as this is the collection model/object. In your code example you are calling getAttributes() on $prod which is a product model/object.

You should remove the line $prod = Mage::getModel('catalog/product')->load($col->getId()); which is causing a huge load because you are loading every individual product again while they were already loaded.

Just call $col->getAttributes(); right away.

By the way, as far as I can see, getAttributes() just returns all editable attributes of the product EAV model. So this array is the same for all of your 68.000 products (per attribute set that is). If you need all values in an array, just do $col->getData()

Related Solutions

Magento – Get product collection from a category id

Try this:

$products = Mage::getModel('catalog/category')->load($category_id)
 ->getProductCollection()
 ->addAttributeToSelect('*') // add all attributes - optional
 ->addAttributeToFilter('status', 1) // enabled
 ->addAttributeToFilter('visibility', 4) //visibility in catalog,search
 ->setOrder('price', 'ASC'); //sets the order by price

_{Source: http://overlycaffeinated.com/blog/2011/02/get-all-sale-products-from-a-category-in-magento/}

This should work because it adds the category filter for you by virtue of already having the category loaded:

Mage_Catalog_Model_Category

public function getProductCollection()
{
    $collection = Mage::getResourceModel('catalog/product_collection')
        ->setStoreId($this->getStoreId())
        ->addCategoryFilter($this);
    return $collection;
}

Wait, it still doesn't work!

Ok, so you may have larger issues, presumably something overwriting getProductCollection. So let's try circumventing that convenience method:

$category = Mage::getModel('catalog/category')->load($category_id);
$products = Mage::getResourceModel('catalog/product_collection')
        ->setStoreId(Mage::app()->getStore()->getId())
        ->addCategoryFilter($category);

Magento 1.8 – Fix addAttributeToFilter Not Filtering on Product Collection

Try like this

$selections_products = $modelCatalogProduct->getCollection()
->setPageSize(32)
->addAttributeToSelect(array('name','selection_moment','selection_rouge','selection_blanc','selection_cdc','selection_champagne','selection_exception'))
->addAttributeToFilter(
    array(
        array('attribute'=>'selection_moment', 'eq' => '1'),
        array('attribute'=>'selection_rouge', 'eq' => '1'),
        array('attribute'=>'selection_blanc', 'eq' => '1'),
        array('attribute'=>'selection_cdc', 'eq' => '1'),
        array('attribute'=>'selection_champagne', 'eq' => '1'),
        array('attribute'=>'selection_exception', 'eq' => '1')
    )
);

Refer this link

Best Answer

Related Solutions

Magento – Get product collection from a category id

Magento 1.8 – Fix addAttributeToFilter Not Filtering on Product Collection

Related Topic