Customer ID Mapping
RepairShopr customer IDs for ESA programs and other key accounts.
The RepairShopr customer IDs that get used most often — primarily for ESA program order processing. Verified against the live RS data on 2026-04-14.
ESA / EFS programs
| Program | RS Customer ID |
|---|---|
| Odyssey Iowa | 30805989 |
| Tennessee Portal | 31938978 |
| Odyssey Georgia | 34276337 |
| Odyssey Louisiana | 34338975 |
| Odyssey Utah | 34467295 |
Payment terms
All ESA programs are net-30 from ticket_created_at. The invoice generator
uses ticket_created_at (not invoice creation date) to compute the due date.
Why this matters
When the RS ticket sync runs and produces the master order list at:
/home/superht/pricing/exports/repairshopr_ticket_invoice_report_sheet_sync_latest.csv…it joins on these customer IDs to bucket orders by program. If a new ESA program comes online, it has to be added to:
- The customer record in RepairShopr (so tickets/invoices route correctly)
- The mapping table consumed by the ESA order processor
- This page (so the next person looking for it can find it)
Related references
- Hosts — where the sync runs and where the export lives
- Cron Schedule — when the sync runs
- Patterns — ESA order processing workflow (TBD)