Pricelist
Overview
Hotel Price List is the place where prices are created or managed for particular packages. Usually a package contains a Transport and a Room types Hotel but this is not necessarily the case. The price can be added based on interval, discounts, children, or groups, or it can be set for one way or round trip. Each package has a date assigned; this date is pointing to the departure date of the trip.
Purpose
A Price List is the foundation of how trips and offers are sold in Tourpaq.
Its purpose is to:
Define the selling price of a trip
Combines Transport (flight/bus/ship seats) + Hotel (room types, allotments) + other conditions (discounts, stay length, children rates, groups).
Ensures every departure date and room type has a price assigned.
Control availability
Price lists link prices with allotments (how many rooms/seats are available).
Without a price list, even if there are seats/rooms available, the package cannot be booked.
Support different sales channels
The same price list is used by:
Agencies (offers presented on agency sites).
Web Booking (WB) (online sales).
Office (internal bookings by staff).
Enable flexibility
Prices can be adjusted per:
Interval (P1, P2, P3, P4 = different stay lengths or price periods).
Age groups (child/adult discounts).
Trip type (one-way, round-trip).
Brand (same hotel/transport may have different prices depending on the brand).
Provide historical and operational control
Price lists track changes over time (history log).
Manual recalculations or adjustments can be made when allotments or transport costs change.
How it Works
Create/copy price list
Creating a price list is fairly easy. From the Price List tab, select "Create/Copy Price List."
Choose the brand for which the price list is created.
Select the transport.
Select the transport's fix quota.
Select the hotel.
Select the rooms.
Click Create new price list
Price List Search
The search helps to find prices based on brands, Transport, Hotel, Room and the departure date interval. To get results The most basic search you can get is by choosing All Brands and Transport but for the best performance, try to fill most of the fields. The list of transports from the drop-down list is filtered based on the brand selection.
Top Section (Filters related to Dates and Transport):
Date From/To Fields: Set the date range for price list queries (format DD-MM-YYYY)
Resorts Dropdown: Select specific resorts to include in the price list
Transports Dropdown: Configure transport options with code format
Transport Type Dropdown: Filter by transport categories
Hotels Dropdown: Select specific hotels
Allotment Type Dropdown: Select the allotment type
Room Dropdown: Select a specific room type
Fix Quotas Dropdown: Select a transport fix quota
Display Names Checkbox: Toggle to show hotel names in results
Display Checkbox: Toggle to show the price list results
Clear Button: Reset all filter selections (shows "1" indicator, possibly indicating active filters)
Stay Length Field: Used to filter price lists for a specific stay length. It is possible to specify one stay, several stays or a range.
Price Display Options
Hotel Disc on Top Checkbox: Show hotel discounts prominently
Only Set Prices Checkbox: Display only confirmed/set prices
Hide Zero FTA Checkbox: Exclude zero-value FTA (likely "Free to Agent") rates
Hide Zero PHA Checkbox: Exclude zero-value PHA rates
View Management
Save View Button: Preserve current filter configuration
Update View Button: Modify existing saved view
Menu Icon (⋮): Additional options menu
Example: Running a Search
Open the Price List Search page.
In the Date From / To fields, enter 01-07-2025 to 15-07-2025 to search for the first half of July.
From the Brand drop-down, select TourpaqDK.
The Transports list is now filtered for TourpaqDK. Select the transport option FLY-RO.
In the Hotels drop-down, select Hotel Marina.
Choose Double Room with Balcony from the Room field.
Enter 7 in the Stay Length field to filter for week-long stays.
Under Price Display Options, check Only Set Prices to display confirmed rates only.
Click Display to run the search.
✅ The system displays all available TourpaqDK → FLY-RO transport → Hotel Marina → Double Room with Balcony → 7-night stays between 01–15 July 2025, showing only confirmed prices.
Transport and Hotel Selection Behavior
All Brands Selected:
When All Brands is selected, all available transports will appear in the Transport drop-down list.
Specific Brand Selected:
If a specific brand is chosen, only transports assigned to that brand will appear.
Transports are assigned to brands via Transport → Brands Tab | Brands Tab → Edit Transport.
Transports marked as hidden will not appear in the drop-down list. Transport visibility can be managed in Transport → General Tab → General.
Transport Selection Effects:
Once a transport is selected, the Fix Quota field is automatically populated in the multiple selection view.
The Hotels drop-down is filtered to display only hotels associated with the selected transport’s price list.
Hotels marked as hidden will not appear. Visibility can be configured in Hotel → Hotel Tab → General Tab.
Hotel Selection Effects:
Selecting a hotel reveals two additional fields.
These fields provide tools to help save prices using algorithms described in:
Price List → Also Update Prices on Transports
Price List → Update Prices Based on Transport
Display Price List
After performing a search, the Price List results are displayed in a table format. For performance optimization:
Prices are not loaded all at once.
Clicking the Display button loads the first 25 entries.
As you scroll down, the next 25 entries are loaded incrementally until the entire list is displayed.
By default, most columns are hidden to improve performance and maintain clarity.
Column Overview
Column titles are abbreviated to keep the table tidy. Most fields include tooltips that display the full column name. Below is a full list of columns with explanations:
PLTA ID
Price List Unique Identifier. Double-clicking the ID redirects to the Web Booking Page for the specific booking configuration.
Hotel
Hotel Code corresponding to the booking configuration.
Room
Room Code corresponding to the booking configuration.
Dep. Date
Departure date for the booking configuration.
STAYS
Length of stay for interval 1 of the transport.
FHA
Free Hotel Allotment – Number of rooms available for this departure. Default value represents a one-week trip (interval 1). Hover displays allotments for 1, 2, 3, or 4 weeks.
FTA
Free Transport Allotment – Number of transport seats available. Default represents a one-week round trip. Hover displays available seats for 1, 2, 3, or 4 weeks round trip, as well as one-way outbound and inbound trips.
P1
Price for Interval 1.
P2
Price for Interval 2.
P3
Price for Interval 3.
P4
Price for Interval 4.
CH1
Child Price Interval 1 – Price for a child occupying an extra bed. Calculated using an extra bed discount applied to the Grundprins (base price).
Status
Guarantee Availability of the PLTA (Transport + Hotel). Possible statuses: - GREEN – Both transport and hotel have guaranteed allotments. - YELLOW – One of transport or hotel lacks Guarantee Availability. - PINK – Neither transport nor hotel has Guarantee Availability.
Price List History
Price list history is a way to see the evolution in time of prices.
At the beginning of each row, there are tree icons:
View History - where you can see the evolution of prices like in Figure 3.
Clear API Cache - by clicking the icon, you can clear the cache on the API for that particular prices
Free Rooms Count|Recalculate Free room count - you can recalculate on demand both transport and hotel allotment for current prices
Column Filters
Column Filters allow you to display specific portions of information from the Price List grid.
Each interval group has a corresponding checkbox: Interval 1 (P1), Interval 2 (P2), Interval 3 (P3), Interval 4 (P4).
Example: If ALL PRICES (P1, P2, P3, P4) is checked and Interval 1 is selected as the active filter, only the P1 column will be displayed in the table.
Columns not grouped into intervals are always shown by default.
Discounts
Relation PL & Related PL
These are covered in Relation pricelist
Also Update Prices on Transports
The fields are displayed only if the hotel is selected in the search form.
This function is used to update the prices that share the same hotel but have different transports. Let's take, for example, transport T0 and the Transport T1 and each one has a price list with the same hotel, H0, so we have price lists T0_H0 and T1_H0. Let's say that the difference between the price in T0 and T1 is 100, so we set this value on the transport T1 in the column Transport Price (TP). When the price on the T0_H0 is changed, we have the option to update the price on the T1_H0 as well.
T1_H0_Price = T0_H0_Price + T1_H0_Transport_Price
If Override Transport Price is checked and the filed next to the check-box is filled, the column Transport Price, will be overwritten in the transport T1_H0
A simple workflow could be:
Select in the search form Brand, Transport, Fix Quota and Hotel, and click Display button
Check Also update prices on transports and select one or more Transport in the list (The list of transports in this drop down list are transport that have price list with the same hotel)
Check the Override Transport Price and fill the amount
Change one or more prices on the grid and click the Save button.
After the save, you will notice that the price on the selected transport with the same hotel and room has been changed accordingly by the formula above.
Update Prices Based on Transport
This function allows prices to be automatically recalculated when the Transport Price changes.
The fields are displayed only when a hotel is selected in the search form.
Purpose: Update prices (P1, P2, D1, D2, etc.) based on changes in the selected transport.
The transport drop-down list shows only transports that share the same hotel and room.
Example: If P1 was previously updated using the Also Update Prices on Transports tool, and the Transport Price is modified, P1 will be recalculated accordingly based on the price list for that transport.
Last updated
Was this helpful?