Appearance
The previous delivery transferred assets and exposed an API but omitted the import needed to populate it. This completion matches each first-level folder exactly to the existing PostgreSQL product/type nomenclature and creates a stable product reference for each image. No additional mapping categories are invented.
Backend: https://github.com/snag-tcg/tcg-collector-backend/pull/457
Mobile: https://github.com/snag-tcg/poc-tcg-collector/pull/648
Import Results
- Backed up both sealed product/image tables before inserting.
- Imported 2,301 product references with 4,602 thumbnail/detail image references.
- Excluded all 348 assets from the five unmapped main-sealed folders.
- Assigned 819 canonical series using source-code aliases that exist in sets.
- Products without a series remain available by type and search; series facets include only known canonical series.
- Preserved original assets. Checked their SHA256 before decoding. Published metadata-free, versioned JPEG derivatives through the existing image server.
- Physical language, product release date and prices remain null/absent.
- Existing scan/lab records are untouched. Re-running uses insert-only conflicts.
The nomenclature is applied literally: main-items-sealed currently maps to ETB even though that directory includes multiple packaging shapes. This needs an explicit taxonomy correction rather than a silent import override. Source-derived product names also remain candidates for editorial enrichment.
Verification
1071 API tests pass. Mobile lint/typecheck and 2390 tests pass (11 pre-existing skips). The public endpoint returned 30 real products with a next offset, and a referenced thumbnail returned HTTP 200. An Android rebuild and final merged deployment are verified in the linked delivery PRs.