[object Object]

← back to Harlequin Sample Price Analysis

TK-10992: right-size Thibaut collisions — 26 LIVE (Anna French x Thibaut id-collision) + 421 stale

b2da31e40add0adcb18a489e61bf3b5aae71ec20 · 2026-08-31 00:26:50 -0700 · Steve Abrams

- 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>

Files touched

Diff

commit b2da31e40add0adcb18a489e61bf3b5aae71ec20
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Aug 31 00:26:50 2026 -0700

    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>
---
 artifacts/FLEET-INTEGRITY-SWEEP.md | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/artifacts/FLEET-INTEGRITY-SWEEP.md b/artifacts/FLEET-INTEGRITY-SWEEP.md
index 8144a2a..6a79832 100644
--- a/artifacts/FLEET-INTEGRITY-SWEEP.md
+++ b/artifacts/FLEET-INTEGRITY-SWEEP.md
@@ -29,3 +29,15 @@ check is what makes it truthful.
 Open a ticket to reconcile the **Thibaut 447 cross-pattern product-id merges** (same class as the
 Harlequin Cranes fix: each merged pattern needs its own Shopify product + correct mfr_sku). Schumacher's
 5 can ride along. All fixes are gated customer-facing/canonical writes. Detector: `scripts/integrity-report.mjs`.
+
+## Thibaut 447 — deep characterization (read-only, right-sized)
+All 447 are clean PAIRS (898 rows, 2 distinct patterns each). Severity split by LIVE status:
+- **26 LIVE ACTIVE customer-facing collisions** — ALL are **Anna French (`AT####`) × Thibaut (numeric)**.
+  Root cause: Anna French (served on thibautdesign.com, shares the Thibaut catalog) was imported with
+  `shopify_product_id`s that collided with Thibaut-proper products. HIGH priority, tractable (26 products).
+- **421 STALE** — `shopify_product_id` not present in the live shopify_products mirror (points at non-live
+  products). Data-hygiene cleanup, LOW priority, NOT customer-facing.
+- Schumacher's 5 ride along.
+
+**Actionable = 26 live Anna-French×Thibaut merges** (split each to its own product + correct mfr_sku,
+same as the Harlequin Cranes fix). The 421 stale rows are a separate catalog-hygiene pass.

← a0bd685 fleet integrity sweep: Thibaut 447 + Schumacher 5 cross-patt  ·  back to Harlequin Sample Price Analysis  ·  chore: add package.json v1.0.0 (session close) — 25 tests gr ea54ff5 →