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