← back to Dw Add Sellable Variant Tk10902

tk10456/price-snapshots/PROVENANCE.md

19 lines

# TK-10456 price load — provenance (2026-08-31T13:05:13-0700)
Loaded reseller-sourced RETAIL prices into dw_unified staging (Mac2-canonical *_catalog). Shopify NOT touched.

## MDC (mdc_catalog.price_retail) — 731 cohort rows
- Source: commercialwalldecor.com (per-SKU verified) + wallpaperboulevard.com (nvolve collection)
- lentexcontract/jonathanmarkdesigns/restorationelements/taniyanayak/vyconcontract/thomfilicia = $26.99/yd (597 SKUs, high conf)
- nvolve (PVC-free ENV) = $29.99/yd (134 SKUs, MEDIUM conf — collection-level, WPB JS prices)
- All 54" wide, per linear yard, 30yd standard bolt + cut fee; memo sample $5.99
- BEFORE = NULL for all 731 (verified 0/731 priced). Undo: SET price_retail=NULL WHERE mfr_sku IN mdc-restore-mfr-skus.txt

## Pierre Frey (our_price) — 63 of 67 priced
- Source: ladesignconcepts.com RETAIL/MSRP (NOT the 40%-off sale), per yard
- 11 wallpaper (pierre_frey_catalog) + 52 fabric (pierre_frey_fabric_catalog); range $312–$1,761/yd
- 4 NOT loaded (need human eyeball): Simone Creme 600954, Volutes 604514, Chaumont 604298, Parterre Jardin 605729
- BEFORE snapshot: pf-before-*.csv (old our_price all NULL). Undo: restore our_price from that CSV.

## NOTE — these are RESELLER-RETAIL market anchors, not cost-derived (DW rule retail=cost/0.65/0.85 needs cost we don't have).
Confirm DW sell price / markup before any Shopify push. Staging load only; the Shopify variant-price write stays GATED.