COMMERCE AND MANAGEMENT

Connecting your online shop to your invoicing without re-entering the orders

Between the customer's basket and the accounting entry, fields nobody has modelled are always missing.

An online shop produces orders, management software produces invoices and entries. The gap plays out on VAT, shipping costs, deposits, credit notes and available quantities. This page establishes what a ready-made connector really takes over, what it leaves to the client, and why the absence of a webhook changes the way a synchronisation is designed.

A shop order and a Swiss invoice do not carry the same fields

An order recorded in WooCommerce, Shopify or PrestaShop describes a basket, a delivery address, a shipping method and a payment collected or pending. A Swiss invoice demands something else: an identified debtor, lines attached to an account and to a VAT code, a structured payment reference and, in most cases, a compliant QR section. The two objects look alike on screen and diverge in the detail. It is in that gap that Monday morning's re-entries take up residence.

Three flows actually circulate, and they share neither the same rhythm nor the same direction. The first comes down from the shop to the management software, carrying the orders and the customers. The second goes up from the software to the shop, carrying the items, the prices and the available quantities. The third links collection to the accounts, through the bank account, through the payment provider, or through both. A chain that handles only the first flow leaves the catalogue, the quantities and the collection to be done by hand.

Before any technique, a management decision is unavoidable: knowing where the reference for each piece of data lives. Is the catalogue kept in the shop or in the software, does the selling price prevail on the commerce side or on the management side, does the customer number come from the site or from the existing database. As long as that question stays open, two systems write the same data and nobody knows which one is right on the day they differ.

What a ready-made connector really takes over, and what stays on the quay

Several vendors publish shop connectors. Abacus announces Shopify, WooCommerce through pingWoo, Magento and PepperShop. SelectLine announces Shopware, Shopify and Venabo. WinBIZ publishes a WooCommerce connector, a PrestaShop order link and a Sempio connector. Infoniqa lists a directory of 175 third-party links, 159 of them declared compatible with ONE 50. Odoo occupies a different position, shop and management living in the same system, which shifts the question from the interface to the functional scope.

What these connectors cover is real and useful: taking over the orders, creating or updating the customer, creating a commercial document, often reporting the quantities back. What they rarely cover sits in the details that make up the exact turnover. The generic connector handles the nominal case, a simple order, paid, delivered in one go. It is the orders that depart from that nominal case which take up time every week.

WHAT YOU MUST PAY OR BE TO OPEN THE APICHF 15.- API included from the STARTER planWHAT YOU MUST PAY OR BE TO OPEN THEAPICHF 15.-API included from the STARTER plan

VENDOR PAGES AND API DOCUMENTATION, READ ON 23.08.2026

Before signing, the connector's data sheet must therefore be read line by line and every field set against your orders of the last twelve months. A connector that takes over the bulk of the orders without intervention still leaves a daily queue of special cases, and that queue costs more in attention than in minutes.

  • Item variants, size, colour, packaging, and their correspondence with a unique item code
  • Line-level discounts, vouchers and prices by customer group
  • Shipping and handling costs, with their own VAT rate
  • Deposits, partial payments and renewed subscriptions
  • Returns, credit notes and partial refunds from the payment provider
  • Orders in several currencies and exchange costs

Shipping costs, deposits and returns make the total diverge before the accounts

VAT is the first point of friction. The rates in force since 1 January 2024 are 8,1 % for the standard rate, 2,6 % for the reduced rate and 3,8 % for accommodation, and Swiss vendors document how they handle them, WinBIZ for instance on the official forms of the Federal Tax Administration. The question is not there. It is knowing what rate the shop applies to shipping costs, how it treats an order outside Switzerland, and whether displayed prices are entered inclusive of VAT on one side and exclusive on the other.

The second point of friction is collection. A payment provider rarely pays over the amount of the order; it pays a net balance, in batches, after deducting its commissions and the period's refunds. The accounts expect the opposite: an invoice, a receipt, a fee entry. Without a reconciliation rule established in advance, the bank account and the general ledger drift apart a little every week, and the closing is left to work out why.

The third point is the goods return. A refunded customer produces three distinct events: a stock movement, a credit note, and a financial refund. A shop manages that in its own vocabulary, management software in its own. Deciding how one translates into the other is design work, and that work is done once, calmly, rather than case by case.

Two stocks for a single item, and the question of which one prevails

An SME that sells in a shop and online holds two counters for the same item. The problem is not making them equal at a given instant, it is defining who describes the truth between two synchronisations and what happens when both fall at once. The answer depends on your trade, on the preparation lead time, on volume, and on whether an occasional stock-out is acceptable.

The software's scope counts more here than the connector. At bexio, the management of batches, serial numbers and several warehouses is not documented in the vendor's help on the day of reading, and the product import is reported as capped at 15'000 lines. SelectLine announces production and commercial management, Infoniqa ONE 200 logistics and controlling, Odoo stock and production in the same system. SelectLine is deployed on a Windows server with Microsoft SQL Server, the Infoniqa suites are installed at the client's, and implementing Odoo generally goes through a partner. Choosing stock depth is a decision that comes before the choice of connector, not after.

Finally, reservation deserves to be set down in black and white. Should a quantity leave the available stock at the moment of the order, of the payment, or of the shipment. The choice bears directly on the number of orders you will not be able to honour, and it is written the same way in both systems, failing which it means nothing.

Without a webhook, synchronisation becomes a matter of frequency

A webhook is a call the vendor sends to your system at the moment something changes. Without it, the only route left is periodic polling: your program regularly asks what has moved. bexio's public documentation read on 23 August 2026 contains no webhooks section, smallinvoice's exposes no callback path, and searching for the term in WinBIZ's help centre returns nothing. Odoo announces webhooks, and AbaNinja announces them from its Basic plan.

Periodic polling is not a stopgap, it is an architecture that has to be sized. You have to choose a frequency, hold to the pagination the vendor imposes, up to 500 items per request at bexio, a means of spotting what has changed, a memory of what has already been handled, and a course of action when a call fails. KLARA's documentation states that a rate limit exists, with a 429 response, without publishing either the threshold or the window, which makes theoretical calculation impossible and forces a measurement.

THE WEBHOOK, WHO DOCUMENTS ITAnnounced webhooks announced by the vendorTHE WEBHOOK, WHO DOCUMENTS ITAnnouncedwebhooks announced by the vendor

PUBLIC API DOCUMENTATION, READ ON 23.08.2026

One last detail weighs heavily in operations. KLARA's documentation also states that there is no separate test environment and that every call works on production data. That changes the way one builds: you write reads first, you log, you replay dry, and only then do you write.

What we establish before writing the first line of code

We sell no licences. We therefore start from your real orders, not from the connector's data sheet. A sample of the orders of the last twelve months shows the share of simple baskets, that of orders with unusual shipping costs, that of returns and that of the cases nobody had mentioned. That count steers the rest: it says whether a standard connector is enough, whether it must be supplemented, or whether it is better to write directly against the API.

We then check the technical access conditions, in the vendor's documentation read on 23 August 2026 and not in its brochure. SelectLine's API is included from the Premium edition and assumes the installation of the Mobile Manager and the Toolbox. Odoo Online's is open only on the Custom plan. At WinBIZ, the documentation states that the API key is obtained by being a partner under the general partnership terms. At Crésus, exchanges go through import and export templates in text and in CSV.

Then we write the acceptance test before the mechanics. A test order with a variant, one with shipping costs, one with a deposit, one with a partial return, one outside Switzerland, each with the result expected in the management software and in the accounts. On the day the chain runs, that test set becomes the check you relaunch after every update of the shop or of the software, and it belongs to you.

Where these answers come from

Every fact on this page can be checked at the source. The links open directly the website of the vendor or body concerned.

SURVEY OF 23.08.2026

Frequently asked questions

Can WooCommerce be connected to bexio?

Through bexio's public REST API, yes: OAuth 2.0 or a personal access token allow a bespoke link to be written. bexio's Marketplace moreover announces more than a hundred applications, whose exact content is to be checked on the day of the decision, no WooCommerce bridge being named in the sources we read. The documentation read on 23 August 2026 describes no webhook, which means the link polls bexio at regular intervals rather than being notified.

How do you invoice Shopify orders in Switzerland?

The order comes down into your management software, which produces the invoice with the VAT code, the structured reference and the QR section. Two elements deserve to be settled early. The setting of the QR-bill first: KLARA documents it for instance in three variants, without QR, with a Creditor reference, or QR-IBAN with a QRR reference, and the choice binds your payment references. Then the matching: bexio generates the QR-bill natively with automatic reconciliation of payments, which does not exempt you from deciding how the payment provider's net transfer is spread across your invoices.

How do you synchronise the shop's stock and the online shop's?

By first checking that your software handles the depth you need, batches, serial numbers, multiple warehouses, because no connector creates a function the software lacks. The question of which system prevails and of the moment a quantity leaves available stock is dealt with higher up on this page. Then comes the mechanics: a periodic reporting of quantities from the software to the shop and a descent of the sales movements.

Should you buy a connector or go through the API?

The count of your real orders decides. If nearly all your baskets are simple and the connector covers your fields, it costs less than a development. If your variants, your deposits or your returns fall outside the nominal case, the connector will leave a daily queue of manual reworking. Look also at the cost of API access, which varies by edition or subscription plan and can shift the budget.

My software has no documented webhooks, is that blocking?

No, but it changes the architecture. Without an outbound notification, the link polls the software at regular intervals and compares with what it has already handled. A frequency must then be set, the pagination imposed by the vendor respected, and the course of action on failure provided for. The exact values, pagination and rate limit, are to be taken from the documentation of the software chosen.

What becomes of a refunded order in the accounts?

The rule of correspondence between the shop's vocabulary and the management software's is decided once, written into the link and checked by a test set containing at least one partial refund. The point most often forgotten is the link between the credit note and the payment provider's net transfer, which arrives in batches and not order by order.

Is the QR-bill still useful if the order is already paid online?

The invoice document stays useful even when there is nothing left to collect, and most Swiss programs produce it with its payment section. What counts then is the matching: the invoice must be marked as settled by the collection flow and not by a manual entry, failing which your debtors show receivables already collected.

How long does a link of this kind take?

We announce no deadline before having counted your real orders and read your software's access conditions, because both vary widely. What we do announce is the order of the stages: counting the cases, checking technical access, writing the test set with the expected results, then building. A figure given before that reading would be an estimate, comfortable to announce and hard to hold to.

Have your orders counted before choosing a connector

Send us an export of your orders of the last twelve months and the name of your management software. We count your cases, we set each one against the fields announced by the connector's data sheet, we list those that will stay manual, and we give you that finding back at a free diagnostic, with no commitment.