Vehicles in pipeline
6
Purchased inventory only.
Total invested
$76,950
Purchase plus expenses.
Projected margin
$9,460
Live P&L vs list.
Stuck vehicles
1
Over 14 days in status.
Status pipeline
Purchased to recon to ready to listed to soldRecon spend by category
Budget tracking baked in.Recent activity
Audit trail and notes.Vehicle sold - ready for payout
1N4AL3AP0GC284512 - Jan 8 - Luke Turner
Listed on marketplace
5N1AT2MT3JC709112 - Jan 3 - Priya Patel
Moved to ready status
3FA6P0H79JR123980 - Jan 1 - Sasha Lee
Entered recon workflow
2T1BURHE0JC945120 - Dec 23 - Marcus Hill
Vehicle marked purchased
1HGCM82633A123456 - Dec 17 - Alicia Gomez
Marked as dead inventory
KM8J3CA4XKU921407 - Dec 11 - Alicia Gomez
Alerts preview
Phase 2: Telegram notifications.2T1BURHE0JC945120 has been Recon for 18 days
Vehicles
VIN is the unique primary key.
2018 Honda Civic
1HGCM82633A123456
Status workflow
Update status
Actions
Expenses
Events
Vehicle marked purchased
Dec 17 - Alicia Gomez
Expenses
Every expense is linked to a VIN.
Recon over budget
0
Vehicles beyond target.
Avg days to ready
48
Median workflow speed.
Top buyer margin
$5,090
Buyer: Priya Patel
Inventory value
$55,340
Current exposure.
P&L by VIN
Listed and sold inventory.Stuck and over budget
What needs attention today.2T1BURHE0JC945120 has been Recon for 18 days
Buyer performance
Purchases, spend, margin.Vendor spend
Recon vendors at a glance.Automation settings
Phase 2: Telegram alerts.Telegram integration planned for phase 2.
Alert templates include VIN, buyer, and recommended action.
Open alerts
Auto-generated from workflow.2T1BURHE0JC945120 has been Recon for 18 days
Proposed architecture
Postgres as system of record.Postgres Core
Vehicles (VIN PK), expenses, events, alerts. JSONB for integrations.
API Layer
FastAPI or Node REST with auth, audit logging, CSV exports.
Ops UI
Admin dashboard, VIN detail, CSV, alerts.
Milestone timeline
4-week delivery.- Week 1: Schema, migrations, base API, data import.
- Week 2: UI dashboard, VIN detail, CSV exports.
- Week 3: Alerts engine, Ramp integration hooks.
- Week 4: QA, deployment, backups, docs.
Schema sketch
Postgres tables and key fields.vehicles
vin PK, buyer_id, status, purchase_price, list_price, recon_budget, status_updated_at
expenses
id PK, vin FK, category, vendor, amount, expense_date, source (ramp or manual)
events
id PK, vin FK, type, message, created_at, actor
alerts (optional)
id PK, vin FK, rule, severity, status, created_at
Reliability and ops
Monitoring, retries, backups.- Nightly automated backups and weekly restore checks.
- Retry queue for webhooks and Ramp sync.
- Audit log stored in events table with immutable inserts.
- Uptime monitoring with alerts to Ops or Telegram.
Similar projects
Relevant delivery experience.- Automotive inventory platform with live margin tracking.
- Fintech ops console for card spend categorization.
- Marketplace dashboard with seller onboarding workflows.
- Audit-ready expense platform for multi-location retailers.
Deployment and maintenance
Hosted delivery expectations.- Dockerized services with staging and production.
- Infra as code with automated migrations.
- Documentation: runbooks, data dictionary, API reference.
- CSV export and scheduled reports to S3.