Overview
"Booking Import" is a feature that allows you to manually and collectively import bookings into AirHost by uploading data in CSV or Excel format.
This section explains how to import bookings and how to map the relevant fields.
Detail
Steps to Use Import Bookings
1) Click Dashboard > Import & Export > Import Booking.
2) Click [Import Bookings].
3) Select the property to import into, then upload the data file you wish to import.
If "All Properties" is selected in the property selection box, you can choose a property.
If a specific property has already been selected, it cannot be changed.
|
4) Proceed to Next Step to map the items you want to import.
Learn more about mapping
 |
If this is your first time using Import Bookings, there will be no data in [Mapping Configuration].
By using [Save Template], you can save a template and reuse it for future Import Bookings.
5) Proceed to Next Step to finalize the format after import.
Once you have confirmed , click Confirm Import to begin the import.
 |
6) Verify that the import is complete.
Return to the import booking list,
If the status is [Completed], the import has been successfully processed and the data has been reflected.
If the status is [Processing], please wait for a while and check the import status again later.
 |
About mapping
All Confirm 
|
|
Confirm Mapping  |
|
Ignore This Column 
|
|
Select which column from the imported data should be mapped to each field prepared by AirHost. Some fields require mandatory mapping between the imported values and AirHost values (e.g., Room Number). |
|
The "Remarks" field allows you to select multiple columns and merge them into a single field. |
|
Please ensure to select the correct date and time format. |
|
To unmap a field, hover over it and click the ✖ icon. |
|
Fields Provided by AirHost
Confirmation Number | It will be imported as the reservation number, which is also used for search purposes. 
|
Room Type | Room Type |
Room Unit (set only for hotel type) | Room Number |
Checkin date | Check-in date |
Checkin Time | Check-in time |
Checkout Date | Check-out date |
Checkout Time | Check-out time |
Booking Status | It will be imported into [Booking Status]. 
|
Adults | Number of adults |
Children | Number of children |
Infants | Number of infants |
Booked Date | Reservation date and time, reservation confirmation date |
Referred | Reservation site |
Remarks | It will imported into Guest Remark  |
Booking Fee | Total amount invoiced |
Paid Amount | Total amount received |
Channel Fee | OTA commission |
Cleaning fee | Cleaning fee |
First Name | First name of the guest |
Last Name | Last name of the guest |
Email address of the guest | |
Phone | Phone number of the guest |
Address | Guest address |
City | City from the guest's registered address |
State | Prefecture from the guest's registered address |
Country | Country from the guest's registered address |
Nationality | Nationality of the guest |
Company | Company name of the guest |
Zip | Postal code from the guest's registered address |
Display Name | Display name of the guest  |
Booking Import History
You can check the history of your booking imports.
 |
Manage Template | Allows you to manage “templates” where mapping settings for imports are saved. |
Filter Function | You can filter and view the history by selecting one of the following statuses: All / Pending / Processing / Failed / Completed.  |
Property | Property name |
Status | Import Status |
Attachments | Click to download the file used for the import |
Operator | User who handled the import |
Created Date | Date and time when the import was performed |
Actions | Allows you to check import details and error information  |
When Import Fails |
1. In the history with status: Failed, click [View]
|
2. The details of the error are described.
 |
If the error details are unclear, please take a full-screen screenshot while the booking import details are displayed, and send it to our support staff via the AirHost chat support.
How to Modify Reservation Details
To change certain reservation details, such as the rate plan or stay dates, you must edit the original CSV file and upload the updated file again.
During re-import, if the reservation number in the CSV matches an existing reservation, the corresponding reservation will be overwritten and updated with the latest information from the file.
Please note that fields such as the guest name, email address, and phone number can be edited directly from the reservation details page.
Limitations of CSV-Imported Reservations
The CSV Import feature is designed for importing reservation data from third-party PMS systems (e.g., NEC PMS, inCharge7, etc.). As a result, there is no option to select or specify a payment method during the CSV import process.
For reservations with a payment amount entered in the CSV file, the reservation will automatically be registered as OTA Prepaid (OTA Collect).
In addition, reservations created via CSV import have certain restrictions compared to regular reservations. Some reservation details cannot be edited in the same way, and therefore the "Edit Reservation" option may not be displayed.
If you need to change the payment method, please review the source data used for the import and update it to the appropriate payment type before re-importing.