Magento 2 – Remove All Product Attributes at View Level

magento2product-attributeproducts

I have been working on fixing the product attributes that were imported via CSV files. I noticed that somehow the importers fill in attributes on the store view level, which means the change I made to the All Store Views will not be affecting until I manually go through the Default Store View and set each applicable to fall back to the Default Value.

Is there a way to just remove all of them (via MySQL or code or admin UI)?

Best Answer

the attribute values are kept in the tables catalog_product_entity_* where * can be int, varchar, text, datetime, decimal.
All the default values have the field store_id = 0 and the store view values have store_id the actual store id that is > 0.

So you can delete all the values from these tables where store_id is not 0.

DELETE FROM catalog_product_entity_int WHERE store_id <> 0;
DELETE FROM catalog_product_entity_varchar WHERE store_id <> 0;
DELETE FROM catalog_product_entity_text WHERE store_id <> 0;
DELETE FROM catalog_product_entity_decimal WHERE store_id <> 0;
DELETE FROM catalog_product_entity_datetime WHERE store_id <> 0;

But backup your db just to be safe.

Related Solutions

Magento2 Product Attribute – Fix Global Product Attribute Empty on Store View Level

Here is a quick fix.
you need to identify the attribute ids for all global attributes then delete all the values from the catalog_product_entity_* tables that have the attribute id one of those identified above and the store id field not zero.

DELETE FROM `catalog_product_entity_int` 
WHERE
   store_id <> 0 AND
   attribute_id IN (
           SELECT attribute_id 
           FROM catalog_eav_attribute 
           WHERE is_global = 1

   )

Do the same for the tables catalog_product_entity_varchar, catalog_product_entity_text, catalog_product_entity_datetime, catalog_product_entity_decimal.

Rebuild your indexes when your are done.

Note: The select from catalog_eav_attribute in the way I wrote it will give you attribute ids for the global category attributes also, but that's not important since in the product tables you don't have category attributes references.

Also, before trying this, backup your database in case I missed something.

Magento 2: Change Store View in Admin Product List

There is a filter for product list in admin. When you select the store view to the filter it shows the data saved for that store view.

Best Answer

Related Solutions

Magento2 Product Attribute – Fix Global Product Attribute Empty on Store View Level

Magento 2: Change Store View in Admin Product List

Related Topic