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.

34.6k7 gold badges65 silver badges176 bronze badges

answered Dec 18 '14 at 8:37

Abhishek Gupta

1,1478 silver badges16 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 '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

34.6k7 gold badges65 silver badges176 bronze badges

answered Dec 18 '14 at 8:34

Abhishek Gupta

1,1478 silver badges16 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 '14 at 1:22

add a comment |

2 Answers 2