Versions Compared

Key

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

Insert excerpt
Dynamic Pricing
Dynamic Pricing
nopaneltrue

...

1. POS Tasks

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

Status
colourRed
titleRequired

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], Date picker, and Is required settings

    Status
    colourRed
    titlerequired

  • Generate attribute combinations

    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

    Status
    colourBlue
    titleoptional

  • Show pricing Calendar view

    Status
    colourBlue
    titleoptional

Update Settings

  1. CatalogSettings.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

    Status
    colourBlue
    titleoptional

  • Add reloadable media

    Status
    colourBlue
    titleoptional

  • Setup cutoff days/time

    Status
    colourBlue
    titleoptional

Status
colourYellow
titlePrerequisite

Dynamic Pricing Module Configuration

1. Configure Season Type(s)

Status
colourBlue
titleoptional

2. Assign Season Type to product

Status
colourBlue
titleoptional
Jenni Optional Correct?

3. Create Pricing Season(s)

Status
colourBlue
titleoptional

4. Configure Products for Dynamic Pricing

Status
colourRed
titleRequired

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

    Status
    colourRed
    titleRequired

  • Set up Tiers

    Status
    colourBlue
    titleoptional

5. Price Product Using Pricing Tool

Status
colourRed
titlerequired

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

    Status
    colourRed
    titlerequired

  • “Override” 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

...

  • Products where price changes depending on the reservation date (e.g. during a certain season, a product is sold at a higher price).

  • Products that are not available every day of the season but do not use inventory pools to narrow available dates.

  • Products that you wish to display the pricing calendar in order to display how much inventory is left throughout the season. ^Jenni This should be in Overview and not needed here?

Before dynamically pricing a product, ensure the following is true:

...

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 you can decide if you want to allow non-consecutive multi-day selection or if you’ll allow consecutive multi-day selections. If neither option is not necessary for your product, skip to the next step.

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

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

  • Click Add.

...

3. Optional Product Setup

...

“Season Types” group seasons together to assign to products (e.g. a Lift Ticket Season Type may be assigned to lift ticket products and include a Lift Ticket Weekdays Season and a Lift Ticket 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.

Info

NOTE: Currently, each season can only be assigned to one season type. If product A and product B both use the Saver Season, but product A’s seasons are Saver, Off-Peak, and Holiday, and product B’s seasons are Saver and Regular, then create a different season type to assign to product A and B. Two Saver seasons will also need to be created, one for the season type that will be assigned to Product A, and another for the season type that will be assigned to Product B.

^Jenni? what is this?

2. Assign Season Type to product

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

  • Select the desired Product

  • Select the Season Type

  • Click Add

...

3. Create Pricing Seasons

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, whole season, etc)

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

      • Season Type: Select the Season Type created above.  

    • 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

4. Configure Products for Dynamic Pricing

...

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 should not be set as “Base” will appear automatically and is reserved for 100.

    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.)

...

Info

NOTE: If all “Days Out Start” date ranges are not fully encompassed then the earlier date will be used. For example, in the screenshot above if a guest buys a product 3 days prior, then the pricing will fall under the “3 - 2 days out price” window.

^Jenni - Does this note make sense? And are there any risks to not have all dates overlapping? Like could $0 tickets be sold? I feel like I’ve seen $0 tix sold with this config.

Setup Pricing Tiers (Optional)

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.

...

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 amount 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.

...

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.

Info

NOTE: You will need to manually clear the cache in admin in order for your price changes to appear in the store to guests.

Jenni - Does “Show Grid” do anything and should we bother mentioning here?

6. Export/Import Excel Pricing Spreadsheet

In order to speed up dynamically pricing products, and to enable quickly changing pricing on the fly, use the dynamic pricing export/import tool to export pricing into Excel and re-import pricing spreadsheets to make changes to pricing quickly. Import If using multiple tiers and override windows it is recommended to use Aspenware’s Import Pricing upload to manage pricing. Importing pricing works for all variations of dynamically priced products, including products with tiers restricting the quantity of certain prices, override windows, and more.

Before a Pricing Spreadsheet can be exported or imported, the product must first be set up for dynamic pricing using the steps above, the pricing import spreadsheet can only pull back and update dates that already have pricing defined for them. When entering pricing using the dynamic pricing tool, you can enter “dummy” pricing and quantities, which is usually $1000 with 1000 quantity. As long as something is set up, the pricing export can overwrite it with actual prices added through the import. For help “dummy” pricing a product at the start of your season, contact your Aspenware representative. 

...

Info

NOTE: Each date desired to update within Excel must first be “dummy priced” in the dynamic pricing tool. $1000 and 1000 quantity are recommended for dummy pricing before making changes in Excel.

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. 

  • A

    If the product

    must

    is set up

    for dynamic pricing and priced for the season, even if the prices added are “dummy prices.” If this setup is not first done it will not work. 
  • You can identify if a product is set up for dynamic pricing if you search for a product and the “type” is set to Override. If it is set to none, first set up the product for dynamic pricing using the sections above. 

...

  • If the product is set up with tiered pricing, there will be two buttons under Import Pricing. Products that have tiers require two upload spreadsheets to be exported and imported:

    1. Import Pricing: This will be used whether the product has tiers or not. If tiers are not set up on a product, this is the only option you will see. Use this link to import pricing for Base pricing, and all override (list) pricing that is not tiered (inventory-based pricing)

...

  • Import Tiered Pricing: Will be used only if the product has tiered pricing to import. This does not import list pricing or base pricing, but only values that are defined as “tiered prices”. If a product should have tiered pricing, but the Import Tiered Pricing button doesn’t appear, first setup the product for tiered dynamic pricing using the steps above. 

...

  • Guidelines for preparing the Import Pricing (without tiers) spreadsheet are outlined below.

  • Before importing pricing spreadsheets is possible, preparing the correct pricing export sheet is required. This sheet has specific values that must be present for the import to work, so creating the spreadsheet without first exporting is not possible. To prepare your export spreadsheet, define the start and end date for the date range that will be updated. This can be an entire season.

  • Click to Prepare Import Spreadsheet

    Image Removed

    with tiered pricing, there will be two buttons under Import Pricing. Products that have tiers require downloading and uploading two separate spreadsheets.

Import Pricing (button): This will be used whether the product has tiers or not. If tiers are not set up on a product, this is the only option you will see. Use this link to import pricing for Base pricing, and all Override pricing.

...

Import Tiered Pricing (button): Only visible if the product has tiered pricing setup. Use this button to price tiers and input available quantities for each tier.

...

1. Click Import Pricing button > then under the “Download” header complete the following:

2. Start Date: enter earliest date you want to update

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

...

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

...

  • 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 is completed with desired data updates, it’s ready to be re-imported. 

    1. Define the same start and end dates as what was defined for the pricing download spreadsheet

    2. Find the recently updated pricing download spreadsheet on your computer. Ensure it’s saved as a csv. 

    3. Select Import Pricing Spreadsheet

      Image Removed

the inventory using rules outlined below.

...

Note

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

...

Note

WARNING: 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. 

1. Click Import Pricing button > then under the “Download” header complete the following:

2. Start Date: enter earliest date you want to update

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.

...

Info

NOTE:If only a set of dates or combinations are being updated, pricing imports can be trimmed down to only have relevant rows in them. This will not cause issues with the upload, but only data that is defined in this spreadsheet will be updated with the import. 

  • 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. 

Tier Import Pricing

  • To prepare the Import Tiered Pricing (WITH tiers), follow the same steps as above, however, define the “available inventory” quantity to have the inventory that is available at that price before the price bumps to the next tier. 

...