[object Object]

← back to Dw Yolo Loop

specs pattern-crosswalk probe (c33): PARTIAL feasibility + structural ceiling

150b6a140db028e1bbaea9e2dfcca3c32ec5d734 · 2026-06-16 13:23:24 -0700 · Steve Abrams

Read-only follow-up to c32. Width/material are per-pattern, so pattern_name (100%
populated both sides) can bridge the SKU-namespace gap WITHOUT exact-SKU. Coverage:
Clarke 288/1392 (21%), Coordonné 451/1320 (34%) live products. Ceiling is
structural — vendor-direct catalog is wallpaper-only (CCW), so it can't cover the
1,028 distributor-imported Clarke fabrics (F#). Path: pattern-crosswalk for the
partial free win + distributor (Cowtan) re-scrape for the rest.

Files touched

Diff

commit 150b6a140db028e1bbaea9e2dfcca3c32ec5d734
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 16 13:23:24 2026 -0700

    specs pattern-crosswalk probe (c33): PARTIAL feasibility + structural ceiling
    
    Read-only follow-up to c32. Width/material are per-pattern, so pattern_name (100%
    populated both sides) can bridge the SKU-namespace gap WITHOUT exact-SKU. Coverage:
    Clarke 288/1392 (21%), Coordonné 451/1320 (34%) live products. Ceiling is
    structural — vendor-direct catalog is wallpaper-only (CCW), so it can't cover the
    1,028 distributor-imported Clarke fabrics (F#). Path: pattern-crosswalk for the
    partial free win + distributor (Cowtan) re-scrape for the rest.
---
 .../probe-pattern-crosswalk.sh                     | 25 ++++++++++++++++++++++
 1 file changed, 25 insertions(+)

diff --git a/scripts/specs-crosswalk-probe/probe-pattern-crosswalk.sh b/scripts/specs-crosswalk-probe/probe-pattern-crosswalk.sh
new file mode 100755
index 0000000..35a5d30
--- /dev/null
+++ b/scripts/specs-crosswalk-probe/probe-pattern-crosswalk.sh
@@ -0,0 +1,25 @@
+#!/bin/sh
+# probe-pattern-crosswalk (c33) — READ-ONLY feasibility test of bridging the
+# specs SKU-namespace gap (c32) via pattern_name instead of exact SKU. Width &
+# material are per-PATTERN (constant across colorways), so a pattern-level match
+# suffices to assign specs. Verdict: PARTIAL — Clarke 288/1392 (21%), Coordonne
+# 451/1320 (34%) live products covered; ceiling is structural (vendor-direct
+# catalog is wallpaper-only CCW, can't cover the 1,028 distributor fabrics F#).
+# READ-ONLY. $0 (local PG mirror).
+PSQL=/opt/homebrew/opt/postgresql@14/bin/psql
+DB="postgresql:///dw_unified?host=/tmp"
+for v in "Clarke And Clarke:clarke_clarke_catalog" "Coordonné:coordonne_catalog"; do
+  vendor="${v%%:*}"; cat="${v##*:}"
+  echo "## $vendor vs $cat — pattern-name crosswalk coverage"
+  $PSQL "$DB" -c "
+    with cat as (
+      select distinct lower(regexp_replace(
+        case when color_name>'' then regexp_replace(pattern_name,color_name,'','i') else pattern_name end,
+        '[^a-z0-9]','','gi')) p
+      from $cat where width_inches is not null)
+    select count(*) live_products,
+      count(*) filter (where lower(regexp_replace(pattern_name,'[^a-z0-9]','','gi')) in (select p from cat)) covered_by_pattern_crosswalk
+    from shopify_products where vendor='$vendor' and status='ACTIVE' and pattern_name>'';"
+done
+echo "## live Clarke product-type split (catalog is wallpaper-only)"
+$PSQL "$DB" -c "select case when mfr_sku like 'F%' then 'fabric F#' when mfr_sku like 'W%' then 'wallpaper W#' else 'other' end typ, count(*) from shopify_products where vendor='Clarke And Clarke' and status='ACTIVE' group by 1 order by 2 desc;"

← 83eb6fa specs-reparse sizing (c32): the data exists but won't join —  ·  back to Dw Yolo Loop  ·  canary promotion harness (c34): stage 5 new canaries as inst e3d61c1 →