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

16 lines
-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Content-match recovery (concat-key -> knoll_catalog dw_sku, existing code, no mint). TK-10900.
UPDATE shopify_products SET dw_sku='DWKN-250638' WHERE shopify_id='gid://shopify/Product/7913023111219' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250645' WHERE shopify_id='gid://shopify/Product/7913025175603' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250647' WHERE shopify_id='gid://shopify/Product/7913025798195' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250641' WHERE shopify_id='gid://shopify/Product/7913023963187' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250639' WHERE shopify_id='gid://shopify/Product/7913023471667' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250643' WHERE shopify_id='gid://shopify/Product/7913024520243' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250646' WHERE shopify_id='gid://shopify/Product/7913025470515' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250642' WHERE shopify_id='gid://shopify/Product/7913024225331' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250649' WHERE shopify_id='gid://shopify/Product/7913026355251' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250648' WHERE shopify_id='gid://shopify/Product/7913026093107' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250637' WHERE shopify_id='gid://shopify/Product/7913022783539' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250640' WHERE shopify_id='gid://shopify/Product/7913023701043' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWKN-250644' WHERE shopify_id='gid://shopify/Product/7913024847923' AND (dw_sku IS NULL OR btrim(dw_sku)='');