Reports

Orders Report

4min
the orders report gives you an overview of all orders that have been made on your account this can be account wide or for one specific event, collection, or class each row in the report represents an order that was placed during the selected date range on the orders report, you can customize which columns of data are shown on the report at the bottom of the report, you will have various checkboxes to control exactly what is shown on your report the orders report allows you to group your data by any column of data that you wish to do so, drag the column title to the bar along the top of the report the data will then be sorted accordingly you can drag multiple columns into the bar to view data based on another piece of data for instance, you can drag "event time" and then "discount code" to view the discount used for a specific event time rather than just overall view orders reports follow the instructions below to pull an orders report for the desired domain global orders report to pull an account wide orders report, click reports (from the top navigation bar) > orders event orders report to pull an event specific orders report, click the events tab from the top navigation bar then, click reports > orders next to the desired event collection orders report to pull a collection specific orders report, click collections > standard from the top navigation bar then, click reports > orders next to the desired collection class orders report to pull a class specific orders report, click collections > classes from the top navigation bar then, click reports > orders next to the desired class terms and definitions for an orders report on the left side of an orders report, there are two icons the first is a quick link to open the order summary page the second is a direct link to print the tickets for an order the following terms are the different options that you can show/hide as columns on your orders report order i d the order number for the transaction is used for internal tracking (click the link to open the order summary page type the payment method for the order (credit, cash, comp, etc ) status whether the order is paid, refunded, partially refunded, or released channel whether the order was "sef serve" (purchased by the patron online) or "box office" sold by a user via your admin panel check in time the time an order was checked in first name , last name , email , phone number , address , state , zip code the corresponding information for the patron who made the purchase discount code the name of the discount code used on the order discount reason shows the reason entered when a one off discount is completed by an admin access code the name of the access code used to gain early access passes the name of the pass used to redeem/purchase tickets retrieval the ticket retrieval method used on the order (print, digital, will call) alumni year the alumni year for the patron making the purchase (if applicable) event the name of the event, class, or collection for which the purchase is event time the event time or class time for the purchase student ledgers the student to which the purchase is credited (if applicable) suggested article student credit docid\ dv9mtdybkv24pfoh7l51u admin name the name of the admin that made the purchase only for purchases made on your admin panel, not those purchased online by patrons independently private notes any private notes attached to the order ref code the referral code attached to the order suggested article create referral links docid\ vlb5vsuqvnq72q6cism u purchase date the date of the purchase purchase time the time the purchase was made arrival time the arrival time selected for the event suggested article enable arrival times docid\ lu84dtqwky39e2fvenjmf tickets/fees (quantity) the number of tickets/fees/registrations in the order add ons (quantity) the number of add ons purchased money received the total money received on the order this includes all payment methods like cash, check, etc refunds includes the following four columns on the orders report refunded if an order has been refunded 0 = "no" 1 = "yes" refund total the amount of money that has been refunded refund date the date the refund was processed refund notes any notes that were added by an admin at the time of refund gift cards included the following two columns on the orders report gift cards the code of the discount used on the order gift cards $ the dollar amount from a gift card used on the purchase picked up if a will call ticket has been marked as "picked up" 0 = "no" 1 = "yes"