How to Manage Inventory for a Retail Store with Physical and Online Sales

The fastest way to lose customer trust is simple: accept payment for an item you no longer have. Nigerian shoppers talk — one viral complaint about "they collected my money and said it is out of stock" can undo months of goodwill.

If you sell in person and online, inventory is not a back-office chore. It is the core of your operations.

Why separate spreadsheets fail

Many retailers maintain a notebook for the shop and a Excel file for the website. Updates happen at closing time — or when someone remembers. During busy weekends, lag between channels creates oversells.

Real-world triggers of inventory chaos:

• Market weekend rush sells through fast-moving SKUs
• Staff forgets to update the website after restocking
• WhatsApp orders reserved stock that was already sold in-store
• Returns restocked physically but not online

Centralised inventory: one source of truth

Modern retail platforms treat stock as a single number per product variant, regardless of where the sale originated. Oshop247 deducts quantity immediately when:

• A customer completes online checkout
• A cashier completes a POS sale
• You manually adjust stock after damage or shrinkage

Everyone on your team sees the same figure in admin, POS, and the public storefront (shown as "in stock" or "out of stock").

Inventory modes for different business shapes

Oshop247 supports settings for how online stock relates to branches:

• Central warehouse — one pool for all online orders
• Fulfilment branch — online orders draw from a designated location
• Multi-branch — each location tracks its own quantities (ideal for chains)

Choose the mode that matches how you actually pick and pack orders. A single boutique in Lekki has different needs from three shops in Lagos, Ibadan, and Abuja.

Low-stock alerts and purchasing discipline

Set thresholds per product so admin users receive alerts before you hit zero. Use alerts to trigger supplier reorders, not emergency "sorry madam" calls.

Review a weekly stock movement report: what sold fast, what did not move, what is stuck in storage. Nigerian fashion and electronics businesses often tie up cash in slow SKUs while bestsellers stock out.

Receiving new stock correctly

When shipment arrives:

1. Update quantities in admin (or import CSV for large deliveries)
2. Verify variant-level counts if you track sizes separately
3. Photograph new batches if packaging changed — update listing images if needed
4. Only then promote the restock on WhatsApp status

Announcing before updating stock invites orders you cannot fulfil.

Returns, exchanges, and damaged goods

Define a returns policy on your store and train staff to restock only sellable items. Process refunds through the same order record so finance reports stay accurate. Random cash refunds without order linkage make month-end reconciliation painful.

POS session discipline

Close POS sessions daily. Unclosed sessions blur cash reconciliation and make it harder to match physical counts with system counts. Oshop247 can alert admins when a session from a previous day is still open.

Seasonal planning

December, Eid, and back-to-school periods compress sales into short windows. Before peak season:

• Increase safety stock on hero products
• Pause ads for items you cannot restock quickly
• Display honest delivery timelines on checkout

Inventory accuracy is a customer service strategy. When stock is right, every channel feels professional.