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

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: 1335
Joined: Sun Jun 30, 2013 8:44 am

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

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: 1335
Joined: Sun Jun 30, 2013 8:44 am

Sorry is is a typo. I fixed this.
Post Reply