`apply-plans-content-match/Romo/apply.sql`

13 lines
-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Content-match recovery (concat-key -> romo_catalog dw_sku, existing code, no mint). TK-10900.
UPDATE shopify_products SET dw_sku='DWRM-241256' WHERE shopify_id='gid://shopify/Product/7911498383411' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-241249' WHERE shopify_id='gid://shopify/Product/7911497924659' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-240509' WHERE shopify_id='gid://shopify/Product/7911498121267' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-241252' WHERE shopify_id='gid://shopify/Product/7911498252339' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-240614' WHERE shopify_id='gid://shopify/Product/7911498481715' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-240437' WHERE shopify_id='gid://shopify/Product/7911498547251' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-241257' WHERE shopify_id='gid://shopify/Product/7911498580019' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-240605' WHERE shopify_id='gid://shopify/Product/7911498448947' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-240706' WHERE shopify_id='gid://shopify/Product/7911498285107' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWRM-240741' WHERE shopify_id='gid://shopify/Product/7911498154035' AND (dw_sku IS NULL OR btrim(dw_sku)='');