Base Pricing: How the Base Prices for Campsites Report Works

Learn more about the Base Price for Campsites csv file.

New to Base Pricing in Campspot? Check out these articles as well:

Base Pricing: How To Update Nightly Rates for Campsites

Base Pricing: Add New Site Type

What is Base Pricing?

Campspot's Base Pricing applies 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 Prices for Campsites Report

The Base Prices for Campsites is found through either:

  1. Reporting
    • Search for Base Prices for Campsites Report
    • Click the STAR in front of the report to Add to Favorites
    • Click on the report
    • Complete the required fields in the Run Report dialog box
  2. Campground Setup
    • Click on Properties
    • Click on Base Pricing
    • Click on Pricing Templates (you will be redirected to the Reports page)
    • Click on the report 
    • Complete the required fields in the Run Report dialog box

The Excel Report Downloaded

When the report is downloaded, you will click to open the Excel document. On the report, you will find:

  • Column A on the report contains the system generated site type ID (or add-on ID)
  • Column B contains the system generated site type name (or add-on name).

The information found in Columns A & B are very important. These values are used to associate the base prices from this report 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 report must match what is uploaded to Campspot otherwise your base pricing will not work.

  • The remaining columns will have dates and pricing information for each Site Type (more information below).

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 (to see examples of this, click here to learn more.)

If multiple years of prices are being added, the date ranges can be grouped first by year and then highest priced date range.

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)  

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. 

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. Below is an example of adding rates for weekends versus weekdays.

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: weekend, week, holiday, 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 Prices for Campsites 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 for Campsites 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 report. 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.

Q: How do I add a new Site Type to current Base Prices?

After creating a new Add-on or Site Type, the new site will not be added to the Base Prices for Campsites report. This report pulls active pricing and the associated Site Types' data into the report. As the new Site Type will not have any pricing data, it will not be on this sheet.

You will need to add the information to the Base Prices for Campsites report.

In searching Campspot's Reporting for "base price", one of the results you will see is another version of this report, called Base Prices for Campsites Template report.

By running and opening this report, you will find the Site Type ID and name.

The ID and name should be copied and pasted into the Base Price for Campsites report sheet.

Do not upload the Base Prices for Campsites Template report into your system without consulting support. This version of the report will erase very important information about your current rates.

Only upload the Base Prices for Campsites report with updated rates on it.