Integrate the user-supplied 82 logical families / 87 technical keys, specification and CSV. Generate French presentation names/subtitles from verified catalogue metadata or source-linked reviewed facts, without guessing translations, characters, quantities, dates or product-code pairings. Product exceptions outrank family templates, including Braségali, First Partner Series, K.O. and Double Pack. Mixed main-items-sealed remains excluded. Battle Stadium's EX | 2004 subtitle still needs separate confirmation before its display-only Deck correction.

Publication uses data.naming.fr, not a destructive rewrite of source names or taxonomy. IDs, SKU, series links, compositions, images, embeddings, reference URLs, pricing identities and holdings are preserved. Other language entries survive. API list/search exposes the reviewed presentation; old rows fall back.

Read-only Catalogue Preview

Public reviewed products were exported in one read-only VPS transaction and planned offline. No user table was read. Final result on 2026-10-20:

Status	Products
Ready proposals, not applied	497
Blocked pending verified facts or variant review	1910
Excluded mixed aggregate	56
Already unchanged	0
Total	2463

The CSV/JSON full report and separate ambiguity CSV were delivered locally for human review. Partial names in blocked rows are suggestions, not safe updates. Frequent missing facts include block/code, localized Pokemon, distinctive names, extensions, years, collection, quantities and combined-series codes. These are not claimed as solved renames. Same titles never authorize SKU merging.

Approved-result digest to review (not an approval already granted):

37bd4eb559f9ed56a1c390d2e7d9aacc86048b2a57c4971957f46d4f8937ecff

Examples: Blister Couronne Stellaire / Écarlate et Violet | EV07; ETB Vigueur Spectrale / XY | XY04; Deck -ROUGE Shanks- / One Piece | ST-23.

Future Application, Not Executed

The operation tool is dry-run by default and needs an explicit approved digest and exclusive private backup path for writes. It regenerates the report, locks and checks live row snapshots, fsyncs backup before UPDATE, commits atomically and skips already-applied rows. Rollback checks the published snapshot and refuses intervening changes. Offline manual facts are bound to original row digests, with no preliminary DB modification. Keep a normal database backup as well. Operator instructions are in the backend's docs/BACKEND.md.

No VPS UPDATE, migration, deployment, service restart, real-account deletion or collection change occurred. Production publication still requires the user's review and explicit approval; merging code alone does not rename catalogue data.

Validation

API: 1,381 passed / 11 skipped, including the disposable PostgreSQL 16 naming integration. Focused sealed catalogue suite: 92 passed / 0 skipped. Ingest: 554 passed. TypeScript/check-JS and diff checks pass. Red/Green cycles covered new behaviors individually; all non-excluded technical templates have fixture coverage. Real SQL checks backup-failure recovery, unchanged raw source names, holding links, editorial API search, replay and rollback. The temporary local PostgreSQL server was stopped afterward. Full Docker E2E was not run because the local Linux daemon is unavailable. Hosted CI may remain blocked by billing.

Backend: https://github.com/snag-tcg/tcg-collector-backend/pull/530

Mobile: https://github.com/snag-tcg/poc-tcg-collector/pull/794