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.
You can use the printable price table to create a CSV file.
This means you only need to amend the prices and not start from scratch. Though, it is also possible to start a completely new table in the spreadsheet of your choice and use it for the CSV-file creation.
1. Go to Properties > Edit > Price planner on the right > Go > click the Printable prices button
2. Select the year and click Go
A table like this will be created.
Select the contents of the table and paste it into a spreadsheet
3. Convert the dates from e.g. Thu 31 Mar 2022 to 31/03/2022.
Repeat this for all dates in the table.
Please note:
It is important to make sure the below rules are followed.
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/2025 and end when desired (e.g. 31/01/2025).
IMPORTANT:
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.
Example:
The file name must not be longer than 20 characters.
This-name-is-way-too-long-as there-are-too-many-characters.scv
This-name-is-fine.csv
Example:
There must not be any other characters in the file name other than
letters
number
- (hyphen)
_ (underscore)
This_is_file-123.csv -> The file name is okay.
This is file 123.csv -> The file name will cause an error.
First,second,third list.csv -> The file name will cause an error.
The_right_name?.csv -> The file name will cause an error.
12-15-2024 prices.csv -> The file name will cause an error.
4. Add a column for the number of guests.
Please note:
All fields need contain 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 note:
If no per person pricing is being used, then this column needs to be filled with 0.
The pricing import tool will assume full occupancy by default.
If per person pricing is being used every number of guests needs to have it's own row with prices.
6. Delete the header row.
Please note:
Headers are for example only.
There MUST NOT be any headers in the file when it is being saved.
The final table needs to look like this.
7. Save the file as CSV file without any further formatting.
Please note:
The below screenshots still show the headings. this is for illustration purposes only to make it clearer which prices have been added.
If the csv-file is not being imported, please ensure you have followed the below steps when preparing the file 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.
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 scroll to the bottom of the page and click Import prices.
Please note:
Importing prices will remove all existing prices in the SuperControl price planner for the property you are updating the prices using the import of a CSV-file.