The Order Export report creates an Excel-friendly list of orders for a selected event. You can filter the results by order status, dates, products, suppliers, and other event details.
Description
Use the Order Export report to create a flat list of orders for an event. After running the report, click the blue disk icon in the report parameter area and choose Excel to export the results.
Report Example
Available Filters
Use the following filters to select the event, orders, items, and delivery details included in the export.
| Field Name | Available Values | Default |
|---|---|---|
| Choose From Events In | Event years | Future |
| Event | Any event in the system | None |
| Status(es) | Payment Pending Confirmed Cancelled Closed |
Payment Pending Confirmed Closed |
| Product Code | Any specific product code | None |
| Order Start Date | Any date | Beginning of time |
| Order End Date | Any date | Today |
| Deliver Start Time | Any date | Event move-in date, or event start date if no move-in date is set |
| Deliver End Time | Any date | Event move-out date, or event end date if no move-out date is set |
| Order Modify Start Date/Time | Any date | Beginning of time |
| Order Modify End Date/Time | Any date | Today |
| Item Modify Start Date/Time | Any date | Beginning of time |
| Item Modify End Date/Time | Any date | Today |
| Revenue Type(s) | Revenue types defined in the system | All |
| Location(s) | All locations defined in the event | All |
| Pavilion(s) | All pavilions defined in the event | All |
| Product(s) | All products available in the event | All |
| Suppliers | All active suppliers | All active suppliers. If you select specific suppliers, the events included depend on whether those suppliers are associated with them. |
Filter Details
Choose From Events In: Determines which event years are available. Future is selected by default.
Event: Selects the event for the export. No event is selected by default.
Status(es): Filters orders by status. Payment Pending, Confirmed, and Closed are selected by default.
Product Code: Filters orders by a specific product code. No product code is selected by default.
Order Start Date and Order End Date: Set the order date range. The default range begins at the beginning of time and ends today.
Deliver Start Time and Deliver End Time: Set the delivery date range. By default, the range uses the event’s move-in and move-out dates. If those dates are not set, the event start and end dates are used.
Order Modify Start Date/Time and Order Modify End Date/Time: Set the date range for when orders were modified. The default range begins at the beginning of time and ends today.
Item Modify Start Date/Time and Item Modify End Date/Time: Set the date range for when order items were modified. The default range begins at the beginning of time and ends today.
Revenue Type(s): Selects which revenue types to include. All revenue types are included by default.
Location(s): Selects locations defined for the event. All locations are included by default.
Pavilion(s): Selects pavilions defined for the event. All pavilions are included by default.
Product(s): Selects products available in the event. All products are included by default.
Suppliers: Selects which active suppliers to include. All active suppliers are included by default. When you select specific suppliers, events are included based on whether those suppliers are associated with each event.
Sample Report
Open the Order Export Spreadsheet to see an example of the exported report.