Import Guest CSV

Post here if you cannot find a better category
Post Reply
[email protected]
Posts: 21
Joined: Thu Nov 30, 2017 7:29 pm

Import Guest CSV

Post by [email protected] » Thu Feb 08, 2018 12:57 am

I have recently moved to Beds24 from a previous channel manager.

Is it possible to import a database of guests. I cannot find an option in the control panel and I have a csv file from my prev channel manager with all guest details.

Thanks

annettemorgenroth
Posts: 890
Joined: Sun Jun 30, 2013 8:44 am

Re: Import Guest CSV

Post by annettemorgenroth » Thu Feb 08, 2018 2:39 pm

Welcome to Beds24!


You can upload them through a .csv file as bookings (just add dates in the past) via our API (http:/api.beds24.com/).

This is how you do it:
1. Export your bookings into a .csv file
2. Go to SETTINGS -> ACCOUNT -> ACCOUNT ACCESS and allow API Access in the 'Link' section.
3. Go to http:/api.beds24.com/
4. Click on https:/api.beds24.com/getbookingscsv.php
5. Download a sample file so you have the correct format
6. Open the file in a Excel or similar and dd your existing bookings in exactly the same format into the file
7. Upload the modified .csv file t via https:/api.beds24.com/putbookingscsv.php

The instructions in https:/api.beds24.com/putbookingscsv.php explain the procedure in detail.

For Booking.com and Expedia we have the option to automatically import all upcoming bookings. We recommend to use this method because for bookings imported directly from Booking.com we will then be able to automatically import changes. You can use this function when the channel manager is set up but not activated. The button is available in SETTINGS->CHANNEL MANAGER->BOOKING.COM/EXPEDIA.

kalaekilohana
Posts: 5
Joined: Sat Jul 07, 2018 6:45 am

Re: Import Guest CSV

Post by kalaekilohana » Wed Jul 18, 2018 10:33 pm

annettemorgenroth wrote:
Thu Feb 08, 2018 2:39 pm
Welcome to Beds24!


You can upload them through a .csv file as bookings (just add dates in the past) via our API (http:/api.beds24.com/).

This is how you do it:
1. Export your bookings into a .csv file
2. Go to SETTINGS -> ACCOUNT -> ACCOUNT ACCESS and allow API Access in the 'Link' section.
3. Go to http:/api.beds24.com/
4. Click on https:/api.beds24.com/getbookingscsv.php
5. Download a sample file so you have the correct format
6. Open the file in a Excel or similar and your existing bookings in exactly the same format into the file
7. Upload the modified .csv file t via https:/api.beds24.com/putbookingscsv.php

The instructions in https:/api.beds24.com/putbookingscsv.php explain the procedure in detail.
Aloha- I did not understand #6. What is dd? Can I modify the categories in the .cvs that I downloaded from Reservation Key to be exact matches? I'm not quite sure what this recommends.Thanks for any clarification you can provide.

annettemorgenroth
Posts: 890
Joined: Sun Jun 30, 2013 8:44 am

Re: Import Guest CSV

Post by annettemorgenroth » Thu Jul 19, 2018 7:36 am

Sorry is is a typo. I fixed this.

Post Reply