7

I have around 1260 categories.If i switch the store view , the all attributes have own value.But i want to set the all attribute values as parent main store view value. I can not open each category and checked the Use Default Value checkbox. So can you give me any hint how can i checked this checkbox using programmatically or sql Query.

Please see this screenshot.!

enter image description here

4

For categories i ran the following query and it worked.

DELETE FROM `catalog_category_entity_text` where store_id = 1;
DELETE FROM `catalog_category_entity_datetime` where store_id = 1;
DELETE FROM `catalog_category_entity_decimal` where store_id = 1;
DELETE FROM `catalog_category_entity_int` where store_id = 1;
DELETE FROM `catalog_category_entity_varchar` where store_id = 1;
  • 1
    Great!! it works for me. Thanks.. Keep it up bro – Sunny Rahevar Dec 3 '18 at 11:15
1

You need to change in database OR create PHP script to update database value.

  • Can you please explain me in brief? – Sunny Rahevar Dec 3 '18 at 9:29
  • 1
    Yes, you need to create PHP script for update values for all categories in Database. – Ronak Dec 3 '18 at 9:30
0

I do not see the Use Default checkbox at all! On several platforms running 2.1.16 there is no checkbox to restore the Default values. In the Release notes I can't find anything about it. What Magento version were you running in the screenshot?

  • Thanks for your answer.! I have solved issue. jaimin's answer is working for me. – Sunny Rahevar Jan 8 at 5:47

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.