This feature allows you to upload historical reservations into PriceLabs when switching PMS systems, or when reservations exist in the PMS but cannot be automatically retrieved by PriceLabs. It can also be used to update booking dates if they are incorrect in the PMS or to upload reservation block information that PriceLabs has not received.

Before You Start

• This feature is available on request. Please contact support@pricelabs.co to request access.
  
• Only use this feature for reservations that do not exist in PriceLabs or if the booking date is incorrect.
  
• Important: This feature should not be used for current or ongoing reservations already present in the PMS, as these will be automatically synced every 24–36 hours by PriceLabs.

Uses of Manual Reservation Upload

• Upload old historical reservations when PMS switching occurs and data transfer options are unavailable.
  
• Upload direct or offline bookings that PriceLabs cannot retrieve from the PMS API.
  
• Update booking dates when they are incorrect in the PMS.
  
• Upload reservation block information if the PMS does not send this data to PriceLabs.
  

1. Navigate to Portfolio Analytics (KPIs and Historic Reports).
   
2. Click on the three vertical dots in the top right corner.
   
3. Download the sample CSV file.
   
   
4. Fill in the necessary information and upload the file.
   
   
5. After uploading, you will receive an email with success or failure details in an attachment.
   

Correcting Booking Dates for API Reservations

Points to Note

1. Listing ID: Ensure it matches the one in PriceLabs, or the upload will fail
   
   
2. Make sure listing_id column is in text format.
   
   
3. Mandatory Columns: listing_id, pms_name, start_date, end_date, total_cost (if status is booked), rental_revenue, currency (ISO3 format) & pl_status.
   
4. Listings must be unhidden in your PriceLabs account, and Portfolio Analytics should be enabled for the respective PMS.
   
5. Reservation_ID: Optional. If not provided, the system will generate it based on the format: Listing ID _ Start Date _ End Date
   
6. Total_cost and rental_revenue must not be less than or equal to 0 if the pl_status is booked. Please make sure total_cost, rental_revenue and all other revenue related fields should be in numeric form without any symbol or text in it. Example - $25, USD25 are both incorrect ways to provide values.
   
7. booked_time cannot be left blank if the status is booked
   
8. To modify or update any entry, please upload the revised data using the same reservation ID, or use the above-mentioned format if it was not provided earlier. Furthermore, you can download all reservations with reservation IDs from the 'Trends by Booking Creation Date' section by selecting 'Bookings' in the graph option and downloading the CSV.
   
9. pl_status Options: booked, blocked, cancelled & available.
   
10. Booking Source Options: airbnb, vrbo, bcom, manual & others.
    
11. A maximum of 5000 entries can be updated at a time
    
12. If pl_status is canceled, mention cancelled_time else the upload will fail
    
13. Do not remove or tamper with mandatory columns. Users can re-order or delete optional columns during upload.
    
14. Booked time cannot be greater than start date & end date. Please note booked time is actually is booked date in the below mentioned acceptable formats.
    
15. Ensure the file type remains as CSV. Save as should be used to change the extension if needed (don't use rename to change file extension).
    
16. Accepted date formats: YYYY-MM-DD, DD month YYYY, DD.MM.YYYY (e.g., 2019-01-19, 19 January 2019, 19.01.2019.
    
17. Sometimes in case of large numbers, csv tend to convert them in scientific notation. Make sure you click on 'Don't convert' to keep the original non scientific format as shown in screenshot below.