0

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
+50

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

===UPDATE===

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

===UPDATE===

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

===UPDATE===

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 – Baby in Magento Feb 10 '16 at 17:01
  • i checked in 1st page, store id is 0 for all rows, is i need to look for particular attribute ? – Baby in Magento Feb 10 '16 at 17:03
  • just updated, if you get a result, we can take the next step – David Verholen Feb 10 '16 at 17:15
  • i got this result : prntscr.com/a1if47 – Baby in Magento Feb 10 '16 at 17:20
  • 1
    no problem :) glad I could help you – David Verholen Feb 10 '16 at 18:32

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.