CRM system for booking makeup sessions in the Telegram bot aiogram

Developed a fully functional CRM system for a makeup studio that operates entirely within a Telegram bot. The bot combines the client side and the administrative panel in one interface, without a separate website.

Client capabilities:
- Booking an appointment in three steps: selecting a service, a date a month in advance, and available time
- Viewing and canceling their own appointments
- List of services with prices and durations
- Profile settings: phone and notifications
- Automatic notifications about appointment confirmation or cancellation

Administrative panel directly in the bot:
- Orders with filters by status (new, confirmed, completed, canceled) and actions: confirm, complete, cancel, delete
- Statistics: number of appointments, income, clients, workload schedule
- Client database with visit history
- Service management: adding, editing, hiding, deleting
- Flexible working schedule: working days, hours, slot duration, booking horizon
- Mass mailing to clients and editing the welcome message
- Administrator management (one or multiple) by username or Telegram ID

The generation of available slots occurs automatically, taking into account the working schedule and already booked appointments, thus eliminating double bookings.

Technologies: Python, aiogram 3, SQLAlchemy 2, SQLite. Clean modular architecture, convenient deployment via .env.

#telegram #telegrambot #python #aiogram #crm #bot #sqlalchemy #automation #booking #Backend