Uploading Reservations Into Guesty From Channels (Except Vrbo)

Have more questions? Submit a request

We can assist in uploading your existing reservations into Guesty.

For Vrbo, follow these steps. For all other channels, follow the steps below.

Step by step:

  1. Download this csv file.
  2. Fill out the form following the below guidelines for each field. Do not alter the headers of the template or our system may not be able to read the file.
  3. Send the completed template to Customer Solutions.

Template Mandatory Fields 

  1. accountId - Account ID (Leave this blank, to be filled in by Guesty)
  2. listingId - Listing ID (ex: 59340fbed0140d1000c49f2f) Find your listing ID
  3. firstName - Guest first name (ex: Lucy)
  4. lastName - Guest last name (ex: Perricone)
  5. numberOfGuests - Number of guests (ex: 7)
  6. checkIn - Date - YYYY-MM-DD (ex: 2019-07-22)
  7. checkOut - Date - YYYY-MM-DD (ex: 2019-07-23)
  8. status - One of the following:
  9. Confirmed
  10. Reserved
  11. Inquiry
  12. currency - Currency (ex: USD)
  13. source - String (ex. External)

Template Optional Fields

  1. accommodationFare - Accommodation fare (ex: 13828.2)
    •  If not provided, the price will be calculated according to the daily prices.
  2. cleaningFee - Cleaning fee (ex: 50) 
    • If not provided, the listing cleaning fee definition will be used.
  3. Additional Fees - (If one of the following fields is filled, the rest are mandatory):
    • The template includes the ability to fill in up to 3 additional fees per reservation. To add more, add the following 3 columns for every additional fee you want to add on top of the available columns in the template:
      • Additional fee type - (ex: additional bed, air conditioning, pool, etc.)
      • Additional fee name - (ex: Breakfast)
      • Additional fee amount -  (ex: 100)
  4. Fully paid  - If you fill out this field, "Payment method" is mandatory:
    • Boolean (ex: true)
  5. money.totalPaid - If you fill out this field, "Payment method" is mandatory:
    • Number (ex: 500). Only use this field if the reservation was only partially paid for.
  6. Payment method - One of the following:
    • Cash
    • Credit card
    • Debit card
    • E-check
  7. phone - Phone number (ex:16266883744)
  8. email - Guest email.
  9. confirmedAt - Date - YYYY-MM-DD (ex: 2019-07-22)
Was this article helpful?
0 out of 0 found this helpful