New: Build your own online store with our course. R995 until 31 December 2026. See the course →
Strategy · Integrations·November 2026·5 min read

Stock in two places: how to keep your store and warehouse in sync

Selling something you do not have is one of the fastest ways to lose a customer. It usually happens because stock lives in two places: your online store and your warehouse or accounting system. Here is how to keep them in line.

Pick one source of truth

Decide which system holds the “real” stock number. For most businesses that is the accounting system, ERP or warehouse system, not the website. Everything else reads from it.

How often should stock sync?

  • Near real time: best for fast-moving stock and busy stores.
  • Every 15 to 60 minutes: fine for most businesses.
  • Once a day: only if stock changes slowly and you keep a buffer.

Use a safety buffer

If stock syncs every hour, keep a small buffer. For example, show an item as sold out when two are left. It protects you between syncs.

Common causes of stock errors

  • Product codes that do not match between systems.
  • Several warehouses added together when they should be shown separately.
  • Sales on other channels, such as a marketplace or your shop counter, that never reach the website.
  • Returns that go back on the shelf but not into the system.

Selling on more than one channel

If you also sell on a marketplace or in a physical shop, every channel must take stock from the same source. Otherwise two customers can buy the last item at the same time.

Where to start

  1. List every place you sell and every place stock is counted.
  2. Match product codes across all of them.
  3. Pick your source of truth.
  4. Choose a sync method that fits your volume.

For trade customers, stock visibility is also a key portal feature. See what a B2B trade portal needs. For integration projects, see enterprise ecommerce development.

Tired of selling stock you do not have?
I connect stores to accounting, ERP and warehouse systems. Fixed price, in writing.

Get a project quote →

Louw van Riet
Written by
Louw van Riet
Founder, eCommerce Development SA · eCommerce, payments and AI

Louw is the founder of eCommerce Development SA, the Shopify Certified Partner agency ranked number one for ecommerce development in South Africa, with 400+ online stores built since 2011. He works where ecommerce, payments and AI meet: checkout, conversion, platform choice and growth. He writes here to share the practical playbook he uses with clients every day.