Order Summary report
Use this report to review and analyze store performance.
Options: start date, end date
Sorted by: year, month
Grouped by: year, month, currency
| Report Column Name | Table Name | Column Name |
|---|---|---|
| Year | ORDERITEMS | TIMESHIPPED |
| Month | ORDERITEMS | TIMESHIPPED |
| Total Product Charges | sum(ORDERITEMS.TOTALPRODUCT) | |
| Total Tax on Products | sum(ORDERITEMS.TAXAMOUNT) | |
| Total Shipping Charges | sum(ORDERITEMS.SHIPCHARGE) | |
| Total Tax on Shipping | sum(ORDERITEMS.SHIPTAXAMOUNT) | |
| Total Adjustments | sum(ORDERITEMS.TOTALADJUSTMENT) | |
| Total Order Value | sum(ORDERITEMS.TOTALPRODUCT + ORDERITEMS.TAXAMOUNT + ORDERITEMS.SHIPCHARGE + ORDERITEMS.SHIPTAXAMOUNT + ORDERITEMS.TOTALADJUSTMENT) | |
| Number of Orders | count (distinct ORDERS.ORDERS_ID) | |
| Average Sales per Order | sum(ORDERITEMS.TOTALPRODUCT + ORDERITEMS.TAXAMOUNT + ORDERITEMS.SHIPCHARGE + ORDERITEMS.SHIPTAXAMOUNT + ORDERITEMS.TOTALADJUSTMENT) / count (distinct ORDERS.ORDERS_ID) | |
| Currency | ORDERS | CURRENCY |