This table maps our internal Product Code to the retailer-facing UPC Number. It is the source of truth the middleware uses to translate incoming products and to populate UPC values in downstream exports and carrier label payloads.

• Lookup: Server code calls UpcsTable::GetUpc(productcode) to fetch the UPC for a given product code (exact match).
• Where used: Export/build steps in the legacy CRS/JET flows read UPCs when composing retailer files and labels (see v1/src/Controller/CrsController.php references).
• Soft delete aware: Soft-deleted rows are excluded from all queries and exports automatically.
• Uniqueness: Aim for one row per Product Code. If duplicates exist, the first match may be used.
• Edits go live immediately: Changes here affect new imports/exports instantly.