Integrating an online store with accounting: Horizon, Tildes Jumis and Erply

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

  1. Analysis: which data, in which direction, how often, and which system is the main one;
  2. Data mapping: product codes, VAT rates, units of measure, currencies, customer groups;
  3. Development in a test environment — if the accounting system has one;
  4. Error log and notifications: so that a failed synchronisation does not go unnoticed;
  5. 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.

Sources

  1. Visma: system integration options (Info Day)

Portfolio

Related projects

FAQ

Frequently asked questions

How are integrations priced?

Integrations — for example, with accounting, warehouse or CRM/ERP systems or third-party APIs — are not included in package prices. We assess each integration separately based on the system, the volume of data and the data exchange logic. In the calculator they are marked as “Individual assessment” and are not added to the starting budget.

Can the system be connected to accounting, a warehouse or an online store?

Yes. Integrations are a common part of systems: accounting software, warehouse and logistics systems, payment service providers and third-party APIs. We assess the scope of each integration separately.

Contact

Start a project

Describe your project or question — we will reply and suggest the most suitable solution.

Request about: General request Change

Optional. Names and prices are taken from our price list.

Optional · one file · PDF, JPG or PNG · up to 10 MB

required · Privacy policy

Request a project

Describe your project or question — we will reply and suggest the most suitable solution.

Message us on WhatsApp (opens in a new tab)