Website Management

Online sales reports

To use view the online sales for a given period,

Login to the 24-7 admin system
Select 'Reports (Export Data)' (you may need your id to be setup for this - contact support@worthers.com if you don't have the link)
Select the 'Export Data - Order Summary with Order Items and user details (Date Selectable)' link.
Type in the relevant dates in the format listed. You can leave off the minutes if you don't want to be that precise. Click on the 'Create Report' button to have the report downloaded to your PC.
Open the file you downloaded into Excel, and view the data as required.

Further Important Notes:

If you are working on sales, make sure that you don't include 'orderstatus' of postcallback if the sale didn't go through.
The 3's the magic number product repeats three times. Ensure that it is only included once per 'id' in any calculations.
Donations on an order are repeated across multiple rows per 'id'. Ensure that each donation is only included once per 'id' in any calculations.