Skip to content

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.