← back to Harlequin Sample Price Analysis

artifacts/BLOCKERS.md

46 lines

# TK-10870 — read-only resolution of the 2 remaining blockers

Cycle 1 (codex-10870, 2026-08-30). Read-only investigation of the only two things that
were NOT sell-price-computable in the 32 on-Shopify cohort. **No writes performed.**

## Census (whole Harlequin catalog, informational for the gate)
- 842 rows · 732 (87%) have cost AND formula-correct retail (`cost/0.65/0.85`, ratio 1.810).
- 106 rows still cost-gap ($150 placeholder / NULL cost) · 86 rows NULL `dw_sku`.
- **Takeaway:** repricing Harlequin is now a *bounded backfill*, not an "unknown cost" wall.

## Blocker 1 — the 1 cost-gap row (Cranes In Flight / Marine, DWHA-570138)
The `Cranes In Flight` pattern (mfr code **haw0065**) has 4 colorways:

| colorway | mfr_sku | price_trade | on_shopify |
| --- | --- | ---: | :--: |
| Blush | cranes-in-flight-blush-haw0065-03 | 140.00 | no |
| Emerald | cranes-in-flight-emerald-haw0065-04 | 140.00 | no |
| Platinum | cranes-in-flight-platinum-haw0065-01 | 140.00 | no |
| **Marine** | cranes-in-flight-marine-haw0065-05 | **NULL** | **yes** |

**3 of 3 priced siblings agree at $140.00** → implied retail **$253.39**. Colorways of one
pattern share a wholesale cost, so this is a **high-confidence CANDIDATE to confirm**, not a
value to write. Encoded safely as `inferSiblingCostCandidate()` (returns `{candidateCost:140,
confident:true}`) — the confirmation + backfill is a GATED dw_unified/Shopify write, not this lane's.

## Blocker 2 — the 5 NULL-`dw_sku` rows
Joined `harlequin_catalog` → `shopify_products` on `mfr_sku`:

| catalog mfr_sku | Shopify sku | status | verdict |
| --- | --- | --- | --- |
| houndstooth-black-earth-soft-focus-haw0289-04 | DWHQ-335016 | ACTIVE | **mirror sync gap** (SKU exists on Shopify, NULL in mirror) |
| houndstooth-first-light-mist-haw0289-01 | DWHQ-335017 | ACTIVE | mirror sync gap |
| houndstooth-seaglass-soft-focus-haw0289-02 | DWHQ-335018 | ACTIVE | mirror sync gap |
| houndstooth-taupe-soft-focus-haw0289-03 | DWHQ-335019 | ACTIVE | mirror sync gap |
| flores-cornflower-first-light-denim-haw0288-03 | (no match) | — | **genuinely unmapped** — needs attention |

**4 of 5** are a **mirror back-fill** issue (`harlequin_catalog.dw_sku` ← `shopify_products.sku`
by mfr_sku) — reversible, bounded, GATED (dw_unified write). **1 of 5** (Flores haw0288-03) has
no Shopify mfr_sku match and is a real mapping gap. Note both DW-SKU schemes are legitimate
Harlequin prefixes per `vendor_registry.legacy_prefixes = ['DWHA-','DWHQ-']`.

## Net after cycle 1
Of the original 32 cohort: **31 computable now**; the 1 cost-gap has a confident $140 candidate;
the 5 null-`dw_sku` are 4 sync-gaps + 1 real gap. Nothing here is a mystery anymore — the
remaining actions are all bounded, reversible, and **GATED** (Steve's call), not blocked on unknowns.