Please ensure you follow the below steps in preparation for importing the prices
- Start date and End date should be formatted as dd/mm/yyyy
- There should be no headers in the file
- The 'pax' (number of guests) column should be 0 (zero) for full occupancy
- No currency signs, e.g. £, only numbers in the file
- If using daily prices ensure you include a weekly price in the last column
- Please ensure the start date and end date are different between price bands.y
For example, a price band will start on the 01/01/2025 and ends on the 07/01/2025; the next price band should start the following day 08/01/2019 and end when desired (e.g. 31/01/2025).
Please make sure the END date of the last price band must NOT have a date in the following year.
Example:
start date - 10.12.2025
end date - 06.01.2026
The correct latest end date should be 31.12.2025.
If the dates of the last price band are spanning over two year / arch into the following year, the system will not be able to import the data provided.
It is also important that you save the file in the correct CSV format. View a video on how to do this in Excel.
01/01/2019 | 07/01/2019 |
08/01/2019 | 31/01/2019 |
Here is an example on how the CSV file should be formatted:
Headers are for example only. DO NOT include headers in the file.
Please note:
All fields need to be containing content. If you do not charge a price for e.g. a set number of nights, please make sure to enter 0 (zero) into the field.
Please make sure you use the CSV-file format without any further encoding, e.g. UTF-8
You can import your prices from a CSV file directly into SuperControl.
Please email our Client Care team at [email protected] to enable this function in your account.
Preparation of the CSV file
Importing the CSV file
Please note:
The import function needs to be enabled in order for you to be able to import your prices SCV file.
Should you not see the import button, please contact our support team and request the import function to be enable for your account.
1. Go to Properties > Edit > Price planner (to the right of the property) > Go.
You will see a new CSV Price Import button on the top right section of the screen.
A new page will open for the import.
2. There are three Price models you can select from the drop down.
The option you select needs to be in line with the property settings.
Fixed price for number of nights
The prices are set for a specific number of nights, e.g. 4 nights. There is no distinction between bookings for weekdays or weekend days.
Fixed price for number of nights (midweek and weekend)
This option needs to be used when different prices are being used for midweek and weekend breaks, e.g. 4 nights weekend £500; 4 nights midweek £300.
Please note:
Any booking containing a Friday or Saturday is regarded as weekend booking.
For both the above options this property settings this option has been selected:
Nightly prices
This needs to be selected when the prices are setup weekday specific, e.g. Monday £150, Tuesday £175 etc.
In the property settings this option needs to have been selected.
3. Select the property you are importing the prices for.
4. For Use end date select the option Yes - uploading prices with start and end date.
5. Choose your CSV file with the prices.
Then click Upload.
The next screen will let you review the prices before you can scroll at the bottom of the page > click Import prices.
Please note that importing prices will remove all existing prices in SuperControl for the year you have entered in the CSV file.
------------------------
------------------