vendors: wire Brewster & York (costExpr=cost) — price list already loaded, flips coverage 0%->99.8% (+8697 SKUs)

f3aead0e586221ceb01400b241b274bd22c86ea8 · 2026-06-12 07:51:55 -0700 · SteveStudio2

Files touched

M shopify/scripts/cadence/vendors.js

Diff

commit f3aead0e586221ceb01400b241b274bd22c86ea8
Author: SteveStudio2 <steve@designerwallcoverings.com>
Date:   Fri Jun 12 07:51:55 2026 -0700

    vendors: wire Brewster & York (costExpr=cost) — price list already loaded, flips coverage 0%->99.8% (+8697 SKUs)
---
 shopify/scripts/cadence/vendors.js | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/shopify/scripts/cadence/vendors.js b/shopify/scripts/cadence/vendors.js
index 3a9317cb..fa2518c1 100644
--- a/shopify/scripts/cadence/vendors.js
+++ b/shopify/scripts/cadence/vendors.js
@@ -26,6 +26,11 @@ module.exports = {
   'York Contract': { table: 'york_contract_catalog', costExpr: 'retail_price * 0.50',  soldBy: 'Single Roll', productType: 'Wallcovering', discountNote: '50% off retail (confirmed)' },
   // WallQuest: price_retail column actually holds the COST (price_dw = our retail, verified 2026-06-11)
   'WallQuest':  { table: 'wallquest_catalog',        costExpr: 'price_retail::numeric', soldBy: 'Single Roll', productType: 'Wallcovering' },
+  // Brewster & York: downloaded price list already loaded into brewster_catalog —
+  // cost = wholesale (populated on 8697/8715 rows), us_map = MAP, price_retail = MSRP.
+  // discount_confirmed=true. retail = cost/0.65/0.85 (formula sits above us_map on samples,
+  // so MAP floor is satisfied without a sellExpr). Steve 2026-06-12 "you have the price lists".
+  'Brewster & York': { table: 'brewster_catalog',    costExpr: 'cost',                 soldBy: 'Single Roll', productType: 'Wallcovering', discountNote: 'cost from downloaded York/Brewster price list (wholesale); us_map available as MAP floor' },
   // Kravet: cost loaded from authoritative GDrive wholesale list (Kravet Price list 1-20-26.xlsx,
   // eff 2026-01-17) into cost_price = NEW WHLS incl tariff; sell floored at NEW MAP (Steve 2026-06-11).
   // Kravet + ALL subbrands (Brunschwig, Lee Jofa, GP&J Baker, Cole & Son, Donghia,

← a1d4c12e schumacher importer: dedup gallery images by URL at ingest ( · back to Designer Wallcoverings · Archive all 154 live Nicolette Mayer Wallpaper products (Ste 408f0bb9 →