Retail Solutions

Stock Synchronization Engine

A resilient sync layer that keeps branch POS databases aligned with cloud inventory — bridging SQL Server and PostgreSQL.

Challenge

Stale branch stock

On-premise POS databases and cloud dashboards drifted apart. Manual exports meant wrong allocations and overnight surprises.

Solution

Scheduled sync service

A Windows service reads incremental changes from SQL Server, transforms payloads, and posts them through a REST API into PostgreSQL with retries and idempotent keys.

Outcome

Near real-time alignment

Branch sales and stock levels appear in cloud dashboards without spreadsheet consolidation — even after brief outages.

Architecture

One-way and configurable sync paths between retail POS databases and cloud reporting stores.

Branch POS (SQL Server)
Windows Sync Service
REST Ingestion API
PostgreSQL (Cloud)
Dashboards & Allocation Rules

Interface overview

Replace frames with screenshots in assets/images/projects/stock-sync-*.png.

Sync service status — last run, queued batches, failures
Service monitoring
Cloud stock view after successful sync cycle
PostgreSQL-backed inventory view

Tech stack & highlights

C# Windows Service, SQL Server, PostgreSQL, REST API, retry queues.

← Retail Solutions