← back to Mfr Recovery 2026 08 23

novasuede-recon-20260826/novasuede_conflicts_RESTORE_20260826.sql

36 lines

-- ROLLBACK Gate 1: restore pre-adopt catalog codes
BEGIN;
UPDATE novasuede_catalog SET mfr_sku='T3POW' WHERE sku='novasuede™-pistachio';
UPDATE novasuede_catalog SET mfr_sku='T3DFW' WHERE sku='novasuede™-putty';
UPDATE novasuede_catalog SET mfr_sku='T3DCW' WHERE sku='novasuede™-raffia';
UPDATE novasuede_catalog SET mfr_sku='T3I8W' WHERE sku='novasuede™-sable';
UPDATE novasuede_catalog SET mfr_sku='T3D8W' WHERE sku='novasuede™-safari';
UPDATE novasuede_catalog SET mfr_sku='T3DGW' WHERE sku='novasuede™-saffron';
UPDATE novasuede_catalog SET mfr_sku='T3PGW' WHERE sku='novasuede™-sage';
UPDATE novasuede_catalog SET mfr_sku='T3E1W' WHERE sku='novasuede™-sand';
UPDATE novasuede_catalog SET mfr_sku='T3R8W' WHERE sku='novasuede™-sandalwood';
UPDATE novasuede_catalog SET mfr_sku='T3J8W' WHERE sku='novasuede™-scarlet-wine';
UPDATE novasuede_catalog SET mfr_sku='T3LDW' WHERE sku='novasuede™-steel';
UPDATE novasuede_catalog SET mfr_sku='T3O2W' WHERE sku='novasuede™-straw';
UPDATE novasuede_catalog SET mfr_sku='T3B1W' WHERE sku='novasuede™-strong-white';
UPDATE novasuede_catalog SET mfr_sku='T3J3W' WHERE sku='novasuede™-sugar-plum';
UPDATE novasuede_catalog SET mfr_sku='T3T1W' WHERE sku='novasuede™-sweet-lilac';
UPDATE novasuede_catalog SET mfr_sku='T3E7W' WHERE sku='novasuede™-tan';
UPDATE novasuede_catalog SET mfr_sku='T3PNW' WHERE sku='novasuede™-tarragon';
UPDATE novasuede_catalog SET mfr_sku='T3K3W' WHERE sku='novasuede™-taupe';
UPDATE novasuede_catalog SET mfr_sku='T3PBW' WHERE sku='novasuede™-thyme';
UPDATE novasuede_catalog SET mfr_sku='T3L9W' WHERE sku='novasuede™-trench';
UPDATE novasuede_catalog SET mfr_sku='T3I5W' WHERE sku='novasuede™-cocoa';
UPDATE novasuede_catalog SET mfr_sku='T3A1W' WHERE sku='novasuede™-black';
UPDATE novasuede_catalog SET mfr_sku='T3S1W' WHERE sku='novasuede™-royal-purple';
UPDATE novasuede_catalog SET mfr_sku='T3L8W' WHERE sku='novasuede™-sea-grass';
UPDATE novasuede_catalog SET mfr_sku='T3F7W' WHERE sku='novasuede™-sienna';
UPDATE novasuede_catalog SET mfr_sku='T3K5W' WHERE sku='novasuede™-smoke';
UPDATE novasuede_catalog SET mfr_sku='T3R5W' WHERE sku='novasuede™-soft-clay';
UPDATE novasuede_catalog SET mfr_sku='T3P2W' WHERE sku='novasuede™-seafoam';
UPDATE novasuede_catalog SET mfr_sku='T3J9W' WHERE sku='novasuede™-ruby';
UPDATE novasuede_catalog SET mfr_sku='T3DRW' WHERE sku='novasuede™-salt';
UPDATE novasuede_catalog SET mfr_sku='T3N3W' WHERE sku='novasuede™-sky-blue';
UPDATE novasuede_catalog SET mfr_sku='T3LJW' WHERE sku='novasuede™-storm';
COMMIT;