Skip to main content
3 of 5
format the code
7ochem
  • 7.6k
  • 14
  • 52
  • 80

Understand product attribute type multiselect

Can anyone tell why magento saves product attribute multiselect as varchar and hence its options in catalog_product_entity_varchar as array?

Is not it better to consider multiselect as "multidropdown" and save it like an int and insert multiple records in catalog_product_entity_int?

If it were so I could join catalog_product_entity_int with eav_attribute_option_value on value=option_id

What I can't do with catalog_product_entity_varchar if value is an array.

LucScu
  • 2.4k
  • 28
  • 39