[object Object]

← back to Harlequin Sample Price Analysis

TK-10870: flag Cranes identity collision

fa82ec55178f1b1940cad7c75b8a5d526299f6c9 · 2026-08-30 09:36:36 -0700 · Steve Abrams

Files touched

Diff

commit fa82ec55178f1b1940cad7c75b8a5d526299f6c9
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sun Aug 30 09:36:36 2026 -0700

    TK-10870: flag Cranes identity collision
---
 FINDINGS.md                 | 4 ++++
 MODEL-COMPARISON.md         | 8 +++++++-
 verification/e2e-proof.json | 6 ++++++
 3 files changed, 17 insertions(+), 1 deletion(-)

diff --git a/FINDINGS.md b/FINDINGS.md
index 42adc90..23de188 100644
--- a/FINDINGS.md
+++ b/FINDINGS.md
@@ -61,6 +61,10 @@ All Houndstooth colorways + one Flores; each has a real cost → computed retail
 4. **Tariff not in retail.** `harlequin_catalog.tariff_*` columns are entirely NULL, but the sibling
    Sanderson registry row notes a 10% Section 122 UK-import tariff (unconfirmed). The current retail
    carries no tariff line.
+5. **Cranes identity collision.** Catalog Emerald and Marine share Shopify product ID
+   `7787420680243`; live DWHQ-335001 and DWHQ-335002 both carry the Marine manufacturer code.
+   Exclude the whole Cranes In Flight family from any price draft until product/colorway identity
+   is reconciled.
 
 ## 6. Status of the missing-sample fix (already executed by the prior agent — NOT re-done here)
 
diff --git a/MODEL-COMPARISON.md b/MODEL-COMPARISON.md
index 8ec0b14..187e276 100644
--- a/MODEL-COMPARISON.md
+++ b/MODEL-COMPARISON.md
@@ -40,9 +40,15 @@ reproduced the current state:
 - `harlequin_catalog` uses DWHA staging SKUs, while the live products use DWHQ SKUs. They are
   nevertheless the same original 32 products by Shopify product ID; SKU text alone is not a
   safe join key.
+- The Cranes In Flight exception is not safe to target yet. Catalog rows Emerald
+  (`DWHA-570137`) and Marine (`DWHA-570138`) share Shopify product ID `7787420680243`, while
+  live products DWHQ-335001 and DWHQ-335002 both carry the Marine manufacturer code. The
+  `$140` sibling value remains a candidate, but the product-to-colorway identity must be
+  repaired before a price draft can name a Shopify target.
 
 ## Safe next action
 
 Keep production writes blocked. Reconcile the S1 trade-price provenance, vendor registry
 rollups/discount, and SSP rule; then generate a drift-guarded Shopify price draft for the 31
-matched products and a separate exception record for Cranes In Flight / Marine.
+unambiguous products. Keep the Cranes In Flight family excluded until its duplicate product-ID
+mapping and manufacturer-SKU stamps are reconciled.
diff --git a/verification/e2e-proof.json b/verification/e2e-proof.json
index 3b6be50..ab9cf32 100644
--- a/verification/e2e-proof.json
+++ b/verification/e2e-proof.json
@@ -31,6 +31,12 @@
       "verdict": "PASS",
       "evidence": "32/32 product IDs matched DWHQ-335xxx live rows; 32 ACTIVE"
     },
+    {
+      "name": "Cranes In Flight identity integrity",
+      "command": "server-read-only catalog and shopify_products enumeration for HAW0065",
+      "verdict": "PASS",
+      "evidence": "Confirmed catalog Emerald and Marine share product ID 7787420680243; live DWHQ-335001 and DWHQ-335002 both carry the Marine mfr_sku. Family must be excluded from repricing until repaired."
+    },
     {
       "name": "write boundary",
       "verdict": "PASS",

← fb1b229 TK-10870 cycle1 Cody gate: name 3 reproduced prerequisite bl  ·  back to Harlequin Sample Price Analysis  ·  TK-10870: record Steve's ruling — price_trade IS DW net cost 34902d9 →