Pricing - market pricing


Navigate to admin>Pricing Schemas>market-pricing.

pricing admin menu

pricing market pricing menu

How market pricing works

Given a selected trip, we will try to find a Journey pricing record that matches the trip. If found it will applied following the same rules as with JP pricing.

If prices can't be added we will check in the fare tables for the point to point prices and for a Market price modifier and apply those modifiers to each of the individual tickets in the trip.

Trip search pull prices from only one Pricing Schema at the same time, it is not possible to combine JP and Fare Tables for a single trip search.

Landing page

Once in the main market pricing page you will see two options, fare tables and modifiers.

landing page market pricing

Fare tables list

Clicking in the fare table area you will see a list of fare tables, grouped by route.

fare table list

The list has the route name, a list of stops in the route and the products associated to that route that have the market-pricing schema. Clicking in a product name will open the fare table details, where you can edit the prices

fare table filters

You can filter the list by route, product or both. The filters are inclusive, if you select both a route and a product the only results that you will see are fare tables for that product as long as they are also associated to the route. So if that route is not associated to the product you will not see any results.

Creating and updating some prices

The fare tables will have an effective date, seat class and fare class. It's not possible create or edit a fare tale withe the same or overlapped period, also is not possible create or edit a duplicate fare table.

  • Effective to date and from date: this property defines the effectives date for this fare table.
  • Seat Class: if the account has a seat class, the user can add a seat class to apply to the fare table.
  • Fare Class: if the account has a fare class, the user can add a fare class to apply to the fare table.
  • Currency: if the account is a multicurrency, the user can add a currency to apply to the fare table.

The user can edit an exist fare table, clicked in the "edit" or add new ones clicked in "Add new".

fare table list

In the fare table create or add screen, the user can define the effectives dates, seat class or fare class for this new fare table.

fare table edit

The inputs Seat Classes or Fare Classes is only showed if the acount has configurate this ones respective.

If your account is multicurrency, you will see a field to select the currency of the fare table.

fare table multicurrency edit

After set the prices clicked the save button.

If the fare table has an overlapped period whit another fare table, you see these messages

fare table overlapped period error

In market pricing that do not use journey pricing and seat classes, the fare classes can be used as price modificator taking into these configurations:

  • The value any is for all fare class that the account has.
  • If exist only one fare table for the trip and is asigned one fare class, the trip result return the price only for this fare class. The fare classes without fare table will be exclude from trip result.
  • If the trip has segments, it is important that each segment has a fare table assigned with the fare classes to be used or defined in any, otherwise the system can not build the trip.

After saving the values the page will reload and display the new values in the fare table. -warning Leaving a value empty will result in no sales possible between those two O & D's for that product. If you want to set a Zero value, you should enter "0"

Using CSV to upload prices

Sometimes you may want to change all or most of the prices associated to a fare table. In those case you can download a CSV file with the existing values, change it using Excel or a text editor and upload the new file.

To download the existing prices click the Download button.

fare table download

After modifying and saving the file (as a CSV) into your computer, click the Upload button.

fare table upload

It will show a file selection component. Click on the component and your computer will open a file browser window (it depends on the operating system). Select the file you just saved with the new prices. In the example below the name of the file is fares.csv. If the file is processed correctly you will see the new values in the table. Then you need to press Save to apply the changes, otherwise the values will loss.

fare table upload processing

If the file is processed correctly you will see a success message.

fare table upload success

In case of an error you will see an error message. (The error will be different based on what went wrong)

fare table upload error

Accessing from the route details page

fare table route page

In the route details page, for the products that use the market-pricing pricing schema, you will see a link that will take you to the fare table page directly.

Modifiers

Modifiers are pricing records that apply to individual legs of a trip. Simlilar to JP, they can be configured to apply based on a set of trip parameters. These modifiers will apply on top of the point to point prices found in the fare tables for those legs of a trip that match the modifier.

Modifiers get assigned a weight based on how specific a modifier is and the ones with the highest weight are matched first. Once a modifier that matches a leg is found it will be applied for that leg.

Modifiers are used when there is no JP records that match the trip.

Further price adjustments defined at the product and or fare level are applied as well.

Modifiers list

modifiers list

You will be presented with a list of modifiers or an empty list if there are no modifiers created in the account. At the top right corner there is a button that can take you to the instructions with explanations of each field and the requirements.

modifiers instructions

Creating a modifier

To create a modifiers click the Add new button, a new row will be shown at the top of the list where you can select the correct values and enter at least one modifier.

modifiers creation

Then, a list of fields required to create the new modifier is displayed.

modifiers fields_product_properties

Product: This field will allow to assign the modifier to a specific Product Line.

Fare Classes: This field will allow the modifier to work for certain selected Fare Class types. If the 'Any' option is selected, then the modifier can be applied to any available Fare Class associated with the selected product.

You must click on the "+" button to add the selected value. This applies to all multiple choice fields.

Channels: This field will allow to select the types of channels under which the modifier will operate.

Shift Locations: This field will allow selecting the locations from which a shift can be opened and the modifiers can be executed.

modifiers fields_location_channels

Currency: This field will allow selecting the currency in which the modifier can be executed.

Tax Exempted: This field will indicate if the modifier is tax exempt.

One way: This field will allow the modifier to be applied to 'One-Way' ticket types. Adjustments can be made with a specific value or a percentage.

Return: This field will allow the modifier to be applied to 'Return' ticket types. Adjustments can be made with a specific value or a percentage.

Open return: This field will allow the modifier to be applied to 'Open return' ticket types. Adjustments can be made with a specific value or a percentage.

Same day return: This field will allow the modifier to be applied to 'Same day return' ticket types. Adjustments can be made with a specific value or a percentage.

Accumulation ratio: This field indicates the cumulative rate for the Loyolaty points program. The number of points to be accumulated will be obtained by multiplying the ratio by the price.

Redemption ratio: This field indicates the redemption rate for the Loyolaty points program. The number of points to be redeemed for a ticket will be obtained by multiplying the ratio by the price.

modifiers fields_price_adjustments

Schedules: In this section, the corresponding fields will allow you to select whether the modifiers will work on all, some or be exempted from specific schedules.

Routes: This field will allow to select the routes on which the modifier will work.

Amenities: This field will allow to select the amenities on which the modifier will work.

Brands: This field will allow to select the brands on which the modifier will work.

modifiers fields_trip_properties

Travel days of the week: This field will allow to select the days on which the modifiers will work.

Advance purchase: This field will allow configuring the hours from which the modifier will operate, based on the current date.

Selling from/Selling to: This field will allow the modifier to be executed for a specific date range during which a reservation sale is attempted.

Trip from/Trip to: This field will allow the modifier to be executed for a specific date range during which a trip is attempted.

modifiers fields_dates_ranges

Load Factor: This field will allow configuring the range (in percentage) of bus capacity at which the modifier will be executed. For example, if the bus has 40 seats and the Load Factor is set with a range from 10% to 100%, the modifier will only execute when at least 4 seats are reserved, as the modifier configuration will apply starting from the fourth seat. If it is desired for the modifier to always execute from the first seat, then the opening range should be set to 0%.

modifiers fields_dates_ranges

You can click the Save button once you are done.

modifiers save button

You can see an error in case you missed to enter at least one modifier value as shown below.

modifiers save error

Modifiers and loyalty

Acumulation of points

Loyalty points are assigned at the leg level and added up for the whole trip. Loyalty points to accumulate are always added and if a segment doesn't have points it will be assigned a value of zero, so a customer will receive a total of points only for the legs that credited points once the whole trip is redeemed.

Paying a trip with points

A trip will have a point price only if all legs in the trip have a point value. If any of the legs in the trip doesn't have a point value the whole trip will not be available to be purchased with points. This prevents selling trips for a smaller point value.

Editing a modifier

To edit a modifier you select the row clicking to checkbox besides it, it will enable the Edit and Delete button

modifiers edit delete buttons

Clickk in the edit button and the row will become editbale, change whatever value you need and click the Save button as when creating a new entry. Same conditions apply.

Deleting a modifier

To delete a modifier you select the row clicking to checkbox besides it, it will enable the Edit and Delete button

modifiers edit delete buttons

Click the delete button and you will be presented with a confirmation message.

modifiers delete confirmation

If you click Delete the row will be deleted and you will see a confirmation as below.

modifiers delete success

If you click Cancel the row will not be deleted.

Adding Journey Prices

The Market Pricing Schema also allows you to use some Journey Pricing records if you need more specific pricing rules. Please contact support@betterez.com or your Betterez Account rep to ask more about how to enable this in your account.

The process for adding JP records is documented in this link: Journey Pricing Create

Troubleshooting

Market Pricing requires the account to have at least one Fare Class.

Use case regarding combining fare types: If you define a Journey pricing record for a single fare type, you won’t be able to book it together with a fare type that only has prices on a Fare Table. You would only be able to book them separately (doing separate trip searches). If you need to book them together, both fare types should have a JP record.

In some cases, for a JP to be pulled correctly, you need to have a defined price in the Fare Table for the O&D you want to use. For example, this happens for Open Return trips. Prices may be defined on the JP record, but both departure and return trip should have a base price defined in the Fare Table.

Common problems

During the creation or update of a fare table may appear some errors related with his values. The tables has a validation that restrict its structure. This way, the fare tables with overlapped effective dates must have the same shape. It means that all of them (overlapped) must have values and blanks in same positions.

For example: If exists a fare table with the next structure values:

fare table with blank

Then if we want to add another with overlapped dates, but with a different structure, the system will throw an error indicating a conflict with other fare tables in certain positions.

fare table without blank

fare table error validation

The message specify the origin/destination and identifiers of the fare tables in conflict.

Other example: If exists a fare table with values in certains positions and then we want to add a new fare table with a blank in that positions, the system will throw the next error.

fare table error validation

In order to solve this error, and if you need to change the fare table structure, first you have to change the effective dates to avoid the error, update the table values and save. Then you can update the other fare table. Finally you should back the effective dates to previous value