How to connect a shop
to an ERP system?
Two-way data exchange: real-time stock levels and automatic flow of orders and sales documents.
An online shop and an ERP system are the two hearts of a trading company. One sells, the other looks after goods, documents and money. As long as they don't talk to each other, someone in the company plays the role of a “human API” and retypes data by hand.
What exactly do we sync?
Before the first line of code is written, we agree which data flows in which direction and which system is its source of truth.
From the ERP to the shop: products, prices, stock levels, order statuses and tracking numbers.
From the shop to the ERP: orders, customer data, payments and returns.
Both ways: customers and their history, if you also use a CRM.
Real-time stock levels
This is the most common source of problems. If the shop updates stock once a day, it sells goods that a customer bought in the store that morning.
The solution is event-driven sync: every stock change in the ERP reaches the shop immediately, and every order in the shop reserves the goods at once. For large catalogues we combine it with a periodic full sync that catches any discrepancies.
Automatic flow of orders and documents
An order placed in the shop should go through the whole process on its own: reservation in the warehouse, issuing the sales document, booking the shipment and notifying the customer.
In practice this means the warehouse worker sees a ready picking order, accounting gets the document without retyping, and the customer receives an email with the tracking number without anyone lifting a finger.
What if something goes wrong?
The integration has to be resilient to failures. If the ERP is briefly unavailable, the order must not get lost. Well-designed data exchange retries failed attempts, logs errors and notifies the person responsible for the system.
Where to start?
List the systems you use and check whether they provide an API.
Point out which data you retype by hand today and how much time it takes.
Decide which system is the source of truth for products, prices and stock.
Start with the most painful flow, usually orders and stock.
If you like, we'll go through these steps together in the first conversation.
