BookingLive: Online Booking System

Editting / Uploading Rates

To upload/change your Accommodation's rates you have two options:

  1. Edit the existing spreadsheet (If you have already uploaded rates).
  2. Upload Rates via a CSV file (if you uploading for the first time or want to update many rates at once).

 

Edit Spread Sheet And Save
1. Load a spread sheet with rates
2. double click on any cell to edit it
3. Hit save once you complete editing that cell, (the save button on top right, before the close button )
4. After editing all the fields you need, check hit the save link on top left
5. You will get the same type of form which is like the one you get on upload rates via a file's 3rd step 
6. hit confirm and all the rates will be updated, 
Upload Rates Via A File
1. The CSV should look like the left hand side one, first column is the Type (SDP/Season), next is the season name, thrid is the dwelling name, the other numeric columns are the number of days
2. If you leave blank cells like F4 then those rates will be 0
3. Once you upload you will get a read only spreadsheet and a small form where the upload field was before, asking for your confirmation, hit confirm button and it will save the new rates.
Type,Name,Dwelling,2,3,4,5,6,7
SDP,,,,,,,,
Season,MID Season,SEASCAPE,222,333,444,555,666,777
Season,MID Season,ADMIRAL AUSTEN,222,333,,555,666,777
Season,HIGH SUMMER,SEASCAPE,111,111,111,111,111,111
Once rates have been changed these are avaialbe to veiw from teh "archive" this means that if you have a booking that doesn't match the current rate seen - the rates that were effective at the time of the booking can be referenced instead

Edit Spread Sheet And Save

Go to ACCOMMODATION > ACCOMMODATION RATES.

  1. Double click on any rate cell to edit it.
  2. Hit SAVE once you complete editing that cell, (this is above the rates on the purple bar).
  3. After editing all the fields you need, hit the SAVE button again.
  4. Hit CONFIRM and all the rates will be updated.

 

Upload Rates Via A File

If you are going to upload rates via a CSV file, then there are several steps that you need ensure you complete:

1. Create a spreadsheet in Microsoft Excel with four columns: Dwelling, Name, Type, 1.

Dwelling - this column needs to display the [Dwelling Name] [space] Rate = [Rate Category]
e.g. Dwelling Room 1 Rate = Studio Room Bed & Breakfast.

Name - this column needs to display the name of the seasons that you are uploading on this CSV e.g. Off Peak Season / Peak Season.

Type - this column needs to always be "Season".

1 - this column is to show what the rate of 1 night would cost for this dwelling + rate category e.g. 100.

[Note: This file must be saved as a CSV (comma delimted) - click here to download this example].

 

Important Notes

  • If you leave blank cells on your CSV - then those rates will be 0 (free) and bookable on your website; make sure to remove them from the CSV if they are 0
  • Make sure your Dwelling Name, Rate Category, Season Name are all spelt exactly the same as they are in ACCOMMODATION - if they are spelt differently, they will not import.

 

2. Now go to ACCOMODATION > ACCOMODATION RATES

3. To upload your rates, see the left sidebar where it says 'Upload Rates'. 

4. Click CHOOSE FILE > Choose your file of rates > Click UPLOAD.

5. Once you upload you will get prompted to confirm - click CONFIRM and it will save the new rates.

 

Search Archived

Once rates have been changed these are available to view from the "archive" this means that if you have a booking that doesn't match the current rate seen - the rates that were effective at the time of the booking can be referenced instead