To open the screen, go to 'Other' - 'Settings' - 'Import bookings from CSV file'. There you can also download a sample .CSV file (opened by MS Excel, OpenOffice, etc.).
To import bookings successfully, their details must correspond exactly to the nomenclature in the system.
The nomenclature concerned here is: Room type, Room, Meal, Rate, Company. The details in these fields must be identical to those in the system. For example, if a room type in the system is set 'DBL', the corresponding room type in the import file must be 'DBL', too. The nomenclature is case sensitive.
Allowed values for the 'Status' field: expected, checked_in
'Rate' field format: the data in this field is based on the rate plan name, room type name and the rate name separated through the slash (/) character.
- You have a rate plan named BAR;
- A rate for a DBL room type in this rate plan;
- The rate name is STD;
The value in the 'Rate' field will be BAR/DBL/STD.
Field 'Country' uses the two-letter encoding of ISO 3166-1 alpha-2.
If you plan to import bookings having a manual price, please use the 'Manual price' and the 'Manual currency' fields together.
If only one of these fields is used, you will get an error when testing or importing the file:
- If you enter only one price, it will be applied to each night of the booking.
- If you want to apply different prices per night, please enter each night price as a separate value using comma as separator. The number of prices needs to match the number of nights of the booking. For example: 100,105,100 (for a three-night booking). If the number of individual prices does not match the number of nights, you will get an error when testing or importing the file.
If the fields are empty, they will not be checked during the test or the booking import.
If you plan to import the bookings having payments, please use all payment fields together - 'Payment amount', 'Payment currency' and 'Payment type'.
If you leave one or two of these fields empty, you will get an error when testing or importing the file.
If all are empty, they will not be checked during the test or the booking import
Allowed values for the 'Payment type' field: card, bank, debit, on-line, other.
Allowed values for the 'Manual currency' and 'Payment currency' fields: any currency currently set in the Clock PMS+ subscription.