Loyalty points reconciliation
The daily points reconciliation (recon) file is intended to help you maintain accurate loyalty point totals for your customers. Because Expedia does not have access to adjust your system’s totals, when a customer books travel using loyalty points, your records will need to take that usage into account.
Every day, your site will send a .csv file with information about transactions that occurred on your template site in the 24-hour period between 12:00 AM PST and 11:59 PM PST.
The file will be exchanged daily via secure file transfer protocol (SFTP), which you’ll agree on with your Expedia launch manager.
Recon file name
The standard naming convention for the daily points recon file is (in order) your brand or organization name, the country code in which the template site is operating, and the date and time of the file’s generation. Each element should be separated by an underscore (_) character, like this: YourBrand_countrycode_date.csv.
The date format should be dd_mm_yyyy_hhmm, and country code is case-sensitive. Note: there is no validation of the country code on the Expedia side—it is used only as metadata.
For example, your file name might look like this: YourBrand_USA_28_04_2024_0800.csv.
About the file
The file contains several standard headers and corresponding values. If you have additional fields that need reconciliation, you can include them after the standard values.
Note
Only confirmed transactions need to be sent in the file. Cancelled transactions should be skipped.
Be sure to trim any spaces or nonvisible characters around the header names for accurate reflection on your template site.
| Standard header | Description | Data format | Sample value |
|---|---|---|---|
| TRANSACTION DATE | The date of the transaction | dd-month-yy hh.mm.ss (not null or blank) | 18-Aug-22 19.22.44 |
| ORDER ID | The Expedia order ID shared in the API request Note: If you open the file in Excel, the default import rules can corrupt this field’s values | String (not null or blank) | 9223371999748510705 |
| REQUEST ID | A unique request identifier Expedia provides for use in reconciliation | String (not null or blank) | |
| PARTNER CONFIRMATION ID | A unique transaction identifier that you provide | String (not null or blank) | varies |
| TRANSACTION TYPE | The type of transaction represented; valid values include Redeem or Refund | String | Redeem |
| QUANTITY TOTAL POINTS | The total number of points in the transaction; should always be a positive number | Integer | 1500 |
| VALUE TOTAL POINTS | The currency value of the points used Note: Your Expedia launch manager will discuss further details of this value with you, to make sure that it’s interpreted correctly for all transactions | Integer | 500 |
| CURRENCY CODE | The ISO standard currency code used for the points value; for example, USD, CAD, AUD | String | USD |
Onboarding and file transfer steps
To transfer the daily points recon file, you’ll need to set up communications protocols that will ensure the security of your data.
- First, you’ll create an SSH (secure shell) public/private key pair and share the public key with us.
- We’ll share a public key that you’ll use to encrypt and upload the file.
- We’ll share SFTP details so that you can connect via your SSH private key and upload the encrypted file in the specified directory.
SFTP details
| Server | Values |
|---|---|
| TEST | Host: secure-file-transfer-test.expedia.com UserName: <To be provided by Expedia> Folder : /<file to be uploaded inside root folder> |
| PROD | Host: secure-file-transfer.expedia.com UserName: <To be provided by Expedia> Folder : /<file to be uploaded inside root folder> |