[ 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.