[object Object]

← back to Dw Yolo Loop

null-price live-check (c37): mirror price column unreliable; no blank/$0 epidemic

ccfaa8a394ac85550e407663a25fd1024e61033c · 2026-06-16 14:09:02 -0700 · Steve Abrams

Read-only. ACTIVE shows 41,987/60,075 (70%) null price in the Mac2 mirror, but a
live storefront cross-check proves those products DO have variant prices ($4.25
sample, +real roll where applicable). The mirror price column is only ~30%
populated (split-brain — not in the replicated set), so it cannot measure live
mispricing and NO DB-side price canary may trust it. The real live issue is the
already-known $4.25-sample-as-displayed-price (GMC, 60,455), not a distinct
null/$0 mode. Negative result + instrument caveat.

Files touched

Diff

commit ccfaa8a394ac85550e407663a25fd1024e61033c
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 16 14:09:02 2026 -0700

    null-price live-check (c37): mirror price column unreliable; no blank/$0 epidemic
    
    Read-only. ACTIVE shows 41,987/60,075 (70%) null price in the Mac2 mirror, but a
    live storefront cross-check proves those products DO have variant prices ($4.25
    sample, +real roll where applicable). The mirror price column is only ~30%
    populated (split-brain — not in the replicated set), so it cannot measure live
    mispricing and NO DB-side price canary may trust it. The real live issue is the
    already-known $4.25-sample-as-displayed-price (GMC, 60,455), not a distinct
    null/$0 mode. Negative result + instrument caveat.
---
 scripts/null-price-probe/null-price-livecheck.sh | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

diff --git a/scripts/null-price-probe/null-price-livecheck.sh b/scripts/null-price-probe/null-price-livecheck.sh
new file mode 100755
index 0000000..7d283c8
--- /dev/null
+++ b/scripts/null-price-probe/null-price-livecheck.sh
@@ -0,0 +1,19 @@
+#!/bin/sh
+# null-price-livecheck (c37) — READ-ONLY. Tests whether "ACTIVE products with
+# null/0 price" is a real live-storefront problem or a Mac2-mirror artifact.
+# VERDICT: ARTIFACT — the mirror's price column is only ~30% populated on ACTIVE
+# (split-brain: not in the replicated set), and a live cross-check shows the
+# "null-price" rows actually display $4.25 (the known GMC sample issue), not $0.
+# So no DB-side price canary may trust shopify_products.price on Mac2. $0 local.
+PSQL=/opt/homebrew/opt/postgresql@14/bin/psql
+DB="postgresql:///dw_unified?host=/tmp"
+echo "## ACTIVE price-column distribution (Mac2 mirror)"
+$PSQL "$DB" -c "select count(*) active, count(*) filter (where price is null) price_null,
+  count(*) filter (where price=4.25) eq425, count(*) filter (where price>4.25) real_price
+  from shopify_products where status='ACTIVE';"
+echo "## live cross-check: 5 mirror-null-price ACTIVE products -> live storefront variant prices"
+$PSQL "$DB" -t -A -F'|' -c "select handle from shopify_products where status='ACTIVE' and price is null and handle>'' limit 5;" | while IFS= read -r h; do
+  [ -z "$h" ] && continue
+  curl -s --max-time 12 "https://www.designerwallcoverings.com/products/$h.json" \
+   | node -e 'let s="";process.stdin.on("data",d=>s+=d).on("end",()=>{try{const p=JSON.parse(s).product;console.log(process.argv[1],"-> LIVE:",(p.variants||[]).map(x=>x.price).join(", "))}catch(e){console.log(process.argv[1],"-> (no json)")}})' "$h"
+done

← cb534c8 dark-inventory scan (c36): only 1,062 sellable-ready archive  ·  back to Dw Yolo Loop  ·  Kravet ROLL reprice DRY-RUN (read-only, variant-level): 450 7f37828 →