Dw Catalog 404 Audit
repo: ~/Projects/dw-catalog-404-audit · 6 commits · 0 in last 24h, 0 in last 7d ·
Creative ideas + design notes
Commits with substantial prose (≥120 chars) — the rationale behind each move.
fa1f6c5 · 2026-06-26 · FIX 3(a): full-scan publication diagnostic — confirm published_at predicts 404, populate online_store_published, candidate CSV
- fetch-publication-status.py pages Admin API (76,192 active, 0 throttle, call-limit steady 1/80)
- mechanism CONFIRMED 10/10: published_at NULL => storefront 404, published_at set => 200
- 1,743 ACTIVE-but-unpublished (exact, full-scan); concentrated in Surface Stick 742 / PS Removable 735 / Schumacher 265
- added nullable online_store_published col to local dw_unified.shopify_products, populated 75,610 rows
- unpublished-active-candidates.csv = the true 404 population
File tree
12 files tracked. Click any to browse the source at HEAD.
rendered in 0ms