← back to Mfr Recovery 2026 08 23
TK-10829 Novasuede mfr recovery: authoritative novasuede.com reconciliation + 20 placeholder staging fixes
ed86664ed32623885292e7a39b52345252522f07 · 2026-08-26 11:34:03 -0700 · Steve Abrams
Files touched
A novasuede-recon-20260826/novasuede_32_conflicts_GATED_20260826.csvA novasuede-recon-20260826/novasuede_live_colors_data_20260826.jsonA novasuede-recon-20260826/novasuede_live_source_namecode_20260826.jsonA novasuede-recon-20260826/novasuede_placeholder_APPLY_20260826.sqlA novasuede-recon-20260826/novasuede_placeholder_RESTORE_20260826.sqlA novasuede-recon-20260826/novasuede_placeholder_restore_map_20260826.jsonA novasuede-recon-20260826/novasuede_reconciliation_20260826.json
Diff
commit ed86664ed32623885292e7a39b52345252522f07
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Wed Aug 26 11:34:03 2026 -0700
TK-10829 Novasuede mfr recovery: authoritative novasuede.com reconciliation + 20 placeholder staging fixes
---
.../novasuede_32_conflicts_GATED_20260826.csv | 33 +
.../novasuede_live_colors_data_20260826.json | 2508 ++++++++++++++++++++
.../novasuede_live_source_namecode_20260826.json | 1 +
.../novasuede_placeholder_APPLY_20260826.sql | 29 +
.../novasuede_placeholder_RESTORE_20260826.sql | 23 +
...novasuede_placeholder_restore_map_20260826.json | 87 +
.../novasuede_reconciliation_20260826.json | 1 +
7 files changed, 2682 insertions(+)
diff --git a/novasuede-recon-20260826/novasuede_32_conflicts_GATED_20260826.csv b/novasuede-recon-20260826/novasuede_32_conflicts_GATED_20260826.csv
new file mode 100644
index 0000000..07fb720
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_32_conflicts_GATED_20260826.csv
@@ -0,0 +1,33 @@
+slug,catalog_code,live_authoritative_code,dw_sku
+pistachio,T3POW,T3P6W,DWNS-970097
+putty,T3DFW,T3K3W,DWNS-970102
+raffia,T3DCW,T3D5W,DWNS-970103
+sable,T3I8W,T3F7W,DWNS-970108
+safari,T3D8W,T3E7W,DWNS-970109
+saffron,T3DGW,T3O2W,DWNS-970110
+sage,T3PGW,T3P3W,DWNS-970111
+sand,T3E1W,T3D8W,DWNS-970113
+sandalwood,T3R8W,T3F5W,DWNS-970114
+scarlet-wine,T3J8W,T3R5W,DWNS-970115
+steel,T3LDW,T3LBW,DWNS-970126
+straw,T3O2W,T3DCW,DWNS-970130
+strong-white,T3B1W,T3DAW,DWNS-970131
+sugar-plum,T3J3W,T3S7W,DWNS-970132
+sweet-lilac,T3T1W,T3S1W,DWNS-970133
+tan,T3E7W,T3E1W,DWNS-970134
+tarragon,T3PNW,T3PGW,DWNS-970135
+taupe,T3K3W,T3K9W,DWNS-970136
+thyme,T3PBW,T3PDW,DWNS-970137
+trench,T3L9W,T3F2W,DWNS-970138
+cocoa,T3I5W,T315W,DWNS-970028
+black,T3A1W,T3BLW,DWNS-970010
+royal-purple,T3S1W,T3S4W,DWNS-970106
+sea-grass,T3L8W,T3P2W,DWNS-970119
+sienna,T3F7W,T3Q7W,DWNS-970120
+smoke,T3K5W,T3L5W,DWNS-970123
+soft-clay,T3R5W,T3K7W,DWNS-970124
+seafoam,T3P2W,T3N3W,DWNS-970118
+ruby,T3J9W,T3R6W,DWNS-970107
+salt,T3DRW,T3DBW,DWNS-970112
+sky-blue,T3N3W,T3N5W,DWNS-970122
+storm,T3LJW,T3LHW,DWNS-970129
diff --git a/novasuede-recon-20260826/novasuede_live_colors_data_20260826.json b/novasuede-recon-20260826/novasuede_live_colors_data_20260826.json
new file mode 100644
index 0000000..17b8d28
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_live_colors_data_20260826.json
@@ -0,0 +1,2508 @@
+[
+ {
+ "slug": "acorn",
+ "hex": "#78370c",
+ "hsl": [
+ 24,
+ 82,
+ 26
+ ],
+ "rgb": [
+ 120,
+ 55,
+ 12
+ ]
+ },
+ {
+ "slug": "adobe",
+ "hex": "#eedac2",
+ "hsl": [
+ 33,
+ 56,
+ 85
+ ],
+ "rgb": [
+ 238,
+ 218,
+ 194
+ ]
+ },
+ {
+ "slug": "african-violet",
+ "hex": "#2d1e3f",
+ "hsl": [
+ 267,
+ 35,
+ 18
+ ],
+ "rgb": [
+ 45,
+ 30,
+ 63
+ ]
+ },
+ {
+ "slug": "amber",
+ "hex": "#b0743f",
+ "hsl": [
+ 28,
+ 47,
+ 47
+ ],
+ "rgb": [
+ 176,
+ 116,
+ 63
+ ]
+ },
+ {
+ "slug": "apricot",
+ "hex": "#d15f34",
+ "hsl": [
+ 16,
+ 63,
+ 51
+ ],
+ "rgb": [
+ 209,
+ 95,
+ 52
+ ]
+ },
+ {
+ "slug": "arrow-wood",
+ "hex": "#746147",
+ "hsl": [
+ 35,
+ 24,
+ 37
+ ],
+ "rgb": [
+ 116,
+ 97,
+ 71
+ ]
+ },
+ {
+ "slug": "aubergine",
+ "hex": "#351929",
+ "hsl": [
+ 326,
+ 36,
+ 15
+ ],
+ "rgb": [
+ 53,
+ 25,
+ 41
+ ]
+ },
+ {
+ "slug": "baltic",
+ "hex": "#bdc0be",
+ "hsl": [
+ 140,
+ 2,
+ 75
+ ],
+ "rgb": [
+ 189,
+ 192,
+ 190
+ ]
+ },
+ {
+ "slug": "beige",
+ "hex": "#dfcab4",
+ "hsl": [
+ 31,
+ 40,
+ 79
+ ],
+ "rgb": [
+ 223,
+ 202,
+ 180
+ ]
+ },
+ {
+ "slug": "biscuit",
+ "hex": "#decdb8",
+ "hsl": [
+ 33,
+ 37,
+ 80
+ ],
+ "rgb": [
+ 222,
+ 205,
+ 184
+ ]
+ },
+ {
+ "slug": "black",
+ "hex": "#0d0e0f",
+ "hsl": [
+ 210,
+ 7,
+ 5
+ ],
+ "rgb": [
+ 13,
+ 14,
+ 15
+ ]
+ },
+ {
+ "slug": "blank-slate",
+ "hex": "#7a7b75",
+ "hsl": [
+ 70,
+ 3,
+ 47
+ ],
+ "rgb": [
+ 122,
+ 123,
+ 117
+ ]
+ },
+ {
+ "slug": "bliss",
+ "hex": "#c4af9d",
+ "hsl": [
+ 28,
+ 25,
+ 69
+ ],
+ "rgb": [
+ 196,
+ 175,
+ 157
+ ]
+ },
+ {
+ "slug": "bluestone",
+ "hex": "#807680",
+ "hsl": [
+ 300,
+ 4,
+ 48
+ ],
+ "rgb": [
+ 128,
+ 118,
+ 128
+ ]
+ },
+ {
+ "slug": "blush-pink",
+ "hex": "#d9676f",
+ "hsl": [
+ 356,
+ 60,
+ 63
+ ],
+ "rgb": [
+ 217,
+ 103,
+ 111
+ ]
+ },
+ {
+ "slug": "blush-rose",
+ "hex": "#b19f90",
+ "hsl": [
+ 27,
+ 17,
+ 63
+ ],
+ "rgb": [
+ 177,
+ 159,
+ 144
+ ]
+ },
+ {
+ "slug": "bone",
+ "hex": "#bfad87",
+ "hsl": [
+ 41,
+ 30,
+ 64
+ ],
+ "rgb": [
+ 191,
+ 173,
+ 135
+ ]
+ },
+ {
+ "slug": "brown",
+ "hex": "#120c0b",
+ "hsl": [
+ 9,
+ 24,
+ 6
+ ],
+ "rgb": [
+ 18,
+ 12,
+ 11
+ ]
+ },
+ {
+ "slug": "buff",
+ "hex": "#e8d0b6",
+ "hsl": [
+ 31,
+ 52,
+ 81
+ ],
+ "rgb": [
+ 232,
+ 208,
+ 182
+ ]
+ },
+ {
+ "slug": "buttercup",
+ "hex": "#e5b380",
+ "hsl": [
+ 30,
+ 66,
+ 70
+ ],
+ "rgb": [
+ 229,
+ 179,
+ 128
+ ]
+ },
+ {
+ "slug": "cane",
+ "hex": "#c38343",
+ "hsl": [
+ 30,
+ 52,
+ 51
+ ],
+ "rgb": [
+ 195,
+ 131,
+ 67
+ ]
+ },
+ {
+ "slug": "carbon",
+ "hex": "#c1b396",
+ "hsl": [
+ 40,
+ 26,
+ 67
+ ],
+ "rgb": [
+ 193,
+ 179,
+ 150
+ ]
+ },
+ {
+ "slug": "cashew",
+ "hex": "#b46d32",
+ "hsl": [
+ 27,
+ 57,
+ 45
+ ],
+ "rgb": [
+ 180,
+ 109,
+ 50
+ ]
+ },
+ {
+ "slug": "cashmere",
+ "hex": "#927339",
+ "hsl": [
+ 39,
+ 44,
+ 40
+ ],
+ "rgb": [
+ 146,
+ 115,
+ 57
+ ]
+ },
+ {
+ "slug": "celadon",
+ "hex": "#b7a186",
+ "hsl": [
+ 33,
+ 25,
+ 62
+ ],
+ "rgb": [
+ 183,
+ 161,
+ 134
+ ]
+ },
+ {
+ "slug": "celery",
+ "hex": "#908f55",
+ "hsl": [
+ 59,
+ 26,
+ 45
+ ],
+ "rgb": [
+ 144,
+ 143,
+ 85
+ ]
+ },
+ {
+ "slug": "cement",
+ "hex": "#8e9296",
+ "hsl": [
+ 210,
+ 4,
+ 57
+ ],
+ "rgb": [
+ 142,
+ 146,
+ 150
+ ]
+ },
+ {
+ "slug": "champagne",
+ "hex": "#efdac8",
+ "hsl": [
+ 28,
+ 55,
+ 86
+ ],
+ "rgb": [
+ 239,
+ 218,
+ 200
+ ]
+ },
+ {
+ "slug": "china-blue",
+ "hex": "#055174",
+ "hsl": [
+ 199,
+ 92,
+ 24
+ ],
+ "rgb": [
+ 5,
+ 81,
+ 116
+ ]
+ },
+ {
+ "slug": "chrome-grey",
+ "hex": "#465359",
+ "hsl": [
+ 199,
+ 12,
+ 31
+ ],
+ "rgb": [
+ 70,
+ 83,
+ 89
+ ]
+ },
+ {
+ "slug": "cinder",
+ "hex": "#0e080a",
+ "hsl": [
+ 340,
+ 27,
+ 4
+ ],
+ "rgb": [
+ 14,
+ 8,
+ 10
+ ]
+ },
+ {
+ "slug": "cloud",
+ "hex": "#c0bfb6",
+ "hsl": [
+ 54,
+ 7,
+ 73
+ ],
+ "rgb": [
+ 192,
+ 191,
+ 182
+ ]
+ },
+ {
+ "slug": "cocoa",
+ "hex": "#805b3b",
+ "hsl": [
+ 28,
+ 37,
+ 37
+ ],
+ "rgb": [
+ 128,
+ 91,
+ 59
+ ]
+ },
+ {
+ "slug": "colonial-blue",
+ "hex": "#455870",
+ "hsl": [
+ 213,
+ 24,
+ 35
+ ],
+ "rgb": [
+ 69,
+ 88,
+ 112
+ ]
+ },
+ {
+ "slug": "coral",
+ "hex": "#d7957c",
+ "hsl": [
+ 16,
+ 53,
+ 66
+ ],
+ "rgb": [
+ 215,
+ 149,
+ 124
+ ]
+ },
+ {
+ "slug": "cottage-grey",
+ "hex": "#a9a498",
+ "hsl": [
+ 42,
+ 9,
+ 63
+ ],
+ "rgb": [
+ 169,
+ 164,
+ 152
+ ]
+ },
+ {
+ "slug": "cream",
+ "hex": "#dec8b3",
+ "hsl": [
+ 29,
+ 39,
+ 79
+ ],
+ "rgb": [
+ 222,
+ 200,
+ 179
+ ]
+ },
+ {
+ "slug": "cypress",
+ "hex": "#5e4632",
+ "hsl": [
+ 27,
+ 31,
+ 28
+ ],
+ "rgb": [
+ 94,
+ 70,
+ 50
+ ]
+ },
+ {
+ "slug": "dark-sand",
+ "hex": "#ab823a",
+ "hsl": [
+ 38,
+ 49,
+ 45
+ ],
+ "rgb": [
+ 171,
+ 130,
+ 58
+ ]
+ },
+ {
+ "slug": "dew",
+ "hex": "#c29366",
+ "hsl": [
+ 29,
+ 43,
+ 58
+ ],
+ "rgb": [
+ 194,
+ 147,
+ 102
+ ]
+ },
+ {
+ "slug": "dove",
+ "hex": "#b1b2ae",
+ "hsl": [
+ 75,
+ 3,
+ 69
+ ],
+ "rgb": [
+ 177,
+ 178,
+ 174
+ ]
+ },
+ {
+ "slug": "dune",
+ "hex": "#e7d3ba",
+ "hsl": [
+ 33,
+ 48,
+ 82
+ ],
+ "rgb": [
+ 231,
+ 211,
+ 186
+ ]
+ },
+ {
+ "slug": "dusty-ranch",
+ "hex": "#906e47",
+ "hsl": [
+ 32,
+ 34,
+ 42
+ ],
+ "rgb": [
+ 144,
+ 110,
+ 71
+ ]
+ },
+ {
+ "slug": "dusty-rose",
+ "hex": "#d49f9d",
+ "hsl": [
+ 2,
+ 39,
+ 72
+ ],
+ "rgb": [
+ 212,
+ 159,
+ 157
+ ]
+ },
+ {
+ "slug": "dusty-teal",
+ "hex": "#344e5e",
+ "hsl": [
+ 203,
+ 29,
+ 29
+ ],
+ "rgb": [
+ 52,
+ 78,
+ 94
+ ]
+ },
+ {
+ "slug": "ecru",
+ "hex": "#e9d8bd",
+ "hsl": [
+ 37,
+ 50,
+ 83
+ ],
+ "rgb": [
+ 233,
+ 216,
+ 189
+ ]
+ },
+ {
+ "slug": "fawn",
+ "hex": "#ccb19c",
+ "hsl": [
+ 26,
+ 32,
+ 71
+ ],
+ "rgb": [
+ 204,
+ 177,
+ 156
+ ]
+ },
+ {
+ "slug": "fire",
+ "hex": "#9e4039",
+ "hsl": [
+ 4,
+ 47,
+ 42
+ ],
+ "rgb": [
+ 158,
+ 64,
+ 57
+ ]
+ },
+ {
+ "slug": "flagstone",
+ "hex": "#a3a39d",
+ "hsl": [
+ 60,
+ 3,
+ 63
+ ],
+ "rgb": [
+ 163,
+ 163,
+ 157
+ ]
+ },
+ {
+ "slug": "french-blue",
+ "hex": "#587692",
+ "hsl": [
+ 209,
+ 25,
+ 46
+ ],
+ "rgb": [
+ 88,
+ 118,
+ 146
+ ]
+ },
+ {
+ "slug": "gainsborough",
+ "hex": "#cdc4bd",
+ "hsl": [
+ 26,
+ 14,
+ 77
+ ],
+ "rgb": [
+ 205,
+ 196,
+ 189
+ ]
+ },
+ {
+ "slug": "garnet",
+ "hex": "#b72526",
+ "hsl": [
+ 360,
+ 66,
+ 43
+ ],
+ "rgb": [
+ 183,
+ 37,
+ 38
+ ]
+ },
+ {
+ "slug": "gelato",
+ "hex": "#ded0c7",
+ "hsl": [
+ 23,
+ 26,
+ 83
+ ],
+ "rgb": [
+ 222,
+ 208,
+ 199
+ ]
+ },
+ {
+ "slug": "gold",
+ "hex": "#701f12",
+ "hsl": [
+ 8,
+ 72,
+ 25
+ ],
+ "rgb": [
+ 112,
+ 31,
+ 18
+ ]
+ },
+ {
+ "slug": "goldstone",
+ "hex": "#bd6001",
+ "hsl": [
+ 30,
+ 99,
+ 37
+ ],
+ "rgb": [
+ 189,
+ 96,
+ 1
+ ]
+ },
+ {
+ "slug": "granite",
+ "hex": "#c1b396",
+ "hsl": [
+ 40,
+ 26,
+ 67
+ ],
+ "rgb": [
+ 193,
+ 179,
+ 150
+ ]
+ },
+ {
+ "slug": "grape",
+ "hex": "#3c2737",
+ "hsl": [
+ 314,
+ 21,
+ 19
+ ],
+ "rgb": [
+ 60,
+ 39,
+ 55
+ ]
+ },
+ {
+ "slug": "gray",
+ "hex": "#5b5345",
+ "hsl": [
+ 38,
+ 14,
+ 31
+ ],
+ "rgb": [
+ 91,
+ 83,
+ 69
+ ]
+ },
+ {
+ "slug": "green-marble",
+ "hex": "#6e8e88",
+ "hsl": [
+ 169,
+ 13,
+ 49
+ ],
+ "rgb": [
+ 110,
+ 142,
+ 136
+ ]
+ },
+ {
+ "slug": "green",
+ "hex": "#9fb6a8",
+ "hsl": [
+ 143,
+ 14,
+ 67
+ ],
+ "rgb": [
+ 159,
+ 182,
+ 168
+ ]
+ },
+ {
+ "slug": "greystone",
+ "hex": "#625f64",
+ "hsl": [
+ 276,
+ 3,
+ 38
+ ],
+ "rgb": [
+ 98,
+ 95,
+ 100
+ ]
+ },
+ {
+ "slug": "harvest",
+ "hex": "#b8a077",
+ "hsl": [
+ 38,
+ 31,
+ 59
+ ],
+ "rgb": [
+ 184,
+ 160,
+ 119
+ ]
+ },
+ {
+ "slug": "henna",
+ "hex": "#8f5f49",
+ "hsl": [
+ 19,
+ 32,
+ 42
+ ],
+ "rgb": [
+ 143,
+ 95,
+ 73
+ ]
+ },
+ {
+ "slug": "honey",
+ "hex": "#d39f6b",
+ "hsl": [
+ 30,
+ 54,
+ 62
+ ],
+ "rgb": [
+ 211,
+ 159,
+ 107
+ ]
+ },
+ {
+ "slug": "hyacinth",
+ "hex": "#816375",
+ "hsl": [
+ 324,
+ 13,
+ 45
+ ],
+ "rgb": [
+ 129,
+ 99,
+ 117
+ ]
+ },
+ {
+ "slug": "iceberg",
+ "hex": "#bfb196",
+ "hsl": [
+ 40,
+ 24,
+ 67
+ ],
+ "rgb": [
+ 191,
+ 177,
+ 150
+ ]
+ },
+ {
+ "slug": "indigo",
+ "hex": "#041e35",
+ "hsl": [
+ 208,
+ 86,
+ 11
+ ],
+ "rgb": [
+ 4,
+ 30,
+ 53
+ ]
+ },
+ {
+ "slug": "ivory",
+ "hex": "#e5d7cb",
+ "hsl": [
+ 28,
+ 33,
+ 85
+ ],
+ "rgb": [
+ 229,
+ 215,
+ 203
+ ]
+ },
+ {
+ "slug": "jade",
+ "hex": "#013b3a",
+ "hsl": [
+ 179,
+ 97,
+ 12
+ ],
+ "rgb": [
+ 1,
+ 59,
+ 58
+ ]
+ },
+ {
+ "slug": "java",
+ "hex": "#805b3b",
+ "hsl": [
+ 28,
+ 37,
+ 37
+ ],
+ "rgb": [
+ 128,
+ 91,
+ 59
+ ]
+ },
+ {
+ "slug": "kiva",
+ "hex": "#a09986",
+ "hsl": [
+ 44,
+ 12,
+ 58
+ ],
+ "rgb": [
+ 160,
+ 153,
+ 134
+ ]
+ },
+ {
+ "slug": "latte",
+ "hex": "#e5d7cb",
+ "hsl": [
+ 28,
+ 33,
+ 85
+ ],
+ "rgb": [
+ 229,
+ 215,
+ 203
+ ]
+ },
+ {
+ "slug": "lavender",
+ "hex": "#9b698a",
+ "hsl": [
+ 320,
+ 20,
+ 51
+ ],
+ "rgb": [
+ 155,
+ 105,
+ 138
+ ]
+ },
+ {
+ "slug": "light-amethyst",
+ "hex": "#a5a0b5",
+ "hsl": [
+ 254,
+ 12,
+ 67
+ ],
+ "rgb": [
+ 165,
+ 160,
+ 181
+ ]
+ },
+ {
+ "slug": "light-camel",
+ "hex": "#ccb19c",
+ "hsl": [
+ 26,
+ 32,
+ 71
+ ],
+ "rgb": [
+ 204,
+ 177,
+ 156
+ ]
+ },
+ {
+ "slug": "light-grey",
+ "hex": "#a4a093",
+ "hsl": [
+ 46,
+ 9,
+ 61
+ ],
+ "rgb": [
+ 164,
+ 160,
+ 147
+ ]
+ },
+ {
+ "slug": "lilac",
+ "hex": "#9b698a",
+ "hsl": [
+ 320,
+ 20,
+ 51
+ ],
+ "rgb": [
+ 155,
+ 105,
+ 138
+ ]
+ },
+ {
+ "slug": "lime",
+ "hex": "#908f55",
+ "hsl": [
+ 59,
+ 26,
+ 45
+ ],
+ "rgb": [
+ 144,
+ 143,
+ 85
+ ]
+ },
+ {
+ "slug": "linen",
+ "hex": "#dcd2c8",
+ "hsl": [
+ 30,
+ 22,
+ 82
+ ],
+ "rgb": [
+ 220,
+ 210,
+ 200
+ ]
+ },
+ {
+ "slug": "lipstick",
+ "hex": "#8e3138",
+ "hsl": [
+ 355,
+ 49,
+ 37
+ ],
+ "rgb": [
+ 142,
+ 49,
+ 56
+ ]
+ },
+ {
+ "slug": "madison-grey",
+ "hex": "#4d4743",
+ "hsl": [
+ 24,
+ 7,
+ 28
+ ],
+ "rgb": [
+ 77,
+ 71,
+ 67
+ ]
+ },
+ {
+ "slug": "maize",
+ "hex": "#eccb9b",
+ "hsl": [
+ 36,
+ 68,
+ 77
+ ],
+ "rgb": [
+ 236,
+ 203,
+ 155
+ ]
+ },
+ {
+ "slug": "marine-blue",
+ "hex": "#4d6d60",
+ "hsl": [
+ 156,
+ 17,
+ 36
+ ],
+ "rgb": [
+ 77,
+ 109,
+ 96
+ ]
+ },
+ {
+ "slug": "maroon",
+ "hex": "#722527",
+ "hsl": [
+ 358,
+ 51,
+ 30
+ ],
+ "rgb": [
+ 114,
+ 37,
+ 39
+ ]
+ },
+ {
+ "slug": "mauve",
+ "hex": "#2d1e3f",
+ "hsl": [
+ 267,
+ 35,
+ 18
+ ],
+ "rgb": [
+ 45,
+ 30,
+ 63
+ ]
+ },
+ {
+ "slug": "meadow",
+ "hex": "#b0ab63",
+ "hsl": [
+ 56,
+ 33,
+ 54
+ ],
+ "rgb": [
+ 176,
+ 171,
+ 99
+ ]
+ },
+ {
+ "slug": "melon",
+ "hex": "#ee8d4b",
+ "hsl": [
+ 24,
+ 83,
+ 61
+ ],
+ "rgb": [
+ 238,
+ 141,
+ 75
+ ]
+ },
+ {
+ "slug": "milk",
+ "hex": "#eddecf",
+ "hsl": [
+ 30,
+ 45,
+ 87
+ ],
+ "rgb": [
+ 237,
+ 222,
+ 207
+ ]
+ },
+ {
+ "slug": "mint-julip",
+ "hex": "#9fb6a8",
+ "hsl": [
+ 143,
+ 14,
+ 67
+ ],
+ "rgb": [
+ 159,
+ 182,
+ 168
+ ]
+ },
+ {
+ "slug": "mint",
+ "hex": "#7c7a70",
+ "hsl": [
+ 50,
+ 5,
+ 46
+ ],
+ "rgb": [
+ 124,
+ 122,
+ 112
+ ]
+ },
+ {
+ "slug": "mist",
+ "hex": "#c0bfb6",
+ "hsl": [
+ 54,
+ 7,
+ 73
+ ],
+ "rgb": [
+ 192,
+ 191,
+ 182
+ ]
+ },
+ {
+ "slug": "misty-dew",
+ "hex": "#d0c6b5",
+ "hsl": [
+ 38,
+ 22,
+ 76
+ ],
+ "rgb": [
+ 208,
+ 198,
+ 181
+ ]
+ },
+ {
+ "slug": "mocha",
+ "hex": "#805b3b",
+ "hsl": [
+ 28,
+ 37,
+ 37
+ ],
+ "rgb": [
+ 128,
+ 91,
+ 59
+ ]
+ },
+ {
+ "slug": "moss",
+ "hex": "#5b5345",
+ "hsl": [
+ 38,
+ 14,
+ 31
+ ],
+ "rgb": [
+ 91,
+ 83,
+ 69
+ ]
+ },
+ {
+ "slug": "mushroom",
+ "hex": "#946341",
+ "hsl": [
+ 25,
+ 39,
+ 42
+ ],
+ "rgb": [
+ 148,
+ 99,
+ 65
+ ]
+ },
+ {
+ "slug": "navy",
+ "hex": "#004fb7",
+ "hsl": [
+ 214,
+ 100,
+ 36
+ ],
+ "rgb": [
+ 0,
+ 79,
+ 183
+ ]
+ },
+ {
+ "slug": "newport",
+ "hex": "#08111f",
+ "hsl": [
+ 217,
+ 59,
+ 8
+ ],
+ "rgb": [
+ 8,
+ 17,
+ 31
+ ]
+ },
+ {
+ "slug": "noir",
+ "hex": "#1c2a2f",
+ "hsl": [
+ 196,
+ 25,
+ 15
+ ],
+ "rgb": [
+ 28,
+ 42,
+ 47
+ ]
+ },
+ {
+ "slug": "nutmeg",
+ "hex": "#826c45",
+ "hsl": [
+ 38,
+ 31,
+ 39
+ ],
+ "rgb": [
+ 130,
+ 108,
+ 69
+ ]
+ },
+ {
+ "slug": "ocean",
+ "hex": "#4d6d60",
+ "hsl": [
+ 156,
+ 17,
+ 36
+ ],
+ "rgb": [
+ 77,
+ 109,
+ 96
+ ]
+ },
+ {
+ "slug": "olive",
+ "hex": "#2c2514",
+ "hsl": [
+ 43,
+ 38,
+ 13
+ ],
+ "rgb": [
+ 44,
+ 37,
+ 20
+ ]
+ },
+ {
+ "slug": "opal",
+ "hex": "#718183",
+ "hsl": [
+ 187,
+ 7,
+ 48
+ ],
+ "rgb": [
+ 113,
+ 129,
+ 131
+ ]
+ },
+ {
+ "slug": "orange",
+ "hex": "#e8beb1",
+ "hsl": [
+ 14,
+ 54,
+ 80
+ ],
+ "rgb": [
+ 232,
+ 190,
+ 177
+ ]
+ },
+ {
+ "slug": "oyster",
+ "hex": "#b3a482",
+ "hsl": [
+ 42,
+ 24,
+ 61
+ ],
+ "rgb": [
+ 179,
+ 164,
+ 130
+ ]
+ },
+ {
+ "slug": "pale-green",
+ "hex": "#bad6cd",
+ "hsl": [
+ 161,
+ 25,
+ 78
+ ],
+ "rgb": [
+ 186,
+ 214,
+ 205
+ ]
+ },
+ {
+ "slug": "passion-blue",
+ "hex": "#004fb7",
+ "hsl": [
+ 214,
+ 100,
+ 36
+ ],
+ "rgb": [
+ 0,
+ 79,
+ 183
+ ]
+ },
+ {
+ "slug": "pastel-blue",
+ "hex": "#abc2db",
+ "hsl": [
+ 211,
+ 40,
+ 76
+ ],
+ "rgb": [
+ 171,
+ 194,
+ 219
+ ]
+ },
+ {
+ "slug": "pastel-pink",
+ "hex": "#e5cbca",
+ "hsl": [
+ 2,
+ 34,
+ 85
+ ],
+ "rgb": [
+ 229,
+ 203,
+ 202
+ ]
+ },
+ {
+ "slug": "peach",
+ "hex": "#e8beb1",
+ "hsl": [
+ 14,
+ 54,
+ 80
+ ],
+ "rgb": [
+ 232,
+ 190,
+ 177
+ ]
+ },
+ {
+ "slug": "pebble",
+ "hex": "#e5cab8",
+ "hsl": [
+ 24,
+ 46,
+ 81
+ ],
+ "rgb": [
+ 229,
+ 202,
+ 184
+ ]
+ },
+ {
+ "slug": "peppermint",
+ "hex": "#dec3ba",
+ "hsl": [
+ 15,
+ 35,
+ 80
+ ],
+ "rgb": [
+ 222,
+ 195,
+ 186
+ ]
+ },
+ {
+ "slug": "peridot",
+ "hex": "#30280d",
+ "hsl": [
+ 46,
+ 57,
+ 12
+ ],
+ "rgb": [
+ 48,
+ 40,
+ 13
+ ]
+ },
+ {
+ "slug": "periwinkle",
+ "hex": "#8395b3",
+ "hsl": [
+ 218,
+ 24,
+ 61
+ ],
+ "rgb": [
+ 131,
+ 149,
+ 179
+ ]
+ },
+ {
+ "slug": "persimmon",
+ "hex": "#ab5e3f",
+ "hsl": [
+ 17,
+ 46,
+ 46
+ ],
+ "rgb": [
+ 171,
+ 94,
+ 63
+ ]
+ },
+ {
+ "slug": "pink-lace",
+ "hex": "#dbd7de",
+ "hsl": [
+ 274,
+ 10,
+ 86
+ ],
+ "rgb": [
+ 219,
+ 215,
+ 222
+ ]
+ },
+ {
+ "slug": "pistachio",
+ "hex": "#c7cbbc",
+ "hsl": [
+ 76,
+ 13,
+ 77
+ ],
+ "rgb": [
+ 199,
+ 203,
+ 188
+ ]
+ },
+ {
+ "slug": "plum-pleasure",
+ "hex": "#4c1128",
+ "hsl": [
+ 337,
+ 63,
+ 18
+ ],
+ "rgb": [
+ 76,
+ 17,
+ 40
+ ]
+ },
+ {
+ "slug": "port-blue",
+ "hex": "#1b2c38",
+ "hsl": [
+ 205,
+ 35,
+ 16
+ ],
+ "rgb": [
+ 27,
+ 44,
+ 56
+ ]
+ },
+ {
+ "slug": "powder-grey",
+ "hex": "#beb6b2",
+ "hsl": [
+ 20,
+ 8,
+ 72
+ ],
+ "rgb": [
+ 190,
+ 182,
+ 178
+ ]
+ },
+ {
+ "slug": "prairie",
+ "hex": "#94865c",
+ "hsl": [
+ 45,
+ 23,
+ 47
+ ],
+ "rgb": [
+ 148,
+ 134,
+ 92
+ ]
+ },
+ {
+ "slug": "putty",
+ "hex": "#caa57a",
+ "hsl": [
+ 32,
+ 43,
+ 64
+ ],
+ "rgb": [
+ 202,
+ 165,
+ 122
+ ]
+ },
+ {
+ "slug": "raffia",
+ "hex": "#a98557",
+ "hsl": [
+ 34,
+ 32,
+ 50
+ ],
+ "rgb": [
+ 169,
+ 133,
+ 87
+ ]
+ },
+ {
+ "slug": "raisin",
+ "hex": "#2b3034",
+ "hsl": [
+ 207,
+ 9,
+ 19
+ ],
+ "rgb": [
+ 43,
+ 48,
+ 52
+ ]
+ },
+ {
+ "slug": "red",
+ "hex": "#d28e66",
+ "hsl": [
+ 22,
+ 55,
+ 61
+ ],
+ "rgb": [
+ 210,
+ 142,
+ 102
+ ]
+ },
+ {
+ "slug": "rose",
+ "hex": "#dec3ba",
+ "hsl": [
+ 15,
+ 35,
+ 80
+ ],
+ "rgb": [
+ 222,
+ 195,
+ 186
+ ]
+ },
+ {
+ "slug": "rosewater",
+ "hex": "#d9c5c0",
+ "hsl": [
+ 12,
+ 25,
+ 80
+ ],
+ "rgb": [
+ 217,
+ 197,
+ 192
+ ]
+ },
+ {
+ "slug": "royal-blue",
+ "hex": "#1c3152",
+ "hsl": [
+ 217,
+ 49,
+ 22
+ ],
+ "rgb": [
+ 28,
+ 49,
+ 82
+ ]
+ },
+ {
+ "slug": "royal-purple",
+ "hex": "#191020",
+ "hsl": [
+ 274,
+ 33,
+ 9
+ ],
+ "rgb": [
+ 25,
+ 16,
+ 32
+ ]
+ },
+ {
+ "slug": "ruby",
+ "hex": "#701f12",
+ "hsl": [
+ 8,
+ 72,
+ 25
+ ],
+ "rgb": [
+ 112,
+ 31,
+ 18
+ ]
+ },
+ {
+ "slug": "sable",
+ "hex": "#1d0804",
+ "hsl": [
+ 10,
+ 76,
+ 6
+ ],
+ "rgb": [
+ 29,
+ 8,
+ 4
+ ]
+ },
+ {
+ "slug": "safari",
+ "hex": "#d5b192",
+ "hsl": [
+ 28,
+ 44,
+ 70
+ ],
+ "rgb": [
+ 213,
+ 177,
+ 146
+ ]
+ },
+ {
+ "slug": "saffron",
+ "hex": "#dda361",
+ "hsl": [
+ 32,
+ 65,
+ 62
+ ],
+ "rgb": [
+ 221,
+ 163,
+ 97
+ ]
+ },
+ {
+ "slug": "sage",
+ "hex": "#7c7a70",
+ "hsl": [
+ 50,
+ 5,
+ 46
+ ],
+ "rgb": [
+ 124,
+ 122,
+ 112
+ ]
+ },
+ {
+ "slug": "salt",
+ "hex": "#d0cbc3",
+ "hsl": [
+ 37,
+ 12,
+ 79
+ ],
+ "rgb": [
+ 208,
+ 203,
+ 195
+ ]
+ },
+ {
+ "slug": "sand",
+ "hex": "#c3bcb4",
+ "hsl": [
+ 32,
+ 11,
+ 74
+ ],
+ "rgb": [
+ 195,
+ 188,
+ 180
+ ]
+ },
+ {
+ "slug": "sandalwood",
+ "hex": "#d28e66",
+ "hsl": [
+ 22,
+ 55,
+ 61
+ ],
+ "rgb": [
+ 210,
+ 142,
+ 102
+ ]
+ },
+ {
+ "slug": "scarlet-wine",
+ "hex": "#500d20",
+ "hsl": [
+ 343,
+ 72,
+ 18
+ ],
+ "rgb": [
+ 80,
+ 13,
+ 32
+ ]
+ },
+ {
+ "slug": "sea-blue",
+ "hex": "#505f7f",
+ "hsl": [
+ 221,
+ 23,
+ 41
+ ],
+ "rgb": [
+ 80,
+ 95,
+ 127
+ ]
+ },
+ {
+ "slug": "sea-breeze",
+ "hex": "#99afa0",
+ "hsl": [
+ 139,
+ 12,
+ 64
+ ],
+ "rgb": [
+ 153,
+ 175,
+ 160
+ ]
+ },
+ {
+ "slug": "sea-grass",
+ "hex": "#969666",
+ "hsl": [
+ 60,
+ 19,
+ 49
+ ],
+ "rgb": [
+ 150,
+ 150,
+ 102
+ ]
+ },
+ {
+ "slug": "seafoam",
+ "hex": "#796e50",
+ "hsl": [
+ 44,
+ 20,
+ 39
+ ],
+ "rgb": [
+ 121,
+ 110,
+ 80
+ ]
+ },
+ {
+ "slug": "sedona",
+ "hex": "#a45446",
+ "hsl": [
+ 9,
+ 40,
+ 46
+ ],
+ "rgb": [
+ 164,
+ 84,
+ 70
+ ]
+ },
+ {
+ "slug": "shale",
+ "hex": "#55524b",
+ "hsl": [
+ 42,
+ 6,
+ 31
+ ],
+ "rgb": [
+ 85,
+ 82,
+ 75
+ ]
+ },
+ {
+ "slug": "sienna",
+ "hex": "#8f5f33",
+ "hsl": [
+ 29,
+ 47,
+ 38
+ ],
+ "rgb": [
+ 143,
+ 95,
+ 51
+ ]
+ },
+ {
+ "slug": "silver",
+ "hex": "#867b66",
+ "hsl": [
+ 39,
+ 14,
+ 46
+ ],
+ "rgb": [
+ 134,
+ 123,
+ 102
+ ]
+ },
+ {
+ "slug": "sky-blue",
+ "hex": "#94b8cd",
+ "hsl": [
+ 202,
+ 36,
+ 69
+ ],
+ "rgb": [
+ 148,
+ 184,
+ 205
+ ]
+ },
+ {
+ "slug": "smoke",
+ "hex": "#493831",
+ "hsl": [
+ 17,
+ 20,
+ 24
+ ],
+ "rgb": [
+ 73,
+ 56,
+ 49
+ ]
+ },
+ {
+ "slug": "snow",
+ "hex": "#f0f4f0",
+ "hsl": [
+ 120,
+ 15,
+ 95
+ ],
+ "rgb": [
+ 240,
+ 244,
+ 240
+ ]
+ },
+ {
+ "slug": "soft-clay",
+ "hex": "#d27a61",
+ "hsl": [
+ 13,
+ 56,
+ 60
+ ],
+ "rgb": [
+ 210,
+ 122,
+ 97
+ ]
+ },
+ {
+ "slug": "solar-yellow",
+ "hex": "#f1ad48",
+ "hsl": [
+ 36,
+ 86,
+ 61
+ ],
+ "rgb": [
+ 241,
+ 173,
+ 72
+ ]
+ },
+ {
+ "slug": "spice",
+ "hex": "#946341",
+ "hsl": [
+ 25,
+ 39,
+ 42
+ ],
+ "rgb": [
+ 148,
+ 99,
+ 65
+ ]
+ },
+ {
+ "slug": "spruce",
+ "hex": "#273737",
+ "hsl": [
+ 180,
+ 17,
+ 18
+ ],
+ "rgb": [
+ 39,
+ 55,
+ 55
+ ]
+ },
+ {
+ "slug": "steel",
+ "hex": "#867b66",
+ "hsl": [
+ 39,
+ 14,
+ 46
+ ],
+ "rgb": [
+ 134,
+ 123,
+ 102
+ ]
+ },
+ {
+ "slug": "stone-grey",
+ "hex": "#715c55",
+ "hsl": [
+ 15,
+ 14,
+ 39
+ ],
+ "rgb": [
+ 113,
+ 92,
+ 85
+ ]
+ },
+ {
+ "slug": "stone-taupe",
+ "hex": "#ad8568",
+ "hsl": [
+ 25,
+ 30,
+ 54
+ ],
+ "rgb": [
+ 173,
+ 133,
+ 104
+ ]
+ },
+ {
+ "slug": "storm",
+ "hex": "#bfb196",
+ "hsl": [
+ 40,
+ 24,
+ 67
+ ],
+ "rgb": [
+ 191,
+ 177,
+ 150
+ ]
+ },
+ {
+ "slug": "straw",
+ "hex": "#e6b586",
+ "hsl": [
+ 29,
+ 66,
+ 71
+ ],
+ "rgb": [
+ 230,
+ 181,
+ 134
+ ]
+ },
+ {
+ "slug": "strong-white",
+ "hex": "#e3ded8",
+ "hsl": [
+ 33,
+ 16,
+ 87
+ ],
+ "rgb": [
+ 227,
+ 222,
+ 216
+ ]
+ },
+ {
+ "slug": "sugar-plum",
+ "hex": "#d485a6",
+ "hsl": [
+ 335,
+ 48,
+ 68
+ ],
+ "rgb": [
+ 212,
+ 133,
+ 166
+ ]
+ },
+ {
+ "slug": "sweet-lilac",
+ "hex": "#a58cad",
+ "hsl": [
+ 285,
+ 17,
+ 61
+ ],
+ "rgb": [
+ 165,
+ 140,
+ 173
+ ]
+ },
+ {
+ "slug": "tan",
+ "hex": "#d4a37c",
+ "hsl": [
+ 27,
+ 51,
+ 66
+ ],
+ "rgb": [
+ 212,
+ 163,
+ 124
+ ]
+ },
+ {
+ "slug": "tarragon",
+ "hex": "#808436",
+ "hsl": [
+ 63,
+ 42,
+ 36
+ ],
+ "rgb": [
+ 128,
+ 132,
+ 54
+ ]
+ },
+ {
+ "slug": "taupe",
+ "hex": "#e8d5c5",
+ "hsl": [
+ 27,
+ 43,
+ 84
+ ],
+ "rgb": [
+ 232,
+ 213,
+ 197
+ ]
+ },
+ {
+ "slug": "terracotta",
+ "hex": "#997f5d",
+ "hsl": [
+ 34,
+ 24,
+ 48
+ ],
+ "rgb": [
+ 153,
+ 127,
+ 93
+ ]
+ },
+ {
+ "slug": "thistle",
+ "hex": "#2d3036",
+ "hsl": [
+ 220,
+ 9,
+ 19
+ ],
+ "rgb": [
+ 45,
+ 48,
+ 54
+ ]
+ },
+ {
+ "slug": "thyme",
+ "hex": "#35391f",
+ "hsl": [
+ 69,
+ 30,
+ 17
+ ],
+ "rgb": [
+ 53,
+ 57,
+ 31
+ ]
+ },
+ {
+ "slug": "trench",
+ "hex": "#806a5c",
+ "hsl": [
+ 23,
+ 16,
+ 43
+ ],
+ "rgb": [
+ 128,
+ 106,
+ 92
+ ]
+ },
+ {
+ "slug": "tusk",
+ "hex": "#d7cebf",
+ "hsl": [
+ 38,
+ 23,
+ 80
+ ],
+ "rgb": [
+ 215,
+ 206,
+ 191
+ ]
+ },
+ {
+ "slug": "umber",
+ "hex": "#63473e",
+ "hsl": [
+ 15,
+ 23,
+ 32
+ ],
+ "rgb": [
+ 99,
+ 71,
+ 62
+ ]
+ },
+ {
+ "slug": "vanilla",
+ "hex": "#dbcab4",
+ "hsl": [
+ 34,
+ 35,
+ 78
+ ],
+ "rgb": [
+ 219,
+ 202,
+ 180
+ ]
+ },
+ {
+ "slug": "verdigris",
+ "hex": "#829e99",
+ "hsl": [
+ 169,
+ 13,
+ 56
+ ],
+ "rgb": [
+ 130,
+ 158,
+ 153
+ ]
+ },
+ {
+ "slug": "vermilion",
+ "hex": "#813038",
+ "hsl": [
+ 354,
+ 46,
+ 35
+ ],
+ "rgb": [
+ 129,
+ 48,
+ 56
+ ]
+ },
+ {
+ "slug": "wheat",
+ "hex": "#b59c79",
+ "hsl": [
+ 35,
+ 29,
+ 59
+ ],
+ "rgb": [
+ 181,
+ 156,
+ 121
+ ]
+ },
+ {
+ "slug": "white",
+ "hex": "#e3ded8",
+ "hsl": [
+ 33,
+ 16,
+ 87
+ ],
+ "rgb": [
+ 227,
+ 222,
+ 216
+ ]
+ },
+ {
+ "slug": "winter-white",
+ "hex": "#d2cdba",
+ "hsl": [
+ 48,
+ 21,
+ 78
+ ],
+ "rgb": [
+ 210,
+ 205,
+ 186
+ ]
+ },
+ {
+ "slug": "woodland",
+ "hex": "#615841",
+ "hsl": [
+ 43,
+ 20,
+ 32
+ ],
+ "rgb": [
+ 97,
+ 88,
+ 65
+ ]
+ },
+ {
+ "slug": "abyss",
+ "hex": "#565656",
+ "hsl": [
+ 0,
+ 0,
+ 34
+ ],
+ "rgb": [
+ 86,
+ 86,
+ 86
+ ]
+ },
+ {
+ "slug": "porcelain",
+ "hex": "#e7d3c4",
+ "hsl": [
+ 26,
+ 42,
+ 84
+ ],
+ "rgb": [
+ 231,
+ 211,
+ 196
+ ]
+ },
+ {
+ "slug": "satin",
+ "hex": "#cfc3b4",
+ "hsl": [
+ 33,
+ 22,
+ 76
+ ],
+ "rgb": [
+ 207,
+ 195,
+ 180
+ ]
+ }
+]
\ No newline at end of file
diff --git a/novasuede-recon-20260826/novasuede_live_source_namecode_20260826.json b/novasuede-recon-20260826/novasuede_live_source_namecode_20260826.json
new file mode 100644
index 0000000..796f51d
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_live_source_namecode_20260826.json
@@ -0,0 +1 @@
+{"amber": "T3Q8W", "blank slate": "T3L0W", "bliss": "T3Q7W", "blush rose": "T3RFW", "cement": "T3LAW", "colonial blue": "T3C9W", "dusty ranch": "T3FAW", "dusty teal": "T3NGW", "fire": "T3QAW", "flagstone": "T3LKW", "henna": "T3G3W", "kiva": "T3ECW", "lipstick": "T3M4W", "noir": "T3A2W", "opal": "T3PQW", "pastel blue": "T3N0W", "pastel pink": "T3R6W", "persimmon": "T3M8W", "pink lace": "T3RCW", "port blue": "T3NJW", "raisin": "T3PRW", "rosewater": "T3RSW", "royal blue": "T3CCW", "sedona": "T3Q9W", "shale": "T3KDW", "snow": "T3B3W", "spruce": "T3PYW", "terracotta": "T3FCW", "thistle": "T3PMW", "tusk": "T3DJW", "umber": "T3G4W", "verdigris": "T3NHW", "vermilion": "T3MBW", "wheat": "T3FDW", "winter white": "T3B2W", "woodland": "T3H6W", "acorn": "T3H5W", "adobe": "T3K6W", "african violet": "T3SAW", "apricot": "T3Q4W", "arrow wood": "T3F8W", "aubergine": "T3SCW", "baltic": "T3L6W", "beige": "T3E8W", "biscuit": "T3DHW", "black": "T3BLW", "bluestone": "T3N7W", "blush pink": "T3C7W", "bone": "T3DSW", "brown": "T3F6W", "buff": "T3D1W", "buttercup": "T3DEW", "cane": "T3D3W", "carbon": "T3C6W", "cashew": "T3D2W", "cashmere": "T3E6W", "celadon": "T3P1W", "celery": "T3PFW", "champagne": "T3D4W", "china blue": "T3NBW", "chrome grey": "T3PJW", "cinder": "T3LCW", "cloud": "T3L4W", "cocoa": "T315W", "coral": "T3Q3W", "cottage grey": "T3LGW", "cream": "T3D9W", "cypress": "T3PHW", "dark sand": "T3EAW", "dew": "T3F3W", "dove": "T3E2W", "dune": "T3F4W", "dusty rose": "T3R2W", "ecru": "T3K4W", "fawn": "T3E4W", "french blue": "T3NCW", "gainsborough": "T3LLW", "garnet": "T3J6W", "gelato": "T3D7W", "gold": "T3J9W", "goldstone": "T3F1W", "granite": "T3LOW", "gray": "T3L3W", "green": "T3P5W", "green marble": "T3P4W", "greystone": "T3LNW", "harvest": "T3E9W", "honey": "T3DDW", "hyacinth": "T3S2W", "iceberg": "T3LHW", "indigo": "T3C3W", "ivory": "T3E3W", "jade": "T3P6W", "java": "T3H4W", "latte": "T3E3W", "lavender": "T3S3W", "light amethyst": "T3S6W", "light camel": "T3E5W", "light grey": "T3L7W", "lilac": "T3RAW", "lime": "T3PEW", "linen": "T3D6W", "madison grey": "T3L1W", "maize": "T3O3W", "marine blue": "T3N1W", "maroon": "T3JAW", "mauve": "T3S1W", "meadow": "T3PIW", "melon": "T3Q6W", "milk": "T3DQW", "mint": "T3PAW", "mint julip": "T3P5W", "mist": "T3DDW", "misty dew": "T3PLW", "mocha": "T3H7W", "moss": "T3L3W", "mushroom": "T3K1W", "navy": "T3NAW", "newport": "T3C2W", "nutmeg": "T3F9W", "ocean": "T3POW", "olive": "T3PEW", "orange": "T3Q2W", "oyster": "T3EBW", "pale green": "T3P8W", "passion blue": "T3NAW", "peach": "T3Q2W", "pebble": "T3K2W", "peppermint": "T3R4W", "peridot": "T3P7W", "periwinkle": "T3N6W", "pistachio": "T3P6W", "plum pleasure": "T3S5W", "porcelain": "T3DAW", "powder grey": "T3E5W", "prairie": "T3KCW", "putty": "T3K3W", "raffia": "T3D5W", "red": "T3R8W", "rose": "T3R4W", "royal purple": "T3S4W", "ruby": "T3R6W", "sable": "T3F7W", "safari": "T3E7W", "saffron": "T3O2W", "sage": "T3P3W", "salt": "T3DBW", "sand": "T3D8W", "sandalwood": "T3F5W", "scarlet wine": "T3R5W", "sea blue": "T3N9W", "sea grass": "T3P2W", "sea breeze": "T3N8W", "seafoam": "T3N3W", "sienna": "T3Q7W", "silver": "T3LEW", "sky blue": "T3N5W", "smoke": "T3L5W", "soft clay": "T3K7W", "solar yellow": "T3O1W", "spice": "T3K1W", "steel": "T3LBW", "stone grey": "T3L2W", "stone taupe": "T3K8W", "storm": "T3LHW", "straw": "T3DCW", "strong white": "T3DAW", "sugar plum": "T3S7W", "sweet lilac": "T3S1W", "tan": "T3E1W", "tarragon": "T3PGW", "taupe": "T3K9W", "thyme": "T3PDW", "trench": "T3F2W", "vanilla": "T3D5W", "white": "T3WHW"}
\ No newline at end of file
diff --git a/novasuede-recon-20260826/novasuede_placeholder_APPLY_20260826.sql b/novasuede-recon-20260826/novasuede_placeholder_APPLY_20260826.sql
new file mode 100644
index 0000000..acc900d
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_placeholder_APPLY_20260826.sql
@@ -0,0 +1,29 @@
+-- Novasuede STAGING (novasuede_catalog) placeholder->authoritative mfr code fix
+-- Source: novasuede.com live authoritative name->code map (atomic {name,code} pairs), fetched 2026-08-26, $0
+-- Mac2-canonical staging table (*_catalog). Reversible via restore-map JSON.
+-- Blast radius: 20 rows. Only fills rows whose mfr_sku was a non-code placeholder (the slug).
+
+BEGIN;
+UPDATE novasuede_catalog SET mfr_sku='T3R8W' WHERE sku='novasuede™-red' AND mfr_sku='novasuede™-red';
+UPDATE novasuede_catalog SET mfr_sku='T3N1W' WHERE sku='novasuede™-marine-blue' AND mfr_sku='novasuede™-marine-blue';
+UPDATE novasuede_catalog SET mfr_sku='T3PEW' WHERE sku='novasuede™-lime' AND mfr_sku='novasuede™-lime';
+UPDATE novasuede_catalog SET mfr_sku='T3L3W' WHERE sku='novasuede™-gray' AND mfr_sku='novasuede™-gray';
+UPDATE novasuede_catalog SET mfr_sku='T3RAW' WHERE sku='novasuede™-lilac' AND mfr_sku='novasuede™-lilac';
+UPDATE novasuede_catalog SET mfr_sku='T3Q2W' WHERE sku='novasuede™-orange' AND mfr_sku='novasuede™-orange';
+UPDATE novasuede_catalog SET mfr_sku='T3E3W' WHERE sku='novasuede™-latte' AND mfr_sku='novasuede™-latte';
+UPDATE novasuede_catalog SET mfr_sku='T3E5W' WHERE sku='novasuede™-light-camel' AND mfr_sku='novasuede™-light-camel';
+UPDATE novasuede_catalog SET mfr_sku='T3N8W' WHERE sku='novasuede™-sea-breeze' AND mfr_sku='novasuede™-sea-breeze';
+UPDATE novasuede_catalog SET mfr_sku='T3S1W' WHERE sku='novasuede™-mauve' AND mfr_sku='novasuede™-mauve';
+UPDATE novasuede_catalog SET mfr_sku='T3H4W' WHERE sku='novasuede™-java' AND mfr_sku='novasuede™-java';
+UPDATE novasuede_catalog SET mfr_sku='T3WHW' WHERE sku='novasuede™-white' AND mfr_sku='novasuede™-white';
+UPDATE novasuede_catalog SET mfr_sku='T3H7W' WHERE sku='novasuede™-mocha' AND mfr_sku='novasuede™-mocha';
+UPDATE novasuede_catalog SET mfr_sku='T3NAW' WHERE sku='novasuede™-navy' AND mfr_sku='novasuede™-navy';
+UPDATE novasuede_catalog SET mfr_sku='T3LEW' WHERE sku='novasuede™-silver' AND mfr_sku='novasuede™-silver';
+UPDATE novasuede_catalog SET mfr_sku='T3R4W' WHERE sku='novasuede™-rose' AND mfr_sku='novasuede™-rose';
+UPDATE novasuede_catalog SET mfr_sku='T3DDW' WHERE sku='novasuede™-mist' AND mfr_sku='novasuede™-mist';
+UPDATE novasuede_catalog SET mfr_sku='T3PAW' WHERE sku='novasuede™-mint' AND mfr_sku='novasuede™-mint';
+UPDATE novasuede_catalog SET mfr_sku='T3P5W' WHERE sku='novasuede™-green' AND mfr_sku='novasuede™-green';
+UPDATE novasuede_catalog SET mfr_sku='T3J9W' WHERE sku='novasuede™-gold' AND mfr_sku='novasuede™-gold';
+
+SELECT count(*) AS placeholders_remaining FROM novasuede_catalog WHERE mfr_sku LIKE 'novasuede%';
+COMMIT;
diff --git a/novasuede-recon-20260826/novasuede_placeholder_RESTORE_20260826.sql b/novasuede-recon-20260826/novasuede_placeholder_RESTORE_20260826.sql
new file mode 100644
index 0000000..8215775
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_placeholder_RESTORE_20260826.sql
@@ -0,0 +1,23 @@
+-- ROLLBACK: restore placeholder mfr codes
+BEGIN;
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-red' WHERE sku='novasuede™-red';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-marine-blue' WHERE sku='novasuede™-marine-blue';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-lime' WHERE sku='novasuede™-lime';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-gray' WHERE sku='novasuede™-gray';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-lilac' WHERE sku='novasuede™-lilac';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-orange' WHERE sku='novasuede™-orange';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-latte' WHERE sku='novasuede™-latte';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-light-camel' WHERE sku='novasuede™-light-camel';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-sea-breeze' WHERE sku='novasuede™-sea-breeze';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-mauve' WHERE sku='novasuede™-mauve';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-java' WHERE sku='novasuede™-java';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-white' WHERE sku='novasuede™-white';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-mocha' WHERE sku='novasuede™-mocha';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-navy' WHERE sku='novasuede™-navy';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-silver' WHERE sku='novasuede™-silver';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-rose' WHERE sku='novasuede™-rose';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-mist' WHERE sku='novasuede™-mist';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-mint' WHERE sku='novasuede™-mint';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-green' WHERE sku='novasuede™-green';
+UPDATE novasuede_catalog SET mfr_sku='novasuede™-gold' WHERE sku='novasuede™-gold';
+COMMIT;
diff --git a/novasuede-recon-20260826/novasuede_placeholder_restore_map_20260826.json b/novasuede-recon-20260826/novasuede_placeholder_restore_map_20260826.json
new file mode 100644
index 0000000..08b1ed3
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_placeholder_restore_map_20260826.json
@@ -0,0 +1,87 @@
+{
+ "table": "novasuede_catalog",
+ "key": "sku",
+ "column": "mfr_sku",
+ "restore": [
+ {
+ "sku": "novasuede™-red",
+ "old_mfr_sku": "novasuede™-red"
+ },
+ {
+ "sku": "novasuede™-marine-blue",
+ "old_mfr_sku": "novasuede™-marine-blue"
+ },
+ {
+ "sku": "novasuede™-lime",
+ "old_mfr_sku": "novasuede™-lime"
+ },
+ {
+ "sku": "novasuede™-gray",
+ "old_mfr_sku": "novasuede™-gray"
+ },
+ {
+ "sku": "novasuede™-lilac",
+ "old_mfr_sku": "novasuede™-lilac"
+ },
+ {
+ "sku": "novasuede™-orange",
+ "old_mfr_sku": "novasuede™-orange"
+ },
+ {
+ "sku": "novasuede™-latte",
+ "old_mfr_sku": "novasuede™-latte"
+ },
+ {
+ "sku": "novasuede™-light-camel",
+ "old_mfr_sku": "novasuede™-light-camel"
+ },
+ {
+ "sku": "novasuede™-sea-breeze",
+ "old_mfr_sku": "novasuede™-sea-breeze"
+ },
+ {
+ "sku": "novasuede™-mauve",
+ "old_mfr_sku": "novasuede™-mauve"
+ },
+ {
+ "sku": "novasuede™-java",
+ "old_mfr_sku": "novasuede™-java"
+ },
+ {
+ "sku": "novasuede™-white",
+ "old_mfr_sku": "novasuede™-white"
+ },
+ {
+ "sku": "novasuede™-mocha",
+ "old_mfr_sku": "novasuede™-mocha"
+ },
+ {
+ "sku": "novasuede™-navy",
+ "old_mfr_sku": "novasuede™-navy"
+ },
+ {
+ "sku": "novasuede™-silver",
+ "old_mfr_sku": "novasuede™-silver"
+ },
+ {
+ "sku": "novasuede™-rose",
+ "old_mfr_sku": "novasuede™-rose"
+ },
+ {
+ "sku": "novasuede™-mist",
+ "old_mfr_sku": "novasuede™-mist"
+ },
+ {
+ "sku": "novasuede™-mint",
+ "old_mfr_sku": "novasuede™-mint"
+ },
+ {
+ "sku": "novasuede™-green",
+ "old_mfr_sku": "novasuede™-green"
+ },
+ {
+ "sku": "novasuede™-gold",
+ "old_mfr_sku": "novasuede™-gold"
+ }
+ ]
+}
\ No newline at end of file
diff --git a/novasuede-recon-20260826/novasuede_reconciliation_20260826.json b/novasuede-recon-20260826/novasuede_reconciliation_20260826.json
new file mode 100644
index 0000000..7610883
--- /dev/null
+++ b/novasuede-recon-20260826/novasuede_reconciliation_20260826.json
@@ -0,0 +1 @@
+{"placeholder": [["red", "novasuede\u2122-red", "T3R8W", "DWNS-970104"], ["marine-blue", "novasuede\u2122-marine-blue", "T3N1W", "DWNS-970070"], ["lime", "novasuede\u2122-lime", "T3PEW", "DWNS-970066"], ["gray", "novasuede\u2122-gray", "T3L3W", "DWNS-970048"], ["lilac", "novasuede\u2122-lilac", "T3RAW", "DWNS-970065"], ["orange", "novasuede\u2122-orange", "T3Q2W", "DWNS-970088"], ["latte", "novasuede\u2122-latte", "T3E3W", "DWNS-970060"], ["light-camel", "novasuede\u2122-light-camel", "T3E5W", "DWNS-970063"], ["sea-breeze", "novasuede\u2122-sea-breeze", "T3N8W", "DWNS-970117"], ["mauve", "novasuede\u2122-mauve", "T3S1W", "DWNS-970072"], ["java", "novasuede\u2122-java", "T3H4W", "DWNS-970059"], ["white", "novasuede\u2122-white", "T3WHW", "DWNS-970140"], ["mocha", "novasuede\u2122-mocha", "T3H7W", "DWNS-970080"], ["navy", "novasuede\u2122-navy", "T3NAW", "DWNS-970083"], ["silver", "novasuede\u2122-silver", "T3LEW", "DWNS-970121"], ["rose", "novasuede\u2122-rose", "T3R4W", "DWNS-970105"], ["mist", "novasuede\u2122-mist", "T3DDW", "DWNS-970078"], ["mint", "novasuede\u2122-mint", "T3PAW", "DWNS-970076"], ["green", "novasuede\u2122-green", "T3P5W", "DWNS-970049"], ["gold", "novasuede\u2122-gold", "T3J9W", "DWNS-970044"]], "conflict": [["pistachio", "T3POW", "T3P6W", "DWNS-970097"], ["putty", "T3DFW", "T3K3W", "DWNS-970102"], ["raffia", "T3DCW", "T3D5W", "DWNS-970103"], ["sable", "T3I8W", "T3F7W", "DWNS-970108"], ["safari", "T3D8W", "T3E7W", "DWNS-970109"], ["saffron", "T3DGW", "T3O2W", "DWNS-970110"], ["sage", "T3PGW", "T3P3W", "DWNS-970111"], ["sand", "T3E1W", "T3D8W", "DWNS-970113"], ["sandalwood", "T3R8W", "T3F5W", "DWNS-970114"], ["scarlet-wine", "T3J8W", "T3R5W", "DWNS-970115"], ["steel", "T3LDW", "T3LBW", "DWNS-970126"], ["straw", "T3O2W", "T3DCW", "DWNS-970130"], ["strong-white", "T3B1W", "T3DAW", "DWNS-970131"], ["sugar-plum", "T3J3W", "T3S7W", "DWNS-970132"], ["sweet-lilac", "T3T1W", "T3S1W", "DWNS-970133"], ["tan", "T3E7W", "T3E1W", "DWNS-970134"], ["tarragon", "T3PNW", "T3PGW", "DWNS-970135"], ["taupe", "T3K3W", "T3K9W", "DWNS-970136"], ["thyme", "T3PBW", "T3PDW", "DWNS-970137"], ["trench", "T3L9W", "T3F2W", "DWNS-970138"], ["cocoa", "T3I5W", "T315W", "DWNS-970028"], ["black", "T3A1W", "T3BLW", "DWNS-970010"], ["royal-purple", "T3S1W", "T3S4W", "DWNS-970106"], ["sea-grass", "T3L8W", "T3P2W", "DWNS-970119"], ["sienna", "T3F7W", "T3Q7W", "DWNS-970120"], ["smoke", "T3K5W", "T3L5W", "DWNS-970123"], ["soft-clay", "T3R5W", "T3K7W", "DWNS-970124"], ["seafoam", "T3P2W", "T3N3W", "DWNS-970118"], ["ruby", "T3J9W", "T3R6W", "DWNS-970107"], ["salt", "T3DRW", "T3DBW", "DWNS-970112"], ["sky-blue", "T3N3W", "T3N5W", "DWNS-970122"], ["storm", "T3LJW", "T3LHW", "DWNS-970129"]], "nomatch": [["grape", "T3S8W", "", "DWNS-970047"]]}
\ No newline at end of file
← 654c25e zoffany durable mfr recovery builder + guarded apply/restore
·
back to Mfr Recovery 2026 08 23
·
TK-10829 Gate 1 (Steve-approved): adopt-live for 32 mis-scra e08f75e →