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