E-commerce Info Dashboard for Shop Network

Challenge

The team managing a network of Shoptet e-shops spent hours every week manually collecting data — how much was sold, what are this month’s revenues, which products perform best. Each store has its own admin panel, its own exports, its own format. Comparing performance across stores? An Excel spreadsheet, manual copy-paste, every Monday.

Goal: one dashboard where everything is visible in one place — in real time, without manual work.

Solution

We built an internal BI dashboard connected directly to the Shoptet API that automatically pulls data from all stores:

Automatic synchronization — the system pulls new orders and invoices from all connected e-shops every hour
Unified overview — revenue, order counts, top products, and key metrics on a single screen
Period comparison — how are we doing this month versus last? This week versus the same week last year?
Shop management — adding a new e-shop takes minutes, just provide Shoptet OAuth credentials
Sync monitoring — overview of running tasks, sync history, application logs

The system runs as two independent processes — a web server for the dashboard and a worker for background synchronization. This allows independent scaling based on demand.

Shop OAuth tokens are encrypted (AES-256-GCM) and dashboard access is protected by authentication with roles (admin / viewer).

Results

Zero manual data collection — everything syncs automatically every hour
Under 3 seconds from opening the dashboard to full overview of all stores
Historical data — backfill capability for trend analysis
Ready for expansion — architecture supports connecting additional e-commerce platforms beyond Shoptet
Two user roles — admin manages shops and settings, viewer sees data only

Share this project

Like this project? Share it with your network.