5 min read
How to Manage Store and Online Stock in One Place: A Guide for Retailers
How to unify physical store stock with your online store: a single source of truth, POS integration, click and collect, in-store returns and the right platform.
You have a physical store and an online store. A customer buys the last unit on your website, and at almost the same moment a sales assistant sells it at the till. The next day you're calling the online customer to apologize. Or the opposite: an item sitting on the shelf shows as "sold out" online, and you lose the sale.
The most common problem for retailers selling both in store and online is that the two channels don't know about each other's stock. This guide explains how to manage store and online stock in one place, and what to look for when choosing a platform.
Where the problem comes from
In most businesses, the store and the website grow on separate systems. The store has a till and accounting software; the online store is added later with its own stock field, updated by hand or at intervals. The result:
- The same item sells in both channels and an order gets cancelled.
- Items on the shelf show as sold out online.
- When an online return is brought to the store, nobody is sure how it goes back into stock.
- At the end of the day, nobody knows which figure is correct.
The foundation: a single source of truth
The first rule is to keep stock in one place, usually your accounting or ERP system. Both the till and the online store read stock from that source and write every sale back to it.
So when an item sells in the store, online stock drops too; when an online order arrives, the store can see that the item has been reserved.
Connecting the store till
The till is the most critical piece. Store sales need to reach the stock source without waiting for end-of-day. That requires your POS software to integrate with your accounting or ERP system, record sales by barcode, and update stock instantly or at short intervals.
Sales rung up without scanning a barcode are the most common cause of stock discrepancies. Barcoding every product and scanning it at the till is a prerequisite for unified stock.
What stock should the website show?
Not every unit in the store is suitable for online sale. Display items, damaged goods and items reserved in store shouldn't appear as sellable online. That's why two figures are usually kept separately:
- Physical stock: what's actually in the store and warehouse.
- Sellable stock: the part of it available for online sale.
It also helps to keep a small buffer for items that might be sold while a customer is holding them in store. Showing an item as sold out online when only two units remain in store, for example, reduces the risk of selling it twice.
Multiple stores and warehouses
With several stores, each store's stock should be kept as a separate location. When an online order arrives, rules decide where it ships from: the store nearest the customer, the location with the most stock, or only the central warehouse. These rules directly affect delivery time and shipping cost.
Click and collect, and in-store returns
Unified stock lets you offer customers two valuable options.
Buy online, pick up in store
The customer orders online and collects from a nearby store. For this to work, the website must see each store's stock separately, and the item must be reserved in the store when the order arrives. When the store team prepares the order, the customer is notified.
Buy online, return in store
Being able to return online purchases in store is a strong reassurance for customers. But the system must clearly record which order the return belongs to, whether the item can be resold, and which location's stock it goes into. Otherwise the returned item shows up neither in store nor online.
Stock counts and discrepancies
With unified stock, counts matter even more, because a wrong figure now affects two channels. Regular counts, cycle counts for fast-moving items, and recording the reasons for discrepancies are essential. Corrections after a count should go straight into the single stock source.
What to look for in a platform
If you want to unify store and online stock, ask these questions when choosing an e-commerce platform:
- Does it integrate with my POS and accounting software?
- Can it keep multiple stores and warehouses as separate locations?
- Can it separate physical stock from sellable stock?
- Does it support click and collect and in-store returns?
- Are stock updates real time or at intervals?
- If I also sell on marketplaces, can they connect to the same stock source?
Some hosted e-commerce platforms offer these features as modules. If your POS and accounting setup is non-standard, you manage several stores and warehouses, or you need deep ERP integration, a custom integration or software usually works better.
Frequently asked questions
Do I need a new POS system to unify store and online stock?
Not always. If your current POS software integrates with your accounting or ERP system, connecting the website to the same source may be enough. If your POS can't exchange data with external systems, a change may be needed.
How often should stock be updated?
As often as possible, ideally in real time. For fast-selling, low-stock items, even a few minutes' delay can lead to the same item selling in two channels.
Can marketplaces connect to the same system?
Yes. Your store, website and marketplaces can all be fed from the same stock source, keeping stock accurate everywhere whichever channel makes the sale.
What do I need for click and collect?
The website must see each store's stock separately, reserve the item in store when an order arrives, and let the store team notify the customer when the order is ready.
Conclusion
Selling in store and online works best when both channels run from a single stock source: what customers see online is really available, they can collect in store and return in store. The foundations are a single source of truth, a connected till, clearly defined sellable stock and regular counts. If you also sell on marketplaces, see our guide to marketplace inventory sync. Let's review your current setup and find the right way to manage store and online stock in one place.