The Orders Report is useful to view and track the detail of all merchandise product orders made within the selected report date range.
To generate an Orders Report, select Reports, then the Orders tab, and then the Orders Report. Select the relevant Products (or All Products), set the Dates to run the report, and then click the Generate button:
The report will be generated and a success message at the bottom of the page will indicate that report is ready to be downloaded:
Go to the 'Generated Reports' tab to see the list of generated reports:
Click the Download button to download the report in .csv format. The Order Report will include detailed information of each Order line item as a separate row, with the following details displayed as columns:
- Order Date
- Organisation
- Profile ID*
- First Name
- Last Name
- Order Number
- Order ID*
- Order Item ID*
- Product Type*
- Product Name
- Quantity
- Merchandise SKU
- Fulfilment Method
- Address
- Suburb
- Postcode
- State
- Country
- Custom Fields / Product Variants (dynamically appear)
*The below table showcases updates made to report headers and fields from original reports:
| Original Report Header | New Report Header | Change |
| Profile ID |
Not shown previously This is the unique PLayHQ ID associated with the users profile who made the transaction. |
|
| Order ID |
Not shown previously PlayHQ unique ID related to the order of this transaction. An order can contain many order items belonging to the one transaction. |
|
| Order Item ID |
Not shown previously PlayHQ unique ID related to the order line item of this transaction |
|
| Product Type |
Not shown previously Type of product purchased e.g. Merchandise or Fundraising etc |