Map Osborne length and repeat columns so cadence reaches inventory

42d6a0bfd4821ee7ea563a0bc28acf67bd9b53ac · 2026-09-11 09:17:13 -0700 · Steve Abrams

Files touched

M shopify/scripts/cadence/vendors.js

Diff

commit 42d6a0bfd4821ee7ea563a0bc28acf67bd9b53ac
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Fri Sep 11 09:17:13 2026 -0700

    Map Osborne length and repeat columns so cadence reaches inventory
---
 shopify/scripts/cadence/vendors.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/shopify/scripts/cadence/vendors.js b/shopify/scripts/cadence/vendors.js
index 969c8555..4321835f 100644
--- a/shopify/scripts/cadence/vendors.js
+++ b/shopify/scripts/cadence/vendors.js
@@ -35,7 +35,7 @@ module.exports = {
   // remaining terms both equal the correct landed cost AND still guard the corrupt-low-total case.
   'Romo':       { table: 'romo_catalog',           costExpr: 'GREATEST(COALESCE(NULLIF(total_price_per_roll,0),0), COALESCE(NULLIF(trade_price_per_roll,0),0)*(1+COALESCE(tariff_pct,0)/100))', soldBy: 'Single Roll', productType: 'Wallcovering', note: 'landed cost = total_price_per_roll (= trade_price_per_roll * (1+tariff), authoritative per trade.theromogroup.com). Single 5% tariff only — never *1.10.' },
   'Thibaut':    { table: 'thibaut_catalog',         costExpr: 'your_cost',            soldBy: 'Single Roll', productType: 'Wallcovering' },
-  'Osborne & Little': { table: 'osborne_catalog',   costExpr: 'price_trade',          soldBy: 'Single Roll', productType: 'Wallcovering' },
+  'Osborne & Little': { table: 'osborne_catalog',   costExpr: 'price_trade',          soldBy: 'Single Roll', productType: 'Wallcovering', colOverrides: { roll_length: 'length', pattern_repeat: 'repeat_v' } }, // actual catalog columns; otherwise hourly import aborts before inventory flush (TK-11426)
   'Greenland':  { table: 'greenland_catalog',      costExpr: 'NULL::numeric',        soldBy: 'Made to Order', productType: 'Wallcovering', note: 'quote-only cork line — NULL price + quotes tag; activate-gated bypasses the price gate via the quotes exemption' },
   // Zoffany: folded into the metered cadence 2026-06-23 (Steve) after disabling the standalone
   // zoffany-onboard-push burst job. price_trade is our cost; retail = cost/0.65/0.85. 31 net-new costed.

← eca00056 auto-data-snapshot: 2026-09-11T08:57:34 (21 data files) — DW · back to Designer Wallcoverings · auto-data-snapshot: 2026-09-11T09:31:49 (6 data files) — DW- ca0a4ab8 →