← back to Sanderson Onboard

tk10873/held_price_recovery_findings.md

24 lines

# TK-10873 — HELD_NEEDS_PRICE recovery findings (Cycle 1, read-only)

The 3 `HELD_NEEDS_PRICE` rows from `zoffany_optionA_draft.json` were cross-referenced
against the SDG feed harvest (`pilot/zoffany_feed_harvest.jsonl`). Result: **none can be
auto-priced** — each stays HELD. Evidence below (VERIFY-BEFORE-ACTING: these are the
reproducing facts, not inferences promoted to action).

| live mfr_sku | dw_sku | harvest match | recovered price? | disposition |
|---|---|---|---|---|
| `313114` | DWWC-502880 | image code `ZIND313114` → pattern **ZOW0146-01** (Papaver Stripe, trade 230 / retail 416.29) | **candidate only** — inferred via IMAGE filename, not an mfr-key match | HELD → route to mfr-recovery owner (TK-10827 lineage) to confirm `313114`≡`ZOW0146-01` before pricing. This is ALSO the lone missing-sellable product. **Risk:** image-filename codes are vendor-controlled and could be reused across SKU lines — the mapping is a hypothesis, so confirm against a second signal (pattern/color) before any write. |
| `ZFOW312941` | — | none | no | HELD — no harvest data, no staged price |
| `ZFOW312943` | — | image code `ZFOW312943` → **ZOW0094-04UC** (Ormonde Stripe, trade/retail **null**) | no | HELD — **source conflict**: `zoffany_catalog.our_price`=309.50 (=trade 171/0.65/0.85) vs harvest trade=null under a different mfr key (`ZOW0094-04UC`). Do not price off a conflicted source. |

## Why this validates the draft
The draft HELDs all 3 rather than repricing off `our_price` / an image-code inference.
The mining confirms that was correct: one row is a mere image-code candidate needing
mfr confirmation, one has conflicting price sources, one has no data. Auto-pricing any of
them would have shipped an unverified price.

## Next SAFE step (not done here)
Ask the mfr-recovery owner to confirm the `313114 ≡ ZOW0146-01` image-code mapping. If
confirmed, `313114`/DWWC-502880 becomes both a REPRICE (retail 416.29) AND a SELLABLE_ADD
in a future cycle — still Steve-gated for the live write.