Skip to main content

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