Auto Dealer Sales System — One Pipeline Across 5 Dealerships
Automotive
Visual-AI-Labs replaced five disconnected sales spreadsheets with a single pipeline, real-time stock view and per-dealer scoreboards — built in 30–60-day cycles.
- 100% — Real-time stock visibility
- +35% — Conversion rate
- −50% — Time spent on reporting
- 5 → 1 — Sources of truth, unified
A network of five car dealerships had grown by acquisition. Each location kept its own stock list, its own sales spreadsheet and its own definition of “lead”. Headquarters could not answer a question as basic as “how many BMW X3 do we have across the group?” without a phone tree.
The problem
Decentralised operations meant zero centralised visibility. Reporting was a manual end-of-month exercise, conversion rates per dealership were guesses, and stock was routinely sold twice on the same morning because the lists were out of sync.
The solution
Visual-AI-Labs delivered a unified sales platform in two 30-day cycles. Every dealership shares the same pipeline definition, the same stock view and the same scoreboard — without losing local autonomy.
What we built
- Centralised multi-dealer dashboard with role-based access.
- Sales pipeline with configurable stages per dealership.
- Real-time stock tracking with automatic reservation when a deal moves to “contract”.
- Performance reports per dealer, per sales rep and per vehicle segment.
Results
- 100% real-time stock visibility across all five dealerships.
- 35% increase in conversion rate after unifying the pipeline definition.
- 50% reduction in reporting time — dashboards replaced month-end spreadsheets.
- Stock conflicts eliminated thanks to automatic reservation.
Technology & process
- React dashboards
- Supabase as the shared data layer
- Chart.js for scoreboards
- TypeScript end-to-end
Discuss a similar project with Visual-AI-Labs →
FAQ
Did dealerships have to give up local autonomy?
No. Pipeline stages, pricing rules and scoreboards can be configured per dealership; only the underlying data model is shared.
How was data migrated from five spreadsheets?
In a single cutover weekend after two weeks of dual-running. Spreadsheets were retired the following Monday.
How long did the project take?
Two 30-day cycles: cycle one shipped the shared stock view and dashboard; cycle two added pipelines and reporting.
Can it integrate with our existing finance system?
Yes — the platform exposes a clean API and we routinely integrate with accounting and DMS systems.
Does this work for more than 5 dealerships?
Yes. The platform scales horizontally; we have a roadmap for 20+ locations with the same pattern.
What about training?
Each dealership received a 90-minute session; the interface mirrors the spreadsheets they already used.