Selling Online and In-Store? How to Keep One Reliable View of Your Stock

c
ceofounder
13 min read 34 views
Selling Online and In-Store? How to Keep One Reliable View of Your Stock
Inventory & Stock Control

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
If online orders are not deducted or reserved until a staff member manually reviews them, the website may continue advertising stock that is no longer available.

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 masters

Two independent “master” spreadsheets that both claim to be current — and disagree.

✓ One authority

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.

The stock equation

Sellable quantity is not the same as physical quantity

5Physical
−
2Reserved
−
1Unsellable
=
2Sellable

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.

The purpose is to discover where stock movement is not being captured — such as sales, damage or returns — not simply to force the screen to match the shelf.

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.

The same principle applies to cancelled orders where stock was previously reserved.

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.

Avoid keeping an informal second stock list indefinitely — define when the normal source of truth resumes.

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

1

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.

2

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.

3

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.

Illustrative scenario

A shop has five units in the back room. Two are reserved for confirmed online orders and one is damaged.

5 physical − 2 reserved − 1 damaged = 2 sellable

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 →
Share Written by ceofounder

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.

Leave a Comment

Share Your Thoughts