`README.md`

24 lines
# York + York PL reprice — August 2026 master

Source: York Design Group official US master `2026WallpaperMaster-US-August2026.xlsx`
(Google Drive, owned info@designerwallcoverings.com), loaded 2026-07-10.

## Pricing rule (DTD verdict A, 2026-07-10)
Sell at **US MAP**; where MAP is blank derive **MAP = US MSRP × 0.85** (dominant
observed ratio). York enforces MAP; consistent with how DW prices the Kravet family.
Per-line caveat: a few collections cluster at 0.75 / 0.667 — revisit before a
blanket 0.85 on those.

## DB objects (local dw_unified)
- `york_master_aug2026` — authoritative master (14,052 rows), additive, non-destructive.
- `york_master_priced` (view) — one row per barcode with computed `new_price`.

## Deliverables (data/)
- `york-reprice-plan.csv` — 2,798 carried SKUs to reprice (1,884 real changes + 914 newly-priced).
- `york-new-items.csv` — 1,238 master "New" items we don't yet carry (Brewster 791 · A-Street 435 · York DS 12).
- `york-disco.csv` — 578 carried SKUs now Dead/Phasing (disco candidates; 73 flagged on Shopify).

## GATED (needs Steve go)
Live Shopify reprice, new-product creation, and archiving are NOT executed.
Authoritative live match = Shopify API by variant barcode (mirror on_shopify flag is sparse/stale).