E-commerce
Shop and ERP synchronisation
Orders, stock and prices are synchronised between the online shop and the ERP with events and checks.
Fictional scenario. An example situation that illustrates the approach. It is not a client project and describes no measured results.
Business problem
A fictional shop keeps stock in the ERP and orders in the platform. Manual synchronisation leads to selling items that are out of stock.
Assumptions
- The platform has webhooks and an API.
- The ERP is the master system for stock and prices.
- There is a test shop.
Constraints
- No duplicate orders.
- The ERP stays the system of record.
- Synchronisation is idempotent.
Reference architecture
Components by stage — an illustration, not a running system and not a certified design.
01Events
- Shop webhooks
- ERP changes
02Integration
- Queue
- Idempotent processing
03Rules
- Item mapping
- Stock checks
04Targets
- Orders in the ERP
- Stock and prices in the shop
The diagram as a list
| Stage | Components |
|---|---|
| Events | Shop webhooks, ERP changes |
| Integration | Queue, Idempotent processing |
| Rules | Item mapping, Stock checks |
| Targets | Orders in the ERP, Stock and prices in the shop |
Interfaces
| From | To | Via |
|---|---|---|
| Shop | Queue | Signed webhook |
| Processor | ERP | REST API |
| ERP | Shop | Stock API |
Data flow
- A new order sends a signed webhook.
- The processor verifies the signature and idempotency.
- The order enters the ERP once.
- Stock changes are published back.
- Mismatches are reported.
Security boundaries
- Every webhook signature is verified.
- Separate keys for reading and writing.
- No payment data in the integration.
Where a person approves
- Bulk price changes.
- New mapping rules.
Delivery phases
01 · Discovery
Flows, master systems, volumes.
02 · Pilot
Read-only stock.
03 · Integration
Orders and prices.
04 · Operation
Queue and mismatch monitoring.
Limitations
- Depends on API limits.
- Complex variants need a clear mapping.
Trade-offs
- Events vs periodic sync.
- ERP as the master system: slower price changes.
Related services
Related assessments
Integration patterns used
Workshops and assessments
Facing something similar?
We start with an assessment of where you are and propose a realistic first phase.