Rixxo Support

Sometime when using import tools such as Mag Manager you can accidently set different data for different store views.

Assuming that your Default Store View id is 0 this SQL will reset all products back to Use Default Store View in Magento 2

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

If you are using Mag Manager and wish to use the Custom SQL feature and save this for future use you can use

/* This SQL block may be executed to reset the product data back to the Use Default Store View setting   */
/* Please note that this SQL block must be modified manually according to your database specifics to work properly. */ 

DELETE FROM /*PREFIX*/catalog_product_entity_text WHERE store_id <> /*DEF_STORE_ID*/;
DELETE FROM /*PREFIX*/catalog_product_entity_datetime WHERE store_id <> /*DEF_STORE_ID*/;
DELETE FROM /*PREFIX*/catalog_product_entity_decimal WHERE store_id <> /*DEF_STORE_ID*/;
DELETE FROM /*PREFIX*/catalog_product_entity_int WHERE store_id <> /*DEF_STORE_ID*/;
DELETE FROM /*PREFIX*/catalog_product_entity_varchar WHERE store_id <> /*DEF_STORE_ID*/;