`zoffany_durable_apply.sql`

48 lines
-- DURABLE Zoffany mfr_sku recovery — TK-10677 — generated 2026-08-25
-- Runs identically on Kamatera-canonical dw_unified AND the Mac2 mirror.
-- IDEMPOTENT + GUARDED: only fills rows that are still null/empty, only these 24 handles, only ACTIVE Zoffany.
-- A re-run after success updates 0 rows. Reversible via zoffany_restore.sql.
BEGIN;

WITH recover(handle, mfr_sku) AS (
  VALUES
    ('watered-silk-antique-bronze-dwzf-187023', 'ZRHW312914'),
    ('spark-310993-sapphire-dwzf-187024', 'ZQUA310993'),
    ('kensington-grasscloth-mineral-dwzf-187027', 'ZHIW313004'),
    ('abstract-1928-taupe-dwzf-187029', 'ZRHW312889'),
    ('watered-silk-platinum-grey-dwzf-187032', 'ZRHW312916'),
    ('persian-tulip-blue-stone-dwzf-187034', 'ZHIW312997'),
    ('ormonde-stripe-la-seine-dwzf-187041', 'ZFOW312941'),
    ('ormonde-stripe-mushroom-dwzf-187042', 'ZFOW312943'),
    ('eleonora-dwzf-187049', 'ZGUV08004'),
    ('abstract-1928-mineral-dwzf-187011', 'ZRHW312890'),
    ('conway-sahara-dwzf-187003', 'ZTOT312747'),
    ('hawksmoor-antique-bronze-dwzf-187007', 'ZPHA312595'),
    ('persian-tulip-poison-dwzf-187001', 'ZHIW312996'),
    ('shagreen-como-blue-dwzf-187012', 'ZRHW312906'),
    ('shagreen-oyster-dwzf-187006', 'ZRHW312910'),
    ('shagreen-zinc-dwzf-187000', 'ZRHW312907'),
    ('spun-silk-antique-copper-dwzf-187004', 'ZRHW312899'),
    ('weathered-stone-plain-bluestone-dwzf-187005', 'ZKEM312641'),
    ('guinea-blue-stone-dwzf-187016', 'ZKEM312648'),
    ('kensington-grasscloth-paris-grey-dwzf-187021', 'ZHIW313003'),
    ('moresque-glaze-indigo-dwzf-187019', 'ZHIW312994'),
    ('persian-tulip-quartz-grey-dwzf-187015', 'ZHIW312995'),
    ('spun-silk-antique-bronze-dwzf-187014', 'ZRHW312897'),
    ('spun-silk-paris-grey-dwzf-187017', 'ZRHW312903')
)
UPDATE shopify_products sp
SET    mfr_sku = r.mfr_sku
FROM   recover r
WHERE  sp.handle = r.handle
  AND  sp.vendor = 'Zoffany'
  AND  sp.status = 'ACTIVE'
  AND  (sp.mfr_sku IS NULL OR sp.mfr_sku = '');

-- verify: how many of the 24 target handles now carry their mfr code
SELECT count(*) AS zoffany_with_mfr_now
FROM   shopify_products
WHERE  vendor='Zoffany' AND status='ACTIVE' AND mfr_sku IN ('ZRHW312914','ZQUA310993','ZHIW313004','ZRHW312889','ZRHW312916','ZHIW312997','ZFOW312941','ZFOW312943','ZGUV08004','ZRHW312890','ZTOT312747','ZPHA312595','ZHIW312996','ZRHW312906','ZRHW312910','ZRHW312907','ZRHW312899','ZKEM312641','ZKEM312648','ZHIW313003','ZHIW312994','ZHIW312995','ZRHW312897','ZRHW312903');

COMMIT;