In short: integrating an online store with an accounting or ERP system means that products, prices, stock levels and orders move between the systems automatically, rather than being retyped by hand. The most important decision is not the technology, but which system is the “source of truth” for each type of data. Visma Horizon, Tildes Jumis and Erply can use an API for this exchange.
Why do it at all
While there are few orders, they can be entered into the accounting system by hand. Problems start when orders increase: stock levels in the store do not match the warehouse, typing errors appear in invoices, and someone spends an hour every day moving data from one system to another. Integration removes this work and at the same time reduces the number of errors.
What is usually synchronised
- Products and prices — from accounting or the ERP to the store, including customer group prices in B2B stores;
- Stock levels — so that the store does not sell what is not in the warehouse;
- Orders — from the store to accounting, with the buyer’s details, VAT and delivery;
- Invoices and payment statuses — back to the store, so that the customer sees the current status;
- Customers — especially B2B, where the customer has contract prices and a credit limit.
The “source of truth” — the most important decision
For each type of data, one main system has to be designated. For example: prices and stock levels live in the ERP, while product descriptions and images live in the store. If this is not decided at the start, the two systems start overwriting each other, and the result is worse than without integration.
Horizon, Tildes Jumis and Erply — what it looks like in practice
Visma Horizon
Horizon has a REST API through which products, stock levels, orders and classifiers can be retrieved and sent. The integration is usually a separate connection that exchanges data on a schedule or on an event (for example, a new order) and logs every successful and unsuccessful attempt.
Tildes Jumis
We integrated Tildes Jumis via the API: all invoices that come into the system are automatically passed to the accountant in Tildes Jumis. They no longer have to be forwarded by email or entered by hand, and nothing gets lost in the accounts.
Erply
Erply is a cloud-based warehouse and point-of-sale system with an API. In our Hannu-pro project, the WooCommerce store synchronises stock and customers with Erply, so the stock levels online and in the physical shop match.
How an integration project works
- Analysis: which data, in which direction, how often, and which system is the main one;
- Data mapping: product codes, VAT rates, units of measure, currencies, customer groups;
- Development in a test environment — if the accounting system has one;
- Error log and notifications: so that a failed synchronisation does not go unnoticed;
- Launch and monitoring in the first weeks.
The price of an integration depends on the system, the data volume and the directions, so we estimate it individually. More on this on the page Systems development: CRM, ERP and integrations.
