Skip to main content

Hotels

Distribution Master files contain the product you will buy and sell in our Marketplace: hotels, mealplans and other required data to apply your business rules subsequently.

Create and update your hotels.

info

On the HotelCode you'll need to add the same codes that you have specified or will specify in the Mapping Files.

Create and Upload your Hotel Master File​

To get started, create your hotel master file in the correct format and then upload it to your SFTP account. We've provided a template file below ⬇️ to help you with this process. Just click on the file name, add your data, save it in CSV format, and then upload it to the corresponding folder in your SFTP.

sftp.xmltravelgate.com

📁Distribution
     📄Master_Hotels.csv

File Format Specification​

  • File Name: Master_Hotels.csv
  • Directory: Distribution
  • Delimiter: Vertical line (|)
  • Header Row:
    • HotelCode (mandatory)
    • HotelName (mandatory)
    • Address
    • Longitude: Decimal Degrees DD (e.g. 39.637070)
    • Latitude: Decimal Degrees DD (e.g. 2.63170357)
    • Phone: Phone prefix + number (e.g. +34666666666)
    • CategoryCode: Number (e.g. 5)
    • CategoryName: Number + name (e.g. 5 stars)
    • CityCode
    • CityName
    • ISOCountryCode: 2 chars
    • ZIPCode
    • ChainCode
    • ChainName
  • Note:
    • The data of the fields is not encapsulated by " or any other character.
    • Each line represents a unique hotel and contains all the information (fields) about it.
    • Any blank line will be skipped.
    • If a field’s data is not mandatory and we don’t want to set it then we just keep it empty: e.g. …||…
    • The file and its data have to be encoded using UTF-8. Otherwise there can be stored strange characters.
📹 Learn how to change the format of the csv file in order to edit and save it
TAKE INTO CONSIDERATION
  • If a hotel exists then it is updated.
  • If a hotel does not exist then it is created.
  • Existing hotels that are not referenced are not removed.
  • If an existing hotel has to be removed from system then you have to contact with Travelgate.
  • If there is any problem with a hotel’s information then it is omitted (and logged) but the load continues.