I need to retrieve a list of all values which are used for a specific product attribute, in (pseudo) SQL:

SELECT DISTINCT attribute FROM products;

How would I use the Magento ORM to generate an equivalent query? I've tried the distinct() function but it doesn't perform as I'd expect:

// Returns an array of NULL with a length equal to all products in the catalog

What I'm working to get would be an array of attribute values, without duplicates

array('some value', 'some other value', 'a really common value', 'etc...');
  • Are you looking for values for all types of attributes? or drop downs ?
    – Rabea
    Sep 26 '15 at 13:26

Thanks to kalpesh, this is already blogged:


$attribute = Mage::getModel('eav/config')->getAttribute('catalog_product', 'color'); //here, "color" is the attribute_code
$allOptions = $attribute->getSource()->getAllOptions(true, true);
foreach ($allOptions as $instance) {
    $myArray[$instance['value']] = $instance['label'];

Here is another solution: https://stackoverflow.com/a/15509714/1480397

But I'm not sure, whether this works on non-select attributes.

  • Yes, it will only work for select-attributes, but for those it's the way to go. Dec 13 '15 at 17:13

You can submit any SQL statements straight through the connection to acquire any data that is not accessible through magentos' api.

$db_resource = Mage::getSingleton('core/resource');
$db_connection = $db_resource->getConnection('core_write');
$sql = sprintf("SELECT DISTINCT attribute FROM `%s`", $db_resource->getTableName('product'));
$dataset = $db_connection->fetchAll($sql);

The query functions are fetchRow and fetchAll and are structured:

fetchAll($structured_sql, $bind_filters = array(), $fetchMode = null)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.