Beauty Guide – an intelligent booking system for a beauty salon

Task:
Develop a multifunctional Telegram bot with a web admin panel for automating client bookings, managing services and masters, accepting prepayments, and analytics.

Solution:
A full-fledged CRM system has been created in the form of a Telegram bot (aiogram 3.x) and a web administrator interface (Flask). Main modules:

Interactive calendar for selecting date and time.

Real-time availability check for masters.

Manual entry of bookings through the admin panel.

Integration with LiqPay for prepayment (20% of the service cost).

Automatic visit reminders (24 hours and 1 hour before).

Analytical dashboard: service popularity, booking dynamics, revenue.

Shared SQLite database for the bot and admin panel.

Technologies: Python 3.11, aiogram, Flask, SQLite, APScheduler, LiqPay API, Chart.js.

Results:
The client booking process has been fully automated – from service selection to payment. The time for processing applications has been reduced by 80%, and the number of errors in double bookings has been reduced to zero. The administrator has received a convenient tool for managing the business in real time.

#telegram_bot #fastapi #sqlite #aiogram #flask #beauty_industry #automation #freelancehunt