← back to Harlequin Sample Price Analysis
TK-10870: record Steve's ruling — price_trade IS DW net cost (Blocker A resolved)
34902d916a4bfcd70e0dd30d2deca40ccde1fc37 · 2026-08-30 10:09:04 -0700 · Steve Abrams
Steve 2026-08-30: price_trade = confirmed DW net wholesale; retail=trade/0.65/0.85 correct.
Registry products_with_cost=0 / vendor_discount_pct=0.00 are stale rollup, not pricing errors.
Next cycle seed: size the Cranes In Flight (haw0065) product-id/mfr_sku corruption fleet-wide.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Files touched
M FINDINGS.mdM artifacts/harlequin-analysis.jsonM artifacts/harlequin-analysis.md
Diff
commit 34902d916a4bfcd70e0dd30d2deca40ccde1fc37
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Sun Aug 30 10:09:04 2026 -0700
TK-10870: record Steve's ruling — price_trade IS DW net cost (Blocker A resolved)
Steve 2026-08-30: price_trade = confirmed DW net wholesale; retail=trade/0.65/0.85 correct.
Registry products_with_cost=0 / vendor_discount_pct=0.00 are stale rollup, not pricing errors.
Next cycle seed: size the Cranes In Flight (haw0065) product-id/mfr_sku corruption fleet-wide.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
FINDINGS.md | 9 +++++----
artifacts/harlequin-analysis.json | 2 +-
artifacts/harlequin-analysis.md | 2 +-
3 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/FINDINGS.md b/FINDINGS.md
index 23de188..b204d2b 100644
--- a/FINDINGS.md
+++ b/FINDINGS.md
@@ -85,10 +85,11 @@ prior `vp-dw-commerce` pass and are reversible (restore-maps in
The reprice owner must clear these THREE before any write (full evidence + SQL in
`artifacts/CODY-GATE-CYCLE1.md`):
-- **A — `price_trade` provenance.** Retail = `round(cost/0.65/0.85)` to the cent (25 raw ratios
- 1.80991–1.81000, all match), which proves retail was computed FROM trade — NOT that trade is
- DW net cost. If it's the vendor's "trade price" (markup included), 1.81× double-stacks margin.
- Confirm against one real invoice first.
+- **A — `price_trade` provenance. ✅ RESOLVED (Steve, 2026-08-30): `price_trade` IS DW's confirmed
+ net wholesale cost.** Retail = `round(cost/0.65/0.85)` to the cent (25 raw ratios 1.80991–1.81000,
+ all match) is therefore **correct**, and the `discount_confirmed=true`/`vendor_discount_pct=0.00`/
+ `products_with_cost=0` fields are stale rollup artifacts, not a pricing error. The 31 priced cohort
+ rows carry the right retail. (Reprice WRITE still gated — Steve confirmed the cost basis, not the push.)
- **B — write-path SKU namespace.** Catalog `dw_sku` = `DWHA-570xxx`; live Shopify `sku` =
`DWHQ-335xxx` (disjoint). A reprice keyed on `dw_sku` hits nothing — target the DWHQ SKU / product GID.
- **C — Cranes In Flight identity corruption (supersedes the "1 clean cost gap" framing).**
diff --git a/artifacts/harlequin-analysis.json b/artifacts/harlequin-analysis.json
index e863aed..cb88141 100644
--- a/artifacts/harlequin-analysis.json
+++ b/artifacts/harlequin-analysis.json
@@ -1,6 +1,6 @@
{
"ticket": "TK-10870",
- "generated_utc": "2026-08-30T16:33:45.307Z",
+ "generated_utc": "2026-08-30T17:09:04.023Z",
"source": "dw_unified.harlequin_catalog (read-only mirror)",
"cohort": "on_shopify = true",
"headline": {
diff --git a/artifacts/harlequin-analysis.md b/artifacts/harlequin-analysis.md
index 692c131..0953547 100644
--- a/artifacts/harlequin-analysis.md
+++ b/artifacts/harlequin-analysis.md
@@ -1,6 +1,6 @@
# Harlequin missing-sample + price analysis (TK-10870)
-Generated: 2026-08-30T16:33:45.307Z · Source: dw_unified.harlequin_catalog (read-only mirror) · Cohort: `on_shopify = true`
+Generated: 2026-08-30T17:09:04.023Z · Source: dw_unified.harlequin_catalog (read-only mirror) · Cohort: `on_shopify = true`
| metric | value |
| --- | ---: |
← fa82ec5 TK-10870: flag Cranes identity collision
·
back to Harlequin Sample Price Analysis
·
TK-10870 cycle2: size the corruption class + draft consolida 515ebd5 →