The order-history report is viewed in a downloadable Excel spreadsheet. Below, you'll find details about each column you'll see in this report.
Order Reference ID (Column A) - The identifier for the order. You can view Order Reference IDs on the Order History page of your portal.
Order Status (Column B) - The current state of your order. Learn more about what different order statuses mean here.
External Reference ID (Column C) - If you place an order via the API, the string you entered for "externalRefID" will populate this field.
Created By (Column D) - The user who placed the order.
Sender First Name/Sender Last Name (Column E/F) - The text entered in the Sender_Name field in your email template or during your order.
Created Date (Column G) - The date and time the order was placed.
Group Name (Column H) - The name of the Group from which this order was placed.
Group ID (Column I) - The identifier for the Group from which this order was placed.
Account Name (Column J) - The name of the Account from which this order was placed.
Account ID/Account Number (Column K/L) - The identifier for the Account from which this order was placed.
Order Notes (Column M) - If you place an order via the API, the string you entered for "notes" will populate in this field.
Line-Item Number (Column N) - If your order contains more than one reward, those rewards will be distinguished by their line-item number.
Recipient Email Address (Column O) - The email address to which the order was sent.
Recipient First Name (Column P) - The first name of the recipient entered during order flow.
Recipient Last Name (Column Q) - The last name of the recipient entered during order flow.
Reward (Column R) - The reward item selected for the order.
UTID (Column S) - The identifier for the selected reward item.
Amount (Column T) - The amount entered for the order.
Currency (Column U) - The currency of the reward item.
Amount Charged (Column V) -The balance subtracted from your Account for the order.
Amount Charged Currency (Column W) - The currency of the balance taken from your Account for the order.
Reward Message (Column X) - The text entered in the "Reward Message" field during a Bulk Upload order or the "Message" field during the order process.
Line-Item Notes (Column Y) - The text entered in the "Customer Notes" field during a Bulk Upload order or the "Notes" field during the order process.
ETID (Column Z) - The identifier for the email template used for the order. Learn more about what an ETID is here.
PO Number (Column AA) - If the order is associated with a purchase order, it will populate in this field.
Street Line 1 (Column AB) - The first line of the street address to which the order was sent.
Street Line 2 (Column AC) - The second line of the street address to which the order was sent.
City (Column AD) - The city to which the order was sent.
State (Column AE) - The state to which the order was sent.
Zip (Column AF) - The zip code to which the order was sent.
Country (Column AG) - The country to which the order was sent.
Learn more about your in-portal Order History page here.
*Looking to learn even more about Rewards Genius? Sign up for our weekly webcast here!