Bestsellers

Supporting evidence for the loaded report. Use these checks to understand differences between whole-store totals and product rankings. Trading and daily figures cover the full selected range, regardless of product filters.

Sales and matching reconciliation

Compare product net sales with the comparison range and sales that could not be assigned to a catalogue product.

Product net sales · ex VAT

Last-year net sales · ex VAT

Unmatched sales · ex VAT

Source and coverage

Unmatched sales detail

Check which sales could not be matched to a catalogue product. These amounts remain in the report total but are excluded from product rankings. Resolve changed or duplicated SKUs before treating matched rows as the whole business.

Reported title	SKU	Reason	Net sales ex VAT

Stock comes from the Shopify API, not a CSV upload. It is the aggregate quantity at the saved Shopify catalogue sync, not historical stock. Refresh the catalogue in Setup, then refresh the report to use newer stock. Reported GP covers Shopify sales with costs recorded; margin uses that costed revenue base. Unknown quantities and costs are shown as —. Gift cards and unresolved identities are excluded from the product ranking and retained in reconciliation detail when returned by the sales source. GA4 is not included. Forecast estimates are read-only and use matched sales; they do not create orders.

Trading bridge and cost coverage

Check the components behind trading totals and how much sales have recorded costs. Reversal amounts are signed ledger entries, not settled cash refunds. Measures overlap and must not be summed together. Comparison follows the selected comparison range.

Measure	Selected range	Comparison

Daily sales and reconciliation

Check how whole-store sales and net units build up day by day, including unmatched rows. Days without returned rows appear as zero only after a complete successful read.

Day	Net units	Net sales ex VAT