I want to change attribute label of products. For that I have changed its label in backend like as shown in below image,

enter image description here

I want to change an attribute name from Flavour to Flavour Options but it still shows Flavour at frontend.

enter image description here

I checked further and found on product edit page, under associated products tab, it still showing Flavour and it doesn't use default value. If I use its default value then it works fine and show correct attribute name at frontend. see image--

enter image description here

There are hundreds of products, so I can't change them manually.

How can I use default value for all products for that store or can edit the value of attribute name ?


You can achieve what you want by a single database query.

UPDATE `catalog_product_super_attribute_label` SET `use_default`= 1;

Run this in your database and it will use default value for all of your products attributes.

| improve this answer | |
  • 1
    Thanks Jainam, I have already resolved it before your answering. Thanks once again – Shashank Kumrawat Mar 31 '17 at 5:51
  • But I don't know why it is happening only with one website , while on other website it works without changing in DB. – Shashank Kumrawat Mar 31 '17 at 5:52
  • Did you use the same method or any other method to resolve it? @shashank – Jaimin Sutariya Mar 31 '17 at 5:53
  • Since it didn't work at admin so I did it from DB query. – Shashank Kumrawat Mar 31 '17 at 6:13

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.