← back to Sanderson Onboard
TK-10873 cycle4: cross-validate REPRICE prices vs independent S1 feed — CRITICAL: 209/328 are ~2.54x BELOW the S1 feed (systematic double-roll x GBP->USD mismatch); only 30 CONFIRMED, 89 unverifiable. Reprice of the 209 BLOCKED pending canonical-source ruling. +10 tests
b68c06445f408c1fa289aa617d78875805d3fd6f · 2026-08-30 10:08:46 -0700 · Steve Abrams
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Files touched
A tk10873/cross_validate_feed.jsonA tk10873/cross_validate_feed.mdA tk10873/cross_validate_feed.mjsA tk10873/test_cross_validate.mjs
Diff
commit b68c06445f408c1fa289aa617d78875805d3fd6f
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Sun Aug 30 10:08:46 2026 -0700
TK-10873 cycle4: cross-validate REPRICE prices vs independent S1 feed — CRITICAL: 209/328 are ~2.54x BELOW the S1 feed (systematic double-roll x GBP->USD mismatch); only 30 CONFIRMED, 89 unverifiable. Reprice of the 209 BLOCKED pending canonical-source ruling. +10 tests
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
tk10873/cross_validate_feed.json | 2325 ++++++++++++++++++++++++++++++++++++++
tk10873/cross_validate_feed.md | 21 +
tk10873/cross_validate_feed.mjs | 110 ++
tk10873/test_cross_validate.mjs | 21 +
4 files changed, 2477 insertions(+)
diff --git a/tk10873/cross_validate_feed.json b/tk10873/cross_validate_feed.json
new file mode 100644
index 0000000..84cce34
--- /dev/null
+++ b/tk10873/cross_validate_feed.json
@@ -0,0 +1,2325 @@
+{
+ "ticket": "TK-10873",
+ "cycle": 4,
+ "generated_at": "2026-08-30T17:08:06.262Z",
+ "read_only": true,
+ "source_a": "zoffany_catalog.price_retail (used by the Option-A draft)",
+ "source_b": "SDG S1 feed harvest retail_usd (TK-10877, independent)",
+ "reprice_total": 328,
+ "counts": {
+ "CONFIRMED": 30,
+ "DISCREPANT_UNIT_2_5X": 209,
+ "DISCREPANT_OTHER": 0,
+ "UNVERIFIABLE": 89,
+ "BAD_PROPOSED": 0
+ },
+ "verdict": "FAIL",
+ "status": "FAIL",
+ "finding": "209 REPRICE prices are ~2.54x BELOW the independent S1 feed (systematic unit/currency mismatch). Which source is canonical is a Steve/pricing-owner decision — reprice of these is BLOCKED until resolved.",
+ "buckets": {
+ "CONFIRMED": [
+ {
+ "mfr_sku": "ZOW0016-01",
+ "dw_sku": "DWZF-187088",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0016-03",
+ "dw_sku": "DWZF-187090",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0020-01",
+ "dw_sku": "DWZF-187072",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0020-02",
+ "dw_sku": "DWZF-187073",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0023-01",
+ "dw_sku": "DWZF-187076",
+ "proposed": 320.36,
+ "feed_retail": 320.36,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0023-02",
+ "dw_sku": "DWZF-187077",
+ "proposed": 320.36,
+ "feed_retail": 320.36,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0023-04",
+ "dw_sku": "DWZF-187079",
+ "proposed": 320.36,
+ "feed_retail": 320.36,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0036-04",
+ "dw_sku": "DWZF-187309",
+ "proposed": 508.6,
+ "feed_retail": 508.6,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0036-05",
+ "dw_sku": "DWZF-187310",
+ "proposed": 508.6,
+ "feed_retail": 508.6,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0037-01",
+ "dw_sku": "DWZF-187311",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0042-02",
+ "dw_sku": "DWZF-187094",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0042-03",
+ "dw_sku": "DWZF-187095",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0044-04",
+ "dw_sku": "DWZF-187227",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0048-02",
+ "dw_sku": "DWZF-187229",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0048-03",
+ "dw_sku": "DWZF-187230",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0048-04",
+ "dw_sku": "DWZF-187231",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0050-01",
+ "dw_sku": "DWZF-187255",
+ "proposed": 1073.3,
+ "feed_retail": 1073.3,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0050-02",
+ "dw_sku": "DWZF-187256",
+ "proposed": 1073.3,
+ "feed_retail": 1073.3,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0052-01",
+ "dw_sku": "DWZF-187118",
+ "proposed": 320.36,
+ "feed_retail": 320.36,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0053-02",
+ "dw_sku": "DWZF-187119",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0054-02",
+ "dw_sku": "DWZF-187120",
+ "proposed": 320.36,
+ "feed_retail": 320.36,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0054-03",
+ "dw_sku": "DWZF-187121",
+ "proposed": 320.36,
+ "feed_retail": 320.36,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0055-02",
+ "dw_sku": "DWZF-187123",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0057-01",
+ "dw_sku": "DWZF-187124",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0057-02",
+ "dw_sku": "DWZF-187125",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0057-03",
+ "dw_sku": "DWZF-187126",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0058-01",
+ "dw_sku": "DWZF-187127",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0058-02",
+ "dw_sku": "DWZF-187128",
+ "proposed": 376.47,
+ "feed_retail": 376.47,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0059-01",
+ "dw_sku": "DWZF-187353",
+ "proposed": 447.06,
+ "feed_retail": 447.06,
+ "ratio": 1
+ },
+ {
+ "mfr_sku": "ZOW0059-02",
+ "dw_sku": "DWZF-187354",
+ "proposed": 447.06,
+ "feed_retail": 447.06,
+ "ratio": 1
+ }
+ ],
+ "DISCREPANT_UNIT_2_5X": [
+ {
+ "mfr_sku": "ZOW0007-01",
+ "dw_sku": "DWZF-187083",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0007-02",
+ "dw_sku": "DWZF-187084",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0014-01",
+ "dw_sku": "DWZF-187085",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0014-02",
+ "dw_sku": "DWZF-187086",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0014-03",
+ "dw_sku": "DWZF-187087",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0016-02",
+ "dw_sku": "DWZF-187089",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0019-01",
+ "dw_sku": "DWZF-187224",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0019-02",
+ "dw_sku": "DWZF-187225",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0023-03",
+ "dw_sku": "DWZF-187078",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0026-01",
+ "dw_sku": "DWZF-187248",
+ "proposed": 158,
+ "feed_retail": 401.81,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0027-01",
+ "dw_sku": "DWZF-187249",
+ "proposed": 106,
+ "feed_retail": 269.68,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0027-02",
+ "dw_sku": "DWZF-187250",
+ "proposed": 106,
+ "feed_retail": 269.68,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0027-03",
+ "dw_sku": "DWZF-187251",
+ "proposed": 106,
+ "feed_retail": 269.68,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0031-01",
+ "dw_sku": "DWZF-187252",
+ "proposed": 106,
+ "feed_retail": 269.68,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0032-01",
+ "dw_sku": "DWZF-187253",
+ "proposed": 158,
+ "feed_retail": 401.81,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0033-01",
+ "dw_sku": "DWZF-187254",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0036-01",
+ "dw_sku": "DWZF-187307",
+ "proposed": 200,
+ "feed_retail": 508.6,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0041-01",
+ "dw_sku": "DWZF-187091",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0041-02",
+ "dw_sku": "DWZF-187092",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0042-01",
+ "dw_sku": "DWZF-187093",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0043-01",
+ "dw_sku": "DWZF-187096",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0043-02",
+ "dw_sku": "DWZF-187226",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0047-01",
+ "dw_sku": "DWZF-187228",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0059-04",
+ "dw_sku": "DWZF-187356",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0067-01",
+ "dw_sku": "DWZF-187364",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0067-03",
+ "dw_sku": "DWZF-187366",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0072-01",
+ "dw_sku": "DWZF-187370",
+ "proposed": 422,
+ "feed_retail": 1073.3,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0072-02",
+ "dw_sku": "DWZF-187371",
+ "proposed": 422,
+ "feed_retail": 1073.3,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0074-01",
+ "dw_sku": "DWZF-187129",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0074-02",
+ "dw_sku": "DWZF-187130",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0074-03",
+ "dw_sku": "DWZF-187131",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0075-01",
+ "dw_sku": "DWZF-187132",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0075-02",
+ "dw_sku": "DWZF-187133",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0075-03",
+ "dw_sku": "DWZF-187134",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0076-01",
+ "dw_sku": "DWZF-187135",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0076-02",
+ "dw_sku": "DWZF-187136",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0076-03",
+ "dw_sku": "DWZF-187137",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0077-01",
+ "dw_sku": "DWZF-187138",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0077-02",
+ "dw_sku": "DWZF-187139",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0077-03",
+ "dw_sku": "DWZF-187140",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0077-04",
+ "dw_sku": "DWZF-187141",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0078-01",
+ "dw_sku": "DWZF-187142",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0078-02",
+ "dw_sku": "DWZF-187143",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0078-03",
+ "dw_sku": "DWZF-187144",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0078-04",
+ "dw_sku": "DWZF-187145",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0079-01",
+ "dw_sku": "DWZF-187146",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0079-02",
+ "dw_sku": "DWZF-187147",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0079-03",
+ "dw_sku": "DWZF-187148",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0079-04",
+ "dw_sku": "DWZF-187149",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0079-05",
+ "dw_sku": "DWZF-187150",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0080-01",
+ "dw_sku": "DWZF-187151",
+ "proposed": 164,
+ "feed_retail": 416.29,
+ "ratio": 2.538
+ },
+ {
+ "mfr_sku": "ZOW0080-02",
+ "dw_sku": "DWZF-187152",
+ "proposed": 164,
+ "feed_retail": 416.29,
+ "ratio": 2.538
+ },
+ {
+ "mfr_sku": "ZOW0080-03",
+ "dw_sku": "DWZF-187153",
+ "proposed": 164,
+ "feed_retail": 416.29,
+ "ratio": 2.538
+ },
+ {
+ "mfr_sku": "ZOW0080-04",
+ "dw_sku": "DWZF-187257",
+ "proposed": 164,
+ "feed_retail": 416.29,
+ "ratio": 2.538
+ },
+ {
+ "mfr_sku": "ZOW0081-01",
+ "dw_sku": "DWZF-187154",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0082-01",
+ "dw_sku": "DWZF-187155",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0083-01",
+ "dw_sku": "DWZF-187156",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0083-02",
+ "dw_sku": "DWZF-187157",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0083-03",
+ "dw_sku": "DWZF-187158",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0083-04",
+ "dw_sku": "DWZF-187159",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0084-01",
+ "dw_sku": "DWZF-187317",
+ "proposed": 200,
+ "feed_retail": 508.6,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0084-02",
+ "dw_sku": "DWZF-187318",
+ "proposed": 200,
+ "feed_retail": 508.6,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0084-03",
+ "dw_sku": "DWZF-187319",
+ "proposed": 200,
+ "feed_retail": 508.6,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0084-04",
+ "dw_sku": "DWZF-187320",
+ "proposed": 200,
+ "feed_retail": 508.6,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0085-01",
+ "dw_sku": "DWZF-187321",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-02",
+ "dw_sku": "DWZF-187322",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-03",
+ "dw_sku": "DWZF-187323",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-04",
+ "dw_sku": "DWZF-187324",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-05",
+ "dw_sku": "DWZF-187325",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-06",
+ "dw_sku": "DWZF-187326",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-07",
+ "dw_sku": "DWZF-187327",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-08",
+ "dw_sku": "DWZF-187328",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-09",
+ "dw_sku": "DWZF-187329",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0085-10",
+ "dw_sku": "DWZF-187330",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0086-01",
+ "dw_sku": "DWZF-187331",
+ "proposed": 180,
+ "feed_retail": 457.92,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0086-02",
+ "dw_sku": "DWZF-187332",
+ "proposed": 180,
+ "feed_retail": 457.92,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0086-03",
+ "dw_sku": "DWZF-187333",
+ "proposed": 180,
+ "feed_retail": 457.92,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0087-01",
+ "dw_sku": "DWZF-187334",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0087-02",
+ "dw_sku": "DWZF-187335",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0087-03",
+ "dw_sku": "DWZF-187336",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0087-04",
+ "dw_sku": "DWZF-187337",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0087-05",
+ "dw_sku": "DWZF-187338",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0087-06",
+ "dw_sku": "DWZF-187339",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0087-07",
+ "dw_sku": "DWZF-187340",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0088-01",
+ "dw_sku": "DWZF-187341",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0088-02",
+ "dw_sku": "DWZF-187342",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0088-03",
+ "dw_sku": "DWZF-187343",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0088-04",
+ "dw_sku": "DWZF-187344",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0088-05",
+ "dw_sku": "DWZF-187345",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0088-06",
+ "dw_sku": "DWZF-187346",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0088-07",
+ "dw_sku": "DWZF-187347",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0089-01",
+ "dw_sku": "DWZF-187348",
+ "proposed": 180,
+ "feed_retail": 457.92,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0089-02",
+ "dw_sku": "DWZF-187349",
+ "proposed": 180,
+ "feed_retail": 457.92,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0089-03",
+ "dw_sku": "DWZF-187350",
+ "proposed": 180,
+ "feed_retail": 457.92,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0090-01",
+ "dw_sku": "DWZF-187351",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0090-02",
+ "dw_sku": "DWZF-187352",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0104-01",
+ "dw_sku": "DWZF-187258",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0104-02",
+ "dw_sku": "DWZF-187259",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0105-01",
+ "dw_sku": "DWZF-187260",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0106-01",
+ "dw_sku": "DWZF-187261",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0107-01",
+ "dw_sku": "DWZF-187262",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0108-01",
+ "dw_sku": "DWZF-187263",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0110-01",
+ "dw_sku": "DWZF-187264",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0110-02",
+ "dw_sku": "DWZF-187265",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0110-03",
+ "dw_sku": "DWZF-187266",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0110-04",
+ "dw_sku": "DWZF-187267",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0110-05",
+ "dw_sku": "DWZF-187268",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0110-06",
+ "dw_sku": "DWZF-187269",
+ "proposed": 154,
+ "feed_retail": 390.95,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0111-01",
+ "dw_sku": "DWZF-187270",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0111-02",
+ "dw_sku": "DWZF-187271",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0111-03",
+ "dw_sku": "DWZF-187272",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0111-04",
+ "dw_sku": "DWZF-187273",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0112-01",
+ "dw_sku": "DWZF-187274",
+ "proposed": 100,
+ "feed_retail": 253.39,
+ "ratio": 2.534
+ },
+ {
+ "mfr_sku": "ZOW0112-02",
+ "dw_sku": "DWZF-187275",
+ "proposed": 100,
+ "feed_retail": 253.39,
+ "ratio": 2.534
+ },
+ {
+ "mfr_sku": "ZOW0112-03",
+ "dw_sku": "DWZF-187276",
+ "proposed": 100,
+ "feed_retail": 253.39,
+ "ratio": 2.534
+ },
+ {
+ "mfr_sku": "ZOW0112-04",
+ "dw_sku": "DWZF-187277",
+ "proposed": 100,
+ "feed_retail": 253.39,
+ "ratio": 2.534
+ },
+ {
+ "mfr_sku": "ZOW0113-01",
+ "dw_sku": "DWZF-187278",
+ "proposed": 382,
+ "feed_retail": 971.95,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0114-01",
+ "dw_sku": "DWZF-187097",
+ "proposed": 158,
+ "feed_retail": 401.81,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0114-02",
+ "dw_sku": "DWZF-187098",
+ "proposed": 158,
+ "feed_retail": 401.81,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0115-01",
+ "dw_sku": "DWZF-187099",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0116-01",
+ "dw_sku": "DWZF-187372",
+ "proposed": 136,
+ "feed_retail": 345.7,
+ "ratio": 2.542
+ },
+ {
+ "mfr_sku": "ZOW0117-01",
+ "dw_sku": "DWZF-187373",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0117-02",
+ "dw_sku": "DWZF-187374",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0118-01",
+ "dw_sku": "DWZF-187375",
+ "proposed": 418,
+ "feed_retail": 1062.44,
+ "ratio": 2.542
+ },
+ {
+ "mfr_sku": "ZOW0118-02",
+ "dw_sku": "DWZF-187376",
+ "proposed": 418,
+ "feed_retail": 1062.44,
+ "ratio": 2.542
+ },
+ {
+ "mfr_sku": "ZOW0119-01",
+ "dw_sku": "DWZF-187377",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0119-02",
+ "dw_sku": "DWZF-187378",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0120-01",
+ "dw_sku": "DWZF-187379",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0121-01",
+ "dw_sku": "DWZF-187380",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0121-02",
+ "dw_sku": "DWZF-187381",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0121-03",
+ "dw_sku": "DWZF-187382",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0122-01",
+ "dw_sku": "DWZF-187383",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0122-02",
+ "dw_sku": "DWZF-187384",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0123-02",
+ "dw_sku": "DWZF-187386",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0123-03",
+ "dw_sku": "DWZF-187115",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0124-01",
+ "dw_sku": "DWZF-187116",
+ "proposed": 244,
+ "feed_retail": 620.81,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0125-01",
+ "dw_sku": "DWZF-187117",
+ "proposed": 196,
+ "feed_retail": 497.74,
+ "ratio": 2.539
+ },
+ {
+ "mfr_sku": "ZOW0126-01",
+ "dw_sku": "DWZF-187055",
+ "proposed": 422,
+ "feed_retail": 1073.3,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0126-02",
+ "dw_sku": "DWZF-187056",
+ "proposed": 422,
+ "feed_retail": 1073.3,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0127-01",
+ "dw_sku": "DWZF-187057",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0127-02",
+ "dw_sku": "DWZF-187058",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0127-03",
+ "dw_sku": "DWZF-187059",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0128-01",
+ "dw_sku": "DWZF-187060",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0128-02",
+ "dw_sku": "DWZF-187061",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0128-03",
+ "dw_sku": "DWZF-187062",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0129-01",
+ "dw_sku": "DWZF-187063",
+ "proposed": 116,
+ "feed_retail": 295.02,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0129-02",
+ "dw_sku": "DWZF-187064",
+ "proposed": 116,
+ "feed_retail": 295.02,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0129-03",
+ "dw_sku": "DWZF-187065",
+ "proposed": 116,
+ "feed_retail": 295.02,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0130-01",
+ "dw_sku": "DWZF-187066",
+ "proposed": 244,
+ "feed_retail": 620.81,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0130-02",
+ "dw_sku": "DWZF-187067",
+ "proposed": 244,
+ "feed_retail": 620.81,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0131-01",
+ "dw_sku": "DWZF-187068",
+ "proposed": 116,
+ "feed_retail": 295.02,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0131-02",
+ "dw_sku": "DWZF-187069",
+ "proposed": 116,
+ "feed_retail": 295.02,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0131-03",
+ "dw_sku": "DWZF-187070",
+ "proposed": 116,
+ "feed_retail": 295.02,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0131-04",
+ "dw_sku": "DWZF-187071",
+ "proposed": 116,
+ "feed_retail": 295.02,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0132-01",
+ "dw_sku": "DWZF-187279",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-02",
+ "dw_sku": "DWZF-187280",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-03",
+ "dw_sku": "DWZF-187281",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-04",
+ "dw_sku": "DWZF-187282",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-05",
+ "dw_sku": "DWZF-187283",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-06",
+ "dw_sku": "DWZF-187284",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-07",
+ "dw_sku": "DWZF-187285",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-08",
+ "dw_sku": "DWZF-187286",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-09",
+ "dw_sku": "DWZF-187287",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-10",
+ "dw_sku": "DWZF-187288",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0132-11",
+ "dw_sku": "DWZF-187289",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0133-01",
+ "dw_sku": "DWZF-187160",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0133-02",
+ "dw_sku": "DWZF-187161",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0133-03",
+ "dw_sku": "DWZF-187162",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0133-04",
+ "dw_sku": "DWZF-187163",
+ "proposed": 126,
+ "feed_retail": 320.36,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0134-01",
+ "dw_sku": "DWZF-187164",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0134-02",
+ "dw_sku": "DWZF-187165",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0134-03",
+ "dw_sku": "DWZF-187166",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0134-04",
+ "dw_sku": "DWZF-187167",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0135-01",
+ "dw_sku": "DWZF-187168",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0135-02",
+ "dw_sku": "DWZF-187169",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0135-03",
+ "dw_sku": "DWZF-187170",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0135-04",
+ "dw_sku": "DWZF-187171",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0135-05",
+ "dw_sku": "DWZF-187172",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0135-06",
+ "dw_sku": "DWZF-187173",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0136-01",
+ "dw_sku": "DWZF-187174",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0136-02",
+ "dw_sku": "DWZF-187175",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0136-03",
+ "dw_sku": "DWZF-187176",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0137-01",
+ "dw_sku": "DWZF-187177",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0137-02",
+ "dw_sku": "DWZF-187178",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0137-03",
+ "dw_sku": "DWZF-187179",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0137-04",
+ "dw_sku": "DWZF-187180",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0137-05",
+ "dw_sku": "DWZF-187181",
+ "proposed": 122,
+ "feed_retail": 309.5,
+ "ratio": 2.537
+ },
+ {
+ "mfr_sku": "ZOW0138-01",
+ "dw_sku": "DWZF-187182",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0138-02",
+ "dw_sku": "DWZF-187183",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0138-03",
+ "dw_sku": "DWZF-187184",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0138-04",
+ "dw_sku": "DWZF-187185",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0138-05",
+ "dw_sku": "DWZF-187186",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0138-06",
+ "dw_sku": "DWZF-187187",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0139-01",
+ "dw_sku": "DWZF-187232",
+ "proposed": 136,
+ "feed_retail": 345.7,
+ "ratio": 2.542
+ },
+ {
+ "mfr_sku": "ZOW0139-02",
+ "dw_sku": "DWZF-187233",
+ "proposed": 136,
+ "feed_retail": 345.7,
+ "ratio": 2.542
+ },
+ {
+ "mfr_sku": "ZOW0140-01",
+ "dw_sku": "DWZF-187234",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0140-02",
+ "dw_sku": "DWZF-187235",
+ "proposed": 148,
+ "feed_retail": 376.47,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0141-01",
+ "dw_sku": "DWZF-187236",
+ "proposed": 452,
+ "feed_retail": 1149.32,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0142-01",
+ "dw_sku": "DWZF-187237",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0142-02",
+ "dw_sku": "DWZF-187238",
+ "proposed": 210,
+ "feed_retail": 533.94,
+ "ratio": 2.543
+ },
+ {
+ "mfr_sku": "ZOW0143-01",
+ "dw_sku": "DWZF-187239",
+ "proposed": 250,
+ "feed_retail": 635.29,
+ "ratio": 2.541
+ },
+ {
+ "mfr_sku": "ZOW0144-01",
+ "dw_sku": "DWZF-187240",
+ "proposed": 186,
+ "feed_retail": 472.4,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0145-01",
+ "dw_sku": "DWZF-187241",
+ "proposed": 402,
+ "feed_retail": 1022.62,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0146-01",
+ "dw_sku": "DWZF-187242",
+ "proposed": 164,
+ "feed_retail": 416.29,
+ "ratio": 2.538
+ },
+ {
+ "mfr_sku": "ZOW0146-02",
+ "dw_sku": "DWZF-187243",
+ "proposed": 164,
+ "feed_retail": 416.29,
+ "ratio": 2.538
+ },
+ {
+ "mfr_sku": "ZOW0146-03",
+ "dw_sku": "DWZF-187244",
+ "proposed": 164,
+ "feed_retail": 416.29,
+ "ratio": 2.538
+ },
+ {
+ "mfr_sku": "ZOW0147-01",
+ "dw_sku": "DWZF-187245",
+ "proposed": 486,
+ "feed_retail": 1236.2,
+ "ratio": 2.544
+ },
+ {
+ "mfr_sku": "ZOW0148-01",
+ "dw_sku": "DWZF-187246",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ },
+ {
+ "mfr_sku": "ZOW0148-02",
+ "dw_sku": "DWZF-187247",
+ "proposed": 176,
+ "feed_retail": 447.06,
+ "ratio": 2.54
+ }
+ ],
+ "DISCREPANT_OTHER": [],
+ "UNVERIFIABLE": [
+ {
+ "mfr_sku": "ZAMW310430",
+ "dw_sku": "DWZF-187051",
+ "proposed": 200,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZAMW310431",
+ "dw_sku": "DWZF-187052",
+ "proposed": 200,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZAQF322696",
+ "dw_sku": "DWZF-187045",
+ "proposed": 132,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZCON311996",
+ "dw_sku": "DWZF-187031",
+ "proposed": 320.36,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZCOT313015",
+ "dw_sku": "DWZF-187037",
+ "proposed": 210,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZCOT313026",
+ "dw_sku": "DWZF-187036",
+ "proposed": 148,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZDAR312857",
+ "dw_sku": "DWZF-187026",
+ "proposed": 164,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZDAR312861",
+ "dw_sku": "DWZF-187039",
+ "proposed": 148,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZDAR312864",
+ "dw_sku": "DWZF-187022",
+ "proposed": 148,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZDAR312865",
+ "dw_sku": "DWZF-187038",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZDAR312869",
+ "dw_sku": "DWZF-187025",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZDAR312873",
+ "dw_sku": "DWZF-187002",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZDAR312884",
+ "dw_sku": "DWZF-187020",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZEND313098",
+ "dw_sku": "DWZF-187030",
+ "proposed": 148,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZGUV08002",
+ "dw_sku": "DWZF-187047",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZGUV08003",
+ "dw_sku": "DWZF-187048",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZGUV08004",
+ "dw_sku": "DWZF-187049",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZHIW312994",
+ "dw_sku": "DWZF-187019",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZHIW312995",
+ "dw_sku": "DWZF-187015",
+ "proposed": 253.39,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZHIW312996",
+ "dw_sku": "DWZF-187001",
+ "proposed": 253.39,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZHIW312997",
+ "dw_sku": "DWZF-187034",
+ "proposed": 253.39,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZHIW313003",
+ "dw_sku": "DWZF-187021",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZHIW313004",
+ "dw_sku": "DWZF-187027",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZIND313111",
+ "dw_sku": "DWZF-187033",
+ "proposed": 136,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZJAI311727",
+ "dw_sku": "DWZF-187010",
+ "proposed": 309.5,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZKEM312641",
+ "dw_sku": "DWZF-187005",
+ "proposed": 309.5,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZKEM312648",
+ "dw_sku": "DWZF-187016",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0020-05",
+ "dw_sku": "DWZF-187074",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0025-01",
+ "dw_sku": "DWZF-187080",
+ "proposed": 320.36,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0036-02",
+ "dw_sku": "DWZF-187308",
+ "proposed": 465.16,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0040-01",
+ "dw_sku": "DWZF-187314",
+ "proposed": 345.7,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0040-04",
+ "dw_sku": "DWZF-187316",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0059-03",
+ "dw_sku": "DWZF-187355",
+ "proposed": 447.06,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0060-01",
+ "dw_sku": "DWZF-187357",
+ "proposed": 293.21,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0091-01",
+ "dw_sku": "DWZF-187194",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0091-02",
+ "dw_sku": "DWZF-187195",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0091-03",
+ "dw_sku": "DWZF-187196",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0092-01",
+ "dw_sku": "DWZF-187199",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0092-03",
+ "dw_sku": "DWZF-187201",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0092-04",
+ "dw_sku": "DWZF-187202",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0092-05",
+ "dw_sku": "DWZF-187203",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0093-02",
+ "dw_sku": "DWZF-187205",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0093-03",
+ "dw_sku": "DWZF-187206",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0093-05",
+ "dw_sku": "DWZF-187208",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0093-07",
+ "dw_sku": "DWZF-187210",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0094-01",
+ "dw_sku": "DWZF-187211",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0094-03",
+ "dw_sku": "DWZF-187213",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0094-06",
+ "dw_sku": "DWZF-187216",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0095-01",
+ "dw_sku": "DWZF-187217",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0095-02",
+ "dw_sku": "DWZF-187218",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0095-03",
+ "dw_sku": "DWZF-187219",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0095-05",
+ "dw_sku": "DWZF-187221",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0096-01",
+ "dw_sku": "DWZF-187222",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0096-02",
+ "dw_sku": "DWZF-187223",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0096-03",
+ "dw_sku": "DWZF-187387",
+ "proposed": 122,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0097-01",
+ "dw_sku": "DWZF-187290",
+ "proposed": 158,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0098-01",
+ "dw_sku": "DWZF-187291",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0098-02",
+ "dw_sku": "DWZF-187292",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0098-03",
+ "dw_sku": "DWZF-187293",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0100-01",
+ "dw_sku": "DWZF-187295",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0100-02",
+ "dw_sku": "DWZF-187296",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0100-03",
+ "dw_sku": "DWZF-187297",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0101-01",
+ "dw_sku": "DWZF-187298",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0101-02",
+ "dw_sku": "DWZF-187299",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0102-01",
+ "dw_sku": "DWZF-187300",
+ "proposed": 196,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0102-02",
+ "dw_sku": "DWZF-187301",
+ "proposed": 196,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0102-03",
+ "dw_sku": "DWZF-187302",
+ "proposed": 196,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0103-01",
+ "dw_sku": "DWZF-187303",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0103-02",
+ "dw_sku": "DWZF-187304",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZOW0103-03",
+ "dw_sku": "DWZF-187305",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZPAW05001",
+ "dw_sku": "DWZF-187050",
+ "proposed": 244.34,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZPHA312595",
+ "dw_sku": "DWZF-187007",
+ "proposed": 508.6,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZPHA312622",
+ "dw_sku": "DWZF-187013",
+ "proposed": 176,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZQUA310993",
+ "dw_sku": "DWZF-187024",
+ "proposed": 253.39,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312889",
+ "dw_sku": "DWZF-187029",
+ "proposed": 508.6,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312890",
+ "dw_sku": "DWZF-187011",
+ "proposed": 508.6,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312897",
+ "dw_sku": "DWZF-187014",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312899",
+ "dw_sku": "DWZF-187004",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312903",
+ "dw_sku": "DWZF-187017",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312906",
+ "dw_sku": "DWZF-187012",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312907",
+ "dw_sku": "DWZF-187000",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312910",
+ "dw_sku": "DWZF-187006",
+ "proposed": 390.95,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312914",
+ "dw_sku": "DWZF-187023",
+ "proposed": 320.36,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZRHW312916",
+ "dw_sku": "DWZF-187032",
+ "proposed": 320.36,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZTOT312747",
+ "dw_sku": "DWZF-187003",
+ "proposed": 447.06,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZWOO311333",
+ "dw_sku": "DWZF-187053",
+ "proposed": 447.06,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZWOO311336",
+ "dw_sku": "DWZF-187009",
+ "proposed": 447.06,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZWOO311338",
+ "dw_sku": "DWZF-187054",
+ "proposed": 447.06,
+ "feed_retail": null,
+ "ratio": null
+ },
+ {
+ "mfr_sku": "ZWOO311346",
+ "dw_sku": "DWZF-187008",
+ "proposed": 376.47,
+ "feed_retail": null,
+ "ratio": null
+ }
+ ],
+ "BAD_PROPOSED": []
+ }
+}
\ No newline at end of file
diff --git a/tk10873/cross_validate_feed.md b/tk10873/cross_validate_feed.md
new file mode 100644
index 0000000..a29e843
--- /dev/null
+++ b/tk10873/cross_validate_feed.md
@@ -0,0 +1,21 @@
+# TK-10873 cycle 4 — REPRICE vs independent S1 feed cross-validation
+
+- **Verdict:** FAIL
+- Source A (draft): `zoffany_catalog.price_retail`
+- Source B (independent): SDG S1 feed harvest `retail_usd` (TK-10877)
+- REPRICE rows: 328
+
+## Cross-validation buckets
+| bucket | count | meaning |
+|---|---|---|
+| CONFIRMED | 30 | feed agrees with draft (ratio ~1.0) — 2nd-source verified |
+| DISCREPANT_UNIT_2_5X | 209 | feed ~2.54x the draft price — systematic unit/currency mismatch, draft may be a ~2.5x UNDERPRICE |
+| DISCREPANT_OTHER | 0 | feed disagrees by some other factor |
+| UNVERIFIABLE | 89 | feed has no retail for this mfr_sku — cannot 2nd-source check |
+| BAD_PROPOSED | 0 | proposed price nonpositive (should be 0) |
+
+## What this means
+The ~2.54x factor (= 2 × ~1.27) is consistent with a double-roll × GBP→USD transform applied by one source and not the other. **This tool does NOT decide which is right** — it surfaces the discrepancy. The Option-A reprice of the DISCREPANT_UNIT_2_5X cohort is BLOCKED pending a Steve/pricing-owner ruling on the canonical price source (the epic TK-10874 says S1/feed is authoritative, which would make the draft's zoffany_catalog values wrong-low).
+
+Safe-to-reprice now = CONFIRMED (30). Everything else holds.
+
diff --git a/tk10873/cross_validate_feed.mjs b/tk10873/cross_validate_feed.mjs
new file mode 100644
index 0000000..b57b93a
--- /dev/null
+++ b/tk10873/cross_validate_feed.mjs
@@ -0,0 +1,110 @@
+#!/usr/bin/env node
+// cross_validate_feed.mjs — TK-10873 cycle 4. Cross-validate the Option-A REPRICE
+// proposed prices (sourced from zoffany_catalog.price_retail) against the INDEPENDENT
+// SDG S1 feed harvest (pilot/zoffany_feed_harvest.jsonl, from TK-10877 — a different
+// price source), keyed by mfr_sku.
+//
+// READ-ONLY. NO SHOPIFY/DB WRITES, NO http/fetch. Reads two local files only.
+//
+// Why: the sanity gate could only "legibility-check" 238/328 retail-only prices with no
+// independent cost floor (Cody cycle-3). The feed harvest is that missing 2nd source.
+//
+// FINDING (cycle 4): the two sources are cleanly BIMODAL — ~30 agree (ratio ~1.0) and
+// a large cohort disagree by a near-constant ~2.543x (== 2 * 1.27, i.e. a double-roll x
+// GBP->USD unit/currency transform). Where the feed price is ~2.54x the draft price, the
+// draft (zoffany_catalog) value is potentially a ~2.5x UNDERPRICE. This does NOT auto-
+// resolve which source is canonical — it FLAGS the discrepancy for Steve/pricing-owner.
+import fs from 'node:fs';
+
+const DIR = new URL('.', import.meta.url).pathname;
+const DRAFT_IN = `${DIR}zoffany_optionA_draft.json`;
+const FEED_IN = '/Users/macstudio3/Projects/sanderson-onboard/pilot/zoffany_feed_harvest.jsonl';
+const JSON_OUT = `${DIR}cross_validate_feed.json`;
+const MD_OUT = `${DIR}cross_validate_feed.md`;
+
+// classification thresholds
+const AGREE_TOL = 0.02; // |ratio-1| < 2% => sources agree
+const UNIT_LO = 2.3, UNIT_HI = 2.8; // ratio in this band => the ~2.54x unit/currency discrepancy
+
+export function classifyVsFeed(proposed, feedRetail) {
+ const p = Number(proposed), f = Number(feedRetail);
+ if (!Number.isFinite(f) || f <= 0) return { klass: 'UNVERIFIABLE', ratio: null };
+ if (!Number.isFinite(p) || p <= 0) return { klass: 'BAD_PROPOSED', ratio: null };
+ const ratio = f / p;
+ if (Math.abs(ratio - 1) < AGREE_TOL) return { klass: 'CONFIRMED', ratio };
+ if (ratio >= UNIT_LO && ratio <= UNIT_HI) return { klass: 'DISCREPANT_UNIT_2_5X', ratio };
+ return { klass: 'DISCREPANT_OTHER', ratio };
+}
+
+function loadFeed() {
+ const map = new Map();
+ for (const line of fs.readFileSync(FEED_IN, 'utf8').trim().split('\n')) {
+ const r = JSON.parse(line);
+ if (r.mfr_sku && Number(r.retail_usd) > 0) map.set(r.mfr_sku, Number(r.retail_usd));
+ }
+ return map;
+}
+
+function main() {
+ const draft = JSON.parse(fs.readFileSync(DRAFT_IN, 'utf8'));
+ const reprice = draft.filter(p => p.action === 'REPRICE');
+ const feed = loadFeed();
+
+ const buckets = { CONFIRMED: [], DISCREPANT_UNIT_2_5X: [], DISCREPANT_OTHER: [], UNVERIFIABLE: [], BAD_PROPOSED: [] };
+ for (const r of reprice) {
+ const { klass, ratio } = classifyVsFeed(r.proposed_sellable_price, feed.get(r.mfr_sku));
+ buckets[klass].push({
+ mfr_sku: r.mfr_sku, dw_sku: r.live_dw_sku || r.staged_dw_sku,
+ proposed: r.proposed_sellable_price, feed_retail: feed.get(r.mfr_sku) ?? null,
+ ratio: ratio == null ? null : Number(ratio.toFixed(3)),
+ });
+ }
+
+ const report = {
+ ticket: 'TK-10873', cycle: 4, generated_at: new Date().toISOString(), read_only: true,
+ source_a: 'zoffany_catalog.price_retail (used by the Option-A draft)',
+ source_b: 'SDG S1 feed harvest retail_usd (TK-10877, independent)',
+ reprice_total: reprice.length,
+ counts: Object.fromEntries(Object.entries(buckets).map(([k, v]) => [k, v.length])),
+ // headline: how many are 2nd-source CONFIRMED vs flagged discrepant vs unverifiable
+ verdict: buckets.DISCREPANT_UNIT_2_5X.length > 0 ? 'FAIL' : 'PASS',
+ status: buckets.DISCREPANT_UNIT_2_5X.length > 0 ? 'FAIL' : 'PASS',
+ finding: buckets.DISCREPANT_UNIT_2_5X.length > 0
+ ? `${buckets.DISCREPANT_UNIT_2_5X.length} REPRICE prices are ~2.54x BELOW the independent S1 feed (systematic unit/currency mismatch). Which source is canonical is a Steve/pricing-owner decision — reprice of these is BLOCKED until resolved.`
+ : 'no systematic discrepancy vs the S1 feed',
+ buckets,
+ };
+ fs.writeFileSync(JSON_OUT, JSON.stringify(report, null, 2));
+
+ const c = report.counts;
+ const md = [
+ `# TK-10873 cycle 4 — REPRICE vs independent S1 feed cross-validation`, '',
+ `- **Verdict:** ${report.verdict}`,
+ `- Source A (draft): \`zoffany_catalog.price_retail\``,
+ `- Source B (independent): SDG S1 feed harvest \`retail_usd\` (TK-10877)`,
+ `- REPRICE rows: ${report.reprice_total}`, '',
+ `## Cross-validation buckets`,
+ `| bucket | count | meaning |`,
+ `|---|---|---|`,
+ `| CONFIRMED | ${c.CONFIRMED} | feed agrees with draft (ratio ~1.0) — 2nd-source verified |`,
+ `| DISCREPANT_UNIT_2_5X | ${c.DISCREPANT_UNIT_2_5X} | feed ~2.54x the draft price — systematic unit/currency mismatch, draft may be a ~2.5x UNDERPRICE |`,
+ `| DISCREPANT_OTHER | ${c.DISCREPANT_OTHER} | feed disagrees by some other factor |`,
+ `| UNVERIFIABLE | ${c.UNVERIFIABLE} | feed has no retail for this mfr_sku — cannot 2nd-source check |`,
+ `| BAD_PROPOSED | ${c.BAD_PROPOSED} | proposed price nonpositive (should be 0) |`, '',
+ `## What this means`,
+ `The ~2.54x factor (= 2 × ~1.27) is consistent with a double-roll × GBP→USD transform applied by one source and not the other. **This tool does NOT decide which is right** — it surfaces the discrepancy. The Option-A reprice of the DISCREPANT_UNIT_2_5X cohort is BLOCKED pending a Steve/pricing-owner ruling on the canonical price source (the epic TK-10874 says S1/feed is authoritative, which would make the draft's zoffany_catalog values wrong-low).`, '',
+ `Safe-to-reprice now = CONFIRMED (${c.CONFIRMED}). Everything else holds.`, '',
+ ];
+ fs.writeFileSync(MD_OUT, md.join('\n') + '\n');
+
+ console.log('=== REPRICE vs S1 feed cross-validation (READ-ONLY) ===');
+ console.log(`reprice=${report.reprice_total} ${JSON.stringify(c)}`);
+ console.log(`verdict=${report.verdict}`);
+ console.log(report.finding);
+ console.log(`\nartifacts:\n ${JSON_OUT}\n ${MD_OUT}`);
+ // Exit nonzero on the systematic discrepancy so this is a real gate.
+ process.exit(report.verdict === 'FAIL' ? 1 : 0);
+}
+
+// run only if invoked directly (so tests can import classifyVsFeed)
+if (import.meta.url === `file://${process.argv[1]}`) main();
diff --git a/tk10873/test_cross_validate.mjs b/tk10873/test_cross_validate.mjs
new file mode 100644
index 0000000..6d1b905
--- /dev/null
+++ b/tk10873/test_cross_validate.mjs
@@ -0,0 +1,21 @@
+#!/usr/bin/env node
+// test_cross_validate.mjs — unit tests for classifyVsFeed (pure, no DB/network).
+import { classifyVsFeed } from './cross_validate_feed.mjs';
+
+let pass = 0, fail = 0;
+const ok = (c, m) => { if (c) pass++; else { fail++; console.error(`FAIL: ${m}`); } };
+
+ok(classifyVsFeed(176, 176).klass === 'CONFIRMED', 'identical -> CONFIRMED');
+ok(classifyVsFeed(176, 178).klass === 'CONFIRMED', 'within 2% -> CONFIRMED');
+ok(classifyVsFeed(422, 1073.3).klass === 'DISCREPANT_UNIT_2_5X', '2.54x -> DISCREPANT_UNIT_2_5X');
+ok(classifyVsFeed(100, 254).klass === 'DISCREPANT_UNIT_2_5X', 'exactly 2.54x -> unit discrepancy');
+ok(classifyVsFeed(100, 500).klass === 'DISCREPANT_OTHER', '5x -> DISCREPANT_OTHER');
+ok(classifyVsFeed(100, 150).klass === 'DISCREPANT_OTHER', '1.5x -> DISCREPANT_OTHER (outside agree + unit bands)');
+ok(classifyVsFeed(176, null).klass === 'UNVERIFIABLE', 'no feed -> UNVERIFIABLE');
+ok(classifyVsFeed(176, 0).klass === 'UNVERIFIABLE', 'zero feed -> UNVERIFIABLE');
+ok(classifyVsFeed(0, 176).klass === 'BAD_PROPOSED', 'nonpositive proposed -> BAD_PROPOSED');
+// ratio is reported
+ok(Math.abs(classifyVsFeed(422, 1073.3).ratio - 2.543) < 0.01, 'ratio ~2.543 reported');
+
+console.log(`\ntest_cross_validate: ${pass} passed, ${fail} failed`);
+process.exit(fail === 0 ? 0 : 1);
← 55fb121 TK-10873 cycle3 Cody-hardening: restore-map is a labeled TEM
·
back to Sanderson Onboard
·
TK-10873 cycle4: web-verified feed is canonical (Zoffany US a08d3c6 →