← back to Dw Sku Integrity
TK-10896: README current — canonical recovery status + full tool inventory
48d71e378f001c16b16f919532947ee8d0719fe8 · 2026-08-31 01:39:15 -0700 · codex-10896
Files touched
Diff
commit 48d71e378f001c16b16f919532947ee8d0719fe8
Author: codex-10896 <steve@designerwallcoverings.com>
Date: Mon Aug 31 01:39:15 2026 -0700
TK-10896: README current — canonical recovery status + full tool inventory
---
README.md | 37 +++++++++++++++++++++++++++++++------
1 file changed, 31 insertions(+), 6 deletions(-)
diff --git a/README.md b/README.md
index 83d9322..b35d906 100644
--- a/README.md
+++ b/README.md
@@ -31,15 +31,40 @@ existing `sku`.
- Any actual `dw_sku` write is canonical + customer-facing → **gated** (drafted to
`~/.claude/yolo-queue/pending-approval/`, ledgered, reversible). Not this repo's job.
+## Status — recoverable-now RECOVERY COMPLETE (2026-08-31)
+
+Executed against **canonical Kamatera** (not the mirror — the mirror was stale, see
+`evidence/ANALYSIS-2026-08-30.md`). Canonical blank `dw_sku` backlog **15,415 → 10,868**;
+**4,547 codes recovered** (2,645 self-copy across 19 vendors + 2,000 Carnegie staging-link),
+all EXISTING scraper-assigned codes, **zero mints**, every batch `preflight → apply →
+verify GO`, reversible + ledgered. Remaining 10,868 = 10,671 re-scrape (TK-10900) +
+145 `null-Sample` import-defect (TK-10900) + 42 provenance-review + 8 dedup (TK-10649).
+
## Files
- `classify.mjs` — pure classifier: `stripUnitSuffix()`, `classifyRow()`, `RECOVERY_GROUP`.
-- `dwsku-backlog-scan.mjs` — read-only DB scanner → segmentation summary + plan JSONL.
-- `provenance-ledger-join.mjs` — local-only, fail-closed join for a future exact
- `sku_repair_p4_20260826` JSONL export; requires a completeness manifest, row count,
- and SHA-256 before releasing any mixed-prefix candidate.
-- `test/*.test.mjs` — 32 unit tests (`node --test`).
-- `evidence/` — committed scan outputs + the analysis writeup.
+- `dwsku-backlog-scan.mjs` — read-only DB scanner (parameterized via `DWSKU_PSQL`) → segmentation + plan JSONL.
+- `provenance-ledger-join.mjs` — local-only, fail-closed join of the SHA-256-verified
+ reverted-mint undo ledger; ledger membership decides residue-vs-native for every DW-code row.
+- `apply-plan-gen.mjs` — read-only generator of GATED per-vendor self-copy `apply.sql` /
+ `undo.sql` / `restore-map.json`, keyed on `shopify_id` (stable cross-machine).
+- `staging-link-gen.mjs` — read-only generator of GATED staging-link plans (recover
+ `dw_sku` via `mfr_sku → <vendor>_catalog.dw_sku`, cross-machine: Kamatera rows × Mac2 catalog).
+- `preflight-check.mjs` — read-only GO/NO-GO checker; `--mode preflight` (before) / `--mode verify` (after).
+- `fire-self-copy.sh` / `fire-staging-link.sh` — Steve-run guarded `preflight→apply→verify→ledger` loops.
+- `RUNBOOK.md` — the turnkey per-vendor gated firing runbook.
+- `test/*.test.mjs` — 47 unit tests (`node --test`).
+- `evidence/` — committed scan outputs (mirror + canonical) + the analysis writeup.
+
+## Canonical target (all read-only tools + the gated writes)
+
+```bash
+export DWSKU_PSQL='ssh root@45.61.58.125 psql dw_unified' # canonical Kamatera
+node dwsku-backlog-scan.mjs # SELECT-only segmentation
+node preflight-check.mjs --plan-dir apply-plans-canonical --vendor <v> # GO before firing
+node preflight-check.mjs --plan-dir apply-plans-canonical --vendor <v> --mode verify # GO after
+# the apply itself is a canonical customer-facing write — HARD-GATED, fired by Steve via the fire-*.sh scripts.
+```
## Usage
← 5f639b2 TK-10896: staging-link-gen + Carnegie 2,000 plan (preflight
·
back to Dw Sku Integrity
·
chore: lint (node --check clean) + v0.2.0 (session close — c b5f98d8 →