🔐 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
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
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.
