← back to Mfr Recovery 2026 08 23

zoffany_restore.sql

8 lines

-- REVERSIBLE UNDO for the durable Zoffany mfr recovery — TK-10677
-- Sets the 24 recovered mfr_sku back to '' (only rows that currently hold exactly these codes).
BEGIN;
UPDATE shopify_products
SET    mfr_sku = ''
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;