If you have multiple properties and would like to update the rates across more than one at the same time, you can do so by bulk updating your rates.
First, navigate to Account > Defaults and scroll down to the bottom to find "Bulk Update Rates." Click "Expand."
1. Delete Rates First?
- No: Any custom rate periods that have already been created for your properties will remain. Note: If any of the new rates you are bulk updating conflict with existing dates, you will get an error.
- Yes: This will remove all existing custom rates, past and present. Note: The standard rate will not be deleted.
2. Upload Rate Data
- Use the provided CSV template in the Bulk Update Rates section, or download the file below.
- See below instructions for correctly inputting data into the spreadsheet.
- Important! The file must be saved as a CSV in order to upload.
Adding data to the spreadsheet
Now that you have downloaded the Rates Import Template, you will need to correctly enter data in order to successfully bulk update your rates.
Step 1: Open the csv file
You can use Microsoft Excel, Open Office, Google Sheets, etc. We have found that Google Sheets is the easiest to work with for this purpose.
In Google Sheets, create a new sheet, then click File > Import > Upload, then select the RatesImportTemplate.csv file from your computer.
Step 2: Enter Data
Standard Rate: Enter the property number and corresponding rates, but leave the 'Label,' 'Start Date' and 'End Date' columns blank.
Seasonal/Holiday Rates: 'Label,' 'Start Date' and 'End Date' are required fields
Changeover days: If you have this requirement, it must be entered for each day of the week. You have several options for entering this value: true/false, 1/0, or y/n. The first digit will always represent Sunday, the second Monday, and so on. So if your changeover day is Saturday only, it should look as any of the following:
- Minimum stay through: If you have this requirement, it must be entered for each day of the week. Enter 7 digits from 0-7, each separated by a comma (no spaces). Again, the first digit will always represent Sunday, the second Monday, and so on. So if you have a minimum stay of 3 nights for Friday and Saturday and 2 nights every other day, it would look as follows: 2,2,2,2,2,3,3.
- Do not use punctuation other than decimal points. Entering $ signs or commas will result in errors. So if the rate should be $3,000 enter it as 3000.
- Dates should be formatted as either of the following examples: 10/01/2018 (month/day/year) or 2018-10-01 (year/month/day).
- If using the minimum stay through or changeover day settings, you must enter values for all 7 days of the week. The first number will always represent Sunday.
Step 3: Save the document
- In Excel, click File > Save As. Under format select 'Comma Separated Values (.csv)'
- In Google Sheets, click File > Download As: Comma-separated values (.csv, current sheet).
Step 4: Upload the document
- Navigate back to Account > Defaults: Bulk Update Rates.
- Click 'choose csv.' This will allow you to select a file from your computer.
- Once selected, click the 'Bulk Update' button. You will have to click it once more to confirm.
If the upload is successful, you will see a message in green similar to the following:
If the upload is not successful, you will receive an error message similar to the following. You will need to rectify the error(s) in the original document and try uploading again.