Skip to main content

How to Use the Adjustments Table

Price adjustments change the price of a product to match the prices on the market or because a custom price is needed

🔐 Required Role Permissions: Adjustments

🔓 Optional Role Permissions: Save Searches, See Bulk Action, Data Export, Generate Reports

📗 TIP

To enable price adjustments and learn how to apply them, read our article How to Use Adjustments.


Default Columns

Bookings - Adjustments

Default Columns

  • Customer - shows the name of the person for whom the booking was made

  • Status - refers to the current status of a booking:

Status

Description

Pending

the order is being processed; an order must be processed in the course of a timeout period. Once the timeout runs out, the order expires and a new one must be placed. The duration of a timeout period can be set in Supplier Settings > Edit Supplier > Order Timeout (mins).

Expired

an order took too long to process; a new booking is required.

Balance Due

the booking was not paid in full

Confirmed

the booking was purchased but not yet redeemed

Cancelled

the booking was annulled

Part Redeemed

bookings with multiple includes (packages) where only some of the includes have been redeemed

Redeemed

tickets in the booking have been used; orders made through a Point of Sale are automatically redeemed because they are sold as entrances.

Upgraded

the original booking was changed to a new, more advantageous one; upgrades to a product are added in Products > Products > [select product} > Comparisons (Up-sell).

Duplicate

reseller reference was introduced twice; for example, a booking comes in through Direct API but it is not scanned because there is no coverage. The moment it is reconciled, the booking is assigned the same reference. To avoid it being counted double, the system marks this as duplicate and they can be merged.

No-show

you have the option to mark a booking as ‘No-show’ when a customer does not show up for the tour

Pending Confirmation

if the ‘Operator Confirmation Required’ checkbox is ticked on the product detail page (Products > Products > [select-product} > [press-pen-and-paper-icon}), a booking with this product remains in this status until it is confirmed by the operator

Rejected

operator rejected the booking; cancel and refund the booking.

  • Product - the name of the product purchased

  • Channel - where the sale was made:

Channel

Description

Terminals

orders coming from a physical device, e.g. Sunmi, PAX, iPhone operated by a seller or reseller agent

Web Checkout

orders carried out on a website and widgets

Backoffice

orders carried out through the box office (such as concierge, but using a seller’s PIN), and orders made with the + New Order button in the Ventrata dashboard using admin access

Direct API

orders coming through an API connection with an OTA

Concierge

orders carried out through a sales portal by a concierge or tour operator.

Sales Kiosk

orders carried out by the customer using a self-service booth with a screen

+ other custom channels

  • Booking Type - indicates the type of product purchased

Booking Type

Description

Standalone (Individual)

a single product was purchased

Package

multiple products combined

Option

include in a package. If you include options in the bookings table, a package booking will have more than one line - the package name with the revenue, then a line for each include with $0

  • Travel Date - date when the tour takes place

  • Booking Date - date when the product was purchased

  • Amount - the amount (currency or percentage) by which the original price was adjusted

  • Per - by what criterion the adjustment was applied; options include:

Adjustment Per

Description

Booking

specify the amount by which the booking price is changed

Ticket

specify the amount by which the ticket price is changed

Percentage

specify the percentage amount by which the booking price is changed

  • Notes - description of the reason why a price adjustment was made

📗 TIP

Columns can be easily filtered by pressing the arrow next to the column title.

Actions

The action bar between the navigation bar and the adjustments table enables you to perform a number of additional functions.

Actions Bar

Actions

  • Search bar - filter the adjustments table, using any parameter from the available columns, see Generate Report below

  • Keep Filter - when using search, tick the checkbox to make the column filters available

  • Saved Searches - press Saved Searches> Save Current Search to save your current search parameters and filtered columns, or Saved Searches > Manage Searches to edit or delete existing searches

📗 TIP

To learn more about saved searches, read our article Working with Saved Searches.

  • Reset All Filters - appears when a filter was used; press to reset filters to their default states

  • Bulk Actions - select one or multiple bookings and press to apply an action on your selection; options include

Bulk Action

Description

Delete All

select one or multiple lines to delete adjustments; bookings where these adjustments were applied will now display the price before adjustment.

  • Show Columns - press to add new columns, or remove existing ones from your current view

📗 TIP

The list of columns which can be added is listed at the end of this article, under Generate Report.

  • Export - export the adjustments table in CSV, Excel or SQL format

  • Generate Report - create charts and reports to analyse data from the adjustments table

📗 TIP

To learn more about reports, read our article Working with Charts and Reports.

Report function

Description

Total

sum of values

Minimum

the lowest value

Maximum

the highest value

Average

the sum of values included in the report divided by their count

Count

number of the selected parameter

Available Columns

See the How to Use Table Columns for the complete list.

Did this answer your question?