← back to Dw Sku Integrity

apply-plans-content-match/Thibaut/apply.sql

64 lines

-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Content-match recovery (concat-key -> thibaut_catalog dw_sku, existing code, no mint). TK-10900.
UPDATE shopify_products SET dw_sku='DWTT-74442' WHERE shopify_id='gid://shopify/Product/7896955256883' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74444' WHERE shopify_id='gid://shopify/Product/7896955322419' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74503' WHERE shopify_id='gid://shopify/Product/7897527058483' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74490' WHERE shopify_id='gid://shopify/Product/7897371836467' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74508' WHERE shopify_id='gid://shopify/Product/7897544622131' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74485' WHERE shopify_id='gid://shopify/Product/7897341329459' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74458' WHERE shopify_id='gid://shopify/Product/7897159532595' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74447' WHERE shopify_id='gid://shopify/Product/7896995659827' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74491' WHERE shopify_id='gid://shopify/Product/7897395658803' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74487' WHERE shopify_id='gid://shopify/Product/7897341394995' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74500' WHERE shopify_id='gid://shopify/Product/7897505005619' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74468' WHERE shopify_id='gid://shopify/Product/7897245220915' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74553' WHERE shopify_id='gid://shopify/Product/7899158904883' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74489' WHERE shopify_id='gid://shopify/Product/7897371803699' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74502' WHERE shopify_id='gid://shopify/Product/7897505103923' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74560' WHERE shopify_id='gid://shopify/Product/7899386675251' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74462' WHERE shopify_id='gid://shopify/Product/7897169330227' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74464' WHERE shopify_id='gid://shopify/Product/7897196003379' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74497' WHERE shopify_id='gid://shopify/Product/7897418203187' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74495' WHERE shopify_id='gid://shopify/Product/7897407160371' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74558' WHERE shopify_id='gid://shopify/Product/7899374583859' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74483' WHERE shopify_id='gid://shopify/Product/7897331466291' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74564' WHERE shopify_id='gid://shopify/Product/7899471937587' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74552' WHERE shopify_id='gid://shopify/Product/7899158806579' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74505' WHERE shopify_id='gid://shopify/Product/7897527156787' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74438' WHERE shopify_id='gid://shopify/Product/7896929337395' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74501' WHERE shopify_id='gid://shopify/Product/7897505071155' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74448' WHERE shopify_id='gid://shopify/Product/7897015058483' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74561' WHERE shopify_id='gid://shopify/Product/7899386708019' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74446' WHERE shopify_id='gid://shopify/Product/7896995627059' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74493' WHERE shopify_id='gid://shopify/Product/7897395724339' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74555' WHERE shopify_id='gid://shopify/Product/7899330576435' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74504' WHERE shopify_id='gid://shopify/Product/7897527091251' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74443' WHERE shopify_id='gid://shopify/Product/7896955289651' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74506' WHERE shopify_id='gid://shopify/Product/7897544556595' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74482' WHERE shopify_id='gid://shopify/Product/7897331433523' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74440' WHERE shopify_id='gid://shopify/Product/7896943820851' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74484' WHERE shopify_id='gid://shopify/Product/7897331531827' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74556' WHERE shopify_id='gid://shopify/Product/7899330707507' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74449' WHERE shopify_id='gid://shopify/Product/7897015091251' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74562' WHERE shopify_id='gid://shopify/Product/7899386740787' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74492' WHERE shopify_id='gid://shopify/Product/7897395691571' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74480' WHERE shopify_id='gid://shopify/Product/7897310724147' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74510' WHERE shopify_id='gid://shopify/Product/7897619693619' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74551' WHERE shopify_id='gid://shopify/Product/7899158642739' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74557' WHERE shopify_id='gid://shopify/Product/7899374551091' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74507' WHERE shopify_id='gid://shopify/Product/7897544589363' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74460' WHERE shopify_id='gid://shopify/Product/7897169264691' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74488' WHERE shopify_id='gid://shopify/Product/7897371770931' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74461' WHERE shopify_id='gid://shopify/Product/7897169297459' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74498' WHERE shopify_id='gid://shopify/Product/7897418235955' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74554' WHERE shopify_id='gid://shopify/Product/7899330379827' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74467' WHERE shopify_id='gid://shopify/Product/7897245188147' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74559' WHERE shopify_id='gid://shopify/Product/7899374649395' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74494' WHERE shopify_id='gid://shopify/Product/7897407127603' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74481' WHERE shopify_id='gid://shopify/Product/7897310756915' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74465' WHERE shopify_id='gid://shopify/Product/7897196068915' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74496' WHERE shopify_id='gid://shopify/Product/7897407193139' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74499' WHERE shopify_id='gid://shopify/Product/7897418268723' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74509' WHERE shopify_id='gid://shopify/Product/7897619660851' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWTT-74463' WHERE shopify_id='gid://shopify/Product/7897195970611' AND (dw_sku IS NULL OR btrim(dw_sku)='');