Magento – Get store view attribute value from collection

attributesmagento-1.9product-collection

I'm using the following call to get a product collection:

        $collection = Mage::getModel('catalog/product')
        ->getCollection()
        ->setStoreId($storeId)
        ->addStoreFilter($storeId)
        ->addAttributeToSelect(array('attribute_name1','attribute_name2'))
        ->addAttributeToFilter('status', array('eq' => Mage_Catalog_Model_Product_Status::STATUS_ENABLED));

The product "attribute_name1" has never been set on the default view of the product in Magento admin, but it has been set on the store view level.

If I call the attribute in my code with $product->getAttributeName1() it returns null – even if a value has been set on the store view level in admin.

If I set the default value of the attribute to "foo" and the store view value af the attribute to "bar" the call $product->getAttributeName1() returns "bar" as expected.

My questions is: How can I structure my collection call to ensure that my $product->getAttributeName1() call returns the store view level value, even if a default value hasn't been set?

Best Answer

You can load each product with $product->load(), but you will kill your website performance.

Use the following raw attribute access code:

$myValue = Mage::getResourceModel('catalog/product')
  ->getAttributeRawValue($productId, 'my_attribute_name', $storeId);

It will be much much faster ;) (of course depending on the number of attribute you need to load )

Related Solutions

Magento – Product view attribute value different on two store views

You can have different scopes for different attributes. Your attribute has obviosuly the scope "store view". Alterantives are: "store", "website" and "global".

You can change the scope with a script, but after that change, I think you have to clean up the database because magento ignores the scope while fetching the data. It only is important when writing them.

You can check this in the backend, when you view a product you can change the scope in the upper left side and beside the selectbox is the information [store view] what the scope of the attribute is.

Magento2 Product Attribute – Fix Global Product Attribute Empty on Store View Level

Here is a quick fix.
you need to identify the attribute ids for all global attributes then delete all the values from the catalog_product_entity_* tables that have the attribute id one of those identified above and the store id field not zero.

DELETE FROM `catalog_product_entity_int` 
WHERE
   store_id <> 0 AND
   attribute_id IN (
           SELECT attribute_id 
           FROM catalog_eav_attribute 
           WHERE is_global = 1

   )

Do the same for the tables catalog_product_entity_varchar, catalog_product_entity_text, catalog_product_entity_datetime, catalog_product_entity_decimal.

Rebuild your indexes when your are done.

Note: The select from catalog_eav_attribute in the way I wrote it will give you attribute ids for the global category attributes also, but that's not important since in the product tables you don't have category attributes references.

Also, before trying this, backup your database in case I missed something.

Related Topic