Magento 2 – Set Use Default Value for All Categories Attributes

categorycategory-attributemagento2

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.!

Best Answer

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;

Related Solutions

Magento2 Use Default Value Setting – Where to Check

If you want all products have checked Use Default value then run below sql in database:

DELETE FROM `catalog_product_entity_text` where store_id = 1;
DELETE FROM `catalog_product_entity_datetime` where store_id = 1;
DELETE FROM `catalog_product_entity_decimal` where store_id = 1;
DELETE FROM `catalog_product_entity_int` where store_id = 1;
DELETE FROM `catalog_product_entity_varchar` where store_id = 1;

In example code store ID 1 is ID of store. You need to check ID's of all store-views in admin and run the above code for each store-views.

PS: Make sure you take backup of database before sql query.

Magento 2 ImportExport – Set All Product Infos to ‘Use Default Value’

To achieve this, you have to change attribute scope to global when import the product using CSV.

Please refer below image for changing the scope of the attribute

Best Answer

Related Solutions

Magento2 Use Default Value Setting – Where to Check

Magento 2 ImportExport – Set All Product Infos to ‘Use Default Value’

Related Topic