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 an order made in Advanced Mode

Line-Item Notes (Column Y) - The text entered in the "Customer Notes" field during a Bulk Upload order or the "Notes" field during an order made in Advanced Mode

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!

Did this answer your question?