vendors.js: add Kravet (costExpr cost_price) — cost loaded from GDrive wholesale list

2d60072dbb76fdba9335d631c1c15bfbe0134bc3 · 2026-06-11 11:42:28 -0700 · SteveStudio2

Kravet 0%->86.5% costed (8592/9930) from the authoritative Jan-2026 wholesale list.
discount_confirmed set in vendor_registry (cited source). Tracker total 4.8%->9.4%.

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

Files touched

M shopify/scripts/cadence/vendors.js

Diff

commit 2d60072dbb76fdba9335d631c1c15bfbe0134bc3
Author: SteveStudio2 <stevestudio2@SteveStudio2s-Mac-Studio.local>
Date:   Thu Jun 11 11:42:28 2026 -0700

    vendors.js: add Kravet (costExpr cost_price) — cost loaded from GDrive wholesale list
    
    Kravet 0%->86.5% costed (8592/9930) from the authoritative Jan-2026 wholesale list.
    discount_confirmed set in vendor_registry (cited source). Tracker total 4.8%->9.4%.
    
    Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
---
 shopify/scripts/cadence/vendors.js | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/shopify/scripts/cadence/vendors.js b/shopify/scripts/cadence/vendors.js
index f22eb730..61b0c467 100644
--- a/shopify/scripts/cadence/vendors.js
+++ b/shopify/scripts/cadence/vendors.js
@@ -26,4 +26,7 @@ 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' },
+  // 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':     { table: 'kravet_catalog',           costExpr: 'cost_price',           soldBy: 'Single Roll', productType: 'Wallcovering', discountNote: 'cost from GDrive Jan-2026 wholesale list (incl 5% tariff)' },
 };

← 4c223491 Add gdrive-price-loader.py — load vendor cost from authorita · back to Designer Wallcoverings · Wire Kravet feed into daily cadence (com.steve.kravet-feed) d38a5433 →