E-commerce Stock and Accounting Sync

The Problem

A UK online retailer doing low seven-figure revenue had hit the wall that most growing e-commerce businesses hit somewhere between fifty and two hundred orders a day. Shopify held the orders. The warehouse used a separate inventory management tool that an operations staff member updated by hand. Xero held the accounts, and the bookkeeper re-keyed daily Shopify totals into journal entries every morning. Each of the three systems thought it was the source of truth for something, and none of them agreed.

The visible symptoms were oversells and accounting drift. A bestselling SKU would show six units in Shopify when the warehouse had already shipped the last one. A customer would then place an order the business could not fulfil, generating a refund, an apology, and a small reputational hit. On the finance side, the bookkeeper’s manual journals matched Shopify’s daily summary but did not reconcile to the bank, because Shopify’s totals included gift card redemptions and refunds that the manual process classified inconsistently.

The team had tried off-the-shelf connectors. Each handled one pairing (Shopify to Xero, or warehouse to Shopify) but none handled all three together, and the gaps between the connectors were where most of the errors lived.

The Approach

We built a sync layer that sits in the middle of the three systems and treats each as a feed rather than a source of truth in isolation. Orders flow from Shopify into the sync layer, which deducts stock against the warehouse system and writes the financial movement into Xero with the correct mapping for tax, shipping, refunds, and gift cards. Stock adjustments made in the warehouse system push back to Shopify within minutes, so the storefront reflects real availability.

The non-obvious work was in the edge cases. Refunds had to reverse stock and accounting consistently. Partial shipments had to defer revenue recognition. Pre-orders had to allow oversell deliberately while flagging the position to the warehouse. Each of these was a quiet rule in the bookkeeper’s head before the sync existed; making them explicit forced some sensible cleanup of how the business actually wanted to handle each case.

The System We Built

A sync layer running on a small server with API connections to Shopify, the warehouse inventory system, and Xero. Orders, refunds, stock movements, and journal entries flow through a queue with retry logic and a reconciliation dashboard that surfaces any item that fails to sync within fifteen minutes. The mapping rules for tax, gift cards, refunds, and shipping are configurable rather than hardcoded. A daily reconciliation report compares Shopify revenue, warehouse stock movements, and Xero journal entries and flags any discrepancy for human review.

The Outcome

Oversells stopped within the first week of go-live. The bookkeeper’s morning Xero re-keying disappeared entirely. The journals now post automatically with correct mapping, and reconciliation against the bank takes a fraction of the time it used to. The reconciliation dashboard catches the rare sync failure within minutes rather than the team discovering the discrepancy at month-end, which is when it would previously have surfaced.

A secondary effect: the operations team now trusts Shopify’s stock numbers, which means they make stocking and reordering decisions from the storefront view rather than running parallel queries against the warehouse system. The mental overhead of maintaining two pictures of reality has gone.

What We Learned

The temptation on a project like this is to pick one system as the master and force the others to follow. We deliberately kept each system authoritative for its own domain: Shopify for orders, warehouse for stock, Xero for accounts, with the sync layer mediating between them. This kept the existing user habits intact and avoided the political problem of telling the warehouse team that their system was now downstream of marketing’s.

Same Problem at Your Scale?

If your e-commerce business is growing past the point where manual reconciliation between Shopify, your warehouse, and your accounts is reliable, get in touch to discuss what a custom sync layer would look like. The finance back-office modernisation and multi-location finance reporting dashboard case studies cover related integration and reconciliation work. Our data sync system page covers what we built here. The case studies overview has the full list.