Import bookings via CSV

From Beds24 Wiki
Revision as of 14:08, 22 April 2022 by Lesley (talk | contribs) (Created page with "Category:Customise_Control_Panel Category:Daily_Use <div class="heading">Bookings</div> This page is about formatting the data in your .csv file to importing bookings...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Bookings
This page is about formatting the data in your .csv file to importing bookings existing bookings through our API. 

1 General

Bookings must have a checkin between 1 year in the past and 5 years in the future. The data in the .csv file must be in the correct format before you try to upload the data to Beds24.


1.1 Setup the data to upload

Step 1: Download your bookings from Switch

You will have a file which looks like this:

Switchxls.png view large


Step 2: Modify the downloaded file

  1. Delete all rows above the column headings (here the first four rows)
  2. Delete all bookings for future dates from Airbnb, Booking.com, Expedia.

You should import these directly from the channels so the channels can update them to Beds24.

  1. Exchange the header names to match the names Beds24 uses and
  • Name =
  • E-Mail =
  • Phone =
  • Room =
  • Pax =
  • Source =
  • Status =

Valid values for the status column are the New, Confirmed, Cancelled Request or Black.

Booking = ID Booking Date Check In To reliably import dates use the FirstNight and one of LastNight or CheckOut columns (no space between words), the dates should be in YYYY-MM-DD format (i.e. 2015-01-30).

If the dates are not in YYYY-MM-DD use the date format selector to specify the order of month and date.

Check Out To reliably import dates use the FirstNight and one of LastNight or CheckOut columns (no space between words), the dates should be in YYYY-MM-DD format (i.e. 2015-01-30). If the dates are not in YYYY-MM-DD use the date format selector to specify the order of month and date. Arrival Time Room Type = Roomid The Roomid number must be set to a room id in your Beds24 Proeprty, otherwise the booking will not import. (Go to Settings > Properties > Rooms > then you can see the Room id) Is Group =

The REF number must be blank for new bookings or the booking id number of an existing booking to modify it. If it is the word GROUP, the booking will be added as a new booking to the previous booking in the file to create a booking group.


Your file should now look like this:

Switchxls1.png view large

Step 3: Create .csv file Use the “Save as” function in your spreadsheet programme and save the file with UTF-8 encoding and use commas, tabs or semicolons to separate the data fields.

1.2 Allow access to your Beds24 Account

Step 4: Allow Beds24 to upload your .csv file

  1. Go to (SETTINGS) > ACCOUNT > ACCOUNT ACCESS
  2. Enable the setting “API without API key” by setting it to “Allow Any IP”.

1.3 Upload existing bookings

Step 4: Make a test upload

  • Copy the .csv file you have created and remove all booking except for one or two.
  • Go to, https://api.beds24.com/csv/getbookingscsv
  • Insert your Beds24 username and password and set a date range where you know that there is a booking.
  • Check if the booking is imported as you expect.

Step 5: Upload If the test booking is imported as you expect, upload the file which contains all bookings.