Projects

Order and Integration Operations Panel

An operations interface that brings marketplace, e-commerce, accounting and shipping connections into one panel: order flow, invoice status, sync health.

PythonFlaskSQLite

Senkora is an operations panel that makes the flow of data between marketplace, e-commerce, accounting and shipping systems observable from a single screen. It shows which stage an order is at, whether its invoice has been issued, and which integration is running healthily — all on the same page, so the team no longer tours panel after panel for a daily check.

Problem

In a business selling across multiple channels, an order is born on Trendyol, product data lives in OpenCart, the invoice is issued on the accounting side, and the shipment goes to a carrier. Because each lives in its own panel, simple questions become laborious: has this order shipped, where is its invoice, how many orders arrived yesterday?

The real risk, though, is silent failure. When an integration stops working, the system does not show an error screen; data simply stops flowing — and that is usually noticed days later, through a customer complaint. There is no single screen that says when and why a sync stopped.

Solution

Senkora reduces every connection to a common “provider” structure: marketplace, store software, accounting and shipping connections all appear in the same interface, in the same status language. Every synchronization enters a queue as a work record, so which job is running, which is waiting, how many completed and how many failed is tracked live on the panel.

This lets the operation answer two questions at a glance: what is the state of the work today and is the system itself healthy?

Key Features

  • Order flow summary: Counts of new orders, pending packages, shipments in transit and deliveries completed — the day’s operation at a glance
  • Document and invoice status: Total invoices, records waiting to be pushed to accounting, the email queue and unmatched documents, each counted separately
  • Provider health cards: Healthy, partial or failing status per integration, the time of the last successful sync, and a one-click re-run
  • Work queue monitoring: Live counters for running, queued, completed and failed jobs, with a jump to the queue screen for detail
  • Channel-level trends: Daily order volume per provider over the last 30 days plus channel distribution, showing which channel produces how much work
  • Modular structure: Operations, marketplaces, stores, accounting, shipping, invoicing and communication channels are managed as separate sections

Technical Foundation

At the center of the panel is a provider abstraction: every external system speaks through a common interface that hides its own API details. Adding a new marketplace or carrier means defining a new provider rather than changing the rest of the panel.

Synchronizations run through a queue instead of directly. That choice buys three things: jobs line up during peak hours instead of locking the system, a failed job can be retried, and because every job’s outcome is recorded, the answer to “when did this last run?” is always available. The panel reads those records to produce provider health and trend charts.

Results

The need to open separate panels for order, invoice and shipment tracking disappeared; the daily check happens on one screen. More importantly, a stalled integration now announces itself: the status and last-sync time on the provider card mean a failure is caught before the customer complaint arrives. Channel-level trend charts make it visible which sales channel produces how much work, putting operational planning on a data footing.