View Yield Pricing - Setting up Exception Records
Yield Pricing - Setting up Exception Records
Scenario: You are trying to drive more clients to your web reservation system. You have a promotion that states: For the first five people who go to your web site and book airport service online each day for travel during the month of October, you will offer a 50% discount off of base fares for Shared Ride. You need to configure your web system to award this 50% discount to the selected service for the first 5 bookings each day of October only, and to track the discounts so that only the first 5 reservations for each day in October receive the stated discount. The Hudson web reservations system uses a process called Yield Pricing to accomplish this task.
By completing and uploading a specially formatted csv file to the web reservation system, clients can apply a special Web Discount to fares and services or modify the base fare according to a specific number of seats / capacity. The structure of the csv file for yield pricing is the same as for exception records, so if you are already familiar with exception records, the formatting outline below will look very familiar.
There are 3 steps required to setup and enable Yield Pricing:
- Define Yield Pricing parameters and create yields.csv file.
- Upload and import yields.csv to the web reservation site
- Enable Yield Pricing in General Configuration
Define locations, yield pricing parameters according to the csv format guidelines below. When finished, save the file with the name: yields.csv. When creating yield pricing Keys, you want to create the most restrictive conditions or keys first and the least restrictive conditions last.
Yield Pricing csv format
Key formats in priority search order:
<fare key>.<yymmdd>.AIRPORTKEY - specific location on this date for specific airport
<fare key>.<yymmdd> - specific location on this date
*.<yymmdd>.AIRPORTKEY - all locations on this date for specific airport
*.<yymmdd> - all locations on this date
<fare key>.*.AIRPORTKEY - this location on any date for specific airport
<fare key>.* - this location on any date
*.*.AIRPORTKEY - catch all for specific airport
* - catch all
This field specifies the direction of either Departure or Arrival that
this record applies to. If the record does not match the direction the
record is ignored. Valid values are:
Empty,DA or AD: applies to both
D: departure only
A: arrival only
Start time^stop time or Weekdays^Start time^Stop time
Time format is HH:MM
This field specifies the start and stop times that this record applies
to. If the times are defined and the flight time is not in the range
specifed, the record is ignored.
F 5 Rule
Format:
Type^exception string
Supported types:
BASE - base fare
F - fixed discount
F2 - fixed discount per passenger
P - Percent discount of fare
R - Percent discount of fare, rounded
U - Percent discount of fare, rounded up
BASE^S1:%PAX%*9 ($9 per passenger for Svc 1)
F^S12&452&ORD:%PAX%*2 ($2 discount per passenger for Svc 12…)
*.070101,D,04:30^23:59,25,BASE^S1:10;S2:15
;<fare key>.<yymmdd>.AIRPORTKEY,direction,time range (start^stop),max capacity,rule
*.070101,D,04:30^14:00,25,BASE^S1:10;S2:15
*.070101,D,14:01^23:59,25,F^S1:10;S2:15
*,D,02:30^23:59,25,BASE^S1:10;S2:15
91901.070102.*,D,14:01^23:59,25,P^S1:10;S2:15
2) Upload and Import the yields.csv to web system
Login to your web site Utility page
Browse to your primary web reservation entry page, and add ‘util’ to the end of the URL.
Enter an authorized Username and Password
Locate the Utilities column, and browse to the "Upload and import csv file" menu item.
Set File Type = Yield pricing
In the Upload File field, click Browse button to navigate your local server and select the yields.csv file name.
Place a Check Mark in the box: Import and Replace Database
Click the UPLOAD button.
3) Enable Yield Pricing in web configuration
Login to your web site Utility page
Locate the Configuration column, and browse to and select the "General Configuration" menu item
Browse to the Subcategory on the page labeled: General Settings.
Locate Enable Yield Pricing, and set to YES.
Scroll to the bottom of the Page and click SUBMIT, to save changes.