Amazon Daily Order Stats

A day-by-day roll-up of Amazon order volume, fulfilment, cancellations and gross revenue over a chosen date window.

Purpose

Sales managers track daily Amazon order throughput and the cancellation trend.
Quickly spot spikes in cancelled orders against total orders (charted side by side).
Read the headline numbers (total orders, cancel rate %, gross amount) for the period at a glance.

How to Access

Desk > Reports > Amazon Daily Order Stats, or /app/query-report/Amazon%20Daily%20Order%20Stats. Report type: Script Report. Reference DocType: Amazon Daily Order Stat.

Filters

Filter	Type	Required	Description
From Date	Date	No	Window start. Defaults to 30 days before To Date (`add_days(to_date, -30)`).
To Date	Date	No	Window end. Defaults to today (`today()`).

Columns

Column	Type	Description
Date	Date	`stat_date` — the day the stats belong to.
Total Orders	Int	`total_orders` placed that day.
Shipped	Int	`shipped_orders` — orders shipped that day.
Cancelled	Int	`cancelled_orders` — orders cancelled that day.
Gross Amount	Currency	`gross_amount` for the day, formatted in the row `currency`.
Currency	Link (Currency)	`currency` the gross amount is denominated in (defaults to GBP when absent).

How It Works

The report is a thin reader over the pre-aggregated Amazon Daily Order Stat doctype — it does no joins. It pulls every Amazon Daily Order Stat row whose stat_date falls between [from_date, to_date], ordered stat_date asc, selecting the six fields above.

flowchart LR
  A[Amazon Daily Order Stat] -->|stat_date between from_date..to_date| B[get_all + order_by stat_date asc]
  B --> C[rows / columns table]
  B --> D[bar chart: Total Orders vs Cancelled]
  B --> E[report summary cards]

Chart. A bar chart (barOptions.stacked = 0) plots two datasets per date: Total Orders (#449cf0, blue) and Cancelled (#e24c4c, red).

Summary cards. Computed across the returned rows:

Total Orders — sum(total_orders), indicator Blue.
Cancelled — sum(cancelled_orders), indicator Red.
Cancel Rate % — total_cancelled / total_orders * 100 (0 when no orders), indicator Orange.
Gross Amount — sum(gross_amount) in the first row's currency (GBP fallback), indicator Green.

Notes

Data quality depends entirely on the upstream job that populates Amazon Daily Order Stat; the report shows nothing for days with no stat row.
Both date filters are optional; omitting them yields the trailing 30 days up to today.
Related: Amazon Order Sync Health, Amazon Top Selling SKU.