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 '15 at 19:24
@STW That other answer works but seems kludgy. I'm inclined to leave this open. — benmarks♦, Sep 10 '15 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.

33.5k764174

answered Dec 18 '14 at 8:37

Abhishek Gupta

987716

it returns only TEXT means not its Value. Like dropdown option 33,34 etc, but it shows AM,PM(which is text) – Pratik C Joshi Oct 7 '15 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

33.5k764174

answered Dec 18 '14 at 8:34

Abhishek Gupta

987716

1

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

add a comment |

2 Answers 2