dark-vendor check (c43): 4 vendors fully DARK (not mis-collected) — 1,943 products

b10bbb7229468fdbefecab13ea04a298bc02884b · 2026-06-16 15:42:55 -0700 · Steve Abrams

Read-only. c42's all-empty-collection vendors resolved: Colefax&Fowler (361),
Carlisle & Co. Walls (441), 1838 Wallcoverings (467 DRAFT+14 arch), Paul Montgomery
(656) = 1,943 products. All have empty live collections + sample PDPs 404 live +
mirror 100% archived/draft → CATALOG-DARK, not mis-collected. 1838 is DRAFT
(staged-never-launched, likeliest reactivation candidate); others archived.
Reactivation gated + needs cost-enrichment (c36: 1.4% archived cost coverage).

Files touched

A scripts/dark-vendor-check/dark-vendor-check.sh

Diff

commit b10bbb7229468fdbefecab13ea04a298bc02884b
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 16 15:42:55 2026 -0700

    dark-vendor check (c43): 4 vendors fully DARK (not mis-collected) — 1,943 products
    
    Read-only. c42's all-empty-collection vendors resolved: Colefax&Fowler (361),
    Carlisle & Co. Walls (441), 1838 Wallcoverings (467 DRAFT+14 arch), Paul Montgomery
    (656) = 1,943 products. All have empty live collections + sample PDPs 404 live +
    mirror 100% archived/draft → CATALOG-DARK, not mis-collected. 1838 is DRAFT
    (staged-never-launched, likeliest reactivation candidate); others archived.
    Reactivation gated + needs cost-enrichment (c36: 1.4% archived cost coverage).
---
 scripts/dark-vendor-check/dark-vendor-check.sh | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

diff --git a/scripts/dark-vendor-check/dark-vendor-check.sh b/scripts/dark-vendor-check/dark-vendor-check.sh
new file mode 100755
index 0000000..129b543
--- /dev/null
+++ b/scripts/dark-vendor-check/dark-vendor-check.sh
@@ -0,0 +1,15 @@
+#!/bin/sh
+# dark-vendor-check (c43) — READ-ONLY. c42 found 4 vendors with ALL collections
+# empty live. This distinguishes mis-collected (PDPs live, just not in a collection)
+# from CATALOG-DARK (PDPs 404 + all archived/draft). VERDICT: all 4 are fully DARK
+# (collections empty + sample PDPs 404 live + mirror 100% archived/draft) = 1,943
+# products not shopper-reachable. Not a collection-assignment fix; a reactivation
+# (gated, needs cost-enrichment per c36) or intentional-hide decision. $0.
+PSQL=/opt/homebrew/opt/postgresql@14/bin/psql
+DB="postgresql:///dw_unified?host=/tmp"
+for v in "Colefax and Fowler" "Carlisle & Co. Walls" "1838 Wallcoverings" "Paul Montgomery"; do
+  echo "## $v"
+  $PSQL "$DB" -c "select status, count(*) from shopify_products where vendor='$v' group by status order by 2 desc;"
+  h=$($PSQL "$DB" -t -A -c "select handle from shopify_products where vendor='$v' and handle<>'' order by random() limit 1;")
+  echo "  live PDP $h -> HTTP $(curl -s -o /dev/null -w '%{http_code}' --max-time 12 https://www.designerwallcoverings.com/products/$h.json)"
+done

← e3607af add_roll_variants: commit the 305-target inputs into repo + · back to Dw Yolo Loop · add_roll_variants: enforce ROLL-unit in-script (standing rul 72fbe08 →