Market Analysis
Part of Omnichannel retail business models
Understanding channel shifts without double counting sales
Use one sales record and separate channel attributes to reconcile online, store and collection reports without counting purchases twice.
Count each sale once in the retailer’s total, even when a customer orders online, a store picks the goods and the customer collects them there. Record those activities as attributes of the same purchase. Adding reports organised by different channel attributes can count one purchase more than once.
Build a reconcilable sales view
Start with an identifiable sale and a consistently defined net sales amount for the reporting period. A split order may need line-level or transaction-level records; an order number alone is not always one completed sale. Link cancellations, returns and later adjustments to the relevant original record. Record order origin, stock source, fulfilment method and handover location as separate fields.
Field / Question it answers for a collected order
- Order origin
- Was the order placed online or at a store checkout?
- Stock source
- Which location supplied the items?
- Fulfilment method
- Were the goods prepared for collection, delivery or immediate purchase?
- Handover location
- Where did the customer receive them?
A store can receive management credit for picking or handover without creating a second retailer sale. Label that internal allocation separately from total sales. This is a method for channel reporting, not a rule for statutory revenue recognition or GST.
Key Metrics for Reconcilable Sales Reporting
- Order origin
- Online or store checkout
- Stock source
- Store or warehouse
- Fulfilment method
- Collection, delivery, or in-store purchase
- Handover location
- Store or home
Steps to Avoid Double Counting Sales
- Define a single identifiable sale with net value
- Record order origin, stock source, fulfilment method, and handover location as separate fields
- Link cancellations, returns, and adjustments to original records
- Use consistent classification rules across reporting periods
See where reports overlap
In this illustration, three separate $100 purchases are completed: one online order is delivered, one online order is collected at a store, and one purchase is made at a store checkout. In this illustration, the retailer has $300 of sales.
Online-origin sales are $200. Sales handed over at stores are also $200 because they include collection and checkout. Adding those views produces $400 because the collected order appears in both. The two views classify the same sale in different ways.
For a report requiring mutually exclusive channels, state the rule. Assigning sales by order origin would show $200 online and $100 at store checkout in this illustration. A separate handover report would show $100 delivered and $200 received at stores. Each view should reconcile to $300 on its own; do not add their channel columns across views.
Check a claimed shift
For each period, compare the sales total with the sum of categories in the chosen exclusive channel view. Investigate unmatched records, duplicate imports, split orders, cancellations, returns and reporting-date differences. Apply the same classification rule in both periods. If collected orders are reassigned to another channel, disclose the change before interpreting the apparent movement as customer behaviour.
The ABS Retail Trade, Australia publication ceased after its June 2025 release.
A defensible channel-shift statement names the classification rule and reports both the change in channel mix and the change in total retailer sales. If online-origin share rises while total sales are steady, the records show a mix change under that rule. Whether customers moved purchases from store checkouts or changed how often or how much they bought needs further evidence.
