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.
ETID (Column Z) - The identifier for the email template used for the order. Learn more about what an ETID is here.
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!