Page summary
- How market pricing works
- Landing page
- Fare tables list
- Creating and updating some prices
- Using CSV to upload prices
- Accessing from the route details page
- Modifiers
- Modifiers list
- Creating a modifier
- Modifiers and loyalty
- Acumulation of points
- Paying a trip with points
- Editing a modifier
- Deleting a modifier
- Adding Journey Prices
- Troubleshooting
- Common problems
Pricing - market pricing
Navigate to admin>Pricing Schemas>market-pricing.
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.
Fare tables list
Clicking in the fare table area you will see a list of fare tables, grouped by route.
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
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".
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.
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.
After set the prices clicked the save button.
If the fare table has an overlapped period whit another fare table, you see these messages
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.
After modifying and saving the file (as a CSV) into your computer, click the Upload button.
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.
If the file is processed correctly you will see a success message.
In case of an error you will see an error message. (The error will be different based on what went wrong)
Accessing from the route details 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
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.
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.
Then, a list of fields required to create the new modifier is displayed.
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.
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.
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.
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.
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%.
You can click the Save button once you are done.
You can see an error in case you missed to enter at least one modifier value as shown below.
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
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
Click the delete button and you will be presented with a confirmation message.
If you click Delete the row will be deleted and you will see a confirmation as below.
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.
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:
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.
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.
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