vendors: wire Newwall (6 confirmed lines, cost=trade_net*0.80, retail=cost/0.65/0.85); other Newwall brands stay uncosted

7c8eaf1b5303591ad76db3912f488d26f986de82 · 2026-06-12 09:17:17 -0700 · SteveStudio2

Files touched

M shopify/scripts/cadence/vendors.js

Diff

commit 7c8eaf1b5303591ad76db3912f488d26f986de82
Author: SteveStudio2 <steve@designerwallcoverings.com>
Date:   Fri Jun 12 09:17:17 2026 -0700

    vendors: wire Newwall (6 confirmed lines, cost=trade_net*0.80, retail=cost/0.65/0.85); other Newwall brands stay uncosted
---
 shopify/scripts/cadence/vendors.js | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/shopify/scripts/cadence/vendors.js b/shopify/scripts/cadence/vendors.js
index fa2518c1..d17388a0 100644
--- a/shopify/scripts/cadence/vendors.js
+++ b/shopify/scripts/cadence/vendors.js
@@ -26,6 +26,15 @@ 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' },
+  // Newwall: distributor of European lines. Website (logged-in) shows US TRADE NET in
+  // price_trade (captured via authenticated /products/{handle}.js). DW gets a confirmed
+  // 20% off trade net (Tricia Robb / Steve 2026-06-12) on EXACTLY these 6 lines:
+  // Coordonné, 17 Patterns, House of Hackney, Masi x Newwall, Tres Tintas, Wall&decò.
+  // cost = trade_net * 0.80; retail = cost/0.65/0.85. All OTHER Newwall brands have NO
+  // confirmed discount → costExpr returns NULL so they're never costed/imported.
+  'Newwall':    { table: 'newwall_catalog',
+                  costExpr: `CASE WHEN vendor_name IN ('Coordonné','17 Patterns','House of Hackney','Masi x Newwall','Tres Tintas','Wall&decò') AND price_trade > 0 THEN price_trade * 0.80 ELSE NULL END`,
+                  soldBy: 'Single Roll', productType: 'Wallcovering', discountNote: '20% off US trade net (price_trade); 6 confirmed lines only' },
   // 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,

← 6cc85e55 worker-guard: pre-push dedup guard module + 9-test harness + · back to Designer Wallcoverings · worker-guard: verify backfill table correct (launch-pad gate 3a8a8504 →