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*/;