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 ?

1 Answer 1


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.

  • 1
    Thanks Jainam, I have already resolved it before your answering. Thanks once again Mar 31, 2017 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. Mar 31, 2017 at 5:52
  • Did you use the same method or any other method to resolve it? @shashank Mar 31, 2017 at 5:53
  • Since it didn't work at admin so I did it from DB query. Mar 31, 2017 at 6:13

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.