Get product attribute 'option label'?

Question

I have manage to retrieve the value for an attribute relative to a particular product

 $store_id = Mage::app()->getStore()->getStoreId();
 $attribute_code = 'code';
 $value =  Mage::getResourceModel('catalog/product')
        ->getAttributeRawValue($prod_id, $attribute_code, $store_id);

What I miss here is the label associated to the attribute value.

How can I get it, without load the full product object ?

Answer 1

This code works fine and avoid to load the entire product obj

$option_id = Mage::getResourceModel('catalog/product')
    ->getAttributeRawValue($prod_id, $attribure_code, $store_id); 

Method 1

$option_value = Mage::getResourceModel('eav/entity_attribute_option_collection')
    ->setStoreFilter($store_id)
    ->setIdFilter($option_id)
    ->getFirstItem()
    ->getValue();

Method 2 (@Marius)

// to be tested
// not loading the product - just creating a simple instance
$singleton_prod = Mage::getSingleton('catalog/product')
     ->setStoreId($store_id)
     ->setData($attribure_code, $option_id); 
$optionLabel = $singleton_prod->getAttributeText($attribure_code);

Answer 2

You can also use some thing like this if you have $product variable.

$product->getResource()->getAttribute($attribute_code)->getFrontend()->getLabel($product);

Answer 3

I used this code.

$some_attr_code = "brand"
$optionId = Mage::app()->getRequest()->getParam('option_id');

/** @var Mage_Eav_Model_Attribute $attribute */
$attribute = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, $some_attr_code);
$label = $attribute->getStoreLabel();
if($optionId){
  $optionLabel = $attribute->getFrontend()->getOption($optionId);
}

Answer 4

This solution isn't bound to a strict model or a resource model and can be used to retrieve an option label of an attribute that is assigned to whatever entity type:

// In your case $entityType should be `catalog_product`
$attribute = Mage::getModel('eav/config')->getAttribute($entityType, $attributeCode);
echo $attribute->getSource()->getOptionText($optionId);

FYI, $attribute->getSource() returns an instance of Mage_Eav_Model_Entity_Attribute_Source_Table which has the following methods:

Array
(
    [0] => getAllOptions
    [1] => getOptionText
    [2] => addValueSortToCollection
    [3] => getFlatColums
    [4] => getFlatIndexes
    [5] => getFlatUpdateSelect
    [6] => setAttribute
    [7] => getAttribute
    [8] => getOptionId
    [9] => getIndexOptionText
)

I should note that Method 1 from accepted answer throws an SQL error in Magento v1.9.4 (I'm not sure about the other versions):

Column 'option_id' in where clause is ambiguous

The reason could be found in the below generated SQL query:

SELECT
    `main_table`.*,
    `tdv`.`value` AS `default_value`,
    `tsv`.`value` AS `store_default_value`,
IF
    ( tsv.value_id > 0, tsv.VALUE, tdv.VALUE ) AS `value` 
FROM
    `eav_attribute_option` AS `main_table`
    INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id
    LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id 
    AND tsv.store_id = 0 
WHERE
    ( tdv.store_id = 0 ) 
    # This is the culprit
    AND ( `option_id` IN ( 9999 ) )

Answer 5

What about this?

$attribute = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, $attribute_code);
$label = $attribute->getFrontend()->getLabel();