The following columns must be present, these column names must be in row 1 of the CSV file with each booking on a following row. Other columns in the file will be ignored.
| Column Name | Data |
|---|---|
| Roomid | Room id to import the booking into |
| Reservation ID | Expedia Reservation ID |
| Guest | Guest name |
| Check-In | Check-In date in YYYY-MM-DD format |
| Check-Out | Check-Out date in YYYY-MM-DD format |
| Who Collects | Who collects the money (optional) |
| Status | Booking Status, only bookings with status Booked are imported |
This is possible within the expedia.com extranet.
The CSV file must be modified to specify the roomid for each booking.
Open the file you downloaded in a spreadsheet program.
Add a new column with the headline Roomid on row 1
For each booking, add the appropriate room id number to the new column called Roomid.
Save or export the CSV file using the instructions for your spreadsheet program. The file must be saved in CSV format with comma separaters in the same format (plus added room id) it was downloaded.
Make sure the date format is not changed, it must be in YYYY-MM-DD format.
Upload the file WITHOUT ticking the "Save Changes" checkbox. A report will be shown of the information read from the file. If the preview shows errors fix them in your CSV file and upload again.
Bookings with the Action "Ok to add" will be imported, otherwise the Action value will report the reason the booking can not import.
It is a good idea to upload a maximum of 50 bookings at a time. It can take up to a minute to process a file, do not re-click submit while the file is processing or you may end up with duplicate imports.
Once bookings are uploaded they can only be deleted manually so make sure they are correct before making a bulk upload.