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
- List every place you sell and every place stock is counted.
- Match product codes across all of them.
- Pick your source of truth.
- 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.
We have built 400+ online stores for South African businesses since 2014. Read more about B2B eCommerce development in South Africa.





