Orders reports

Order volume, value and flow — how many, how large, how discounted, how returned — counted once across every store you own instead of once per store.

15 built-in reports — every one opens in the report editor, runs across all connected stores in one currency, and can be saved, exported or scheduled. The query under each report is the whole report — readable, and yours to change.

Orders by sales channel

How many orders came through each sales channel, and what they averaged.

FROM sales
  SHOW orders, average_order_value, total_sales
  WHERE sales_channel IS NOT NULL
  SINCE startOfDay(-30d) UNTIL today
  GROUP BY sales_channel WITH TOTALS
  ORDER BY orders DESC
  LIMIT 1000
  VISUALIZE orders TYPE horizontal_bar

Orders over time

Orders placed per day, with items per order, average order value and reversed items.

FROM sales
  SHOW orders, quantity_ordered_per_order, average_order_value, reversed_quantity
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES day WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE orders TYPE line

Items ordered over time

Units ordered per day, before any returns or reversals.

FROM sales
  SHOW quantity_ordered
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES day WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE quantity_ordered TYPE line

Reversed quantity over time

Items removed from orders per day — returns, cancellations and edits — with order count and average order value alongside.

FROM sales
  SHOW orders, reversed_quantity, average_order_value
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES day WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE reversed_quantity TYPE line

Reversed quantity rate over time

Share of ordered items that were reversed, tracked daily.

FROM sales
  SHOW reversed_quantity_rate
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES day WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE reversed_quantity_rate TYPE line

Items reversed by product

Items ordered, reversed and the reversal rate per product, ranked by units ordered.

FROM sales
  SHOW quantity_ordered, reversed_quantity, reversed_quantity_rate
  WHERE product_title IS NOT NULL AND product_id IS NOT NULL
  SINCE startOfDay(-30d) UNTIL today
  GROUP BY product_title
  ORDER BY quantity_ordered DESC
  LIMIT 1000
  VISUALIZE reversed_quantity TYPE bar

Top returned products with reasons

Returned items per product, split by the reason the customer gave, ranked by total returns per product.

FROM returns
  SHOW returned_quantity
  GROUP BY product_title_at_time_of_sale, return_line_item_reason
    WITH TOTALS, GROUP_TOTALS
  SINCE startOfDay(-365d) UNTIL today
  ORDER BY returned_quantity DESC,
    product_title_at_time_of_sale ASC,
    return_line_item_reason ASC
  LIMIT 1000
  VISUALIZE returned_quantity TYPE stacked_bar

Orders and reversals by product

Ordered and reversed items per product with the reversal rate, compared to the previous period.

FROM sales
  SHOW quantity_ordered, reversed_quantity, reversed_quantity_rate
  WHERE product_title IS NOT NULL AND product_id IS NOT NULL
  SINCE startOfDay(-30d) UNTIL today
  GROUP BY product_title WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY quantity_ordered DESC
  LIMIT 1000
  VISUALIZE quantity_ordered TYPE bar

Items bought together

The product combinations customers buy in one order, with the sales and customer behaviour behind each basket.

FROM sales
  SHOW orders,
    average_order_value,
    orders_first_time,
    orders_returning,
    net_sales,
    gross_sales,
    total_sales,
    customers,
    number_of_orders_per_customer,
    amount_spent_per_customer
  WHERE number_of_products_bought_together BETWEEN 2 AND 4
  GROUP BY
    products_bought_together
  WITH TOTALS
  SINCE
    -6m until today
  ORDER BY orders desc
  LIMIT 1000
  VISUALIZE orders TYPE table

Orders fulfilled over time

Orders fulfilled, shipped and delivered per day.

FROM fulfillments
  SHOW orders_fulfilled, orders_shipped, orders_delivered
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES day WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE orders_fulfilled TYPE line

Orders delivered over time

Orders delivered per day, alongside the fulfilled and shipped counts.

FROM fulfillments
  SHOW orders_fulfilled,
    orders_shipped,
    orders_delivered
  TIMESERIES day
  WITH TOTALS
  SINCE startOfDay(-30d) UNTIL today
  LIMIT 1000
  VISUALIZE orders_delivered TYPE line

Orders with tracking included

Share of fulfilled orders that include carrier tracking, by week.

FROM fulfillments
  SHOW orders_with_tracking_included_rate
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES week WITH TOTALS
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE orders_with_tracking_included_rate TYPE line

Order to fulfillment time

Median hours from an order being placed to it being fulfilled, per day.

FROM fulfillments
  SHOW median_hours_order_to_fulfillment
  SINCE startOfDay(-30d) UNTIL today
  TIMESERIES day WITH TOTALS, PERCENT_CHANGE
  COMPARE TO previous_period
  ORDER BY timeseries ASC
  LIMIT 1000
  VISUALIZE median_hours_order_to_fulfillment TYPE line

Shipping and delivery performance

Orders fulfilled, shipped and delivered, split by how many days the fulfillment took.

FROM fulfillments
  SHOW orders_fulfilled, orders_shipped, orders_delivered
  GROUP BY fulfillment_event_days WITH TOTALS
  SINCE startOfDay(-30d) UNTIL today
  ORDER BY fulfillment_event_days ASC
  LIMIT 1000
  VISUALIZE orders_fulfilled TYPE bar

Shipments by carrier

Fulfillment volume, deliveries and median delivery time per carrier — who ships your orders and how fast.

FROM fulfillments
  SHOW orders_fulfilled, orders_delivered, median_hours_to_deliver, on_time_rate
  WHERE tracking_company IS NOT NULL
  SINCE startOfDay(-30d) UNTIL today
  GROUP BY tracking_company WITH TOTALS
  ORDER BY orders_fulfilled DESC
  LIMIT 1000
  VISUALIZE orders_fulfilled TYPE bar

FAQ

Do these orders reports cover all my Shopify stores? Yes — every report on this page aggregates across all connected stores and converts to one currency. Group by store inside any of them for the per-store split.

Can I change what a report shows? Yes — every report opens in the report editor, where metrics, groupings, filters, date ranges and the chart are all editable, and your version saves to your own library.

Can I get these reports automatically? Yes — any report can be downloaded as CSV or Excel, or scheduled to arrive by email or FTP on the cadence you choose.