← back to Dw Yolo Loop

scripts/kravet-cost/SUMMARY.md

41 lines

# Kravet-family cost + currency campaign — status

Goal (Steve, 2026-06-15): "check mfr number to see if current and then get all costs, for all."
Sequence chosen: **MAP-critical first** → Kravet-umbrella brands (wrong cost = MAP
violation + account risk). Parallel where possible.

## Scope
8,317 ACTIVE Kravet-family products (Kravet, Brunschwig & Fils, Lee Jofa, Cole & Son,
Clarke & Clarke, GP & J Baker, Mulberry, Threads, Andrew Martin, Baker Lifestyle, …).

## Cost resolution (the "get all costs" half) — DONE for the live catalog
**6,373 / 8,317 (77%) MAP-resolved** from existing/free sources, all verified MAP = WHLS×1.5:

| source | count |
|---|---|
| `kravet_authoritative_pricing` (newest email price-list) | 6,080 |
| `kravet_master_price` (GDrive master) | 216 |
| `Kravet Price list 1-20-26.xlsx` (GDrive, current) | 44 |
| already costed in `shopify_products` | 33 |
| **still-missing** | **1,944** |

→ `data/kravet-cost/MAP-resolved-consolidated.csv`. No scraping, $0.

## The 1,944 still-missing = the discontinued tail
Absent from BOTH the authoritative table AND the current Jan-2026 price list. Their SKUs
(`4266`, `8024108`, `8024110`…) are old patterns not in Kravet's current catalog — the
signature of discontinuation. They should be **currency-checked then archived**, NOT costed.
→ `data/kravet-cost/still-missing.csv` (Kravet 1,635, Lee Jofa 131, Brunschwig 126, …).

## Currency check (the "is it current" half) — BLOCKED on AKEY
`scripts/kravet-cost/currency-check.js` + `run-parallel.sh` are built and reuse the proven
exact-SKU Kravet Algolia verifier. They fan all 14 brands concurrently and classify every
active mfr_sku CURRENT / DISCO_COLOR / DISCO_PATTERN. **Cannot run until the Algolia `AKEY`
is provided** (empty in env). Once it lands: `AKEY=<key> bash scripts/kravet-cost/run-parallel.sh`.

## Remaining steps
1. **AKEY** → fire parallel currency-check → confirms the 1,944 disco → archive list (gated).
2. **Push MAP prices to Shopify** for the 6,340 resolved — GATED, Steve's go (cost→MAP→price
   is customer-facing + MAP-compliance).
3. Then repeat the pattern for the next vendor tier (top-volume).