Get Product Attribute Value for Dropdown Without Loading the Whole Product

Question

Been using this snippet to retrieve the attribute values but this only works for input type text or boolean but not for dropdown type of attributes:

$_resource = Mage::getResourceSingleton('catalog/product');
$_resource->getAttributeRawValue($_productId, 'color', Mage::app()->getStore());

For the select dropdown type, it returns bool(false) and I am expecting it would return the dropdown frontend value/label.

How can I get the attribute value of a product without loading the whole product model?

Thank you.

possible duplicate of How do I get the ID of a dropdown attribute by its text label? — STW, Sep 9, 2015 at 19:24
@STW That other answer works but seems kludgy. I'm inclined to leave this open. — benmarks, Sep 10, 2015 at 0:55

Fabian Blechschmidt · Accepted Answer · 2015-02-21 21:24:10Z

2

Another option for getting dropdown attribute value :

$_product->getAttributeText('contrast_ratio');

getAttributeText method is use for retrieving the SELECT, MULTISELECT, DROPDOWN or YES/NO attributes value.

35.2k8 gold badges72 silver badges180 bronze badges

answered Dec 18, 2014 at 8:37

Abhishek Gupta

1,1658 silver badges17 bronze badges

it returns only TEXT means not its Value. Like dropdown option 33,34 etc, but it shows AM,PM(which is text)
– Pratik
Oct 7, 2015 at 5:29

Add a comment |

Fabian Blechschmidt · Accepted Answer · 2015-02-21 21:24:31Z

0

Below code is help you out :

$_product->getResource()->getAttribute('contrast_ratio')
    ->getFrontend()->getValue($_product);

Note : contrast_ratio is your dropdown attribute code

35.2k8 gold badges72 silver badges180 bronze badges

answered Dec 18, 2014 at 8:34

Abhishek Gupta

1,1658 silver badges17 bronze badges

1

Well, I don't need to load the whole product model so I don't have access to $_product.
– user1240207
Dec 19, 2014 at 1:22

Add a comment |

2 Answers 2