Business Automation & CRM

CUT Studio CRM Bot

A cross-platform manager bot for a digital tailoring studio. Connects the landing page, Telegram Bot API, and Max Platform API (VK Teams) via a shared SQLite database — enabling production workflow management directly from messaging apps.

Python SQLite Webhooks & API

Key Features:

  • Dual-platform notification push: A new order card from the website is instantly sent to all master chats on both Telegram and Max platforms simultaneously.
  • Bidirectional click sync: When a master is assigned or an order status is updated (Cutting, Fitting, Sewing, Ready) on one platform, the change is instantly reflected on the other in real time.
  • Client lookup mode: Secure order search by phone number or ID for clients — without exposing internal management controls.

System Architecture

Frontend (cut.c0de4seek.ru)

Client submits measurements and contact details via an interactive quiz-calculator. A POST request is sent to /api/submit.

Nginx Reverse Proxy & HTTP Server

Routes requests from external domains to the local port of the Python bot server (Telegram/Max webhooks and site API).

Backend Synchronizer

Python script processes callbacks, updates the SQLite DB, and dynamically edits messages across all active master chats (editMessageText in TG, PUT messages in Max).

Synchronized Interface Across Two Platforms

Telegram Interface
Back
CUT Studio Bot
bot
🧵 New order in CUT Studio (#12)!

👤 Client: Jan
📞 Phone: +79991234567
🧥 Type: Custom tailoring
📐 Measurements:
  • Height: 180 cm
  • Chest: 100 cm

✉️ Order details:
Wool overcoat per sketch.

📍 Status: New
👥 Master: unassigned
Message...
Max (VK Teams) Interface
CUT Studio CRM
online
🧵 New order in CUT Studio (#12)!

👤 Client: Jan
📞 Phone: +79991234567
🧥 Type: Custom tailoring
📐 Measurements:
  • Height: 180 cm
  • Chest: 100 cm

✉️ Order details:
Wool overcoat per sketch.

📍 Status: Cutting
👥 Master: Alena
✓ Order #12 status changed to: Cutting (Alena)
Type a message...