Generate an Orders Report

Applicable to: All Administrators

Application(s): Admin Portal > Reports > Orders

This article will cover the following:

1. What the Orders Report shows
2. How to generate the report
3. Understanding the report data

Related articles:

• Generate a Transaction Report - Payment details for orders
• Generate reports for your organisation - All available reports

Overview

The Orders Report shows all merchandise product orders made within your selected date range. This includes team uniforms, equipment, fundraising items, and custom payment requests.

Use this report to track what's been sold, manage inventory, and organise product fulfilment.

Generate the report

1. Go to Reports
   1. Navigate to Admin Portal > Reports
   2. Click Orders tab
   3. Select Orders Report
2. Set your options
   1. If you are an Admin Body organisation, select the Organisation you wish to run a report for (or leave as All Organisations). For Clubs and Associations, skip this step.
   2. Choose your Product (or leave as All Products)
   3. Set the From and To Dates for your report period
   4. Click Generate
3. Download your report
   1. Wait for the success message
   2. Go to Generated Reports tab
   3. Click Download for CSV format

Understanding your report

What you'll see

Each product ordered appears as a separate row. If someone ordered 3 different items, you'll see 3 rows with the same Order Number.

Key information included

• When - Order Date
• Who - Customer name and Profile ID
• What - Product Name, Quantity, SKU
• Where - Delivery address details
• How - Fulfilment Method (pickup/delivery)

Useful for

• Inventory tracking - See what's been sold
• Fulfilment planning - Organise deliveries and pickups
• Sales analysis - Track popular products

Report fields

• Order Details: Order Date, Order Number, Order ID
• Customer Information: First Name, Last Name, Profile ID, Address details
• Product Information: Product Type, Product Name, Quantity, Merchandise SKU
• Delivery Information: Fulfilment Method, Address, Suburb, Postcode, State, Country
• Custom Options: Any product variants or special requirements appear as additional columns

Frequently asked questions

Why are there multiple rows for one order? Each product appears on its own row. Look at the Order Number to see which items were bought together.

Can I see payment details? No, this report shows products only. Use the Transaction Report for payment information.

How do I track inventory? This shows what's been sold. You'll need to compare with your stock records to see what's remaining.

What are the new fields? We've added Profile ID, Order ID, Order Item ID, and Product Type to help with tracking and analysis.

Next steps

• For payment details: Generate a Transaction Report using the same date range
• For other reports: Return to Generate reports for your organisation