Monitor uses 2026 authoritative pricing (kravet_authoritative_pricing.new_map), not stale 2022 snapshot

4b00794e71aa91afb35dff2e1bd9c60ab1313149 · 2026-06-11 23:07:26 -0700 · SteveStudio2

Files touched

M shopify/scripts/cadence/kravet-price-monitor.js

Diff

commit 4b00794e71aa91afb35dff2e1bd9c60ab1313149
Author: SteveStudio2 <stevestudio2@SteveStacStudio.lan>
Date:   Thu Jun 11 23:07:26 2026 -0700

    Monitor uses 2026 authoritative pricing (kravet_authoritative_pricing.new_map), not stale 2022 snapshot
---
 shopify/scripts/cadence/kravet-price-monitor.js | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/shopify/scripts/cadence/kravet-price-monitor.js b/shopify/scripts/cadence/kravet-price-monitor.js
index a41486f3..6e306869 100644
--- a/shopify/scripts/cadence/kravet-price-monitor.js
+++ b/shopify/scripts/cadence/kravet-price-monitor.js
@@ -44,11 +44,11 @@ function ddl(){
   const cursor = psql(`SELECT v FROM kravet_monitor_state WHERE k='cursor'`) || '0';
   const rows = psql(`
     WITH cand AS (
-      SELECT DISTINCT s.shopify_id, s.mfr_sku, a.map_price
+      SELECT DISTINCT s.shopify_id, s.mfr_sku, a.new_map AS map_price
         FROM shopify_products s
-        JOIN kravet_map_authoritative a ON upper(trim(a.mfr_sku))=upper(trim(s.mfr_sku))
+        JOIN kravet_authoritative_pricing a ON upper(trim(a.mfr_sku))=upper(trim(s.mfr_sku))
        WHERE s.vendor ~* 'kravet|lee ?jofa|groundworks|brunschwig|baker|mulberry|threads|clarke|cole|gp ?& ?j|colefax|nicolette'
-         AND s.product_type ~* 'wallcover' AND a.map_price>0)
+         AND s.product_type ~* 'wallcover' AND a.new_map>0)
     SELECT shopify_id, mfr_sku, map_price FROM cand
      WHERE shopify_id > '${cursor.replace(/'/g,"")}' ORDER BY shopify_id LIMIT ${BATCH}`).trim();
   if(!rows){ psql(`INSERT INTO kravet_monitor_state(k,v) VALUES('cursor','0') ON CONFLICT(k) DO UPDATE SET v='0'`);

← 7c4e1121 cost-handoff: README documenting the DTD-B decoupled archite · back to Designer Wallcoverings · Launch latest 300: activate + tag 'Trending Wallpaper 2026' 76b49046 →