Buyer reviewing stock across multiple retail stores
Back to blog

Why Gut-Feel Reorders Fail for Mid-Size Retailers

At 5 stores, intuition-based buying starts to break down. A 2-store boutique may manage by instinct, but regional complexity soon exceeds what one buyer can track mentally.

By Miquel Subirats 6 min read Demand forecasting

At 5 stores, intuition-based buying is no longer enough. A buyer running two stores can retain much inventory knowledge. They know the 20 SKUs behind most revenue, which location sells out first on new collections, and that the supplier for their leading accessories line arrives two days late every time. That knowledge is real, and it works.

The strain appears as a business moves from 3 stores to 5, or from 5 to 8 across Spain's regions. SKU-location combinations multiply beyond the buyer's tracking capacity. What works at 3 stores becomes unworkable at 7, even for the same experienced buyer doing the same job.

What Gut Feel Means

Gut feel in retail buying is not guesswork. It is compressed judgment built through pattern recognition. An experienced buyer knows their Bilbao store sells differently in late October than in early November because of the local feria calendar. They know some accessories categories rise in December but slow in January, and which suppliers warn about production delays versus simply shipping late.

That knowledge has value, but it works through abstractions. A buyer thinks, "Madrid sells more basics in summer," rather than, "the Calle Mayor store sells SKU 4821 at 3.8 units per week in July and 1.1 units per week in October." The concept remains, but the precision needed for a current reorder decision is lost.

At two stores, that precision loss is limited. At seven stores with 250 active SKUs each, it is where stockouts and dead stock appear.

The Five-Store Inflection Point

We see this pattern consistently in retailers growing from small to mid-size. Below four stores in one region with similar customer profiles, experienced buyers can usually monitor inventory closely enough to catch costly problems. Above five stores, especially across cities or regions with different demand, the mental model starts failing in clear ways.

The buyer is not becoming less skilled. Information complexity has exceeded what one person can reliably track through weekly checks. That is not a personal failing, but a structural limit of unaided cognition once the operation passes a threshold.

Three Failure Modes at Scale

The highest-revenue store attracts the most attention. Buyers naturally devote more mental time to the location that matters most financially. Smaller stores then drift toward chronic under-stock, forgotten during reorders, or chronic over-stock, ordered cautiously to avoid a stockout where oversight is lighter.

Seasonal carryover mistakes compound. A buyer may remember overbuying a knitwear category last autumn, but that memory reflects the flagship's sell-through, not necessarily smaller regional stores with different local conditions. Buying less across the chain this autumn then undershoots at stores where last year's overstock was not a problem.

Reorder timing slips under pressure. Supplier relationships, approval workflows, promotions, and daily questions from store managers push slower or less visible stores down the list. Repeating that delay weekly through a season produces a 10 to 15 percent higher emergency-order rate than a systematic reorder trigger.

Why Spreadsheets Miss the Cognitive Limit

When inventory gets unwieldy, the instinct is to build a better spreadsheet. That is sensible and useful. A structured sheet with current stock counts and a reorder threshold is far better than having no system.

Spreadsheets solve one issue while adding another. The buyer must maintain data, update thresholds, and check results on schedule. The burden shifts from tracking inventory to maintaining the tracking system and its accuracy. For one or two buyers handling 200 to 400 SKUs across seven stores, that upkeep becomes a bottleneck.

More importantly, a spreadsheet reports the current state but does not project ahead. It cannot tell the buyer that SKU 4821 at the Bilbao store will stock out in 9 days at its current depletion rate if no order goes in today. The buyer must calculate that manually for every SKU and location, recreating the original problem.

When the Reorder List Is Generated

When Stockagile creates a weekly reorder list for each location, the buyer moves from detection to review. Detection means scanning every SKU-location combination for approaching thresholds. Review means focusing on the items already identified as requiring a decision this week.

For a buyer handling 8 stores and 300 active SKUs, the shift is from monitoring 2,400 SKU-location pairs to reviewing 30 to 60 flagged recommendations each week. The judgment calls remain similar. The scanning work beforehand disappears.

This is a substantial practical shift. Buyers who make it often describe "getting Mondays back." Spreadsheet checks and reactive problem-solving give way to a structured review lasting 60 to 90 minutes and covering a week's reorder decisions.

Where Intuition Still Helps

We are not saying experienced buyers should follow the model on every decision. Some buying judgments remain outside demand forecasting:

New product launches and new season buys come before any sales history exists. The opening buy depends on market knowledge, category experience, and supplier conversations. The model has nothing to contribute there.

Local events and context remain the buyer's territory. A Spanish city near a major annual festival, construction on the main shopping street, or the recent loss of a nearby anchor tenant can change demand in ways historical data will not capture for several cycles. A buyer aware of those events can adjust the recommendations. The model cannot find them independently.

Supplier knowledge matters as well. Knowing who warns before shipping late and who simply misses the delivery window changes the safety stock needed for a category. That operational knowledge sits with the buyer, not the sales data.

The workable division is straightforward: the model manages the predictable reorder workload, including ongoing replenishment of established SKUs with a clear sales signal. The buyer handles uncertainty, such as new products, local events, and supplier variables. Each handles the work it suits.

Gut feel built through years of retail buying is valuable. It becomes a liability when complexity exceeds what one person can reliably hold. The answer is not to replace judgment, but to offload the scanning.