TK-10978 pre-approval audit: Coordonné 136 dry-run broken (dirty mfr_sku, join=0, content-match=0); Donghia moot (2 left); RW=280 only recoverable cohort. Read-only, no writes

548c7af1142c684193b45886e7b5566420d2aa37 · 2026-09-02 09:50:53 -0700 · Steve Abrams

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

Files touched

A data/remaining-cohort-audit-2026-09-02.md

Diff

commit 548c7af1142c684193b45886e7b5566420d2aa37
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Sep 2 09:50:53 2026 -0700

    TK-10978 pre-approval audit: Coordonné 136 dry-run broken (dirty mfr_sku, join=0, content-match=0); Donghia moot (2 left); RW=280 only recoverable cohort. Read-only, no writes
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
 data/remaining-cohort-audit-2026-09-02.md | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/data/remaining-cohort-audit-2026-09-02.md b/data/remaining-cohort-audit-2026-09-02.md
new file mode 100644
index 0000000..5e08138
--- /dev/null
+++ b/data/remaining-cohort-audit-2026-09-02.md
@@ -0,0 +1,13 @@
+# TK-10978 — Pre-approval audit of the remaining unbuyable dry-run cohorts (2026-09-02)
+
+READ-ONLY re-verification against the current live mirror. **Purpose: stop a stale/broken dry-run plan from being approved.** Triggered by finding that Rebel Walls' claimed identity join yielded 0 in reality.
+
+| Cohort | Dry-run claim | Reality today | Verdict |
+|---|---|---|---|
+| **Rebel Walls** | "494 clean, cost staged" | RS-series mfr **absent** from catalog; identity join = 0. Content-match: **280 safe** / 10 ambiguous / 204 need re-scrape | Corrected plan drafted → `pending-approval/2026-09-02-TK10978-rebelwalls-494-CORRECTED-plan.md` |
+| **Coordonné** | "136 clean, mfr_sku identity join" | Live mfr_sku is dirty (`"6461256 Durable Vinyl"`) → identity join = **0**; numeric-prefix match spurious; naive content-match = **0** (catalog `pattern_name` bakes color: "Leaf Craze White") | **NOT approvable as-is.** Needs real identity reconciliation or a re-scrape. Do not approve the 08-31 dry-run. |
+| **Donghia** | "152 clean, mfr_sku identity join" | Mirror shows only **2** unbuyable now | Stale/moot — recovered elsewhere or flags flipped. No action. |
+
+**Cross-cutting lesson (reinforces the methodology memory):** a dry-run plan's "clean count" is only trustworthy if the *join it claims* is re-verified against current data — live `mfr_sku` values drift (dirty suffixes, series changes) and the mirror's `has_product_variant` is unreliable. Always re-probe the join before approving.
+
+**Net residual for TK-10978 recovery:** Rebel Walls 280 (drafted, gated, pilot-first) is the only remaining data-recoverable cohort. Coordonné needs a scoped reconcile project; Track B (Koroseal/Maya/etc.) still needs Steve cost lists (TK-11042); Innovations 51 still needs the vendor recipient + email approval (TK-11041). No writes fired.

← e1bec63 TK-10978 Rebel Walls RW-494 CORRECTED dry-run: RS-series abs · back to Dw Unbuyable Recovery Pilot · TK-10978 RebelWalls: read-only recon + reversible archive ex ae3731d →