Case Study

Executive Summary

Playwheel KSA aimed to transform the manual booking process for children’s workshops and events in Saudi Arabia into a seamless, automated experience. Facing challenges like complex Odoo integration, real-time availability, and user engagement, the solution delivered a robust platform with a user-friendly interface, secure payments via MyFatoora, and an engaging photo gallery. The result was an 80% reduction in manual workload, a 70% surge in online bookings, and a scalable system handling 1,500 concurrent users during peak times.

Challenges

• Odoo Integration Complexity: Syncing manual bookings from Odoo’s ERP system with the website was technically demanding due to Odoo’s intricate architecture.
• Real-Time Availability: Ensuring accurate, up-to-date event schedules and seat availability to prevent overbooking.
• Payment Gateway Compliance: Integrating MyFatoora to meet local regulations while ensuring secure transactions.
• User Experience: Designing an intuitive interface for parents to manage bookings, profiles, and event photos effortlessly.
• Photo Storage and Performance: Managing high-quality event photos while maintaining fast load times and cost efficiency.
• Scalability: Building a system to handle high traffic during peak booking periods without performance degradation.

Solution

Playwheel KSA’s platform automated the booking process with a modern tech stack and user-centric features:

• Event and Workshop Booking: Browse a calendar, check seat availability, and book instantly with real-time updates to prevent overbooking.
• Package Booking: Customize and book special packages like birthday events directly on the platform.
• Children’s Profile Management: Create and manage children’s profiles with details like age and preferences for streamlined bookings.
• Event Photo Gallery: Display high-quality event photos in a responsive, lazy-loaded gallery to boost trust and engagement.
• Odoo Synchronization: Sync manual bookings from Odoo via custom APIs for data consistency.
• Secure Payments: Integrate MyFatoora for reliable transactions supporting local payment methods.
• Responsive Design: Ensure a seamless experience across desktops, tablets, and mobiles using Next.js.

User Journey

1. Registration and Profile Setup:
   • Users sign up with basic details and create profiles for their children, including age and preferences.
   • A dashboard displays upcoming events and booking history.
2. Event Browsing and Booking:
   • Browse a calendar of workshops and events, with filters for date, type, and availability.
   • Select an event, view available seats, and book instantly with real-time updates.
3. Package Customization:
   • Choose special packages (e.g., birthdays), customize details, and confirm bookings.
4. Photo Gallery Exploration:
   • Access a gallery of event photos, view high-quality images, and share or download them.
5. Payment and Confirmation:
   • Complete secure payments via MyFatoora and receive booking confirmations via email.

Technical Implementation

• Backend: Django with RESTful APIs handled bookings, profiles, and photo uploads. Celery managed background tasks like Odoo sync and email notifications.
• Database: PostgreSQL was optimized with indexes for fast queries on event dates and seat availability. Triggers ensured real-time seat updates.
• Frontend: Next.js enabled SEO-friendly, dynamic UI with MobX for state management of booking forms and photo galleries. Tailwind CSS ensured responsive design.
• Photo Management: AWS S3 stored photos with CDN delivery for fast load times. Lazy loading and progressive image loading enhanced performance.
• Odoo Integration: Custom middleware used Odoo’s XML-RPC API for real-time synchronization of manual bookings.
• Payment Gateway: MyFatoora’s SDK was integrated for secure payment processing, with PostgreSQL storing transaction records.

Technology Stack

• Frontend: Next.js, MobX, Tailwind CSS
• Backend: Python, Django, Django REST Framework
• Database: PostgreSQL
• Photo Storage: AWS S3
• Payment Gateway: MyFatoora
• Background Tasks: Celery
• Odoo Integration: Custom API with XML-RPC

Success Metrics

• Operational Efficiency: 80% reduction in manual booking workload, freeing staff for event planning.
• User Engagement: 70% increase in online bookings and 25% boost in engagement due to the photo gallery.
• Data Accuracy: 99.9% accuracy in Odoo synchronization, eliminating discrepancies.
• Payment Reliability: 98% payment success rate with MyFatoora, with zero security issues.
• Performance: 30% faster page load times for photo-heavy pages via Cloudinary optimization.
• Scalability: Handled 1,500 concurrent users during a major event launch without downtime.

Challenges Overcome

• Odoo Integration: Developed custom APIs and middleware to sync data within seconds, addressing Odoo’s complexity.
• Real-Time Availability: Optimized PostgreSQL with triggers and indexes to ensure accurate seat counts.
• Payment Compliance: Configured MyFatoora to meet local regulations, with rigorous testing for security.
• Photo Performance: Used AWS S3 with CDN and lazy loading to balance quality and speed.
• Scalability: Conducted load testing and optimized server configurations to handle peak traffic.

Conclusion

Playwheel KSA revolutionized children’s event bookings in Saudi Arabia, delivering an automated, user-friendly platform that reduced manual effort, boosted bookings, and enhanced engagement through features like the photo gallery. With a scalable tech stack, seamless Odoo integration, and secure payments, the platform sets a benchmark for event booking solutions in the region, with potential for future expansions.