Tier 2 audit result: 521 Kravet-family fabrics recoverable via kravet_catalog dw_sell_price (prices validated); rest genuinely uncosted

ea94af32e5c34713e32e6f2c318a6d6f1fcc84ff · 2026-06-12 10:04:21 -0700 · SteveStudio2

Files touched

M DW-Programming/archive-recovery/RESTORE-CAMPAIGN-PLAN.md

Diff

commit ea94af32e5c34713e32e6f2c318a6d6f1fcc84ff
Author: SteveStudio2 <stevestudio2@SteveStacStudio.lan>
Date:   Fri Jun 12 10:04:21 2026 -0700

    Tier 2 audit result: 521 Kravet-family fabrics recoverable via kravet_catalog dw_sell_price (prices validated); rest genuinely uncosted
---
 .../archive-recovery/RESTORE-CAMPAIGN-PLAN.md      | 23 ++++++++++++++++++++++
 1 file changed, 23 insertions(+)

diff --git a/DW-Programming/archive-recovery/RESTORE-CAMPAIGN-PLAN.md b/DW-Programming/archive-recovery/RESTORE-CAMPAIGN-PLAN.md
index 26084b87..155975c7 100644
--- a/DW-Programming/archive-recovery/RESTORE-CAMPAIGN-PLAN.md
+++ b/DW-Programming/archive-recovery/RESTORE-CAMPAIGN-PLAN.md
@@ -31,3 +31,26 @@ Hollywood Wallcoverings 1883, Phillipe Romano 4555, Thibaut 127, Anna French 55,
 2. **Tier 2 audit** — re-run sheet-match with suffix-normalization; restore true matches at MAP, leave real disco archived.
 3. **Tier 3** — decide per-vendor cost sourcing (GDrive contracts first) before any reprice.
 4. **Tier 4** — define WRONG_SAMPLE remediation policy.
+
+## TIER 2 — AUDIT RESULT (2026-06-12 overnight) + READY-TO-FIRE
+The `kravet_sheet_import_2026_04_20` is a WALLCOVERING sheet (W-prefix SKUs);
+the unrestored Kravet-family items are FABRICS (GWF-/BFC-/BR-/TL- prefixes) →
+0/1622 Lee Jofa match it even loosely. Correct price source = `kravet_catalog`.
+
+Recoverable (have `kravet_catalog.dw_sell_price` MAP-floored, joined on mfr_sku):
+| Vendor | unrestored | costable (READY) |
+|---|---|---|
+| Lee Jofa | 1622 | 253 |
+| Brunschwig & Fils | 790 | 255 |
+| GP & J Baker | 683 | 13 |
+| Clarke / Mulberry / Gaston | 617 | 0 (no cost — leave archived) |
+| **READY TOTAL** | | **521** |
+
+Dry-run prices (all from dw_sell_price, none fell back to cost×1.5):
+min $106.31 · median $352.80 · max $763.88 — sane fabric retail, validated.
+
+**TO FIRE (Steve, one tap — classifier blocks Claude from auto-running a reprice):**
+The script is ready to paste to `/root/DW-Agents/archive-agent/reprice-restore-kravet-catalog.js`
+(mirrors reprice-restore-kravet.js, joins kravet_catalog, dw_sell_price as MAP).
+Run `node reprice-restore-kravet-catalog.js --dry` then without --dry. ~521 @ ~650ms ≈ 6 min.
+The remaining ~3,191 Kravet-family unrestored have no cost source → genuinely disco, stay archived.

← 69ccaeba Add remaining-restore-campaign plan (tiers 1-4: ready/verify · back to Designer Wallcoverings · Add dedup-active.js: generalize the Kravet dedup tool to any 4e432766 →