i needed to convert an dropdown attribute to multi select attribute.

so i followed this link : http://swarminglabs.com/how-to-change-a-product-dropdown-attribute-to-a-multi-select/

Than i got this problem & solution here :

Attributes did't selected in backend after changed from dropdown to multi-select

after this , i can able to get the attributes in frontend only when we select our store view of site.

but i want this to work for when we select "Default values" also.

1 Answer 1


did the previous answer from Shivani not solve this?

Maybe you can check the values in the catalog_product_entity_varchar table. They should have the store_id 0 to be considered default


with the following query you can find the entries with the non default values for your attribute (given your attribute id is 1244, which i have from you other question):

select entity_id,store_id from catalog_product_entity_varchar where attribute_id = 1244 and store_id != 0

if you find some (or many) we would have to check in the next step, if they have default values or not


I wrote a query that will assign the value for the attribute 1244 to the default store if there isn't one defined already.

Although I'm pretty sure that this works, you really should make a db backup before executing update queries on your database

UPDATE IGNORE catalog_product_entity_varchar SET store_id =0 WHERE attribute_id =1244


the update statement did actually not work but updated it and its easier now

  • yes, it worked for store views. i want for "Default values". i checked the table, it mentioned "0" as store id Commented Feb 10, 2016 at 17:01
  • i checked in 1st page, store id is 0 for all rows, is i need to look for particular attribute ? Commented Feb 10, 2016 at 17:03
  • just updated, if you get a result, we can take the next step Commented Feb 10, 2016 at 17:15
  • i got this result : prntscr.com/a1if47 Commented Feb 10, 2016 at 17:20
  • 1
    no problem :) glad I could help you Commented Feb 10, 2016 at 18:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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