[object Object]

← back to Dw Validator Debug TK11314

Kravet roll-add: repoint MAP price source to authoritative kravet_authoritative_pricing.new_map (master_price was stale 2021, up to 2.8x low)

57ef8948480922ae25e62091406d16cf3618cf0e · 2026-08-18 14:44:30 -0700 · Steve

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

Files touched

Diff

commit 57ef8948480922ae25e62091406d16cf3618cf0e
Author: Steve <steve@designerwallcoverings.com>
Date:   Tue Aug 18 14:44:30 2026 -0700

    Kravet roll-add: repoint MAP price source to authoritative kravet_authoritative_pricing.new_map (master_price was stale 2021, up to 2.8x low)
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
 shopify/scripts/cadence/add-kravet-roll-variants.js | 16 ++++++++++------
 1 file changed, 10 insertions(+), 6 deletions(-)

diff --git a/shopify/scripts/cadence/add-kravet-roll-variants.js b/shopify/scripts/cadence/add-kravet-roll-variants.js
index cd261d77..cb768590 100644
--- a/shopify/scripts/cadence/add-kravet-roll-variants.js
+++ b/shopify/scripts/cadence/add-kravet-roll-variants.js
@@ -8,10 +8,12 @@
  * at the real price. The Kravet-family wallpapers mostly have only the Sample variant; this adds
  * the missing roll variant.
  *
- * PRICE = MAP, across the board for all Kravet lines (Steve, 2026-06-11). MAP source priority:
- *   1) kravet_master_price.map_price   (explicit MAP from GDrive master)
- *   2) kravet_catalog.dw_sell_price    (already MAP-floored)
- *   3) kravet_master_price.whls_cost * 1.5  /  kravet_catalog.cost_price * 1.5  (MAP = cost×1.5)
+ * PRICE = MAP, across the board for all Kravet lines (Steve, 2026-06-11). MAP source priority
+ *   (2026-08-18 fix: authoritative 2026 price-adjustment table FIRST; master_price is the stale 2021 snapshot):
+ *   1) kravet_authoritative_pricing.new_map  (current 2026 authoritative MAP = new_whls×1.5)
+ *   2) kravet_master_price.map_price   (STALE 2021 GDrive master — up to ~2.8x low, fallback only)
+ *   3) kravet_catalog.dw_sell_price    (already MAP-floored)
+ *   4) kravet_master_price.whls_cost * 1.5  /  kravet_catalog.cost_price * 1.5  (MAP = cost×1.5)
  * No MAP source  ->  skipped (never guessed).  See CLAUDE.md "Kravet-family lines price at MAP".
  *
  * SAFE / reversible:
@@ -96,14 +98,16 @@ function candidates() {
       SELECT DISTINCT s.shopify_id,
              COALESCE(NULLIF(trim(s.metafields->'global'->'Item'->>'value'),''), s.mfr_sku) AS mfr_sku,
              s.title, s.variant_sku,
-             COALESCE(km.map_price, kc.dw_sell_price, km.whls_cost*1.5, kc.cost_price*1.5) AS map,
-             CASE WHEN km.map_price>0 THEN 'master_map'
+             COALESCE(ap.new_map, km.map_price, kc.dw_sell_price, km.whls_cost*1.5, kc.cost_price*1.5) AS map,
+             CASE WHEN ap.new_map>0 THEN 'auth_new_map'
+                  WHEN km.map_price>0 THEN 'master_map'
                   WHEN kc.dw_sell_price>0 THEN 'catalog_sell'
                   WHEN km.whls_cost>0 THEN 'master_cost*1.5'
                   WHEN kc.cost_price>0 THEN 'catalog_cost*1.5' END AS map_src
       FROM shopify_products s
       LEFT JOIN kravet_catalog kc ON upper(trim(kc.mfr_sku))=upper(trim(COALESCE(NULLIF(trim(s.metafields->'global'->'Item'->>'value'),''), s.mfr_sku)))
       LEFT JOIN kravet_master_price km ON upper(trim(km.mfr_sku))=upper(trim(COALESCE(NULLIF(trim(s.metafields->'global'->'Item'->>'value'),''), s.mfr_sku)))
+      LEFT JOIN kravet_authoritative_pricing ap ON upper(trim(ap.mfr_sku))=upper(trim(COALESCE(NULLIF(trim(s.metafields->'global'->'Item'->>'value'),''), 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 s.mfr_sku IS NOT NULL AND s.mfr_sku <> ''

← bcea140f TK-10661: revert theme JSON-LD fix — offer_variant loop work  ·  back to Dw Validator Debug TK11314  ·  Kravet roll-add: guard audit INSERT in try/catch so a loggin 252e2e9f →