[object Object]

← back to Designer Wallcoverings

Carl Robinson: SKU numbers start above 100000 (GRS-100001…)

eaec822241fa927944713f8dd6de1a88b960cea2 · 2026-07-06 12:13:01 -0700 · steve@designerwallcoverings.com

Files touched

Diff

commit eaec822241fa927944713f8dd6de1a88b960cea2
Author: steve@designerwallcoverings.com <steve@designerwallcoverings.com>
Date:   Mon Jul 6 12:13:01 2026 -0700

    Carl Robinson: SKU numbers start above 100000 (GRS-100001…)
---
 scripts/wallquest-refresh/remap-skus-carl-robinson.cjs | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/scripts/wallquest-refresh/remap-skus-carl-robinson.cjs b/scripts/wallquest-refresh/remap-skus-carl-robinson.cjs
index 8e4343e7..2e911051 100644
--- a/scripts/wallquest-refresh/remap-skus-carl-robinson.cjs
+++ b/scripts/wallquest-refresh/remap-skus-carl-robinson.cjs
@@ -26,7 +26,7 @@ const numOf = r => parseInt((String(r.mfr_sku).match(/\d+/) || ['0'])[0], 10);
   for (const [mat, rows] of Object.entries(byMat)) {
     const code = CODE[mat] || 'NAT';
     rows.sort((a, b) => numOf(a) - numOf(b));
-    rows.forEach((r, i) => { seqBySku[r.mfr_sku] = `${code}-${String(i + 1).padStart(6, '0')}`; });
+    rows.forEach((r, i) => { seqBySku[r.mfr_sku] = `${code}-${100000 + i + 1}`; }); // sequential, above 100000
     dist[code] = rows.length;
   }
   for (const r of enr) r.dw_sku = seqBySku[r.mfr_sku];
@@ -44,6 +44,6 @@ const numOf = r => parseInt((String(r.mfr_sku).match(/\d+/) || ['0'])[0], 10);
   fs.writeFileSync(MAPOUT, JSON.stringify(map, null, 2));
 
   console.log('sequential DW-less SKU series:');
-  Object.entries(dist).sort((a, b) => b[1] - a[1]).forEach(([c, v]) => console.log(`  ${c}-000001 … ${c}-${String(v).padStart(6, '0')}  (${v})`));
+  Object.entries(dist).sort((a, b) => b[1] - a[1]).forEach(([c, v]) => console.log(`  ${c}-100001 … ${c}-${100000 + v}  (${v})`));
   console.log(`total=${Object.values(dist).reduce((a, b) => a + b, 0)} | map entries=${map.length} | with shopify id=${map.filter(m => m.shopify_product_id).length}`);
 })().catch(e => { console.error('ERROR', e.message); process.exit(1); });

← cf7d3da2 Carl Robinson: 6-digit sequential SKU numbers (GRS-000001…)  ·  back to Designer Wallcoverings  ·  wallquest refresh: port login fix into scrape.cjs (.login-bu 1df17882 →