← All projects

In production Jul 2025 — present

Wholesaler reports bot — 32 distributor spreadsheets into one table

Every month 32 wholesalers send stock and sales in 32 different Excel layouts. A Telegram bot normalises them into one schema per brand; a yearly dashboard then shows where sales are falling.

Role
Solo: bot, parsers, dashboard
Stack
Python · pandas / openpyxl · Telegram Bot API · Power BI · Excel
wholesalers, each with its own layout
32
separate workspaces, cross-brand rows dropped
2 brands
fewer manual entry errors (estimated)
~40 %
Three layouts in, one schema out (synthetic sample)
Three layouts in, one schema out (synthetic sample)

The problem

A pharmaceutical distributor receives monthly “остаток” (stock) and “реализация” (sales) files from 32 wholesalers. Each file has its own columns, its own product names, mixed brands and typos. One analyst spent days re-typing them into a master sheet; territory decisions waited for the result.

What I built

Result

Monthly consolidation went from days of manual work to the time it takes to forward 32 files; manual entry errors fell by an estimated 40 %; and the yearly dashboard changed how territories were assigned. This project is also where I learned that the data problem was upstream — which led to building LM-CRM.