Optimizing Bookings for a Skydiving Experience
DZK
Problem: The client, who owns 5 airfields, faced several issues:
- Bookings were taken by phone and recorded in Excel.
- This led to errors, double bookings, and equipment downtime.
- It was impossible to track real capacity and profitability.
Our Task: To create a unified system that automates bookings, manages schedules across 5 locations, and gathers analytics.
How We Implemented This System
1. Developed a precise booking form
To reduce errors, we removed all unnecessary fields. The 3-step form (Service > Date/Time > Payment) automatically checks available slots in real-time. If there are no spots, the slot cannot be booked.
2. Created a flexible admin panel
The client previously experienced issues because their company had varying prices and services in different cities. We implemented a panel where an administrator can:
- Link a service to a specific city.
- Set a separate schedule and prices for it.
- Define a quota of spots for each time slot.
Result: Launching a new city in the system now takes an administrator 15 minutes, instead of 2 days of coordination.
3. Implemented a dynamic funnel algorithm
For flights to be profitable, aircraft shouldn't fly half-empty. We developed an algorithm:
- The system does not show all slots by default.
- New slots for Day X are opened automatically only after the current ones are 80% full.
- The owner sets this threshold themselves (60%, 80%, etc.).
Result: The system automatically ensures maximum aircraft capacity and minimizes "empty" flights.
4. Integrated marketing modules
We built in two tools to increase sales:
- Gift certificates: Ability to issue a certificate with a fixed validity period (e.g., 6 months).
- Promo codes: Ability to create a promo code for a discount (%) or a fixed amount. The system automatically validates them during booking.
5. Developed a partner module
We created a separate module so that travel agencies and instructors could sell flights. The partner sees their commission, and the owner tracks all sales and statistics for each partner in real-time.
Technology Stack
What We Used
We chose Laravel for the server-side logic (API) and Vue.js for the interfaces.
- Laravel ensures stable and secure transaction processing and schedule management.
- Vue.js makes the admin interface and booking form fast and responsive.
Conclusion
The system implementation allowed the client to move from chaotic manual accounting to a fully automated process. This reduced booking errors by 95% and gave the owner accurate data on the profitability of each airfield. The system's architecture makes it easy to add new cities and partners.