The Shelf Knows Before the Spreadsheet Does

Why growing retail chains outgrow disconnected systems, and what a connected retail ERP changes.

Walk into a supermarket at seven in the morning and the shelves will tell you how the business is performing. They show what sold out overnight, what customers ignored and what has occupied valuable space for months.

The spreadsheet, meanwhile, may still be describing last month.

That gap between what is happening in the store and what management can see in the system is where retail margin quietly disappears. A buyer orders stock that is already sitting in another branch. A promotion ends in one location but continues in another. A category appears profitable until freight, customs duty, rebates and shrinkage are included.

Across our retail implementations in Lebanon and African markets, we see the same underlying issue: the business keeps growing, but its operational systems stop growing with it.

When a retail chain loses a clear view of itself

A single store is relatively easy to understand. The owner or manager can walk the floor, count stock and correct discrepancies quickly because there are few places for inventory to be.

A second location changes the structure of the business. Stock is now moving between branches, warehouses, back rooms and delivery vehicles. A transfer may be physically completed on Tuesday and recorded on Friday. Head office can see a total that looks correct while the quantity available in each location is wrong.

As more branches open, retailers often compensate by adding manual reconciliation. Teams spend the first days of every month rebuilding reports about a period they can no longer influence. That is not real-time management information. It is a reconstruction of the past.

What usually breaks first

1. Stock accuracy

Manual transfer records struggle to keep pace with physical stock movement. When buyers stop trusting inventory figures, they begin purchasing on instinct, increasing the risk of both stockouts and overstocking.

2. Pricing and promotion control

A centrally approved campaign reaches one branch on Monday and another on Wednesday. Customers see the inconsistency before management does, while untracked discounts reduce margin.

3. True margin visibility

A point-of-sale system may report gross margin against cost price, but true profitability also depends on landed cost, freight, customs duty, supplier rebates and shrinkage. If those costs sit in separate systems, reported margin and actual margin diverge.

4. Cash visibility

Supplier payments, branch receipts and stock commitments are managed through different views of the same money. By the time finance reconciles them, management is already making the next set of decisions.

What a connected retail ERP actually changes

Retail ERP is often presented as a complete transformation. Its most valuable contribution is more specific: it gives every authorised team one current version of the numbers.

With Microsoft Dynamics 365 Business Central, retailers can view inventory by location, including stock in transit; raise purchase orders against current sales and availability; manage price lists and campaigns centrally; assign landed costs to items; and post sales and inventory movements to finance automatically.

This does not necessarily mean replacing every existing platform. The point-of-sale system can continue handling till transactions, and the e-commerce platform can continue selling online. The goal is to connect them to a central operational and financial record so they no longer operate as isolated systems.

Six signs your retail systems are limiting growth

• You cannot see current stock across every location in one view.
• Month-end closing consistently takes longer than expected.
• Two departments report different figures for the same period.
• Every new branch requires additional administrative headcount just to keep records aligned.
• Margin by category or store depends on someone manually building a spreadsheet.
• Purchasing decisions rely more on experience than on current sell-through and stock data.

If several of these are familiar, the constraint on growth may no longer be commercial. It may be operational.

A retail ERP implementation sequence that works

Start by mapping how a product actually moves from purchase order to warehouse, branch, shelf and sale, including the workarounds employees use. These workarounds often reveal requirements that have never been formally documented.

Clean the data before migration. Duplicate SKUs, inconsistent units of measure and obsolete item records will undermine even a well-configured system.

Configure the core structure next: locations, item categories, price lists, tax setup, chart of accounts and permissions. Then integrate the point-of-sale system so that sales and stock movements post automatically.

Pilot the setup in one live store before a wider rollout. Fix issues at a small scale, then expand branch by branch. Train each role on the tasks it performs every day, not on the software’s full feature list.

Why growing retail markets feel the pressure sooner

In fast-growing markets, commercial opportunity often moves faster than back-office capacity. New branches open because the demand is there, while operational gaps are absorbed by people working harder and reconciling information manually.

That approach can support growth for a time. Eventually, however, the effects appear in eroding margin, excess inventory, stockouts and management teams that spend more time reconstructing the past than planning the future.

CODERS recently began working with Centro Supermercado in Mozambique on this kind of operational foundation. The value is not technology for its own sake. It is giving a growing retailer the visibility and control needed to expand without multiplying uncertainty.

The question to ask this week

Do not start with “Do we need an ERP?” Ask a more useful question: if we needed our current stock position and true margin by category across every branch right now, how long would it take to produce the answer, and how much would we trust it?

If the answer is measured in days and comes with caveats, the shelves already know something the business does not.

Talk to CODERS about connecting inventory, sales and finance with Microsoft Dynamics 365 Business Central.

Written by the CODERS team. CODERS is a Microsoft Solutions Partner delivering Business Central implementations for retail, distribution and service businesses across Lebanon and African markets.