Updating dates, rates, and available for multiple tours using Accelerate

Updating dates, rates, and available for multiple tours using Accelerate

Overview

  1. Importing Trip Data
  2. Updating Prices for trips
  3. Special note for group / slab pricing
  4. Updating Open slots for trips
    1. Opening a new slot
    2. Modifying a currently open slot
    3. Closing a slot
  5. Verifying the changes
Please follow the following steps to learn more about updating Prices & Rates and Availability of 1 or multiple tours.

Before you begin, please do make sure that your Accelerate account is active and connected with Google Sheets. If you are unsure, please read the support article on how to activate Accelerate

Importing Tour Data

Please check this support article: Importing tour Data to Accelerate sheet

Adding/modifying prices for trips

After ensuring that you have selected and pushed data for existing tours, check the TripsPricingData sheet whereyou will be able to see the entries of availability of the trip along with the price and capacity

Note: Accelerate can be used to open new availability slots only when you already have at least 1 slot opened from the admin panel. If you try to push the data of a trip which doesn't already has open slots then the TripsPricingData sheet will not contain any row related to that tour.



Scroll to the left and find the Pax categories such as Adult, child etc and set the price accordingly (refer screenshot below, in column S and T in this example)

Set the prices as you desire and then go to Column A, titled Action, and type in Edit (refer screenshot below)

Finally, go back to the Accelerate Plugin Page and click on Update Trip Data (refer screenshot below). This will pull the new data (pricing) from the Google Sheet and update the tour in your Vacation Labs account.

You can go back into the sheet and check for the text in the Action column (column A) if the prices gets pushed without any issues then you will get a Success text (refer screenshot below)

Special note for slab / group pricings

In case the trip has group based pricing then they will appear in the sheet like in the screenshot given below. The group pricing structure facilitates easy comprehension of pricing tiers based on the number of passengers. In the provided format, the first slab encompasses groups of up to 5 passengers, priced at 100 per person with no additional charges. Moving to the second tier, accommodating groups from 6 to 2000 passengers, the price per person reduces to 90, with no extra fees. To extend this structure for groups of 2001 to 3000 passengers at a rate of 80 per person, a new row can be added as follows:

Group Pricing
No of passengers
Price per passenger
Additional charge (if any)
written as in the sheet
1st bracket
upto 5 passengers
100
0
 [5,100,0]
2nd bracket
from 6 - upto 2000 passengers
90
0
[(2000,90,0]
3rd bracket (to add)
from 2001 - upto 3000 passengers
80
0
 [3000,80,0]






Please add the pricing brackets in the same cell and not the cell below it or any other place



Opening, modifying and Closing Dates for trips

  1. Column A - Action allows you to decide what action you can take. There are 3 commands available which allow you to edit and manage content via Accelerate:
    1. Open - to open/create new slots or dates on calendar
    2. Edit - to edit/modify the price or capacity of a slot that is already opened
    3. Close - to close any slots which are already ope

Days of Week
In the sheet, there are columns representing days of the week from Monday to Sunday. You can set these to "true" or "false" to indicate which days the trip should be open.

For example, if you set a trip to be open from April 12th to April 30th but mark Saturday and Sunday as "false" in the respective columns, the system will only open the trip on weekdays (Monday through Friday) within the specified date range or vice versa.

This allows you to customize the trip's availability based on specific days of the week, ensuring flexibility in scheduling according to your preferences. (refer screenshot below)

Opening a new date / time slot

  1. Duplicate any existing row and paste it on a new line.
  2. Change the value in the "Action" column from "Skip" to "Open".
  3. Specify the dates:
    1. For a single date slot, input the same date in both the "First open Date" (Column F) and "Last Open Date" (Column G).
    2. For a range of dates, input the starting date in Column F and the ending date in Column G.
  4. Customize the details for the new slot, such as prices, capacity, and advertised price.

    2. After you have made the changes on the sheet go to the Accelerate page and click on Update Trip Data. This will push the new slots to the product and a new slots will be opened on the admin panel.





Editing an existing date / time slot

  1. Locate the row corresponding to the open date you want to modify.
  2. Adjust the date, time, prices for each passenger type, capacity, and advertised price in the sheet.
  3. once done change the value in the "Action" column from "Skip" to "Edit". (refer screenshot below)
  4. Once you've made the necessary changes, navigate to the Accelerate page and click on "Update Trip Data" to apply the modifications to the actual product.

Close an existing date / time slot

  1. Go to the row/opened slot that you want to close
  2. Under the Action column change Skip to Close (refer screenshot below)
  3. After you have made the changes on the sheet go to the Accelerate page and click on Update Trip Data. This will close the selected slots.

Verifying the Changes made via Accelerate

  1. Once you have clicked on the Update Trip Data button, you will get a SUCCESS text in Column A after a few seconds like this(refer screenshot below), this indicates that the changes have been pushed to the trip
  2. Now you can open the trip in the storefront and check the pricing and the available dates.

    • Related Articles

    • How to use Accelerate plugin?

      Overview Accelerate is a Bulk Editing Tool which allows you to modify the content of multiple tours at once. This tool works by connecting your Google account with your Vacation Labs account and giving it access to your drive. Accelerate creates a ...

    • Activating Accelerate - Bulk Editing Tool

      Overview Accelerate is a Bulk Editing Tool which allows you to modify the content, dates, and rates of multiple tours at once. This tool works by connecting your Google account with your Vacation Labs account and giving it access to your Google ...

    • Editing content for multiple tours via Accelerate

      Overview You can add/edit/remove content for the tours via accelerate. Please Note: You cannot create new trips via Accelerate, you can only edit the content of the existing tours Before your start Adding/modifying/removing content of a tour ...

    • Updating Tour Addons via Accelerate

      Overview Importing tour data Adding/editing tour addons Checking the changes made. Importing tour data Please click here for detailed guide on importing tour data: Importing tour data to Accelerate Adding/Editing the tour addons Please Note: you can ...

    • Importing Tour Data in Accelerate sheet

      Please follow these steps to access accelerate: Login to Vacation Labs Go to Settings > Apps section and click on open Accelerate (refer screenshot below) A new page will appear, now click on Open Sheet (refer screenshot below) This will open a ...