Challenge
An oil change service has to remember every customer’s car, when and at what mileage the oil was changed, which filters were replaced and when the next visit is due. At the same time, stock, sales, profit and customer debts all had to be tracked in one place.
Solution
UFLEX built a web admin panel, a management mobile app and the server behind them. The customer base stores each customer’s cars with the plate number and the daily and monthly distance driven.
Each service record holds the current mileage, the mileage the oil is rated for, the mileage of the next visit, and whether the oil, air, fuel and cabin filters were replaced. Products used are written off from stock; discount, amount paid, debt and profit are calculated in both soums and dollars.
The system sends the customer an SMS after the service and a reminder one day before the next one. An SMS also goes out on the debt repayment date. SMS templates, delivery statuses and the SMS balance are visible in the admin panel. Customers can open the receipt of their latest service through a separate link.
In the stock section, products are kept with cost price, sale price, minimum stock level and photos. Administrators get permissions per section, and new services and orders are reported to a Telegram group.
System components
- Web admin panel
- Management mobile app
- Customer and car database
- Service history — mileage, oil and filters
- SMS reminders — after a service, before the next visit and before a debt payment
- Stock — prices, levels, photos
- Debtors — in soums and dollars
- Telegram notifications
Technologies
- Node.js (Express) — server side
- PostgreSQL — database
- React — admin panel
- Expo / React Native — mobile app
- Eskiz — SMS messaging