TK-10670: refresh+verify reconcile vs live; A-bucket restore-map; gated memos drafted

5dccd8f9ab523b77c61509c76bc32bb7f0eaa10e · 2026-09-09 16:16:14 -0700 · Steve Abrams

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01FNCX2YWmCc6caseictb5F9

Files touched

M artifacts/RECONCILIATION.md

Diff

commit 5dccd8f9ab523b77c61509c76bc32bb7f0eaa10e
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Sep 9 16:16:14 2026 -0700

    TK-10670: refresh+verify reconcile vs live; A-bucket restore-map; gated memos drafted
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
    Claude-Session: https://claude.ai/code/session_01FNCX2YWmCc6caseictb5F9
---
 artifacts/RECONCILIATION.md | 44 ++++++++++++++++++++++++++++++++++++--------
 1 file changed, 36 insertions(+), 8 deletions(-)

diff --git a/artifacts/RECONCILIATION.md b/artifacts/RECONCILIATION.md
index fcebf3a..8e670c3 100644
--- a/artifacts/RECONCILIATION.md
+++ b/artifacts/RECONCILIATION.md
@@ -44,13 +44,41 @@ A-bucket (126) gated rewrite — the only high-confidence tier — for Steve.
 `shopify_id, handle, live_sku, mfr_sku, k(normalized), target_dwnm, has_target, live_already_ok`.
 Current: 126 matched / 418 unmatched-flagged / 0 already-ok.
 
-## Gated (NOT executed — pending-approval when ready)
-- Live variant-SKU rewrite on the 543 products (customer-facing).
-- Publish of the ~751 catalog rows not yet on Shopify.
-- Any live price write (BLOCKED separately — see pricing branch).
+## Refresh + verify vs CURRENT live state (2026-09-09, vp-dw-commerce)
+Live Newmor = 542 (116 ACTIVE / 189 DRAFT / 237 ARCHIVED). Staging `newmor_sku_reconcile` = 544 rows.
+Disposition × current live status (verified by gid join to a live Shopify pull):
+
+| bucket | count | live status | @ $4.25 |
+|--------|-------|-------------|---------|
+| A_MATCHED               | 126 | 116 ACTIVE (showroom) + 9 DRAFT (Arona) + 1 deleted | 125 |
+| B_PATTERN_ONLY          | 180 | 180 DRAFT (the "holds")                            | 180 |
+| C_NO_CATALOG_COUNTERPART| 235 | 234 ARCHIVED + 1 deleted                           | 234 |
+| JUNK                    | 3   | 3 ARCHIVED                                          | 3   |
+
+Total at $4.25 = **542/544** (2 catalog-era rows carry null price). Clean mapping: 116 active +
+189 draft (9 arona + 180 holds) + 237 archived (234 C + 3 JUNK). The disposition model is fully
+consistent with current live state — no re-derive needed.
+
+Key A-bucket facts (drive the gated rewrite memo): all 125 live A-bucket products are single-variant
+(Sample only, $4.25 — Newmor is a quote-only showroom line, no sellable variant by design). NO
+`dw_sku` metafield exists anywhere on the line (verified live ACTIVE + DRAFT + the onboarded alacha
+shape) — DWNM identity is variant-SKU-only. `custom.manufacturer_sku` already holds the clean mfr
+code. All 126 targets are distinct DWNM-58xxxx; new SKUs have 0 self-dupes + 0 live collisions.
+
+## Gated (NOT executed — pending-approval, drafted 2026-09-09)
+- **A-bucket variant-SKU rewrite** (125 live products → DWNM-58xxxx-Sample), restore-mapped:
+  `pending-approval/2026-09-09-TK-10670-newmor-A-bucket-sku-normalize.md`
+  (restore map: `artifacts/A-BUCKET-SKU-RESTORE-MAP.json`). ZERO metafield writes.
+- **Consolidated vendor reply to Jill** (Arona status + specifier terms + 180-hold status):
+  `pending-approval/2026-09-09-TK-10670-newmor-consolidated-vendor-reply-jill.md`
+  (supersedes the split Arona + quote-terms drafts). DRAFT ONLY.
+- **C-bucket disposition** (235 rows, 17 patterns 100% absent from catalog, already ARCHIVED) —
+  Steve decision ARCHIVE vs RE-SCRAPE: `pending-approval/2026-09-09-TK-10670-newmor-C-bucket-disposition-decision.md`.
+- Publish of catalog rows not yet on Shopify — still gated (unchanged).
+- Any live price write — BLOCKED (Newmor is a showroom/quote-only line; no material prices per Steve 2026-09-08).
 
 ## Branch status
-- SKU normalization: IN PROGRESS (match rate too low → cycle-2 fuzzy pass).
-- Metafield map: DEFINED (see METAFIELD-MAP.md); backfill gated + depends on refresh.
-- Catalog refresh: BLOCKED — newmor-agent (Norman, :9695) is DOWN in pm2.
-- Pricing: PARKED — `newmor_catalog` has 0/1294 cost; needs LBI Boyd cost list (vendor-price-ingest).
+- SKU normalization: A-bucket (125) READY — gated rewrite memo drafted; B/C need vendor confirmation / decision.
+- Metafield map: DEFINED (see METAFIELD-MAP.md); no dw_sku metafield on the line — do NOT fork the schema.
+- Catalog refresh: BLOCKED — newmor-agent (Norman, :9695) ABSENT from pm2 (re-provisioning, out of scope).
+- Pricing: PARKED — showroom/quote-only line; LBI Boyd quotes on request (no price sheet).

← e8ccb9c auto-data-snapshot: 2026-09-09T16:10:41 (1 data files) — art · back to Newmor Onboard · TK-10670: A-bucket SKU normalize executed (125 products) 8fce1e7 →