What a systems integration actually does

by Travis Hayes, Founder

Ask most business owners what software they'd love to have, and they describe something visible: a better website, a slick app, a dashboard. Almost nobody says "I'd like my systems to talk to each other." Yet in over a decade of building business software, the projects with the best payoff, dollar for dollar, have almost all been integrations.

The problem, in one sentence

Your business runs on several systems, and the thing connecting them is a person with a keyboard.

The website takes orders, the accounting software makes invoices, the inventory lives in the point-of-sale, and the customer list lives in a CRM. None of them were designed to cooperate. So your team does what teams do: they export, they copy, they re-type. Every day.

All that copying costs hours every week, and every re-keyed order is a chance to ship the wrong thing. It also gets worse as you grow: double your orders and you double the typing, which eventually means hiring someone to do work a computer should be doing.

What an integration is

An integration is a small piece of software whose only job is to move information between your systems automatically and correctly.

Order comes in on the website; it appears in your fulfillment system. Invoice gets paid; your accounting software records it. Stock runs low; the count updates everywhere at once. Nobody touched a keyboard.

That's the whole job. A good integration is invisible: things that used to be someone's task happen on their own, on schedule.

When it's worth the money

The math is usually simple. Add up the hours per week your team spends moving data between systems, add something for the errors (a mis-shipped order, a missed invoice, an inventory write-off), and compare it to the one-time cost of connecting the systems.

For some small businesses, that comparison shows a project can recover its cost within a year. The answer depends on the volume of work, the cost of errors, and what the systems allow.

Signs you're ready:

  • Someone's job description includes copying data from one screen to another
  • Your systems disagree about inventory, revenue, or customers
  • Growth plans stall because "the back office can't handle more volume"
  • Month-end reporting involves manually combining exports

What to watch out for

Beware the rip-and-replace pitch. Some vendors answer "my systems don't talk" with "replace all your systems with ours." Occasionally that's right. Usually it's a much bigger, riskier project than connecting what you already own and what your team already knows how to use.

Ask what happens when it breaks. The difference between a good integration and a time bomb is what happens when something goes wrong. Good ones log what they do, retry sensibly, and tell a human when they're stuck. If a developer can't explain their answer to "how will we know if it breaks?", keep looking.

Insist on documentation. An undocumented integration will cost you the day its builder disappears. Whoever builds yours should leave behind a clear description of what connects to what, so any developer can pick it up later.

The short version

If your team is the glue between your systems, you're already paying for an integration. You're paying for it in salary and errors instead of paying once to build it.

If you want help figuring out whether the math works for your systems, tell me what your team is doing by hand.

More articles

Five signs your business has outgrown spreadsheets

Spreadsheets are the right tool until the day they become the most expensive tool you own. Here is how to recognize that day.

Read more

Tell me what is slowing your business down

A short description of the workflow, the systems involved, and the current workaround is enough to start. I'll reply within one business day.

Based in

  • Seattle, WA
    Working remotely with clients
    across the US