The selection of sales reports includes Orders, Tax, Invoiced, Shipping, Refunds, Coupons, and PayPal Settlement.
The Orders Report can be filtered by time interval, date, and status. The report includes the number of orders placed and canceled, with totals for sales, amounts invoiced, refunded, tax collected, shipping charged, and discounts.
The Tax Report can be filtered by time interval, date, and status. The report includes the tax rule applied, tax rate, number of orders, and amount of tax charged.
The Invoice Report can be filtered by time interval, date, and status. The report includes the number of orders and invoices during the time period, with amounts invoiced, paid, and unpaid.
The Shipping Report can be filtered by time interval, date, and status. The report includes the number of orders for carrier or shipping method used, with amounts for total sales and total shipping.
The Refunds Report can be filtered by time interval, date, and status. The report includes the number of refunded orders, and total amount refunded online and offline.
The Coupons report can be filtered by time interval, date, and status. The report includes each coupon code used during the specified time interval, related price rule, and number of times used, with totals and subtotals for sales and discounts.
The PayPal Settlement Report can be filtered by date, merchant account, transaction ID, invoice ID, or PayPal reference ID. The report includes the type of event, such as a debit card transaction, the start and finish dates, gross amount, and related fees. The report can be automatically updated with the most current data from PayPal.
The Braintree Settlement Report can be filtered according to creation date, amount, status, transaction type, payment type, transaction ID, order ID, PayPal payment ID, type, merchant account ID, or settlement batch ID. The report contains the transaction ID, order ID, PayPal payment ID, type, creation date, amount, settlement code, status, settlement response text, reimbursement IDs, merchant account ID, settlement batch ID, and currency.
On the Admin sidebar, go to Reports.
Choose the reports to refresh.
To update statistics, click here in the text.
In the Admin, you can access can generate a report for a whole website or for one store, within a time interval or a date. To filter a sale report, set the following options:
|Date Used||Sets the data to be used for the report.|
|Period||The period for which the data is used: Day/Month/Year.|
|From/To||Used to define search data by start and end date.|
|Order Status||Indicates the order status|
|Empty Rows||Indicates whether to add blank rows to the report.|
To generate the report, click Show Report.
To export the report, select the file type:
Excel XML or
To reduce the performance impact of generating sales reports, Commerce calculates and stores the required statistics for each report. Rather than recalculate the statistics every time a report is generated, the stored statistics are used, unless you refresh the statistics. To include the most recent data, the report statistics must be refreshed before a sales report is generated.
On the Admin sidebar, go to Reports > Statistics > Refresh Statistics.
In the list, select the checkbox for each report to be refreshed.
Set the Actions control to one of the following:
Refresh Lifetime Statistics
Refresh Statistics for the Last Day