To support our customers during COVID-19 pandemic, we had introduced many
offers and discounts
to help your ecommerce businesses. Learn more

Magento 2 check "Use Default Value" checkbox for store view

Magento 2 check "Use Default Value" checkbox for store view

Important: Take a backup of the database before do this.

Run below queries to your database to check the checkbox of "Use Default Value" for all the fields of product.

delete from catalog_product_entity_int where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_decimal where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_text where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_datetime where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_varchar where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_int where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_media_gallery_value where IFNULL(store_id, 0) <> 0;


Run below queries to your database to check the checkbox of "Use Default Value" for all the fields of category.
delete from catalog_category_entity_varchar where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_text where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_int where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_decimal where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_datetime where IFNULL(store_id, 0) <> 0;

After running all the above queries you can see the checkbox of all the fields of products and categories have been checked.

November 13, 2019
Did you like this post?
0
0