Reservations are the most complex thing for import, therefore, we require you to send us .tsv file with all the reservations you want us to import.
Please, have in mind, for this import to be free, make sure that your .tsv file contains all the required columns listed below.
Columns needed:
ID Property (required) ID of the property from OTA Sync (you can find it in the left lower part of the General settings page)
ID Room (required) ID of the room type for which the data is being entered. (The room type can be found by going to Settings > Rooms/Extras, then editing the room type and noting the number at the top next to 'Edit Room)
ID Booking (Booking ID from the sales channel). For group reservations, each room that is part of the reservation, i.e., each row, must have the same ID Booking and the same Booking Date.
Channel Sales channel from which the reservation came. If left blank, it will be a Private Reservation. To work properly, the channel name must be exactly the same as in Channels for that property and in the Excel file. For example, if Channels says 'Booking Test', it must also say 'Booking Test' in our Excel file. If not the same, it will be recorded as a Private Reservation.
Pricing Plan If not entered, it will be the Default Pricing Plan. This field is mainly used to apply a different board for each reservation. For example, if we have HB and BB and 2 pricing plans: Default Pricing Plan (with BB) and Half Board Pricing Plan (with HB), then the value of this column will be either 'Default Pricing Plan' or 'Half Board Pricing Plan'.
Total Value (required) Total value of the room price with the board.
Booking Date (required) When the reservation was created. Must be in YYYY-MM-DD format.
Check-in date (required) Arrival date. Must be in YYYY-MM-DD format.
Check-out date (required) Departure date. Must be in YYYY-MM-DD format.
Adults Number of adults.
Child Number of children.
First Name (required)
Last Name
Email
Nationality Must be either ISO2 (2 letters like ME, RS, HR) or full name in English like Montenegro, Serbia, Croatia for it to work.
Phone
Gender Must be in M or F format for it to work.
Birth day Date of birth. Must be in YYYY-MM-DD format.
Document Type Type of document. Can be: 'passport' or 'id'.
ID Number
Country Issued Must be either ISO2 (2 letters like ME, RS, HR) or full name in English like Montenegro, Serbia, Croatia for it to work.
Country of Residence Must be either ISO2 (2 letters like ME, RS, HR) or full name in English like Montenegro, Serbia, Croatia for it to work.
Guest Address
Guest City
ZIP Code
Note