merchmix

Publish Date :

Online and Stores Planned Separately: Where the Stock Goes Wrong

One shared buy can miss both channels if its size mix reflects neither customer. Merchmix Core connects the channel assumptions with the range’s quantities, while Core Plus supports the store and size response. Reconcile the required size mix before approving the total buy.

A young retail planner checking knitwear sizes between an online fulfilment bench and a store range rail.
Editorial illustration of the retail planning decision.

THE MERCHMIX DECISION / Core + Core Plus

One buy. Two different size curves.

Combine channel needs in units before approving the shared size mix.

Worked retail planning example. Quantities and financial amounts are independent assumptions; money is shown in US dollars. Proposals remain subject to review.

merchmix.Core + Core Plus / planning review
Establish the basisCurrent assumptions

One buy. Two different size curves.

Online / 240 unitsStores / 360 units
SizeOnline needStore needCombined
Small9672168
Medium96180276
Large48108156
Old blended buy / compare with requirement
Small120units
Medium270units
Large210units
Same buy600 units
Same cost$15,000
Mix to reconsider54 units
Requirement stays 168 / 276 / 156Small and medium are short

Against the new requirement, the old curve has 48 fewer small, six fewer medium and 54 more large units.

Keep the channel curves separate

Online needs 96/96/48; stores need 72/180/108.

THE KEY IDEA

Combine channel needs in units before approving the shared size mix.

A correct total can still be the wrong assortment

Separate channel plans do more than compete for stock already held. They can generate a new buy whose total is correct but whose sizes fit an old blended average. The buyer sees sufficient units while the online customer and store customer encounter different gaps.

This article concerns the shape of a future buy, not allocation of existing reservations. Keep each channel’s expected units and size mix visible long enough to combine them properly. A larger total purchase cannot correct a mix error if the extra units repeat the same unsuitable curve.

Planning and product referencesMerchmix Core: documented product scope

Build the shared requirement from channel quantities

Core supports range planning and size analysis using chosen trading periods. Compare online and store evidence on compatible definitions before using it: completed sales, availability, returns treatment and the intended selling window. Observed sales from a missing size understate the opportunity.

Core Plus supports the later location and size decisions. The hand-off should preserve which demand each size is intended to serve. It does not require a promise that a particular channel curve is automatically imported or that every connected channel exposes the same reservation data.

Combine the curves in units rather than averaging them

A planned 600-unit knitwear buy serves online demand of 240 and store demand of 360. Online expects small, medium and large shares of 40%, 40% and 20%, giving 96, 96 and 48 units. Stores expect 20%, 50% and 30%, giving 72, 180 and 108.

The combined requirement is therefore 168 small, 276 medium and 156 large units. An old blended curve of 20%, 45% and 35% would instead buy 120, 270 and 210. The same 600 units leave small 48 short and medium six short against the new requirement, while large exceeds it by 54.

THE FIGURES BEHIND THE DECISION

One buy. Two different size curves.; Combine channel needs in units before approving the shared size mix.
SizeOnline needStore needCombined needOld buy
Small9672168120
Medium96180276270
Large48108156210
Total240360600600

Combined requirement = online units by size + store units by size. Both buys contain 600 units × $25 = $15,000.

Make the correction budget-neutral before assessing value

At an assumed $25 unit cost, both mixes cost $15,000. The proposal changes the mix, not the total quantity or stock investment. Reallocate 54 planned large units into 48 small and six medium units, provided the supplier can still accept that size split.

The calculation does not establish that every required unit will sell. It shows why an unchanged budget can still contain the wrong product structure. Core’s planning context keeps the original and revised assumptions available for comparison rather than concealing the change in a replacement total.

THE PLANNING REFERENCERead the size-curve guide

Separate channel demand from fulfilment ownership

An online order fulfilled from a store should not create a second customer demand record just because the store picked it. Define the selling channel and physical source separately when reconciling evidence. A returned unit also needs its actual condition and location checked before becoming future supply.

These are operating definitions to confirm with the connected systems, not claims of universal automatic reconciliation. Core Plus can support stock decisions only on the source and size basis actually available. A proposed future mix must not be presented as a completed transfer or reservation.

Review what happens if the channel mix changes

Suppose online gains share after the buy is committed. That is a new planning assumption, not evidence that the original supplier order changed with it. Compare the newly required sizes with what is held, incoming and amendable before making another purchase.

Use Core to revisit the range and forward requirement, then Core Plus to assess the supported allocation response. Identify whether the immediate issue is the number of small units, their arrival date or their current location. Each requires a different action and a different approval.

SignalMerchmix workspaceDecision to review
Channel shares changeCore / range planningRecalculate the combined requirement by size.
Stock must serve locationsCore Plus / allocationCheck size, source and timing against the accepted demand.
An order is picked in storeCore / planning basisKeep selling channel distinct from fulfilment source.

Approve the mix that serves the intended customers

For this worked buy, the decision is 168 small, 276 medium and 156 large units at the same $15,000 cost. The owner should confirm the channel quantities, trading evidence and supplier acceptance before replacing the planned split. No size change is represented as executed.

The shared plan earns its value when channel differences remain visible inside it. One budget and one total do not mean one customer curve. Combine channel demand in units, retain its basis and carry the accepted structure into the next stock decision.

BEFORE THE NEXT DECISION

  • Planner

    Reconcile channel units and curves on one period.

  • Buyer

    Confirm whether the size split remains amendable.

  • Allocation owner

    Preserve the accepted demand basis in location decisions.

Common questions

Is this another stock-reservation example?

No. It concerns the size composition of a new 600-unit buy before operational allocation.

Why not average the two channel percentages?

The channels have different quantities. Convert each curve to units, then add the corresponding sizes.

Does the revised mix cost more?

At the common $25 unit cost, both 600-unit mixes cost $15,000.

Are 54 extra large units a confirmed loss?

No. They are above this assumed requirement; actual demand and amendment options still need review.

Does a store fulfilment become store demand?

Not automatically. Define the selling channel separately from the location providing the stock.

core

Recalculate the combined requirement by size.

Explore
core plus

Check size, source and timing against the accepted demand.

Explore

Continue reading: Why size curves need review

Read the retail planning glossary

FROM THE ARTICLE TO YOUR OWN RETAIL PLAN

Review the decision.
See the workflow.

Bring your planning questions to a demo, or explore a proof of concept on your own data.

Book a demo Explore the proof of concept