← Blog
Integrations

Your sales channels are not an inventory system

Ivan de Ramon · SEP 22, 2026

We keep seeing the same problem.

A company sells through Shopify, TikTok Shop, a wholesale marketplace, EDI, email, and maybe a few sales reps. QuickBooks sits somewhere in the middle. Each system has part of the truth. None of them has the whole thing.

The result is not complicated to understand. People copy orders from one system into another. They update sold-out products channel by channel. They fix shipping statuses after the goods have already left. Then they maintain an Excel file or a piece of paper because they no longer trust the inventory count.

That is not an integration. It is a queue of manual corrections.

What this looks like in practice

One apparel wholesaler we spoke with runs two ERPs and sells through several wholesale platforms. Those platforms do not talk to the ERPs. When a color sells out, someone has to update every listing manually. One style can have 20 listings on a single marketplace. Shipping confirmations do not reliably flow back, so an order can still appear unshipped after it has left the warehouse.

Another business sells mostly wholesale, with TikTok Shop, Temu, and other online orders routed through Shopify. QuickBooks is supposed to hold inventory, but the count is known to be wrong. The real process is managed on paper.

A third company receives retailer orders through EDI, then enters them again in QuickBooks to create pick tickets. Its master inventory file is Excel because Shopify is missing newer products.

Different industries. Same operating problem.

The problem is not just moving data

Most integration projects start with the wrong question: “Can we connect these APIs?”

Usually, yes. That is the easy part.

The hard questions are:

  • Which system owns the item record?
  • Which inventory number can the sales channels promise?
  • What happens when two channels sell the last unit at the same time?
  • Are bundles deducted as bundles or as their components?
  • Does a shipment update every channel that needs to know?
  • What happens when a write fails halfway through?
  • Who sees the exception and fixes it?

If those decisions are not explicit, connecting more systems can make the situation worse. Bad data moves faster. Nobody knows which number to trust.

One place does not mean replacing everything

You probably do not need to rip out Shopify, QuickBooks, your EDI provider, and every marketplace.

You need one operational layer that knows what each system is responsible for.

That layer should maintain a canonical item record, translate SKUs and variants across channels, collect every order into one queue, calculate inventory that is actually available to promise, and write fulfillment updates back to the systems that need them.

It should also let you reserve inventory by channel. If losing availability on TikTok hurts the account, or a wholesale customer has committed stock, that allocation should be deliberate. The loudest channel should not take everything by accident.

What a useful setup should do

A useful setup is boring when it works:

  1. An order arrives from any channel.
  2. The item and customer are matched to the same records used everywhere else.
  3. Available inventory changes once.
  4. The warehouse sees the order in the same queue as every other order.
  5. Shipment and tracking information flow back automatically.
  6. Failed updates become visible exceptions instead of disappearing.

The point is not to put more dashboards on top of disconnected systems. The point is to stop entering the same order twice and stop finding out about inventory errors after a customer has already bought the item.

Start with the manual work

Do not begin by making a list of every connector you could build.

Start with the work your team repeats every day. Which orders get re-entered? Which inventory count does nobody trust? Which channel is always stale? Which spreadsheet became the real source of truth?

Fix that path first. Then add the next one.

If your operation is held together by Shopify exports, QuickBooks entries, marketplace portals, and an Excel master, show us the workflow. We will tell you directly what can be synchronized and what still needs a human decision.