Learn how to fill out or make changes to the base price template file for a successful upload.
The base prices apply nightly prices to reservations based on the site type. Base prices can be set for specific days of the week and date ranges. In order for a site or add-on to be bookable it must have a base price. A site or add-on will not be available in a reservation site search if it does not have base prices. The error message "No Sites Available" is an indicator that there are no base prices for the site type.
Base Price Template
The Base Price Template is found in Campground Setup > Properties > Base Pricing > Go to Pricing Templates. Column A on the template contains the system generated site type ID (or add-on ID) and column B contains the system generated site type name (or add-on name). These values are used to associate the base prices with the site types or add-ons in Campspot. When adding new items to your current base price sheet the ID's and names listed in the template must match what is uploaded to Campspot otherwise your base pricing will not work.
Add a new Site Type to current Base Prices
After creating a new Add-on or Site Type, the type ID and type name will be found on the Base Price Template. The ID and name can be copy and pasted into the Base Price sheet. The Base Price sheet is the base pricing currently uploaded to Campspot. This can be found in Reporting > Search: "Base Price". There is a separate Base Price sheet for campsites and add-ons. A site type or add-on type must be set up and currently active in Campground Setup > Unit Setup before base prices can be added.
Pricing Date Ranges
Column C is the first column used for pricing. The pricing date range column(s) should be organized left to right with the highest priced date range(s) coming first. This will ensure that the higher price is read first should any date ranges overlap. If multiple years of prices are being added, the date ranges can be grouped first by year and then highest priced date range.
Row 2 is always the start date of the range and row 3 is always the end date. The date should always be formatted mm/dd/yyyy. Row 1 is always the days of the week the price is applicable to during the date range. Days of the week must be abbreviated and separated with commas as follows: Sunday (Su), Monday (M), Tuesday (T), Wednesday (W), Thursday (Th), Friday (F), Saturday (S).
Changing Price based on the Day of the Week
To offer a different price on different days of the week, copy the date range column and paste to the right of the original date range column. Then adjust the applicable days of the week in row 1 for the new column. Columns with the same date range cannot have the same day of the week in both columns. Each date range must account for all days of the week, but this can be accomplished with multiple columns as shown below.
How to Set Up Weekend Prices
- Copy and paste the date range column the right of the original.
- In the original date range column set the days of the week to Su,M,T,W,Th.
- In the second date range column set the days of the week to F,S.
- Enter the weekend price for each site type in the date range column that applies to Friday and Saturday.
Changing Price based on Dates
Additional date range columns can be added to the Base Price sheet to accommodate price fluctuations based on the weekend, week or season. This is done by copying and pasting an existing date range column and updating the start and end dates and site type prices. The date range(s) included on the Base Price sheet need to cover all future dates you would like to have reservations bookable for. If a date range is not included on the Base Price sheet it will not generate a site to select when searching for reservations on the reservation grid.
Can Date Ranges Overlap?
Date ranges on the Base Price Template can overlap and the price that comes first when reading from left to right will be applied. The ability to overlap date ranges reduces the amount of date range columns needed to produce rates for the entire year.
Prices based on Length of Stay
Prices based on the length of stay cannot be included in the base price template. The values entered in the base price sheet as the price for a particular site type are applied as nightly prices. Weekly, monthly and seasonal rate are configured using package rules. Follow these steps to setup stay length based package rules.
Uploading Base Pricing into Campspot
Once you have made all the necessary changes to the Base Pricing sheet you will need to save the file to your computer. It is recommended you have a specific folder that contains these files so you have a record of any changes and past base pricing. Past Base Pricing sheets are not stored in Campspot. Go to Campground Setup > Properties > Base Pricing. You will select either upload campsite pricing or add-on pricing. There will be a notification in green at the top of the screen when pricing has successfully uploaded. If you have a large Base Price file, it may take a few moments to see the upload confirmation. All current base prices can be downloaded from the Reporting section.