`apply-plans-content-match/Pierre Frey/apply.sql`

7 lines
-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Content-match recovery (concat-key -> pierre_frey_catalog dw_sku, existing code, no mint). TK-10900.
UPDATE shopify_products SET dw_sku='DWPF-606177' WHERE shopify_id='gid://shopify/Product/7878219595827' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWPF-606507' WHERE shopify_id='gid://shopify/Product/7878240698419' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWPF-606502' WHERE shopify_id='gid://shopify/Product/7878240763955' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWPF-606166' WHERE shopify_id='gid://shopify/Product/7878219628595' AND (dw_sku IS NULL OR btrim(dw_sku)='');