Reservation Import
- CSV
- UTF-8
- Separator ; (Semicolon)
- Record Spacer \n (New Line)
- Escape \ (Backslash) e.g. \; will escape a contained semicolon
- Quotes: no
- First record as header: yes
- decimal separator: dot
Field Name | Description |
|---|---|
ID | unique identifier - if another import contains the same ID, the record will be updated recommended |
reservationId | in case you want to reference a specific reservation in the hotelsoftware to be updated (use hotelsoftware internal room reservation IDs only in this field) DO NOT USE |
guestProfileId | only populate with hotelsoftware internal guest profile ID if you want to associate this reservation with a specific guest profile DO NOT USE |
travelAgentId | only populate with hotelsoftware internal guest profile ID if you want to associate this reservation with a specific travel agent profile DO NOT USE |
title | |
firstName | |
name | last name |
street | |
zipCode | |
city | |
countryCode | ISO 2-character country code |
phone | preferably in international format (e.g. +43 660 737 88 90) |
| |
nationality | ISO 2-character country code |
language | ISO 2-character language code |
birthDate | any valid date (unparsable dates will be skipped on import) |
requestExpirationDate | any valid date (unparsable dates will be skipped on import) |
arrivalDate | any valid date required |
departureDate | any valid date either departureDate or numberOfNights is required |
numberOfNights | any valid date (will only be used if no departureDate is set) either departureDate or numberOfNights is required |
roomType | hotelsoftware internal room type ID (will only be used if no roomNumber is set) either roomNumber or roomType is required |
roomNumber | if neither roomNumber nor roomType is set - we will default it to a random room type either roomNumber or roomType is required |
ratePlan | hotelsoftware internal rate plan ID (the default rate plan will be used if this value is not set) required |
internalComment | |
guestComment | |
numChildren | |
childrenAge | comma separated list of children ages make sure to configure the age categories before doing the import - if no age categories do exist at time of import, all children will be imported as adults |
reservationSource | name of the reservation source - we usually recommend inserting the name of the old PMS into this field |
numAdults | required |
totalAmount | total reservation amount in english number format (e.g. 513.79) in the hotels default currency no currency signs, no currency codes, no commas |
prepaymentAmount | prepayment amount requested from the guest (for informational purposes only) |
confirmationCode | can be used to group multiple reservations together to a single group reservation |
- dd.MM.yyyy
- dd/MM/yyyy
- yyyy-MM-dd
- dd-MM-yyyy
