Skip to main content
Discuss your project Custom business systems & automation

Portfolio Chrystofor Tour CRM

From a site enquiry to a paid trip, in one system

A custom CRM for Chrystofor Tour, a tour operator from Lviv. Managers keep clients, deals and payments in it, and the content manager keeps tours with itineraries and prices, which the xt.lviv.ua website pulls from here on its own.

Project

Chrystofor Tour CRM

Chrystofor Tour CRM · project Travel
Client
Chrystofor Tour A tour operator from Lviv: coach and flight tours across Europe, school trips, international festivals and contests.
System
A panel for managers, finance staff and the director Also the source of tours, prices and photos for the website and the inbox for its enquiries.
Our role
Process analysis, data structure, UX/UI, frontend and backend Plus moving clients from the previous CRM and tours from the old systems, the API for the website, testing and rollout.
Technologies
  • PHP
  • Laravel
  • Filament
  • Livewire
  • MariaDB
Integration
Shared data with the xt.lviv.ua website The website pulls tours, excursions and photos through the API and sends bookings and callback requests back to the CRM.

Challenge

Clients, tours and money in different places

Before the launch, clients and companies lived in the previous CRM, while tours sat in a separate system and on the old website. The company needed one system where a deal goes from the first enquiry to payment and a tour is entered once, for both the managers and the website.

A deal from enquiry to trip

Enquiry, quote, offer, agreement, prepayment, confirmation. A manager has to see which step every deal is at and what to do with it next.

Prices and payments in several currencies

Tour prices may be in euros or other currencies, and payments arrive in parts and at different rates. You need to know what has been paid, what is left and when the balance is due.

One set of tours for managers and the site

Day-by-day itineraries, departures with dates and prices, excursions, hotels and photos had to be entered once and appear on the website without copying.

A database full of repeats

Schools, ensembles, group leaders and travellers had piled up over the years in different systems, so one person could be recorded several times.

Solution

A system built around the deal

A deal board by stage

Deals move through the pipeline “New enquiry → Quote → Offer sent → Agreement → Prepayment → Confirmed”. Forward only one step at a time, back only with a comment, to “Lost” only with a reason. A deal with no conversation for over a week is flagged as “quiet”.

The price calculates itself

Adults and children, early-booking prices, a discount and extra costs such as tickets, meals and transfers. The price can be taken from the tour’s price grid by period, number of nights and age.

Payments and debts

Prepayments, balance payments and refunds in six currencies with a rate to the hryvnia. The system keeps the balance of every deal, creates finance tasks by itself and reminds the finance manager a week before full payment is due.

The tours the website lives on

Tours, departures, day-by-day itineraries, excursions with prices by age, hotels and photo sets are edited in the CRM. The website picks up the changes through the API and removes deleted records on its own.

Site enquiries with no retyping

A tour booking becomes a deal for the right tour and departure, and “Call me back” becomes a task with a due time. The system finds the client by phone or email, a repeated request creates no duplicate, and managers are notified at once.

Duplicates and change history

Every night the system looks for similar clients by phone, email and name. A manager decides which record to keep, and all deals, conversations and files move to it. Every change is kept in the record’s history.

Capabilities

From the first enquiry to payment

01 · 5

Clients

  • Contacts and companies: schools, ensembles, agents, travellers
  • Phone, email, Viber, Telegram, Instagram, Facebook
  • Conversation log with the next step planned
  • Nightly duplicate search and record merging
  • Files and documents, including photos from a phone camera

02 · 5

Deals and tasks

  • Pipelines with configurable stages and loss reasons
  • Price calculation from the tour’s price grid
  • Tasks with due dates and a “due today” flag
  • Unassigned site enquiries and a “Take it” button
  • In-panel notifications about new deals and assignments

03 · 6

Finance

  • Payments and refunds in UAH, EUR, USD, GBP, PLN and CAD
  • Exchange rate and hryvnia equivalent for every deal
  • Payment details and settlement statuses
  • Debts and overdue payments
  • Cash desks and bank accounts
  • Automatic finance tasks and reminders

04 · 6

Tours and platform

  • Tours, festivals, contests and cruises
  • Departures, price grids pasted from Excel and day-by-day itineraries
  • Excursions, hotels, carriers, coaches and drivers
  • API for the website: tours, excursions, photos and incoming enquiries
  • Access roles, change history and a sign-in log
  • Internal staff chat

Result

One deal, from the website to a completed trip

Website enquiries reach the CRM together with the tour and departure, and a manager takes each one across the stage board until the trip is over.

Payments in different currencies are converted to hryvnia, debts are visible in a separate list, and the system sets balance-payment reminders on its own.

Tours are edited in one place: the xt.lviv.ua website pulls itineraries, prices and photos from the CRM, so managers and travellers see the same dates and prices. Clients from the previous CRM and tours from the old systems were moved into the new one.