{"slug":"harlequin-sample-price-analysis","total":23,"limit":100,"offset":0,"since":null,"commits":[{"hash":"6ce6408","date":"2026-08-31 02:03:27 -0700","author":"auto-commit-fleet","subject":"auto-data-snapshot: 2026-08-31T02:00:54 (4 data files) — artifacts/job2-snapshots/apply.sql artifacts/job2-snapshots/prestate-kamatera.psv artifacts/job2-snapshots/prestate-local.psv artifacts/job2-snapshots/restore-map.json","body":""},{"hash":"98be7db","date":"2026-08-31 01:48:32 -0700","author":"steve","subject":"cycle 3: read-only verification — 25/25 green, cost-gap closed (approved work landed), 1 gated mfr_sku ride-along","body":""},{"hash":"dc38bb0","date":"2026-08-31 01:36:16 -0700","author":"Steve Abrams","subject":"TK-10981: junk mfr_sku cleanup + fleet cost-gap deep-dive (read-only report + 2 gated batches)","body":""},{"hash":"ea54ff5","date":"2026-08-31 01:23:13 -0700","author":"Steve Abrams","subject":"chore: add package.json v1.0.0 (session close) — 25 tests green, dependency-free","body":""},{"hash":"b2da31e","date":"2026-08-31 00:26:50 -0700","author":"Steve Abrams","subject":"TK-10992: right-size Thibaut collisions — 26 LIVE (Anna French x Thibaut id-collision) + 421 stale","body":"- all 447 are pairs; only 26 map to a live ACTIVE product, ALL Anna French(AT) x Thibaut(numeric)\n- root cause = Anna French import collided shopify_product_ids with Thibaut proper (shared catalog)\n- 421 numeric x numeric are stale (not in live mirror) = low-pri hygiene, not customer-facing\n- turns '447 bugs' into '26 live to fix + 421 stale to clean'\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"a0bd685","date":"2026-08-31 00:15:14 -0700","author":"Steve Abrams","subject":"fleet integrity sweep: Thibaut 447 + Schumacher 5 cross-pattern collisions (Cranes-class); Koroseal/Hollywood legit","body":"- ran the reusable detector's product-id-collision check across 19 vendor catalogs\n- second-level same-pattern-vs-cross-pattern test: real corruption = 452 groups (Thibaut 447 confirmed\n Birch Cork+Tosca / Aida+Barafundle), NOT the 3252 raw (Koroseal 2471 + Hollywood 154 = legit colorway grouping)\n- FLEET-INTEGRITY-SWEEP.md; read-only, fixes gated\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"f3d8761","date":"2026-08-31 00:09:12 -0700","author":"auto-commit-fleet","subject":"auto-data-snapshot: 2026-08-31T00:07:16 (1 data files) — artifacts/restore-maps/locronan-cost-reprice-20260831T000016.json","body":""},{"hash":"7fe0b8f","date":"2026-08-30 23:49:52 -0700","author":"Steve Abrams","subject":"correct and gate junk mfr sku repair plan","body":""},{"hash":"16a6350","date":"2026-08-30 23:04:05 -0700","author":"Steve Abrams","subject":"TK-10870 Action3: recover real Locronan + Cranes mfr codes read-only (unblocks the 'needs scrape' blocker)","body":"- Locronan (Idyllic) is a real 4-colorway pattern; 3 on store, all mfr-scrambled:\n 335022 Aqua->113124, 335023 Clover->113123 (already correct), 335024 Cornflower->113125\n (official harlequin.sandersondesigngroup.com + retailers; not fabricated)\n- Cranes codes already in catalog: 335001->Blush haw0065-03, 335002->Emerald haw0065-04, Marine haw0065-05\n- folded into the Action-3 pending-approval draft; fixes remain gated -> vp-dw-commerce\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"3ec7097","date":"2026-08-30 21:04:37 -0700","author":"Steve Abrams","subject":"TK-10870: vp-dw-commerce executed Steve-approved Actions 1+2 (reprice 27, backfill 4 dw_sku)","body":"- Action 1: 27 Harlequin roll variants repriced $150 placeholder -> formula retail (cost/0.65/0.85),\n live-read idempotent, roll-variant-only, 27/27 verified, restore-map (27 entries) + ledger\n- Action 2: 4 Houndstooth dw_sku backfilled DWHQ-335016/17/18/19 (was NULL), verified in mirror\n- Action 3 drafted (Locronan mfr code unknown -> scrape needed; Marine gated) — no fabrication\n- execution scripts + result artifacts from the officer run\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"cf2952a","date":"2026-08-30 14:31:58 -0700","author":"Steve Abrams","subject":"cycle6 (compound): reusable read-only catalog-integrity detector","body":"- scripts/integrity.mjs (pure) + integrity-report.mjs (read-only runner): generalises the\n TK-10870 findings to ANY vendor — product-id collisions, mfr_sku mis-stamps, junk mfr_sku, cost gaps\n- 5 detector tests (25 total pass); verified live vs Harlequin reproduces 1/2/3/1 -> FAIL\n- turns 6 cycles of one-off queries into a one-command reusable guard\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"25bb6a3","date":"2026-08-30 14:27:38 -0700","author":"Steve Abrams","subject":"cycle5: right-size the junk mfr_sku='TRUE' bug (adjacent finding, read-only)","body":"- 3675 rows/10 vendors but 99.97% recoverable (real sku present), only 83 ACTIVE, 1 unrecoverable\n- reframes the scary '18156 shared skus' as recoverable field-pollution, not broken products\n- JUNK-MFRSKU-CYCLE5.md + enriched v2 memo Action 4 (LOW-MEDIUM ticket recommendation)\n- no writes; new ticket remains Steve-gated\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"7152046","date":"2026-08-30 13:37:01 -0700","author":"Steve Abrams","subject":"TK-10870 cycle4: read-only reprice PLAN + Cody fixes (30->27 repriceable, 3 sample-only)","body":"- built artifacts/REPRICE-PLAN.md + reprice-plan.json (read-only, from mirror, Cody-correct join)\n- Cody caught: mirror variant_id points at the $4.25 Sample; 3 rows sample-only (no roll variant)\n -> repriceable_now=27, needs_roll_variant=3, excluded=2 (27+3+2=32, test-enforced)\n- variant-safety caveat: execution must enumerate variants LIVE, reprice roll only, never the Sample\n- plan-integrity tests added; re-surfaced corrected gated memo v2 (v1 auto-filed to _resolved undecided)\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"aee6b5e","date":"2026-08-30 13:29:45 -0700","author":"auto-commit-fleet","subject":"auto-data-snapshot: 2026-08-30T13:27:48 (1 data files) — artifacts/reprice-plan.json","body":""},{"hash":"f983902","date":"2026-08-30 11:19:55 -0700","author":"Steve Abrams","subject":"TK-10870 cycle3: verification pass — analysis stable, no change; loop paused (idle, only gated work remains)","body":"Co-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"201a10e","date":"2026-08-30 10:17:55 -0700","author":"Steve Abrams","subject":"TK-10870 cycle2 Cody fixes: correct mis-stamp count 3/8->2/4, add Demoiselle/Locronan collision, join-key + junk-concentration","body":"- Cody caught: missed the Demoiselle/Locronan mfr_sku collision (DWHQ-335024 Locronan\n wrongly carries the Demoiselle code) + my count was wrong (2 mfr_skus/4 skus not 3/8)\n- memo exclusion list now covers BOTH collision groups; reprice join key spec'd as\n shopify_id<->shopify_product_id (mfr_sku is corrupt on those rows)\n- 'TRUE' junk concentration named (Fentucci 2070+367 / Retro Walls 946)\n- prevents mispricing Locronan against Demoiselle's cost anchor\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"515ebd5","date":"2026-08-30 10:13:17 -0700","author":"Steve Abrams","subject":"TK-10870 cycle2: size the corruption class + draft consolidated gated memo","body":"- Harlequin: 1 product-id collision (Cranes/haw0065) + 3 mis-stamped mfr codes (8 skus) — bounded\n- fleet-wide honest breakdown: 6271 shared mfr_skus but dominated by junk-value leakage\n ('TRUE'=3671 skus, vendor-names) + pattern-level sharing — NOT 6271 Cranes-style corruptions\n- isJunkMfrSku() pure helper + test (15 tests pass)\n- CORRUPTION-SIZING-CYCLE2.md + pending-approval memo (4 gated actions APPROVE/REVISE/BLOCK)\n- read-only; nothing executed\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"34902d9","date":"2026-08-30 10:09:04 -0700","author":"Steve Abrams","subject":"TK-10870: record Steve's ruling — price_trade IS DW net cost (Blocker A resolved)","body":"Steve 2026-08-30: price_trade = confirmed DW net wholesale; retail=trade/0.65/0.85 correct.\nRegistry products_with_cost=0 / vendor_discount_pct=0.00 are stale rollup, not pricing errors.\nNext cycle seed: size the Cranes In Flight (haw0065) product-id/mfr_sku corruption fleet-wide.\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"fa82ec5","date":"2026-08-30 09:36:36 -0700","author":"Steve Abrams","subject":"TK-10870: flag Cranes identity collision","body":""},{"hash":"fb1b229","date":"2026-08-30 09:36:12 -0700","author":"Steve Abrams","subject":"TK-10870 cycle1 Cody gate: name 3 reproduced prerequisite blockers","body":"- A: price_trade provenance unconfirmed (25 raw ratios 1.80991-1.81000, all match\n round(cost/0.65/0.85) — proves retail computed FROM trade, not that trade=net cost)\n- B: write-path namespace mismatch DWHA-(catalog) vs DWHQ-(Shopify)\n- C: Cranes In Flight identity corruption — 570137/570138 share shopify_product_id\n 7787420680243; DWHQ-335001+335002 both stamped the Marine mfr_sku (NEW finding)\n- CODY-GATE-CYCLE1.md holds the reproduced SQL evidence; still read-only, all fixes GATED\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"d3198f5","date":"2026-08-30 09:35:54 -0700","author":"Steve Abrams","subject":"TK-10870: add independent Codex comparison","body":""},{"hash":"ff71dd7","date":"2026-08-30 09:29:59 -0700","author":"Steve Abrams","subject":"TK-10870 cycle1: read-only resolution of the 2 blockers + sibling-cost inference","body":"- inferSiblingCostCandidate() (pure, HAW-code keyed) + patternKeyFromMfrSku(); 14 tests pass\n- BLOCKERS.md: Cranes/Marine cost-gap has confident $140 candidate (3/3 siblings agree);\n 4/5 null dw_sku are mirror sync-gaps (DWHQ-335016-019 exist on Shopify), 1 real gap\n- census: 732/842 (87%) already cost+formula-correct — reprice is a bounded backfill\n- read-only only; all backfills remain GATED\n\nCo-Authored-By: Claude Opus 4.8 (1M context) "},{"hash":"d5bc8ad","date":"2026-08-30 09:23:15 -0700","author":"Steve Abrams","subject":"TK-10870: read-only Harlequin missing-sample + price analysis (corrected)","body":"- pure pricing lib (retail=cost/0.65/0.85) + 11 passing node:test unit tests\n- read-only psql harness (forced read-only session; SELECT-only guard)\n- FINDINGS.md: gate premise 'COST=UNKNOWN' is STALE — mirror back-filled 8/30,\n price_trade populated 732/842, 31/32 cohort computable, 1 cost gap, 5 null dw_sku\n- no Shopify / no dw_unified writes\n\nCo-Authored-By: Claude Opus 4.8 (1M context) \n"}]}