Selling Online and In-Store? How to Keep One Reliable View of Your Stock
A retailer can sell the last item at the counter just as an online customer places an order for it. This is not only a technology problem — it is a question of how stock movements are recorded.
If the website and shop use separate stock records, the business may have to cancel an order, make an awkward substitution or rush to find replacement stock. The fix depends on which system staff treat as authoritative.
Map every stock movement
List how stock enters and leaves the business, and agree when each movement should be recorded.
- Supplier deliveries
- Walk-in purchases
- Online orders
- Returns
- Damaged items
- Branch transfers
- Reserved items
Choose a source of truth
Decide which record owns the available quantity. That might be a properly configured retail system, an inventory module or the e-commerce platform, depending on the current setup.
Two independent “master” spreadsheets that both claim to be current — and disagree.
One system owns availability. If synchronisation is manual, name who reconciles it and how often.
Separate physical, available and reserved stock
The number on a shelf may differ from what can be sold immediately. Items can be damaged, awaiting inspection, allocated to an order or held for a customer.
Sellable quantity is not the same as physical quantity
A buffer may be sensible for low-count or fast-moving items, but it should be based on observed risk rather than an arbitrary rule applied to everything.
Plan for exceptions
Decide what happens when a payment succeeds but the inventory update fails, a customer returns an item, staff count a discrepancy or a branch transfer is delayed. Keep a traceable record of adjustments and who approved them.
Start with a controlled pilot
Choose a manageable group of products, reconcile their current quantities, run test orders and compare records at the end of each day. Track stock-related cancellations and manual corrections. Expand only when the workflow is reliable enough for staff to maintain.
Reconcile regularly rather than only when something goes wrong
A cycle-count schedule can compare a manageable subset of products with the recorded quantity. Choose high-turnover or high-risk items more frequently, and investigate differences before making adjustments.
Define how returns re-enter stock
A returned item may be saleable, damaged, awaiting inspection or destined for a supplier. It should not automatically increase available stock before its condition is known. Agree who can inspect the return, which status is recorded and when the quantity becomes available for online sale.
Plan for temporary system outages
If the website or inventory connection becomes unavailable, staff need a controlled fallback that prevents duplicate sales and captures transactions for later reconciliation. The fallback should identify who may activate it, how availability is limited and how offline changes are entered afterward.
Monitor the integration as an operational process
Assign someone to review failed updates, unusual quantity changes and unresolved differences. Establish what is considered normal delay and when a failure needs escalation. A connection that works during a demonstration can still fail under real operating conditions, so include monitoring and support ownership in the rollout plan.
Pilot a joined-up stock process
Choose a small group of products that sell through both the physical shop and online. Record the opening quantity and define how sales, reservations, returns, damaged items and transfers affect availability.
Decide which system is authoritative and test typical events plus exceptions: two orders for the last unit, a cancelled order, a returned item and a delayed update. Reconcile the physical and recorded quantities daily during the pilot.
Assign someone to review failed updates and unexplained stock adjustments. Only expand the catalogue after staff can follow the process consistently. Record the fallback procedure for system outages and the method for reconciling any offline transactions once service is restored.
A shop has five units in the back room. Two are reserved for confirmed online orders and one is damaged.
The sellable quantity is not five. The exact handling rules should match the business's products and service promises.
Frequently asked questions
Can I keep using a spreadsheet?
A controlled spreadsheet may suit a small catalogue, but it needs a clear owner, update rules and reconciliation routine.
Should online availability always equal physical stock?
Not necessarily. Reserved, damaged or buffer quantities may need to be excluded from sellable availability.
Action checklist
- All stock movements have a defined recording point.
- One system is authoritative for available quantities.
- Reserved, damaged and returned items are handled consistently.
- Exception procedures and adjustment logs exist.
- A small pilot is reconciled before full rollout.
Final thought
Online and in-store selling can coexist, but only if the business agrees what “available” means and keeps movements visible. Review your current workflow before selecting more software.
Selling online and in-store?
Stonehenge Digital KE's E-Commerce Website with M-Pesa service includes inventory-related capabilities that may be relevant to the discussion.
Explore the E-Commerce Website with M-Pesa Service →Interested in E-Commerce Website with M-Pesa?
Let's build this for your business
Sell to any Kenyan with a phone. Full online shop with Safaricom STK Push payment — no card needed.