When switching to Guesty's direct integration with Vrbo from another PMS/channel manager, all existing reservations in your Vrbo portfolio must be mapped in order to be managed by Guesty. To upload your existing Vrbo reservations to Guesty, contact us with this template in CSV format. Please note that the template must follow the exact format otherwise the upload will fail.
Important:
Please ensure that you have set up your taxes and commission rules in the account or relevant listing before uploading reservations. Otherwise, it will not be added to the reservation.
Mandatory Fields:
- accountId: Guesty Account ID (ex:563e0b6a08a2710e00057b82)
- listingId: Guesty Listing ID (ex: 59340fbed0140d1000c49f2f)
- firstName: Guest first name (ex: Lucy)
- lastName: Guest last name (ex: Perricone)
- numberOfGuests: Number of guests (ex: 7)
- checkIn: Date - YYYY-MM-DD (ex: 2019-07-22)
- checkOut: Date - YYYY-MM-DD (ex: 2019-07-23)
-
status: One of the following:
- Confirmed
- Reserved
- Inquiry
- currency: Currency (ex: USD)
-
source: uploaded_VRBO
- NOTE: This is case sensitive. "uploaded_vrbo" is not valid, it must be "uploaded_VRBO"
Optional fields:
-
accommodationFare: Accommodation fare (ex: 13828.2)
- If not provided, the price will be calculated according to the daily prices.
-
cleaningFee: Cleaning fee (ex: 50)
- If not provided, the listing cleaning fee definition will be used.
-
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. See a list of accepted fee types here.)
- Additional fee name: (ex: Breakfast)
- Additional fee amount: (ex: 100)
- 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:
-
Fully paid: If you fill out this field, "Payment method" is mandatory:
- Boolean (ex: TRUE)
-
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.
-
Payment method: One of the following:
- Cash
- Credit card
- Debit card
- E-check
- phone: Phone number (ex:16266883744)
- email: Guest email.
- confirmedAt: Date - YYYY-MM-DD (ex: 2019-07-22)
