Importing and exporting prices
Upload a new price list by entering data into a template file and importing it. An exported price list can also be adapted and re-imported to update pricing.
Importing a price list
Download template CSV file
Open the relevant price list. Click on the prices tab and choose the import button. This will open a screen where you can download the CSV file in UTF-8 format. Using the template file will ensure that the imported data will be applied correctly.
Entering data into the CSV file
The template file has columns that tell you what data can be imported.
Date: enter the date the price should be applied.
Length of stay: enter the number of nights for which the price is valid.
Active: enter a 1 if the price should be active and a 0 if the price should be inactive.
Price: enter the price. If the length of stay is multiple nights, enter the total price for those nights, not the price for a single night.
Do not set prices to 0 (zero) when trying to make dates unavailable for booking. This would result in the types/objects being available for free. Instead, make the price inactive.
Upload the CSV file
When you have completed your CSV file in UTF-8 format, you can upload it via the same import button. Choose the correct file and click 'Import'.
Exporting a price list
Exporting prices can be useful if you want to modify an existing price list or share it with another party.
Open the relevant price list and click on the prices tab. Then click the 'Export' button, and the file will be sent to the email address associated with your user account.
Are you exporting an existing price list to add prices for the upcoming year? Be sure that you only add, and not remove the prices of the current year in the CSV file.
Prices will be overwritten when re-importing, meaning that if the current prices are no longer present in your import file, they will be deleted from BEX PMS.