Skip to main content

How To Import Booking

Overview

The Import Booking feature allows you to create multiple reservations at once by uploading an Excel file.

To maintain system performance, the following limits apply:

  • Maximum 300 reservations per file upload.
  • Maximum 100 nights per reservation.
  • Maximum 600 reservations imported within a 24-hour period.

How to Import Reservations

Get the Property Information

Before importing reservations, you need to identify the Room ID and Rate Plan ID that will be used in the import file

  1. Navigate to Bookings > Booking List, then click the Import button on the Booking List page. https://res.cloudinary.com/dayo5hqig/image/upload/v1782116320/booking-list-menu_q2farc.png
  2. You will be redirected to the Import Booking page. import-booking-page
  3. To view the available room and rate plan information, click Property Information. !property_information
  4. To view OTA-related information, click OTA/Channel Information. ota-information

Download and Complete the Import Template

While on the Import Booking page, prepare your reservation data using the provided import template.

  1. If you do not already have a template file, click Download Import Template. download-template
  2. You will be redirected to Google Sheets.
    redirect-to-google-docs
  3. In the Google Sheets menu, click File > Download > Microsoft Excel (.xlsx) to save a copy to your computer.
    download-sample-file
  4. Open the downloaded file and enter the reservation information. The following fields are mandatory and cannot be left blank: Room ID, Rate Plan ID, Booking Status, Booking Date, Arrival Date, Check In Date, Check Out Date, Total Night, First Name, Last Name, Country, Tax Total, Total Room Rate, Total, and Currency Code. open-and-edit-the-file

Upload the Completed Template

  1. Select the completed Excel file from the upload field.
  2. Click Import to upload the reservations and wait until the import process is completed.. import-booking

Verify the Imported Reservations

After the import process is completed, verify that the reservations have been imported successfully.

  1. Navigate back to Bookings > Booking List.
  2. Confirm that the imported reservations appear in the booking list. verify-imported-reservations