Delta PMS allows you to use a CSV file to update rates for multiple properties at once.
There are two ways to manage your rate data:
Manage rates separately for each property
Manage rates for multiple properties in a single file
Choose the method that best suits your workflow.
1. Download Rate Data
First, download the rate data from Delta PMS.
Steps
In Delta PMS, go to Rates → Rate Plan.
Click “Import rate”.
Select the property you want to manage.
Select the rate plans you want to export.
Follow the instructions on the screen to export the rate data.
Click “here” to download the data.
If you want to manage rates for multiple properties in a single file, download the rate data for multiple properties or all properties.
2. Choose How to Manage Your Rate Data
You can manage your rate data in two ways.
Method 1: Manage Rates Separately for Each Property
Edit the spreadsheet for each property.
Import each edited CSV file into Delta PMS separately.
This method is suitable if you want to review and manage rates on a property-by-property basis.
Method 2: Manage Multiple Properties (or All Properties) in a Single File
Combine the rate data for multiple properties into a single spreadsheet.
Import the edited CSV file into Delta PMS.
You can update rates for multiple properties with a single import.
Example
If you combine rate data for 10 properties into one spreadsheet, you can update the rates for all 10 properties at once.
3. Edit Rates in a Spreadsheet
Open the downloaded rate data in Google Sheets or Excel and edit the rates you want to change.
Steps
Open the rate data in Google Sheets or Excel.
Change the rate for the relevant property and date.
If necessary, use formulas to update multiple rates at once.
Check that the edited rates, dates, and properties are correct.
Example: Using a Formula to Change Rates
For example, if you want to set your direct booking engine rate 5% lower than the Airbnb rate, you can use a formula that multiplies the Airbnb rate by 0.95.
Example calculation
Airbnb rate: JPY 40,000
Formula: 40,000 × 0.95
Direct booking engine rate: JPY 38,000
4. Save the Edited Data as a CSV File
Before importing the edited data into Delta PMS, you must download the spreadsheet as a CSV file.
Steps
In Google Sheets or Excel, click “File”.
Select “Download”.
Select “Comma-separated values (.csv)”.
Save the CSV file.
⚠️ Important
Simply editing the rates in Google Sheets or Excel does not update the rates in Delta PMS.
You must download the edited data as a CSV file and import it into Delta PMS using the next steps.
5. Import the CSV File into Delta PMS
Upload the edited CSV file to Delta PMS to update your rates.
Steps
In Delta PMS, open “Import rate”.
Rates → Rate Plan
Upload the edited CSV file.
Follow the instructions on the screen to map the CSV columns to the corresponding Delta PMS fields.
Select the sales channels you want to update.
Start the import.
Confirm that the synchronization and update have been completed.
Selecting the Sales Channels to Update
For example, if the rate plan is connected to both Airbnb and Booking.com, you can select which sales channels should be updated when importing the CSV file.
Update Airbnb only: Remove Booking.com by clicking “Clear”.
Update Booking.com only: Remove Airbnb by clicking “Clear”.
Update both: Do not clear either channel.
If you update multiple sales channels at the same time, synchronization may take some time.
Please wait until the process is complete and then confirm that the updated rates are correctly reflected.
6. Continue Using a Rate Management Spreadsheet
Instead of downloading all rate data every time you need to make a change, you can download the rate data for all properties once and create a spreadsheet specifically for rate management.
Recommended Workflow
Download the rate data for all properties initially.
Create a rate management spreadsheet.
When changing rates, record the dates, properties, and rates being changed.
Download the edited data as a CSV file.
Import the CSV file into Delta PMS.
Keep previous rates and change history in the rate management spreadsheet.
Continuing to use a dedicated rate management spreadsheet makes it easier to review your rate change history.
7. When Extending the End Date of a Rate Plan
Extending the end date of a rate plan in Delta PMS does not automatically set rates for the newly extended period.
Therefore, you need to add the dates and rates for the extended period.
You do not need to download a new rate file every time.
You can either:
Add the extended period to your existing spreadsheet, or
Download the latest rate data from Delta PMS again.
Method 1: Continue Using Your Existing Spreadsheet
For example, if you extend a rate plan by three months, follow these steps:
Extend the rate plan end date by three months in Delta PMS.
Add the dates and rates for the additional three months to your existing spreadsheet.
Enter the data using the same format as the existing data.
Download the edited spreadsheet as a CSV file.
Import the CSV file into Delta PMS.
This method allows you to continue using your existing spreadsheet.
Method 2: Download the Latest Rate Data Again
Extend the rate plan end date in Delta PMS.
Download the latest rate data from Delta PMS again.
Edit the rates as needed.
Save the data as a CSV file and import it into Delta PMS.
Both methods can be used. Choose the method that is easiest for you to manage.
Important Points
Simply extending the end date of a rate plan does not set rates for the extended period.
Be sure to add the dates and rates for the extended period.
Enter the additional dates and rates using the same format as the existing data.
You cannot extend the end date of a Delta PMS rate plan from the CSV management spreadsheet. The end date must be changed directly in Delta PMS.
Important Notes When Extending a Rate Plan
Airbnb-connected rate plans can only be synchronized up to 730 days in advance
Rates synchronized to Airbnb can cover up to 730 days (approximately two years) from the current date.
Therefore, set the end date of rate plans connected to Airbnb within this range.
If you set an end date beyond 730 days from the current date, the period is too long and the rates cannot be synchronized to Airbnb.
The 730-day limit is not a fixed period starting from the date the rate plan was originally created.
It is calculated based on the current date when you set or extend the rate plan.
When the same rate plan is also used for Booking.com
Booking.com does not have the same 730-day limitation as Airbnb.
However, if both Airbnb and Booking.com are included as sales channels for the same rate plan, set the end date according to the Airbnb limit.
If you set rates for the next 730 days in this shared rate plan, the same 730 days of rates will also be sent to Booking.com.
This does not mean that Booking.com has a 730-day limit. Rather, the period configured in the shared rate plan is what is sent to Booking.com.
※ Rate plans that are not connected to Airbnb do not have this 730-day limitation. For example, you can set a rate plan for a period extending up to five years in the future.
The rate synchronization period and the guest booking period are different
Sending rates for 730 days to an OTA does not mean that guests can book all of those dates.
The number of days in advance that guests can make a reservation is controlled by the booking window settings on each OTA, such as Airbnb and Booking.com.
Example
If Delta PMS synchronizes rates for the next 730 days, but the OTA's booking window is set to 365 days in advance:
Rates will be synchronized for 730 days.
Guests can only make reservations up to 365 days in advance.
⚠️ Important
Extending the rate plan period does not change the booking window on the OTA.
Please check the settings and calendar on each OTA to confirm the dates that guests can actually book.
8. Summary of the Workflow
Task | How to Handle It |
Get rate data | Download the data for the applicable properties and rate plans from Delta PMS |
Manage rates | Manage each property separately or combine all properties into one file |
Change rates | Edit the data in a spreadsheet or Excel |
Calculate rates in bulk | Use formulas as needed |
Apply edited rates | Save the data in CSV format and import it using “Import Rates” |
Specify what to update | Select Airbnb, your direct booking engine, or both |
Extend a rate plan | Change the end date in Delta PMS |
Set rates for the extended period | Add the data to the existing file or download the latest data again and import the CSV |
Key Points for Operations
If you want to manage a small number of properties individually, use a separate file for each property.
If you want to update a large number of properties at once, use a single file containing all properties.
After editing, always save the data in CSV format and import it into Delta PMS.
After importing, confirm that the updated properties, sales channels, dates, and rates have been correctly reflected.
When extending a rate plan, do not forget to set the rates for the extended period.