← back to Mfr Recovery 2026 08 23
TK-10829 Gate 1 (Steve-approved): adopt-live for 32 mis-scraped novasuede_catalog codes + restore-map
e08f75efb758fa60559c742d1a9bd15036493ab4 · 2026-08-26 12:00:07 -0700 · Steve Abrams
Files touched
A novasuede-recon-20260826/novasuede_conflicts_APPLY_20260826.sqlA novasuede-recon-20260826/novasuede_conflicts_RESTORE_20260826.sqlA novasuede-recon-20260826/novasuede_conflicts_restore_map_20260826.json
Diff
commit e08f75efb758fa60559c742d1a9bd15036493ab4
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Wed Aug 26 12:00:07 2026 -0700
TK-10829 Gate 1 (Steve-approved): adopt-live for 32 mis-scraped novasuede_catalog codes + restore-map
---
.../novasuede_conflicts_APPLY_20260826.sql | 38 ++++++
.../novasuede_conflicts_RESTORE_20260826.sql | 35 ++++++
.../novasuede_conflicts_restore_map_20260826.json | 135 +++++++++++++++++++++
3 files changed, 208 insertions(+)
diff --git a/novasuede-recon-20260826/novasuede_conflicts_APPLY_20260826.sql b/novasuede-recon-20260826/novasuede_conflicts_APPLY_20260826.sql
new file mode 100644
index 0000000..d284e73
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_conflicts_APPLY_20260826.sql
@@ -0,0 +1,38 @@
+-- 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;
diff --git a/novasuede-recon-20260826/novasuede_conflicts_RESTORE_20260826.sql b/novasuede-recon-20260826/novasuede_conflicts_RESTORE_20260826.sql
new file mode 100644
index 0000000..db21770
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_conflicts_RESTORE_20260826.sql
@@ -0,0 +1,35 @@
+-- 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;
diff --git a/novasuede-recon-20260826/novasuede_conflicts_restore_map_20260826.json b/novasuede-recon-20260826/novasuede_conflicts_restore_map_20260826.json
new file mode 100644
index 0000000..3c325fd
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_conflicts_restore_map_20260826.json
@@ -0,0 +1,135 @@
+{
+ "table": "novasuede_catalog",
+ "key": "sku",
+ "column": "mfr_sku",
+ "restore": [
+ {
+ "sku": "novasuede™-pistachio",
+ "old_mfr_sku": "T3POW"
+ },
+ {
+ "sku": "novasuede™-putty",
+ "old_mfr_sku": "T3DFW"
+ },
+ {
+ "sku": "novasuede™-raffia",
+ "old_mfr_sku": "T3DCW"
+ },
+ {
+ "sku": "novasuede™-sable",
+ "old_mfr_sku": "T3I8W"
+ },
+ {
+ "sku": "novasuede™-safari",
+ "old_mfr_sku": "T3D8W"
+ },
+ {
+ "sku": "novasuede™-saffron",
+ "old_mfr_sku": "T3DGW"
+ },
+ {
+ "sku": "novasuede™-sage",
+ "old_mfr_sku": "T3PGW"
+ },
+ {
+ "sku": "novasuede™-sand",
+ "old_mfr_sku": "T3E1W"
+ },
+ {
+ "sku": "novasuede™-sandalwood",
+ "old_mfr_sku": "T3R8W"
+ },
+ {
+ "sku": "novasuede™-scarlet-wine",
+ "old_mfr_sku": "T3J8W"
+ },
+ {
+ "sku": "novasuede™-steel",
+ "old_mfr_sku": "T3LDW"
+ },
+ {
+ "sku": "novasuede™-straw",
+ "old_mfr_sku": "T3O2W"
+ },
+ {
+ "sku": "novasuede™-strong-white",
+ "old_mfr_sku": "T3B1W"
+ },
+ {
+ "sku": "novasuede™-sugar-plum",
+ "old_mfr_sku": "T3J3W"
+ },
+ {
+ "sku": "novasuede™-sweet-lilac",
+ "old_mfr_sku": "T3T1W"
+ },
+ {
+ "sku": "novasuede™-tan",
+ "old_mfr_sku": "T3E7W"
+ },
+ {
+ "sku": "novasuede™-tarragon",
+ "old_mfr_sku": "T3PNW"
+ },
+ {
+ "sku": "novasuede™-taupe",
+ "old_mfr_sku": "T3K3W"
+ },
+ {
+ "sku": "novasuede™-thyme",
+ "old_mfr_sku": "T3PBW"
+ },
+ {
+ "sku": "novasuede™-trench",
+ "old_mfr_sku": "T3L9W"
+ },
+ {
+ "sku": "novasuede™-cocoa",
+ "old_mfr_sku": "T3I5W"
+ },
+ {
+ "sku": "novasuede™-black",
+ "old_mfr_sku": "T3A1W"
+ },
+ {
+ "sku": "novasuede™-royal-purple",
+ "old_mfr_sku": "T3S1W"
+ },
+ {
+ "sku": "novasuede™-sea-grass",
+ "old_mfr_sku": "T3L8W"
+ },
+ {
+ "sku": "novasuede™-sienna",
+ "old_mfr_sku": "T3F7W"
+ },
+ {
+ "sku": "novasuede™-smoke",
+ "old_mfr_sku": "T3K5W"
+ },
+ {
+ "sku": "novasuede™-soft-clay",
+ "old_mfr_sku": "T3R5W"
+ },
+ {
+ "sku": "novasuede™-seafoam",
+ "old_mfr_sku": "T3P2W"
+ },
+ {
+ "sku": "novasuede™-ruby",
+ "old_mfr_sku": "T3J9W"
+ },
+ {
+ "sku": "novasuede™-salt",
+ "old_mfr_sku": "T3DRW"
+ },
+ {
+ "sku": "novasuede™-sky-blue",
+ "old_mfr_sku": "T3N3W"
+ },
+ {
+ "sku": "novasuede™-storm",
+ "old_mfr_sku": "T3LJW"
+ }
+ ]
+}
\ No newline at end of file
← ed86664 TK-10829 Novasuede mfr recovery: authoritative novasuede.com
·
back to Mfr Recovery 2026 08 23
·
TK-10827: fix Novasuede join-key bug in mfr push (nc.sku=han 25fe485 →