`novasuede-recon-20260826/novasuede_conflicts_APPLY_20260826.sql`

39 lines
-- GATE 1 APPROVED by Steve 2026-08-26: adopt authoritative novasuede.com codes for 32 mis-scraped conflicts
-- novasuede_catalog (Mac2-canonical staging). Reversible via novasuede_conflicts_RESTORE_20260826.sql
-- Blast radius: 32 rows.

BEGIN;
UPDATE novasuede_catalog SET mfr_sku='T3P6W' WHERE sku='novasuede™-pistachio' AND mfr_sku='T3POW';
UPDATE novasuede_catalog SET mfr_sku='T3K3W' WHERE sku='novasuede™-putty' AND mfr_sku='T3DFW';
UPDATE novasuede_catalog SET mfr_sku='T3D5W' WHERE sku='novasuede™-raffia' AND mfr_sku='T3DCW';
UPDATE novasuede_catalog SET mfr_sku='T3F7W' WHERE sku='novasuede™-sable' AND mfr_sku='T3I8W';
UPDATE novasuede_catalog SET mfr_sku='T3E7W' WHERE sku='novasuede™-safari' AND mfr_sku='T3D8W';
UPDATE novasuede_catalog SET mfr_sku='T3O2W' WHERE sku='novasuede™-saffron' AND mfr_sku='T3DGW';
UPDATE novasuede_catalog SET mfr_sku='T3P3W' WHERE sku='novasuede™-sage' AND mfr_sku='T3PGW';
UPDATE novasuede_catalog SET mfr_sku='T3D8W' WHERE sku='novasuede™-sand' AND mfr_sku='T3E1W';
UPDATE novasuede_catalog SET mfr_sku='T3F5W' WHERE sku='novasuede™-sandalwood' AND mfr_sku='T3R8W';
UPDATE novasuede_catalog SET mfr_sku='T3R5W' WHERE sku='novasuede™-scarlet-wine' AND mfr_sku='T3J8W';
UPDATE novasuede_catalog SET mfr_sku='T3LBW' WHERE sku='novasuede™-steel' AND mfr_sku='T3LDW';
UPDATE novasuede_catalog SET mfr_sku='T3DCW' WHERE sku='novasuede™-straw' AND mfr_sku='T3O2W';
UPDATE novasuede_catalog SET mfr_sku='T3DAW' WHERE sku='novasuede™-strong-white' AND mfr_sku='T3B1W';
UPDATE novasuede_catalog SET mfr_sku='T3S7W' WHERE sku='novasuede™-sugar-plum' AND mfr_sku='T3J3W';
UPDATE novasuede_catalog SET mfr_sku='T3S1W' WHERE sku='novasuede™-sweet-lilac' AND mfr_sku='T3T1W';
UPDATE novasuede_catalog SET mfr_sku='T3E1W' WHERE sku='novasuede™-tan' AND mfr_sku='T3E7W';
UPDATE novasuede_catalog SET mfr_sku='T3PGW' WHERE sku='novasuede™-tarragon' AND mfr_sku='T3PNW';
UPDATE novasuede_catalog SET mfr_sku='T3K9W' WHERE sku='novasuede™-taupe' AND mfr_sku='T3K3W';
UPDATE novasuede_catalog SET mfr_sku='T3PDW' WHERE sku='novasuede™-thyme' AND mfr_sku='T3PBW';
UPDATE novasuede_catalog SET mfr_sku='T3F2W' WHERE sku='novasuede™-trench' AND mfr_sku='T3L9W';
UPDATE novasuede_catalog SET mfr_sku='T315W' WHERE sku='novasuede™-cocoa' AND mfr_sku='T3I5W';
UPDATE novasuede_catalog SET mfr_sku='T3BLW' WHERE sku='novasuede™-black' AND mfr_sku='T3A1W';
UPDATE novasuede_catalog SET mfr_sku='T3S4W' WHERE sku='novasuede™-royal-purple' AND mfr_sku='T3S1W';
UPDATE novasuede_catalog SET mfr_sku='T3P2W' WHERE sku='novasuede™-sea-grass' AND mfr_sku='T3L8W';
UPDATE novasuede_catalog SET mfr_sku='T3Q7W' WHERE sku='novasuede™-sienna' AND mfr_sku='T3F7W';
UPDATE novasuede_catalog SET mfr_sku='T3L5W' WHERE sku='novasuede™-smoke' AND mfr_sku='T3K5W';
UPDATE novasuede_catalog SET mfr_sku='T3K7W' WHERE sku='novasuede™-soft-clay' AND mfr_sku='T3R5W';
UPDATE novasuede_catalog SET mfr_sku='T3N3W' WHERE sku='novasuede™-seafoam' AND mfr_sku='T3P2W';
UPDATE novasuede_catalog SET mfr_sku='T3R6W' WHERE sku='novasuede™-ruby' AND mfr_sku='T3J9W';
UPDATE novasuede_catalog SET mfr_sku='T3DBW' WHERE sku='novasuede™-salt' AND mfr_sku='T3DRW';
UPDATE novasuede_catalog SET mfr_sku='T3N5W' WHERE sku='novasuede™-sky-blue' AND mfr_sku='T3N3W';
UPDATE novasuede_catalog SET mfr_sku='T3LHW' WHERE sku='novasuede™-storm' AND mfr_sku='T3LJW';
COMMIT;