Last Updated: August 20, 2016
·
202
· sivaschenko

Magento. Merge product attributes data from store to store

insert into catalog_product_entity_varchar (entity_id, store_id, attribute_id, value)
select entity_id, 0, attribute_id, value from catalog_product_entity_varchar tbl where store_id = 1
on duplicate key update value = tbl.value;