`apply-plans-staging-link/China Seas/apply.sql`

32 lines
-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Staging-link recovery: mfr_sku -> catalog dw_sku (existing code, no mint). TK-10896.
UPDATE shopify_products SET dw_sku='DWCH-510616' WHERE shopify_id='gid://shopify/Product/6604508037171' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510626' WHERE shopify_id='gid://shopify/Product/6604508758067' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510615' WHERE shopify_id='gid://shopify/Product/6604508004403' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510601' WHERE shopify_id='gid://shopify/Product/6604507185203' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510617' WHERE shopify_id='gid://shopify/Product/6604508069939' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510607' WHERE shopify_id='gid://shopify/Product/6604507381811' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510606' WHERE shopify_id='gid://shopify/Product/6604507349043' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510610' WHERE shopify_id='gid://shopify/Product/6604507840563' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510624' WHERE shopify_id='gid://shopify/Product/6604508659763' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510599' WHERE shopify_id='gid://shopify/Product/6604507119667' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510608' WHERE shopify_id='gid://shopify/Product/6604507414579' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510609' WHERE shopify_id='gid://shopify/Product/6604507807795' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510628' WHERE shopify_id='gid://shopify/Product/6604508823603' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510621' WHERE shopify_id='gid://shopify/Product/6604508561459' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510611' WHERE shopify_id='gid://shopify/Product/6604507873331' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510604' WHERE shopify_id='gid://shopify/Product/6604507283507' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510612' WHERE shopify_id='gid://shopify/Product/6604507906099' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510605' WHERE shopify_id='gid://shopify/Product/6604507316275' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510623' WHERE shopify_id='gid://shopify/Product/6604508626995' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510614' WHERE shopify_id='gid://shopify/Product/6604507971635' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510622' WHERE shopify_id='gid://shopify/Product/6604508594227' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510619' WHERE shopify_id='gid://shopify/Product/6604508495923' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510627' WHERE shopify_id='gid://shopify/Product/6604508790835' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510603' WHERE shopify_id='gid://shopify/Product/6604507250739' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510625' WHERE shopify_id='gid://shopify/Product/6604508692531' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510620' WHERE shopify_id='gid://shopify/Product/6604508528691' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510600' WHERE shopify_id='gid://shopify/Product/6604507152435' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510613' WHERE shopify_id='gid://shopify/Product/6604507938867' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510602' WHERE shopify_id='gid://shopify/Product/6604507217971' AND (dw_sku IS NULL OR btrim(dw_sku)='');