QloApps Tours and Packages is an addon that will unlock a whole new dimension of the hotel business for the admin.

Using this addon, the admin will be able to sell tours and packages from his website and not just hotels.

The tours and Packages option on a hotel booking website is always one of the USPs for that website.

People prefer booking tours instead of making all the bookings separately due to many reasons. It saves them time and money and is very convenient.

And that is why they are more attracted to the websites that offer tours and packages.

The decision to offer tours and packages on the hotel websites is very fruitful.

It helps the admin to fillout the inventory quickly, and also earn some extra revenue on the services offered in the package.

So let’s explore the features and workings of this addon.

Note: This guide covers QloApps Tour And Packages version 5.0.0, which works with QloApps 1.7.x.

• A totally separate interface for the tours and package
• Attractive and elegant design to display packages
• Responsive to different screen size
• Customers make the search for location and date
• Users can filter the search results on the basis of package duration
• The customer can filter search results on the basis of the package price
• Users can filter search results on the basis of package theme
• Customers can filter search results on the basis of package activity
• Users can filter the search results for the location
• Search results show the offer tags for the packages that have a discount in them
• Customers can check the full itinerary of the tour
• Customer can add the room types to the packages as per their choice
• Book or Enquire about the package
• Book the whole package from a single cart
• Show floating enquiry and contact number buttons on package pages
• Hide the tours and packages pages on the front office with one setting

• Admin can create packages of any duration
• Admin can create as many packages as wants
• Admin can create as many as different availability dates for same package. 
• Decide if a user can book the packages or he can only enquire about it
• Three kinds of package pricing
  • Fixed package price
  • Price per person
  • Price per room
• Decide the child’s age for no charges
• If u want u can add the child pricing also if you don’t want go for no charges 
• Offer a discount on the minimum number of persons or rooms
• Admin can define his Terms and Policies
• Admin can decide which room type will be offered in the package of a particular hotel
• The Admin can create the whole itinerary
• Admin can add activities in the package
• Add transport facility to the package
• Admin can Add special events to the package
• Admin can Add nearby attractions to the package
• Select the theme for the package
• Manage all the inquiries from the customer
• Decide the limit of rooms a user can purchase in a package
• Decide the max occupancy that can be added to a package
• Limit the number of adults and children per room
• Create meals and add them to the itinerary
• Add standalone properties and their room types for packages that do not use a QloApps hotel
• Set the country and city of each element, and a fixed, per person or room wise price on activities, meals, special events and transport facilities
• Count the package quantity separately for each availability date range
• Create hotel orders for the stay, or block room inventory, when a guest books a package
• Drag itinerary days to reorder them

Note: You have to make the below-mentioned changes in QloApps only if you are using QloApps version 1.5.0 or less.

Before you install the QloApps Tours and Packages addon you must make a few changes in the core for the proper functioning of the module.

The step is very simple, you just have to locate the following paths and replace the mentioned codes.

Open the hotel commerce folder –> modules–> hotelreservationsystem then open the hotelreservationsystem.php file.

Now go to the line number 362 and replace the following code:

$orderProducts = $order->getProducts();

replace this code with the following code.

$orderProducts = $order->product_list;

Open hotel commerce folder –> modules–> hotelreservationsystem–> classes then open the HotelBookingDetail.php file.

The change the code from line no 348 to 350

$sql = 'SELECT ri.`id` AS `id_room`, ri.`id_product`, ri.`id_hotel`, ri.`room_num`, ri.`comment` AS `room_comment`
        FROM `'._DB_PREFIX_.'htl_room_information` AS ri
        WHERE ri.`id_hotel`='.(int)$hotel_id.' AND ri.`id_product`='.(int)$room_type['id_product'].' AND ri.`id_status` != 2 AND ri.`id` NOT IN ('.$exclude_ids.')';

will be replaced by:

$selectAvailRoomSearch = 'SELECT ri.`id` AS `id_room`, ri.`id_product`, ri.`id_hotel`, ri.`room_num`, ri.`comment` AS `room_comment`';

$joinAvailRoomSearch = '';

$whereAvailRoomSearch = 'WHERE ri.`id_hotel`='.(int)$hotel_id.' AND ri.`id_product`='.(int)$room_type['id_product'].' AND ri.`id_status` != 2 AND ri.`id` NOT IN ('.$exclude_ids.')';

$groupByAvailRoomSearch = '';
$orderByAvailRoomSearch = '';
$orderWayAvailRoomSearch = '';

Hook::exec('actionAvailRoomSearchSqlModifier',
    array(
        'select' => &$selectAvailRoomSearch,
        'join' => &$joinAvailRoomSearch,
        'where' => &$whereAvailRoomSearch,
        'group_by' => &$groupByAvailRoomSearch,
        'order_by' => &$orderByAvailRoomSearch,
        'order_way' => &$orderWayAvailRoomSearch,
        'params' => array(
            'id_hotel' => $hotel_id,
            'id_product' => $room_type['id_product'],
            'date_from' => $date_from,
            'date_to' => $date_to
        )
    )
);

$sql = $selectAvailRoomSearch;
$sql .= ' FROM `'._DB_PREFIX_.'htl_room_information` AS ri';
$sql .= ' '.$joinAvailRoomSearch;
$sql .= ' '.$whereAvailRoomSearch;
$sql .= ' '.$groupByAvailRoomSearch;
$sql .= ' '.$orderByAvailRoomSearch;
$sql .= ' '.$orderWayAvailRoomSearch;

Open hotelcommerce folder –> modules–> hotelreservationsystem–> classes then open the HotelCartBookingData.php file.

Paste the following code under the “if condition” of line number 815 to 974.

if ($roomDetail = $objRoomType->;getRoomTypeInfoByIdProduct($product['id_product'])) {
	//place code from line no. 815 to 974 under this condition
}

Open hotelcommerce folder –> themes–> hotel-reservation-theme–> js–> modules –> blockcart then open the ajax_cart.js file.

Paste the following code under the “if condition” of line numbers 813 to 822:

if (cart_booking_data[key].date_diff !== 'undefined') {
	// Place code from line no. 815 to 974 under the below if condition
}

Place code from line no. 849 to 858 under the below if condition https://prnt.sc/w5dyzq

if (cart_booking_data[key].date_diff !== 'undefined') {
	// Place code from line no. 815 to 974 under the below if condition
}

The installation of any module is very simple in QloApps.

• Go to the Module and Services tab
• Click on Add New Module

• Now upload the Zip file of the Module and click on Install

After installing the module, read the Readme.md file in the module folder and make the changes mentioned in it.

Now that you have installed the module. So, let us check the module configuration.

The configuration of this addon is very simple. As the module is installed we will have a tab in our menu bar by the name of manage packages.

Now, first let us check how we create activities, transport facilities, special events, nearby attractions, themes, and inclusions for the packages.

Then we will check how to create a package and use the above-mentioned features in the package.

This section will help you add the activities that you can offer in a package.

Just go to the Manage Package tab and select Package Activities.

Now you can add or edit Package Activities.

Now, when you click on Add New Activite, the following page will appear which has three tabs for configuration.

Here you have to enter the basic information about the Activity.

Activities, meals, transport facilities and special events share the same fields. Fill in the following:

• Title and Duration: the name of the element and how long it lasts.
• Description and Documents: the text guests see.
• Country and City: where the element takes place. Choose All to offer it for every location.
• Price Type: Fixed price charges once per booking, Per person price multiplies the price by the adults booked, and Room wise price multiplies it by the rooms booked. Room wise price applies only to packages that include a stay.
• Price, Child Eligibility Age and Child Price: prices exclude tax. Set the child age to 0 to use the default child age limit defined in QloApps.
• Tax Rule: the tax applied to the price.
• Auto add with package: adds the element to the package without the guest choosing it.
• Active: turns the element on or off.

Here you have to select what is included in the activity and what is not.

In this tab, you will be able to Add Activity images

This option will allow you to create all the transportation facilities you offer in your packages so that you can choose which transport facility you want to offer in which package.

Just go to the Manage Package tab and select Package Transport Facility.

When you click on the Add New transport facility, you will have the following page with two tabs.

Enter the basic information about the Transport Facility that you provide.

Here you have to select what is included in the Transport Facility and what is not.

Here you can create and manage special events that can be included in a package.

When you click on the Add New, the following page will appear.

Enter the basic info of Special Events.

Here you have to select what is included in the Special Events and what is not.

Upload the images of the special events here:

With the help of this option, you will be able to add nearby attractions that can be added to a package.

Here to create a nearby attraction, you just have to enter some basic information and upload the images.

Then add an image. 

Use this section to create the meals that you offer in a package, such as breakfast or dinner. Meals are available from version 5.0.0.

Just go to the Manage Package tab and select Package Meals.

Click Add New Package Meal. The form has the same tabs and fields as an activity.

Enter the basic information about the meal.

Here you have to select what is included in the meal and what is not.

Upload the images of the meal here.

Here you can create the Inclusions that can be added to a package.

Just go to Manage Package and select Package Inclusion.

These inclusions are for virtual presentation only. There is one more inclusion tab that u see in manage packages, which tells about the details of the inclusions we create here. 

Click on Add new Inclusion to create one.

Themes define a package. They tell us what kind of package it is. So here we can create themes and then select a theme in a package.

Just click on Add a new theme to create one, then you will have the following page.

Here you can upload the header image of the Tours and Packages landing page.

You can choose whether the landing page destination slider should display available packages based on City and Country.

Use the Global Configurations panel to control the front office buttons and how a package booking affects your hotels. Click Save in this panel after you make changes.

• Disable on Frontend: set to Yes to hide the tours and packages pages on the booking website. Default: No.
• Enable Query Button: shows the floating enquiry button on package pages. Default: Yes.
• Query Button Position, Query Button Text, Bottom Margin (px) and Right/Left Margin (px): the corner, label and distance from the screen edge of the enquiry button. The margins default to 20 and must be positive numbers.
• Create Order for Hotels: set to Yes to create a hotel order for the stay when a guest books a package. Default: Yes.
• Block Room Inventory: when Create Order for Hotels is No, set to Yes to block the stay rooms in the room calendar anyway. Default: Yes.
• Enquiry Popup Phone Number: the number shown as the Call option in the enquiry popup. Leave it blank to hide the option.
• Enable Contact Number Button: shows a floating button with the phone number on the landing page. You can turn it on only when the phone number is filled in. Default: No.
• Contact Button Text, Contact Button Position, Contact Button Bottom Margin (px) and Contact Button Right/Left Margin (px): the label, corner and margins of the contact button. The margins default to 20.
• Enquiry Popup “Know More” CMS Page: the CMS page linked from the enquiry popup when a package has no CMS page of its own.

The floating buttons appear on the landing page like this:

Here you can upload the image of the package destination.

You can upload images for package destination based on the destination type and destination. You can select different images for each package destination.

Use this section when a package includes a stay at a place that is not a hotel in your QloApps. After you create a property, you can select it in the Locations tab of a package. Properties are available from version 5.0.0.

Just go to the Manage Package tab and select Package Properties.

Click Add new property and fill in the following details: Enable Property, Property Name, Rating (0 to 5), Phone, Email, Country, State, City and Description. Save the property first, then add its pictures on the Images tab.

To add room types, edit the property and click Manage Room Types, then click Add new room type. A room type has a Room Type Name, Price, Tax Rules Group, Max Adults, Max Children, Description and images.

Once you click on the Manage Packages option, you will see a list of all created packages.

After creating all the required options for a package, you can start creating a package in QloApps.

To create a new package, click on “Add New Package”.

Now, you have to enter details in various tabs. Let us understand each tab in detail.

In this tab, you will have to fill out the basic details of the package.

Fill in the following details in the information section:

• Title: Enter the title of the package.
• Active: Enable this option to allow booking of this package by guests.
• Overview: Add a brief overview of the package.
• Countries: Select the countries that are included in the package.
• Tour Days: Enter tour duration in days.
• Availability: Enter the date range in which guests can book this tour.
• Add more dates: You can add more than one date range in which guests can book this tour.
• Contact Number For Package Query: Enter the contact number through which your guests can connect with you regarding their queries.
• CMS for “Know More” Link: Select the page on which you want to redirect your guest once he clicks on the “Know More” option of the package query submission form.
• Include Stay: Enable this option if the package you are creating includes the stay of the guest.
• Not Available for Booking: Enable this option if the package you are creating can not be booked directly by the guest. To book the package, they have to first inquire about the same.
• Allow Queries: Enable this option to let guests submit enquiries for this package.

In this tab, you will be able to add all the locations available in the packages along with the hotels and room types included in this package.

In this tab, you can list down all the services that are included and excluded from the package.

This tab tell about the details regarding the inclusion/Exclusion , that is why this tab is different from other inclusion tab which tells about the other visualization of these details.

In this tab, you can define the itinerary of the whole tour. You will have to define each day’s curriculum.

Once you land on this page you will see the list of the day-wise itinerary.

Now to create a day’s itinerary just click on Add New and fill out the following details:

• Information: Here you will have to fill out the basic info of the day and select the location of the tour.

• Activities: Select the activity on that day.

• Events: Select the events scheduled on that day.

• Transport Facility: Select the transport facility offered on that day.

• Nearby Attractions: Here you can add the nearby attractions for better visualization. 

• Meals: Select the meals served on that day.

• Images: Upload up to 4 images per day’s itinerary.

Here you can add all the inclusions that you provide with the package.

This is basically to give the better visual experience about the inclusions. 

This tab will allow you to manage the pricing of the package.

You can price the package on three basis:

• Fixed Price: Select a fixed price of the package and sell it at that price.

• Price per person: Enter per adult price and age of child below which the child will not be charged. The cost of the package will be calculated as per the number of people added to the package by the user.

• Room-wise price: The cost of the package will be calculated as per the number of rooms added to the package by the user.

You can also enter an Additional Price (excluding tax) for a package, and choose the tax rule for the price and for the additional price.

In this tab, you can offer a discount on dynamic prices. So if you are using per-person pricing then you can offer a discount on the basis of the number of people.

For example you can refer to image.

The same can be done for room-wise pricing.

Note: No discounts can be applied in case of fixed pricing.

In this tab, you can add the theme of the tour.

Here you will have to upload all the images that you want to show in the package.

Enter the Package Quantity, the total number of packages available for booking. For a package without a stay, also enter the Seats Quantity, the number of seats available. Turn on Enable Date wise availability to count the remaining stock for each availability date range.

In this tab, you can define all the terms and policies of the package. You can define the Payment Policy, Cancellation Policy, Documents, and Terms and Conditions.

In this tab, you have the option to decide the maximum occupancy that this package can accommodate. This tab appears only for packages that include a stay.

• You can limit the number of rooms that can be added to this package.
• Limit the number of adults and children in this package
• Limit the number of adults and children allowed per room in this package.

To book the tours the user will have to click on the Tour and Packages button on your website homepage.

Once the user clicks on the Tours and Packages button, after which he will land on the Tours and Packages landing page.

screenshot_1744281532071

Now once the user searches for a package on the basis of location and date then he is directed to the package search result page.

The user now clicks on View Details in order to proceed to book a process.

In the itinerary section, the user has the option to customize the room types he wants to book in the package.

The user can also customize the transport facility offered in the package.

Now the user can either Book the package or Enquire about the package.

To book a package the user will have to click on Book Now as shown in the above https://prnt.sc/5SCsJ2umKPt-

.

Once the user clicks on Book Now the system will ask him to add rooms in the package select occupancy in each room.

The user cannot add more rooms than the limit selected by the admin. And he cannot add more occupancy than the limit set by the admin.

Once you click on submit you will have the details of your booking and then you will have to click on Proceed to Checkout.

Once you click on Proceed to Checkout, you will be directed to QloApps default checkout page where you can make the payment and book the package.

When a user clicks on Submit Query a form opens up where the user to enter his details and queries and submit them for the admin to take action.

Once the user submits a query, it will be raised at the backend for the admin to take action.

All the orders placed by the guest of the packages are visible on the “Package Orders” Page.

To view all package orders, click on the orders menu from the menu bar and then select the “Package order” option from the drop-down.

The package order page displays the list of all the booked packages. You can view all the details of the package order, by clicking on the “view” button.

On the package order details page of each order, all details are shown.

NOTE: For each hotel that will provide a stay for a particular package order, a different order will be created for that particular hotel.

Hoteliers can view and edit the booking order of their room type on the hotel orders page.

If you set Create Order for Hotels to No in General Settings, no hotel order is created for the stay. If Block Room Inventory is Yes, the stay rooms are blocked in the room calendar instead. Cancelling or refunding a package order releases the blocked rooms and updates the linked hotel order.

The admin can check Package Enquiries in the Manage Package tab –> Package Enquiries.

Then he will see the list of inquiries submitted by the users. He can click on it to check the details.

Once the admin clicks on View, he can view the details submitted by the user and then change the status of the query.

So, this was all from QloApps Tours and Packages. Hope I was able to explain the module to you.

If you want to learn about the functionality of QloApps then you can visit this link: QLO Reservation System – Free Open-Source Hotel Booking & Reservation System

In case of any query, issue, or requirement please feel free to raise it on QloApps Forum.

Current Product Version – V5.0.0

Supported Framework Version – QloApps 1.7.x