Live
Visit SiteGalleria Motors
Car showroom platform with inventory management and customer inquiries
System Snapshot
Problem Space
Automotive retail digitization
Core Users
Car buyers in Kenya
Primary Constraint
Inventory accuracy and freshness
Role
Full Stack
Technologies Used
Next.jsNode.jsMongoDBCloudinary
Problem
Outdated Listings
- Cars sold but still showing online
- Manual updates across multiple platforms
- No real-time inventory visibility
Poor Lead Capture
- Inquiries via WhatsApp with no tracking
- No structured data on customer interest
- Follow-ups falling through the cracks
System Design
Inventory System
- Single source of truth for all vehicles
- Status workflow: Available → Reserved → Sold
- Bulk image upload with auto-optimization
Lead Management
- Structured inquiry forms per vehicle
- Admin dashboard for lead tracking
- Automated email notifications
Trade-offs
- Chose MongoDB for flexible vehicle schemas
- No payment integration — cash/bank transfer market
- Simple admin over full CRM to ship faster
Market Impact
Shipped
- Public showroom with search and filters
- Admin portal for inventory management
- Lead capture with email notifications
Impact
- 100% inventory accuracy
- 50% reduction in duplicate inquiries
- Professional online presence established
Skills & Lessons
Skills Gained
- Modeling flexible product schemas with NoSQL
- Building custom admin dashboards and workflows
- Optimizing image delivery for media-heavy sites
- Designing effective lead capture funnels
Lessons Learned
- Image quality matters enormously for car sales
- Admin UX is as important as customer UX
- Simple status workflow solved 80% of problems
- Would add WhatsApp integration next iteration
