Skip to content
Canvas printing · 12 workshops

Production logistics saving 5 million rubles per year

A Telegram bot that automatically selects the optimal workshop for each order: factoring in cost price, additional services by size, price and SDEK delivery timelines.

Timeline~21 days
TypeTelegram bot + admin panel
StackPythonAiogram 3FastAPIPostgreSQL
Production logistics saving 5 million rubles per year

Context

The client has several workshops across Russia, each with its own pricing, additional services, delivery cost and production timelines. What looked like a simple contractor choice was in fact a small logistics and margin calculation every time.

Task

The goal was to remove manual workshop selection and make the system quickly calculate the best option for each order, taking into account production cost, delivery, urgency, size limits and additional services.

Solution

  • Built a Telegram bot where the manager enters order parameters.
  • Connected calculations across 12 workshops, including services and SDEK delivery.
  • Added an admin panel for updating price and service dictionaries without a developer.
  • Stored calculation history so management could review complex and expensive orders.

What changed

Managers now make decisions faster and consistently across the team. Management no longer has to manually verify every complex order, and the company stopped losing margin on poor workshop selection.

Project gallery

Click an image to open a larger view

Expand for developers

Python + Aiogram 3 for the bot. FastAPI for the internal API. Configs stored in JSON files, with an option to gradually migrate to PostgreSQL. SDEK API v2 integration — rates fetched in real time. Admin panel — JS-based SPA with authentication. Deployment: VPS, systemd services, Caddy as reverse proxy.

Result

5 000 000 ₽
saved per year by optimizing workshop selection
5 сек
instead of 8 minutes to calculate the optimal workshop
0
selection errors after implementation

Client testimonial

Previously, a manager had to keep dozens of workshop and delivery conditions in their head. Now the bot shows the best option in seconds, and questionable decisions have become much rarer. For us this is not just convenience, but money that used to be lost in manual selection.
И
Ирина Морозова
Operations Director, canvas printing studio
Free audit

Want something similar? Free audit

Tell us about your task — we'll figure out what and how to automate in one call.

Telegram
No advance payment until contract
Estimate in 24 hours
Working since 2019

Cookies and analytics

Yandex Metrica for site improvements. No form data is sent. Details