[object Object]

← back to Designer Wallcoverings

auto-data-snapshot: 2026-08-24T09:04:34 (1 data files) — DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql

3a4f99e52ea40b867ac7709589d41d288ce86cef · 2026-08-24 09:04:49 -0700 · auto-commit-fleet

Files touched

Diff

commit 3a4f99e52ea40b867ac7709589d41d288ce86cef
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Mon Aug 24 09:04:49 2026 -0700

    auto-data-snapshot: 2026-08-24T09:04:34 (1 data files) — DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
---
 .../vendor-command-center/cost-backfill-2026-08-22-APPLY.sql  | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

diff --git a/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql b/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
index 13e494bb..caff4909 100644
--- a/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
+++ b/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
@@ -19,11 +19,12 @@ SET cost_price=k.whls, cost_source='kravet_authoritative_pricing.new_whls (exact
 FROM (SELECT mfr_sku, max(new_whls) whls FROM kravet_authoritative_pricing WHERE new_whls>0 GROUP BY 1) k
 WHERE sp.status='ACTIVE' AND (sp.cost_price IS NULL OR sp.cost_price::numeric=0)
   AND sp.mfr_sku = k.mfr_sku;
--- 1b. FOLLOW-UP (cycle 3, verification currently API-blocked): decorated-vendor recovery
---   for shopify SKUs that carry DW suffixes the source lacks (e.g. Clarke 'W0114/03.CAC.0'
---   vs source 'W0114/03', ~3.5k). Needs a STRUCTURE-PRESERVING suffix-strip (strip only
---   trailing .CAC.0/.CS.0/.<color>.0), NOT the lossy all-punctuation normalization that
---   caused the 488-410 collision. DISABLED until the false-collision sweep is measured.
+-- 1b. REJECTED after measurement (cycle 3, 2026-08-24): a normalized-key fallback was
+--   considered for decorated SKUs, but the authoritative table ALREADY stores decorated
+--   SKUs, so exact-match (1a) recovers 12,242 vs normalized 12,252 — a 10-product delta,
+--   and those 10 include the '488-410'<->'4884.1.0' FALSE collisions. Normalization here
+--   buys ~0 real coverage and reintroduces a mispricing bug. NOT USED — 1a stands alone.
+--   (Separate ~3.5k decorated recovery belongs to the vendor *_catalog step-3 pass, not here.)
 
 WITH jd AS (SELECT upper(regexp_replace(mfr_sku::text,'[^A-Za-z0-9]','','g')) k, max(our_cost_yd) cost
             FROM justin_david_pricing_2026 WHERE our_cost_yd IS NOT NULL AND our_cost_yd>0 GROUP BY 1)

← 799503af Fix Fabricut 'Minimum Order: 9 Yards yards' double-unit bug  ·  back to Designer Wallcoverings  ·  auto-data-snapshot: 2026-08-24T09:36:43 (1 data files) — DW- ffcb4293 →