Magento: class to retrieve data from eav_attribute_option_value

Magento: class to retrieve data from eav_attribute_option_value

September 11, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento: class to retrieve data from eav_attribute_option_value

Retrieving EAV Attribute Option Values in Magento

In a recent project using Magento version 1.4.0.1, we needed to retrieve specific option values from the eav_attribute_option_value table for a given option ID. This data is crucial for displaying product attributes on the frontend and managing them within the admin panel.

Understanding EAV Data Structure

Magento uses an Entity-Attribute-Value (EAV) model to store attribute data dynamically. The eav_attribute_option_value table stores the values of these options. Each row represents a specific value for an option in a certain store view.

For example, consider the following data from the eav_attribute_option_value table:

value_idoption_idstore_idvalue
3570Levertijd 1 tot 3 werkdagen
3660Levertijd 4 tot 10 werkdagen
3750Langer dan 11 werkdagen
3840Levertijd onbekend
3930Pre-Order

In this scenario, we have different delivery options (option IDs) with their corresponding values. If you want to retrieve the value for option ID 6, you would expect “Levertijd 4 tot 10 werkdagen”.

Retrieving Option Values Using Magento Classes

Magento provides several classes that can be used to interact with EAV data without directly querying the database. This approach ensures cleaner code and better integration with the framework.

One of the key classes for this purpose is Mage_Eav_Model_Entity_Attribute_Source_Abstract. This abstract class serves as a base for all attribute source models in Magento, including those used for managing option values.

Here’s an example of how you can use this class to retrieve the desired value:

// Load the required classes
require_once 'app/Mage.php';
Mage::init();

// Get the specific option ID (replace 6 with your actual ID)
$optionId = 6;

// Create a new instance of Mage_Catalog_Model_Resource_Eav_Attribute
$attributeModel = Mage::getSingleton('catalog/resource_eav_attribute');

// Use the load method to get the attribute object
$attribute = $attributeModel->loadByCode('catalog_product', 'delivery_option'); // Replace with your actual attribute code

// Get the source model for the option values
$sourceModel = $attribute->getSource();

// Call the getOptionText method to retrieve the value as a string
$optionValue = $sourceModel->getOptionText($optionId);

// Now you can use $optionValue which contains "Levertijd 4 tot 10 werkdagen"

This code demonstrates how to load an attribute and access its source model. The getOptionText method is provided by the Mage_Eav_Model_Entity_Attribute_Source_Abstract class and returns the human-readable value for a given option ID.

Conclusion

Retrieving EAV data in Magento is a common requirement that can be achieved using built-in classes and methods. By leveraging the framework’s provided functionality, you can ensure your code remains clean, maintainable, and compliant with Magento best practices.

Remember to always refer to the official Magento Developer Documentation for up-to-date information on available classes and methods. This documentation is an invaluable resource for anyone working with Magento’s EAV model or other core components.

In this example, we used a specific product attribute (delivery_option). You can apply the same logic to any custom attributes you have created in your Magento installation by replacing ‘catalog_product’ and ‘delivery_option’ with your actual entity type and attribute code.

Catalog Database Admin Orders

Our network