1

"Use Default Value" in standard is selected for all stores view.

In products --> Catalog I can switch store view example from default store view to English and then edit product and then in description uncheck "Use Default Value".

In single product I can switch store view: enter image description here

and then uncheck: enter image description here

But for above 11k products take more time. Any one know how to uncheck for all products description in one time?

@UPDATE

I will checked in database catalog_product_entity and then try edit sample product.

After this I see only value: enter image description here

@update2: enter image description here

Improve this question
10
  • do you want to keep the default value as it is for another store?
    – Satish Dubariya
    Commented Feb 6, 2019 at 9:43
  • I want to uncheck "Use default value" on short description for all store view
    – Sylvester
    Commented Feb 6, 2019 at 9:54
  • in that case you can select all rows where attribute_id=<attribute_id of short_description> and store_id=0 in catalog_product_entity_text table and re insert all those row in same table with store_id=<another store id>. because magento will checked Use default value checkbox if there is no store wise entry for specific attribute. if magento will get any value for specific store of specific attribute then Use default value checkbox will be unchecked. Take db or table backup before action this and also try only for one product first.
    – Satish Dubariya
    Commented Feb 6, 2019 at 10:05
  • Satish, can you please check my update? I edit sample product in table catalog_product_entity_text and I see this field you write. But what next?
    – Sylvester
    Commented Feb 6, 2019 at 10:12
  • You dont need to update the row, you have to insert the row with same value again with different store id, and the you can check that product in that store for which you inserted row. prnt.sc/mhby7k prnt.sc/mhbzhp
    – Satish Dubariya
    Commented Feb 6, 2019 at 10:16

2 Answers 2

Reset to default
1

I would suggest a DB-query for this.

Delete the values in catalog_product_entity_XXX for the given attribute and store-id.

XXX stands for the data-type of your attribute.

Improve this answer
2
  • Can you please check my update?
    – Sylvester
    Commented Feb 6, 2019 at 9:21
  • I did and I don't understand hat the problem is. there is no actual checkbox. it just the entries in the DB
    – Philipp Sander
    Commented Feb 6, 2019 at 12:25
0

Check you store id , go to mysql database search for stock with your number , and write sql query that update table ( just delete value 1 ) It will be very fast way.

Improve this answer

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.