I was thinking somewhere along the lines of:
DELETE FROM catalog_product_entity_decimal WHERE entity_id IN ( SELECT entity_id FROM catalog_product_entity_decimal WHERE store_id = 3 ); DELETE FROM catalog_product_entity_int WHERE entity_id IN ( SELECT entity_id FROM catalog_product_entity_int WHERE store_id = 3 ); DELETE FROM catalog_product_entity_text WHERE entity_id IN ( SELECT entity_id FROM catalog_product_entity_text WHERE store_id = 3 ); DELETE FROM catalog_product_entity_varchar WHERE entity_id IN ( SELECT entity_id FROM catalog_product_entity_varchar WHERE store_id = 3 ); DELETE FROM catalog_product_entity_datetime WHERE entity_id IN ( SELECT entity_id FROM catalog_product_entity_datetime WHERE store_id = 3 );
Do any of you propose a less volatile method? TIA.
submitted by /u/detectretract
[link] [comments]