0

First post! I have inherited a Magento 1.9.4.5 install with multiple store views.

I have a global attribute (added to all attribute sets) for "Diet and Lifestyle", multi-select with four options (Vegetarian, Vegan, Free From and Organic)

Categories are set to be anchored, and "normal" attributes work perfectly in layered navigation, but the Multi-Select attributes will not pick up any values for filtering.

If I set the attribute to be "Use In Layered Navigation" -> Filterable (no results) I get the attribute showing but the product counts are all zero.

I've checked the database and the values are there in the catalog_product_entity_varchar table:

SET @entity_id = 20795;  -- sku 31889
(SELECT e.attribute_id, e.attribute_code, 'varchar' AS TYPE, v.store_id, v.value FROM catalog_product_entity_varchar v
JOIN eav_attribute e ON e.attribute_id = v.attribute_id WHERE v.entity_id = @entity_id)
UNION
(SELECT e.attribute_id, e.attribute_code, 'datetime' AS TYPE, v.store_id, v.value FROM catalog_product_entity_datetime v
JOIN eav_attribute e ON e.attribute_id = v.attribute_id WHERE v.entity_id = @entity_id)
UNION
(SELECT e.attribute_id, e.attribute_code, 'decimal' AS TYPE, v.store_id, v.value FROM catalog_product_entity_decimal v
JOIN eav_attribute e ON e.attribute_id = v.attribute_id WHERE v.entity_id = @entity_id)
UNION
(SELECT e.attribute_id, e.attribute_code, 'int' AS TYPE, v.store_id, v.value FROM catalog_product_entity_int v
JOIN eav_attribute e ON e.attribute_id = v.attribute_id WHERE v.entity_id = @entity_id)
UNION
(SELECT e.attribute_id, e.attribute_code, 'text' AS TYPE, v.store_id, v.value FROM catalog_product_entity_text v
JOIN eav_attribute e ON e.attribute_id = v.attribute_id WHERE v.entity_id = @entity_id)
 ORDER BY attribute_id;

My attribute (401) gives

401,diet_and_lifestyle,varchar,0,4037,4036,4035,4034

Any help greatly appreciated!

Your Answer

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

Browse other questions tagged or ask your own question.