Skip to main content

Alternative: importing accommodations, guests, and transactions using your own file

See which data and CSV files are required to provide accommodations, locations, guests, and transactions for import.

Alternatively, you can provide the files for the import yourself. All files must be provided as .csv files with UTF-8 encoding. Most systems that export data can export it in the required format.

Accommodations

To import accommodations, we require the following information:

  • Reference (ID from the previous booking system)

  • Accommodation name

  • City (optional)

  • Address (optional)

  • Postal code (optional)

  • Country (optional)

  • Longitude (if the accommodation may be displayed on a map)

  • Latitude (if the accommodation may be displayed on a map)

Locations

To import locations, we require the following information:

  • Reference (ID from the previous booking system)

  • Number (the name of the location)

  • Accommodation name

  • Accommodation reference (ID from the previous booking system)

Guests

To import guests, we require the following information:

  • Reference*: this must be a unique number for each guest. For example, this can be a reservation number.

  • Email address*

  • Type: this can be private individual or company.

  • Initials

  • First name

  • Last name*

  • Name prefix

  • Company name

  • VAT number

  • Salutation

  • Phone number

  • Phone number (home)

  • Phone number (work)

  • Address

  • House number

  • House number addition

  • Postal code

  • City

  • Municipality

  • Country: use a two-letter country code, such as NL, BE, DE, or FR.

  • Language*: use two letters according to the ISO 639-1 standard, for example nl, de, or fr.

  • Date of birth: use the Y-m-d format, for example 1970-05-27.

  • Place of birth

  • Membership number

  • License plates

  • Access code

  • IBAN

  • IBAN account holder

  • BIC

  • Comments

  • Newsletter

  • Guest group

Transactions

Please note: We can import transactions from the previous system, but any connection between these transactions and an online payment provider will be lost. The transactions will continue to function largely the same way, but you will, for example, no longer be able to refund them online.

To import transactions, we require the following information:

  • Reservation number*

  • Payment method

  • Amount*

  • Date*

  • Type*: this can be a payment or refund.

Did this answer your question?