source-gate: reject boolean/NULL tokens as MFR SKU in dwjs-mfr-populator (stops the TRUE-sku re-leak at source; DTD 3/3->A)

4fa1147113398ebc405610fd57a62c85735396c7 · 2026-06-17 10:03:32 -0700 · SteveStudio2

Files touched

M DW-Programming/ImportNewSkufromURL/dwjs-mfr-populator.js

Diff

commit 4fa1147113398ebc405610fd57a62c85735396c7
Author: SteveStudio2 <steve@designerwallcoverings.com>
Date:   Wed Jun 17 10:03:32 2026 -0700

    source-gate: reject boolean/NULL tokens as MFR SKU in dwjs-mfr-populator (stops the TRUE-sku re-leak at source; DTD 3/3->A)
---
 DW-Programming/ImportNewSkufromURL/dwjs-mfr-populator.js | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/DW-Programming/ImportNewSkufromURL/dwjs-mfr-populator.js b/DW-Programming/ImportNewSkufromURL/dwjs-mfr-populator.js
index 8f4243b6..83101ba9 100644
--- a/DW-Programming/ImportNewSkufromURL/dwjs-mfr-populator.js
+++ b/DW-Programming/ImportNewSkufromURL/dwjs-mfr-populator.js
@@ -83,7 +83,15 @@ function parseSpreadsheet(csvData) {
     // Column 28 = Variant Barcode (MFR SKU like SN1302)
     const handle = fields[0] || '';
     const variantSku = fields[18] || '';
-    const mfrSku = fields[28] || '';
+    let mfrSku = fields[28] || '';
+
+    // Source gate (2026-06-17): a Google-Sheets/CSV boolean (serialized uppercase TRUE/FALSE) or a
+    // NULL/UNDEFINED token must NEVER persist as an MFR SKU. A column shift landed such tokens at
+    // fields[28] (Variant Barcode), feeding "TRUE" straight into custom.manufacturer_sku + barcode
+    // for 91 active products (Innovations USA et al.). Treat them as blank so the guard below skips
+    // them — a real wallcovering MFR SKU is never a bare boolean. (DTD 3/3 -> A; see yolo memo
+    // true-sku-leak-fix-2026-06-17.)
+    if (/^(TRUE|FALSE|NULL|UNDEFINED)$/i.test(mfrSku.trim())) mfrSku = '';
 
     // Extract DWJS number from variant SKU
     const dwjsMatch = variantSku.match(/DWJS-(\d+)/);

← 3acf4037 Add prw-92xxxx logo-banner crop tool (deterministic proporti · back to Designer Wallcoverings · prw-92xxxx logo crop: 551/551 banners removed live (0 residu ea18bc58 →