Orders Report
This report doesn't export your orders, but simply displays information about the orders created or updated within the given time period.
From your control panel go to Reports and click on Manage next to the report you want to run (Orders).
Selecting your Export Data
- Select Match Period To to filter by Order Created Date or Order Updated Date
- Select Period to set how the report groups your totals. (Day, Month, Year).
- Set the From and To date.
- Choose the Order Statuses to filter your report by. Can be Any or Specified with each status listed.
- Empty Rows will display empty rows in your report if an order did not occur in the set Period.
- Show Actual Values will display additional columns, described below.
Generate and Export Report
Click on Show Report in the top right to run the report and display it at the bottom of the page:
Click on the Export button to generate a CSV file - it will automatically be downloaded onto your computer.
Refresh Lifetime Statistics
If you see an incomplete report you need to refresh the lifetime statistics.
Total Ordered Report Columns
Period | The Day, Month or Year of Orders being summed. |
Orders | The number of Orders |
Sales Items | The number of items sold in Orders. |
Items | The number of items Invoiced. |
Sales Total | The grand total amount ordered in Orders. |
Revenue | The total paid - total refunded - tax invoiced - shipping invoiced |
Profit | The total paid - total refunded - tax invoiced - shipping invoiced - total invoiced cost |
Paid | The amount paid in the Order and Invoice |
Paid | The amount paid in the Order and Invoice |
Refunded | The amount refunded on Orders. |
Sales Tax | The amount of tax calculated on Orders |
Tax | The amount of tax on the Invoice. |
Sales Shipping | The shipping amount on the Order. |
Updated 8 months ago