← back to Dw Sku Integrity

apply-plans/sancar/apply.sql

44 lines

-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Recovers existing code (no mint). Undo via undo.sql / restore-map.json. TK-10896.
UPDATE shopify_products SET dw_sku='DWSN-345002' WHERE shopify_id='gid://shopify/Product/7787418845235' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345008' WHERE shopify_id='gid://shopify/Product/7787419172915' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345022' WHERE shopify_id='gid://shopify/Product/7787420254259' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345028' WHERE shopify_id='gid://shopify/Product/7787420713011' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345038' WHERE shopify_id='gid://shopify/Product/7787421302835' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345034' WHERE shopify_id='gid://shopify/Product/7787421073459' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345036' WHERE shopify_id='gid://shopify/Product/7787421171763' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345037' WHERE shopify_id='gid://shopify/Product/7787421237299' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345039' WHERE shopify_id='gid://shopify/Product/7787421368371' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345000' WHERE shopify_id='gid://shopify/Product/7787418779699' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345003' WHERE shopify_id='gid://shopify/Product/7787418878003' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345004' WHERE shopify_id='gid://shopify/Product/7787418943539' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345005' WHERE shopify_id='gid://shopify/Product/7787418976307' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345006' WHERE shopify_id='gid://shopify/Product/7787419041843' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345007' WHERE shopify_id='gid://shopify/Product/7787419107379' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345009' WHERE shopify_id='gid://shopify/Product/7787419369523' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345011' WHERE shopify_id='gid://shopify/Product/7787419467827' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345013' WHERE shopify_id='gid://shopify/Product/7787419566131' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345014' WHERE shopify_id='gid://shopify/Product/7787419697203' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345016' WHERE shopify_id='gid://shopify/Product/7787419828275' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345017' WHERE shopify_id='gid://shopify/Product/7787419926579' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345020' WHERE shopify_id='gid://shopify/Product/7787420057651' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345021' WHERE shopify_id='gid://shopify/Product/7787420123187' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345023' WHERE shopify_id='gid://shopify/Product/7787420352563' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345025' WHERE shopify_id='gid://shopify/Product/7787420483635' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345026' WHERE shopify_id='gid://shopify/Product/7787420516403' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345029' WHERE shopify_id='gid://shopify/Product/7787420811315' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345031' WHERE shopify_id='gid://shopify/Product/7787420942387' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345032' WHERE shopify_id='gid://shopify/Product/7787420975155' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345001' WHERE shopify_id='gid://shopify/Product/7787418812467' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345018' WHERE shopify_id='gid://shopify/Product/7787419959347' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345010' WHERE shopify_id='gid://shopify/Product/7787419435059' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345012' WHERE shopify_id='gid://shopify/Product/7787419533363' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345015' WHERE shopify_id='gid://shopify/Product/7787419762739' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345019' WHERE shopify_id='gid://shopify/Product/7787420024883' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345024' WHERE shopify_id='gid://shopify/Product/7787420418099' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345027' WHERE shopify_id='gid://shopify/Product/7787420581939' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345030' WHERE shopify_id='gid://shopify/Product/7787420876851' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345033' WHERE shopify_id='gid://shopify/Product/7787421040691' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345035' WHERE shopify_id='gid://shopify/Product/7787421138995' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWSN-345040' WHERE shopify_id='gid://shopify/Product/7787421466675' AND (dw_sku IS NULL OR btrim(dw_sku)='');