Inventory automation

Inventory automation for multi-location businesses

CIG SaaS · September 8, 2026

A single shop can run on a spreadsheet and a good memory. The moment there are two, the spreadsheet stops being the source of truth and becomes one of several competing versions of it.

Most multi-location operators do not have an inventory problem so much as an inventory reconciliation problem. Each site is usually fine on its own. What breaks is the picture across all of them: the number head office needs to reorder, price, and plan against.

The four places accuracy leaks

1. Separate counts, separate formats. Each location counts on whatever schedule it has time for, into its own sheet, in its own naming. Someone types the results in later. By the time all sites are in, the earliest count is a week old.
2. Channels hold their own numbers. The POS at each shop, the online store, and the accounting package each track stock independently. Nothing forces them to agree, so they drift.
3. Movement is recorded late. Receiving, returns, transfers between sites, and waste get logged hours or days after they happen, or in a note nobody reconciles against.
4. SKUs do not match. The same product is named three ways across three systems. Even when every number is individually correct, they will not line up in a report.

What an automation project actually does

The goal is not "an app". It is one system that owns the stock number, with every other system either reading from it or writing to it through a defined path instead of a copy-paste.

• One source of truth, per location, rolled up. Each site keeps its own live number; head office sees the sum and the breakdown in one view.
• Automated sync. Stock moves between POS, e-commerce and back office on your rules, with a log you can audit, so the online store never sells what a shop already sold.
• Reconciliation that flags, not hunts. A scheduled job compares expected against counted and surfaces the discrepancies for a person to review. Nobody scrolls a transaction list from memory.
• SKU consistency. One catalogue, with mappings that absorb the names your existing systems already use.
• Reorder signals from real movement, sent where your team already works.

When it is worth building, and when it is not

Automation is worth the build when the manual reconciliation is a recurring job someone dreads, when stock genuinely lives in more than one system, or when a wrong number regularly costs a sale or forces a write-off. If none of that is true yet, a shared spreadsheet with discipline is cheaper and we will say so.

An multi-location inventory system is the specific shape of this for operators running several sites; inventory automation covers the single-site version. Both connect the tools you keep rather than replacing them.

We have built inventory systems for multi-location retail running on Odoo and Shopify. Client names and any figures are shared only with permission, and we do not publish result percentages we cannot show you.