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

Related concepts

Operational reports