Commercial Overview

August 2026 · Live sample dashboard
Sample data loaded

Commercial performance at a glance

Auto-calculated from Shopify transaction rows.

Data through —

Sales pace

Daily retail vs online sales

RetailOnline

Store run-rate

Top and bottom stores vs target pace

Stores requiring attention

Lowest run-rate first · needed per day is based on remaining calendar days

Stores & Territories

Targets, sales pace, AOV, UPT and deficit are recalculated from every uploaded file.

— stores

Individual Staff Ranking

Weighted score: Orders 70% · AOV 15% · UPT 15%. Home store is inferred from the uploaded transaction data.

— staff

YTD & Last Year

Previous closed months are retained as historical data; the uploaded current month refreshes automatically.

Retail monthly trend

Actual vs budget · current month shown MTD

ActualBudget

Incentives & Manager Bonus

Rules are configurable in Admin so future tiers, products and payout rates do not require rebuilding the dashboard.

Manager bonus

Full ≥100% run-rate · Half ≥95%

Staff product incentive

—

Upload & Admin

Daily workflow: export the latest month-to-date Shopify CSV, drop it here, and the portal replaces the current snapshot and recalculates everything.

↑

Drop the Shopify CSV here

This prototype does not append a month-to-date export. Every new file becomes the current snapshot, preventing duplicate orders from repeated daily uploads.

Upload validation

No new file uploaded in this session

    The current screen is preloaded with the supplied sample-data calculation.

    Calculation settings

    These are business rules, not daily CSV fields.

    Legacy workbook issue detected: the old top-level Retail Target is £759,538, while the 21 store targets total £775,492. The difference is exactly Southall (£15,954). This prototype uses the store-target total so national and store views reconcile.

    Store targets & ownership

    Edit yearly/monthly master values here instead of changing dashboard formulas.

    —