Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Legacy Dynamic Pricing
Legacy Dynamic Pricing
nopaneltrue

Table of Contents

...

Note

IMPORTANT: There are two methods for configuring Dynamic Pricing – this Legacy Dynamic Pricing and our new Reimagined Dynamic Pricing module which utilizes the same back end as this legacy version, but makes configuration easier with a new interface. You need to decide which one you are going to use to set up dynamic pricing for a given product and CHOOSE ONE METHOD. Using both methods on a given product can cause issues with pricing setup.  

...

1. POS Tasks

1. Follow the POS standard product setup requirements from Configuration: Product Shell

Status
colourRed
titleRequired

  • If you are selling these products onsite, you’ll want to set up pricing for these products so that you can leverage whatever demand based pricing your POS makes available for on-site sales (i.e. Pricing Seasons in RTP|One)

Status
colourYellow
titlePrerequisite

2. Aspenware Commerce Tasks

Configure Core Product

1. Configure Core product according to product shell standards Configuration: Product Shell with the following additional setup:

Status
colourRed
titlerequired

  • Add “Start Date” attribute with

    • [Date] [Dynamic] added to Text Prompt

    • Control Type set to Date picker

    • And Is required selected

      Status
      colourRed
      titlerequired

  • Generate attribute combinations and check to make sure the attribute combination table is perfect before beginning pricing activities

    Status
    colourRed
    titlerequired

  • If utilizing the Large calendar view, add “[Pricing Calendar]” Text prompt to required attributes

    Status
    colourBlue
    titleoptional

2. Add product classification(s)

Status
colourRed
titlerequired

  • Dynamic Pricing Days to Arrival

    Status
    colourRed
    titlerequired

  • Is consecutive multi-day if using inventory pools and the product has multi-day options

    Status
    colourBlue
    titleoptional

  • Show pricing Calendar view if using the pricing calendar display

    Status
    colourBlue
    titleoptional

Update Settings

  1. ccatalogsettings.dynamicpricingcalendar.pricingcountmessagethreshold

    Status
    colourBlue
    titleoptional

  2. catalogsettings.dynamicpricingcalendar.inventorymessagethreshold

    Status
    colourBlue
    titleoptional

  3. seasonsettings.enddate is set to the season end date

    Status
    colourRed
    titlerequired

  4. seasonsettings.startdate is a date in the past

    Status
    colourRed
    titlerequired

Additional commonly utilized setup

  • Setup inventory pools if adding inventory to products

    Status
    colourBlue
    titleoptional

  • Add reloadable media

    Status
    colourBlue
    titleoptional

  • Setup cutoff days/time if preventing purchase x days or hours prior to start

    Status
    colourBlue
    titleoptional

Status
colourYellow
titlePrerequisite

Configure Language String for Savings Display on PDP

Status
colourBlue
titleoptional

Status
colourYellow
titleprerequisite

Dynamic Pricing Module Configuration

1. Create Pricing Season(s)

Status
colourBlue
titleoptional

3. Configure Season Type(s)

Status
colourBlue
titleoptional

3. Assign Season Type to product

Status
colourBlue
titleoptional

4. Configure Products for Dynamic Pricing

Status
colourRed
titleRequired

  • Set up Base & Override Windows (must have “Base” and “Online” at minimum

    Status
    colourRed
    titleRequired

  • Set up Tiers

    Status
    colourBlue
    titleoptional

5. Price Product Using Pricing Tool

Status
colourRed
titlerequired

  • “Base” values can be priced for the entire season

    Status
    colourBlue
    titleoptional

  • “Online” override windows values must be priced for the entire season and the top level “quantity” must be set to a value that will have no chance of selling out such as 10,000

    Status
    colourRed
    titlerequired

  • Price and set quantity for Tiers

    Status
    colourBlue
    titleoptional

6. Export/Import Excel Pricing Spreadsheet

Status
colourBlue
titleoptional

Status
colourGreen
titleDetailed Setup

7. Add Pricing Savings Display to the PDP

Status
colourBlue
titleoptional

Status
colourGreen
titledetailed setup

...

  1. Follow the standard product setup requirements from Configuration: Product Shell.

    1. If you are selling these products onsite, you’ll want to set up pricing for these products so that you can leverage whatever demand based pricing your POS makes available for on-site sales (i.e. Pricing Seasons in RTP|One)

...

2. Add Product Classification(s)

  • Go to Aspenware Commerce > Product Classifications and click Add assignment.

  • Select the product you created above.

  • Scroll to ‘Dynamic Pricing Days to Arrival’ and click the Assign checkbox.

  • Optionally if you’d like to show the large pricing calendar view, scroll to ‘Show pricing calendar view’ and click Assign checkbox.

  • Optionally if the product has inventory controls and is a multi-day product, you’ll want to allow consecutive multi-day selections. If this is not necessary for your product, skip to the next step.

    • If you’d like to require consecutive multi-day selection, scroll to ‘Is Consecutive Multi-Day Product’ and click Assign checkbox.

  • Optionally if the product has inventory controls and is a single-day only product in your POS, but you want to allow guests to select multiple single-day options on a calendar and check out with multiple date bookings as if it’s a single “cart item” online, you’ll want to allow non-consecutive multi-day selections. If this is not necessary for your product, skip to the next step.

    • If you’d like to require consecutive multi-day selection, scroll to ‘Is Non-Consecutive Multi-Day Product’ and click Assign checkbox.

  • Click Add.

...

3. Optional Product Setup

...

If you are adding the Dynamic Pricing Savings Display to the PDP, you have the ability to show and hide the amount remaining beneath the savings display. Resorts on 2.16 or later will have the amount remaining automatically enabled. If you care to disable this feature follow the instructions below:

  • Go to Configuration > Languages > Edit

  • Scroll to the bottom and add the language string Resource Name shown in the table below

...

  • Add the text you would like displayed beneath the price on the PDP in the Value field making sure to keep the {CountRemaining} token which will display the inventory # remaining (in the above example {CountRemaining} = 614

  • Select Add new record.

Detailed Setup Guide

  1. Create Pricing Season(s) - (Optional)

  2. Configure Season Type(s) - (Optional)

  3. Assign Season Type to product - (Optional)

  4. Configure Products for Dynamic Pricing

  5. Price Product Using Pricing Tool

  6. Export/Import Excel Pricing Spreadsheet

  7. (Optional) Add Dynamic Pricing Savings Display to PDP

...

Pricing Seasons are created so that dates can be blocked together when updating pricing for a product in the dynamic pricing tool. These should be set up prior to pricing the product. Pricing seasons are assigned to pricing season types that are assigned to products. 

  • Go to Aspenware Commerce Plugins > Dynamic Pricing

    • Click Seasons (button in the upper right corner) and specify:

      • Name: Enter the name for the season (ie: weekends, weekdays, winter season 20/21, etc)

      • Display Order: (optional) used to determine the display order in Admin.

      • Season Type: Leave blank for now, will be added in step 2.

    • Click Add.

    • Select Set Datesbeside the newly created season (table is organized by display order).

    • Navigate to the first month and year with dates included in this season. Highlight the appropriate dates in the left column. 

      1. Select multiple dates in a row using the Shift key; select multiple non-consecutive dates using the Command key on a Mac and Control on a PC. When all the desired dates in the month are selected, select the > arrow key in the center of the modal. 

    • Continue for each month within the season you are planning to have sales for and when complete, select Save

    • Season names, display orders, season types can be edited and de-activated/activated by selecting Edit. To edit dates, select Set Dates

2. Configure Season Type(s) - (Optional)

“Season Types” group seasons together to assign to products (e.g. a Summer 20/21 Season Type may be assigned to all summer products and include a Summer Weekdays Season and a Summer Weekends Season.)

  • Go to Aspenware Commerce > Dynamic Pricing > Seasons

  • Click Seasons (button in the upper right corner)

  • Click Season Types (button in the upper right corner)

  • Specify the Season Type Name and click Add.

  • Once the Season Type is created Click Seasons (button in the upper right corner).

  • Find all seasons that correspond with the Season Type, select Edit, and update the Season Type.

...

3. Assign Season Type to Product - (Optional)

  • Go to Aspenware Commerce > Dynamic Pricing > Seasons > Season Types > Assign Products to Season Types

  • Select the desired Product

  • Select the Season Type

  • Click Add

...

4. Configure Products for Dynamic Pricing

Note

WARNING: Once a product has been dynamically priced, Dynamic Pricing dynamic pricing cannot be undone.

Setup Override Windows

  • On the Seasons page, click Dynamic Pricing and search for the desired product.

  • Select Edit Override Windowswithin the desired product’s row.

    1. Days to arrival windows are defined here (e.g. rules like unique pricing for day-of purchasers, within 48-hour purchasers, outside of 48 hours, etc.)

  • Override Window setup depends on pricing window rules. Specify the following for all of the days to arrival windows for the product:

    1. Window Title: Enter a descriptive name for the window (ie: “Day of Pricing”)

    2. Display order: Set to 101 for the window that is closest to the start date, 102 for the next furthest window out, and so on. For example, 101 for Day of Pricing, then 102 for the 7 days out until the day before pricing, 103 for the 14 days to 8 days before pricing, etc. 100 or any lesser number should not be set as “Base” will appear automatically and is reserved for 100. The order of the windows matters greatly, so follow these instructions exactly.

    3. Days out start: This is the number of days from the arrival date when the pricing will apply. For example, if setting up an ‘outside of 48 hours’ window, set this to 2 and it will apply two days out from the arrival date if there isn’t a more specific (closer to arrival date) level set that applies to the reservation date. 

    4. Days out end: Set to 100000. Do not set this to a value higher than 100000.

    5. Track Quantity: Check this for all override windows. Checking this will cause the Type drop-down to appear.

    6. Type: select ‘Price’, do not select 'Percent.' 

    7. Click Add.

...

  • Once all Override Windows are added, and if you are not using tiered pricing, the product can be priced. (If you are using Tiers scroll down to the “Setup Pricing Tiers (Optional)” section.)

Note

WarningIMPORTANT: The order for override windows is very important. When all of your override windows have been added, they should be ordered from closest to arrival date to furthest from the arrival date and should look something like the example below if using multiple override windows. Notice Base is first, then the closest window to the arrival date is second, and so on. 

...

Tiers can be used to set limited quantities at discounted pricing.

Go to Aspenware Commerce > Dynamic Pricing > Search for your product > and click Edit Tiers.

...

  • Tier Title: enter “Tier 1” for the initial tier customers will buy from

  • Description:enter “Tier 1” for the initial tier customers will buy from

  • Display Order: enter “1” for the initial tier customers will buy from

  • Then click Add.

Repeat this process by adding “+1” for each required tier. In the example below products will sell through tier 1 then through tier 2.

...

5. Price Product Using Pricing Tool

  • Go to Aspenware Commerce > Dynamic Pricing in Admin.

  • Search for the product using the Product name field (e.g. type “ticket” to find lift tickets).

  • Find the desired product’s row and click Edit Pricing. 

Set Base Pricing

Base pricing is used to show the %savings the customer is receiving by buying online. Configuring base pricing is required.

Note

WARNINGIMPORTANT: Base pricing is required and if not configured may cause unwanted product behavior. Base pricing is also never used as a selling price.

...

6. Click the button that matches the name of your Season Type

...

Note

WARNINGIMPORTANT: If you clicked “Edit Date(s)” in the screenshot above you are only pricing for a few dates instead of the Season you set up.

In the pop-up enter the price that will be used as the base price aka ‘window rate’ and click Update.

...

Info

NOTE: Depending on the number of attributes and the number of dates being input this can take a few minutes for the data to save into the system.

...

Optionally, individual date(s) can also be modified by selecting the date(s) on the calendar then clicking Edit Date Range. There is also a “Month View” toggle on the calendar that can be used to see a wider set of date ranges.

...

Override pricing is the price that guests will purchase the product at. This is where pricing window prices are set, tier pricing is set, and each tier's quantities to be sold are set.

Note

WARNINGIMPORTANT: If Override pricing quantities are exhausted then products will be sold for $0 thereafter. Dynamic pricing is compatible with inventory pools but is not used to control inventory.

...

Quantity: enter 10,000. If sales surpass this number then products will be sold for $0. (see BLUE highlighted area in screenshot below).

...

#: enter the quantity to be sold at this tier (see GREEN and BLACK highlighted areas in the screenshot below)

Once all fields are completed click Update

Info

NOTE: If you are using multiple override windows and tiers, tiers always have their own individual available quantities. So if 1 day out sells through tier 1 and begins selling into tier 2, day of pricing will still start at Tier 1.

...

Optionally, individual date(s) can also be modified by selecting the date(s) on the calendar then clicking Edit Date Range. There is also a “Month View” toggle on the calendar that can be used to see a wider set of date ranges.

...

Once a product is “dummy priced,” or priced with real values, the pricing export can be download and re-imported.

  • Go to Aspenware Commerce > Import Pricing search for the desired product using the product name, category, or both. 

  • If the product is set up with tiered pricing, there will be two buttons under Import Pricing. Products that have tiers require downloading and uploading two separate spreadsheets.

...

3. End Date: enter the last date you want to update

4. Click Prepare Import Spreadsheet

Info

NOTE: only dates and attributes you have priced or “dummy priced” will show up in the excel file.

...

When the export is done, the spreadsheet will look similar to the image below. Find the variant(s),  override window combination(s), and date(s) you wish to update. Then update the price, setting the inventory using rules outlined below.

...

Note

 WARNINGIMPORTANT: For all “Base” prices, do not set Available Inventory, leave it at 0 

...

Note

WARNINGIMPORTANT: For ALL other Override windows, set the available inventory to either 1000 or 9999. This will set the quantity to be unlimited essentially. 

...

Once the pricing spreadsheet updates are completed and saved in a CSV format, it can now be uploaded.

Go to Aspenware Commerce > Import Pricing search for the desired product using the product name, category or both. 

...

3. End Date: enter the last date you want to update

4. Click Import Pricing Spreadsheet

5. Click Ok

Info

NOTE: Likely you will define the same date range as downloaded before. Once uploaded a message will appear detailing how many rows were affected; you can check your Excel file to ensure the total number of rows matches.

...

  • If the product being priced doesn’t have tiers, the import is complete. Be sure to check the product in the Dynamic Pricing plugin to ensure prices were properly updated as expected. 

...

To show an old price on a product that is dynamically priced follow the instructions below:

  • Go to Catalog > Products > Select your product.

  • Select the Advanced tab at the top of the product admin page.

  • Scroll to the Price widget.

  • Type the price that you would like your product to be compared to in the Old Price field.

Info

NOTE: Old price is static and will not change based on different attribute selections made on the PDP. If “Old price” is a greater value than the attribute price it will always display regardless of attribute selection. Old price is only set in the product editor screen and is not defined anywhere in dynamic pricing.

 

...

...