Connecting WooCommerce to bexio: without manual retyping

WooCommerce and bexio can be connected through the bexio interface, so that every order from the shop automatically lands as an invoice in the accounting, without anyone typing the data in a second time. Today, the shop and the accounting are two separate worlds in many businesses, and the same thing always happens: an order comes into the shop, and then someone types the same data into bexio again. Customer name, articles, prices, VAT. That costs time, and with every retyping a mistake eventually slips in.

Here I explain what it concretely means to connect a WooCommerce shop to bexio: what runs automatically, what deliberately stays manual, and from what point the effort is worth it at all.

What “connecting” concretely means

bexio has an open interface (API). Through it, the shop can be connected so that the data flows in one direction, without anyone capturing it twice. Usually that covers these points:

• The order becomes an invoice. As soon as an order comes into the shop, the matching document is created in bexio automatically, with the right line items and the correct Swiss VAT.
• Customers land in the contact records. New buyers are created as a contact in bexio, existing ones are recognized, instead of generating a duplicate for every purchase.
• Articles and stock. Depending on the setup, the range is mirrored from bexio into the shop, or the stock is kept in sync between the two.
• Payment status. A paid order can be marked as settled in bexio, so the list of open items is correct.

What matters is the direction: the shop is the sales front, and for the accounting, bexio is authoritative. You decide once which system leads on which field, and stick to it. Otherwise the two overwrite each other.

How it works technically

In most cases, a connecting piece (a connector) handles the translation between WooCommerce and the bexio API. It listens for new orders, maps the articles to the right bexio line items and accounts, and creates the document. For standard ranges there are ready-made solutions for this, for specific requirements I build the integration directly through the API.

The biggest part of the work is not in the connecting itself, but in the clean mapping: which shop article corresponds to which bexio product, which VAT applies, which account each thing runs to, how shipping costs and discounts are booked. Once this underlying order is right, the rest runs in the background.

From practice: Sanigroup

At Sanigroup, it was about a range of over 6,000 articles that previously sat in a maintenance-heavy legacy system. The task was to bring the shop and the accounting together so that the team does not have to work in two programs for every order.

The effect is always the same, whether it is 60 or 6,000 articles: what was retyped before now happens automatically, and the figures in the accounting match what was sold in the shop. That does not just save time, it also removes the source of errors that comes with double entry.

When it pays off, and when it does not

Let me be honest: not every shop needs this. An integration costs time, and therefore money, to set up. It pays off when orders come in regularly and manual entry noticeably eats up hours.

With a handful of orders a month, the honest answer is: enter it by hand. The effort for an automatic integration does not pay off at that volume. It becomes worthwhile from the point where the retyping turns into a tedious routine, or where errors show up in the accounting because the work is done under time pressure.

What you need for it

• A WooCommerce shop (or the plan to build one).
• A bexio account with API access activated.
• A clear idea of what should run in sync: just invoices, or articles and stock as well.

The rest, meaning the mapping of the accounts, the VAT logic, and setting up the connection, I take care of. If you already have a shop, I first look at how your range and your bexio setup look, and tell you honestly whether and how an integration is worth it.

More on the topic of shop and accounting from a single source is on the WooCommerce and bexio page. If you are seriously thinking about it, write to me briefly about what you work with today, and we can work out right away whether the step pays off for you.