dup-sku scan (c50): genuine dup-SKU ~0 (all colorways); found 529 placeholder/junk SKUs

94244424419000f397ab41059bd83841cc3e533f · 2026-06-16 19:22:38 -0700 · Steve Abrams

Read-only. 2-layer skeptical decode: 2,539 shared-SKU groups raw, but the top are
maker-name placeholders (SANCAR=Versace, the known false positive) and the digit-SKU
shares are colorways of one pattern sharing the vendor's pattern-level SKU (Scalamandre
WP####, Nina Campbell NCW####). Genuine two-different-products-same-real-SKU defects ~0.
REAL finding: 529 ACTIVE products carry a placeholder/junk SKU (no-digit, shared):
SANCAR 179 / TRUE 91 (boolean string leaked into SKU!) / YORK 57 / OSBORNE 56 /
INNOVATIONS 52 / DONGHIA 16 + descriptive strings. Breaks SKU lookup/dedup + junk MPN
to Google. Fix gated.

Files touched

A scripts/dup-sku-scan/dup-sku-scan.sh

Diff

commit 94244424419000f397ab41059bd83841cc3e533f
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 16 19:22:38 2026 -0700

    dup-sku scan (c50): genuine dup-SKU ~0 (all colorways); found 529 placeholder/junk SKUs
    
    Read-only. 2-layer skeptical decode: 2,539 shared-SKU groups raw, but the top are
    maker-name placeholders (SANCAR=Versace, the known false positive) and the digit-SKU
    shares are colorways of one pattern sharing the vendor's pattern-level SKU (Scalamandre
    WP####, Nina Campbell NCW####). Genuine two-different-products-same-real-SKU defects ~0.
    REAL finding: 529 ACTIVE products carry a placeholder/junk SKU (no-digit, shared):
    SANCAR 179 / TRUE 91 (boolean string leaked into SKU!) / YORK 57 / OSBORNE 56 /
    INNOVATIONS 52 / DONGHIA 16 + descriptive strings. Breaks SKU lookup/dedup + junk MPN
    to Google. Fix gated.
---
 scripts/dup-sku-scan/dup-sku-scan.sh | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/scripts/dup-sku-scan/dup-sku-scan.sh b/scripts/dup-sku-scan/dup-sku-scan.sh
new file mode 100755
index 0000000..6015e0a
--- /dev/null
+++ b/scripts/dup-sku-scan/dup-sku-scan.sh
@@ -0,0 +1,13 @@
+#!/bin/sh
+# dup-sku-scan (c50) — READ-ONLY. Looked for distinct ACTIVE products sharing one
+# mfr_sku (data-integrity dup). VERDICT after 2-layer skeptical decode: genuine
+# duplicate-SKU defects ~0 — every "shared SKU" is colorways of one pattern sharing
+# the vendor's pattern-level SKU (Scalamandre WP####, Nina Campbell NCW####). BUT
+# the decode surfaced a real issue: 529 ACTIVE products carry a PLACEHOLDER/junk SKU
+# (no-digit, shared): SANCAR 179 / TRUE 91 (boolean leak!) / YORK 57 / OSBORNE 56 /
+# INNOVATIONS 52 / DONGHIA 16 + descriptive strings — not real SKUs. $0 local.
+PSQL=/opt/homebrew/opt/postgresql@14/bin/psql
+DB="postgresql:///dw_unified?host=/tmp"
+echo "## placeholder/junk SKUs (no-digit mfr_sku shared >3 active products)"
+$PSQL "$DB" -c "select upper(trim(mfr_sku)) sku, count(distinct handle) products, left(string_agg(distinct vendor,', '),60) vendors from shopify_products where status='ACTIVE' and mfr_sku<>'' and trim(mfr_sku) !~ '[0-9]' group by upper(trim(mfr_sku)) having count(distinct handle)>3 order by 2 desc limit 20;"
+$PSQL "$DB" -c "with p as (select upper(trim(mfr_sku)) sku from shopify_products where status='ACTIVE' and mfr_sku<>'' and trim(mfr_sku) !~ '[0-9]' group by upper(trim(mfr_sku)) having count(distinct handle)>3) select count(*) placeholder_sku_products from shopify_products where status='ACTIVE' and upper(trim(mfr_sku)) in (select sku from p);"

← 91e962c orphan-products scan (c49): PASS — 0 un-navigable products o · back to Dw Yolo Loop · body-quality scan (c51): 187 empty + 64 code-fence leaks; 14 b5a6309 →