Since Hotel Booking 3.5.0 version it is possible to export Bookings in CSV format. This allows importing the bookings and related information to excel or spreadsheet document.
In order to export Bookings, you should navigate to Dashboard > Bookings > Reports. There you may use available options to filter the Bookings you want to export by the following parameters:
- Accommodation Type - bookings of certain accommodation type
- Status of Bookings - bookings with certain status applied
- The periods/time frames to select the booking for export between start and end dates
Once you configured these parameters you may select the columns of reservation to export. In
other words what information of the booking you would need exporting CSV file:
- ID
- Status
- Check-in
- Check-out
- Accommodation Type
- Accommodation Type ID
- Accommodation
- Rate
- Adults/Guests
- Children
- Services
- First Name
- Last Name
- Email
- Phone
- Country
- Address
- City
- State / County
- Postcode
- Customer Note
- Full Guest Name
- Coupon
- Total
- Paid
- Payment Details
- Date
The final selection is saved for further export so you would not need to unselect the unnecessary columns again with each next export of bookings.
Here is also a useful video tutorial:
NB:
Imported bookings can not be exported in CSV format as there is not delivered all the information about a guest and the price of a booking is not valid - it shows just base price. You may export such booking in iCal format via Bookings > Sync Calendar saving the file by following iCal URL.
Comments
0 comments
Please sign in to leave a comment.