$200.00
1 day
Qty 2
About this role
Project Type: Programming
Experience Level: Expert
Scope & Deliverables:
Design DB structure and add tables
Responsibilities:
Manage DB
Required Skills:
Mysql, PHPMyAdmin
Timeline:
1 day
Duration:
1 day
Quantity:
2
Screening Question:
how long have you been working with Apache
Project context
Project deadline
2026-06-30
Open Sands Safaris Website Development
This scope outlines the functional and design requirements for the Open Sands Safaris digital platform. The goal is to create a high-end, conversion-optimized presence that streamlines the booking process from initial inquiry to automated itinerary generation.
1. Visual Design & User Experience (UX)
The website will feature a "Clean Design" aesthetic, prioritizing high-resolution imagery of the Okavango Delta and surrounding regions while maintaining a professional, uncluttered interface.
Responsive Design: Fully optimized for mobile, tablet, and desktop.
Minimalist Interface: Use of whitespace, elegant typography, and a natural color palette (earthy tones, sands, and sky blues).
Interactive Media: Support for full-width hero videos and masonry-style photo galleries to showcase lodge interiors and wildlife.
2. Content Management System (CMS)
A robust backend allowing the Open Sands team to manage site content without technical knowledge.
Page Management: Ability to create, edit, or delete pages (e.g., About Us, Safari Packages, Conservation).
Media Library: Centralized hub for managing high-quality images and video assets.
Blog/News Module: For SEO-rich updates on wildlife sightings, travel tips, and company news.
User Roles: Multiple permission levels (e.g., Administrator, Editor).
3. Advanced RFQ & Automated Itinerary Planner
This is the core functional engine of the site, designed to reduce manual admin time.
Dynamic RFQ Form: A multi-step form collecting traveler details, dates, guest count, and specific interests (e.g., photography, birding, luxury).
Itinerary Logic: A logic-based system where users select specific camps or activities to "build" a rough trip.
Automated Quote Drafting:
Generates a PDF or Digital Proposal based on selected inputs.
Includes a preliminary cost estimate (standard vs. luxury rates).
Suggested Addition: Integration with a live currency converter (BWP/USD/EUR).
Email Automation: Instant delivery of the draft itinerary to the user, with a blind copy (BCC) sent to the sales team for follow-up.
4. Availability Calendar & Booking Management
A visual tool to manage the logistics of safari tours and vehicle/guide availability.
Live Availability: A front-end calendar showing "Available," "Limited," or "Sold Out" dates for specific safari packages.
Internal Booking Dashboard: A backend view for staff to manually block out dates or confirm incoming requests.
Suggested Addition: iCal/Google Calendar Integration to sync bookings across external platforms or with lodge partners.
5. Standard Functional Features
Contact Form: A simple, direct inquiry form with CAPTCHA protection.
Social Media Integration: Live feeds (Instagram) and sharing buttons to leverage visual content.
SEO Setup: Schema markup for travel agencies, meta-tag optimization, and Google Analytics 4 integration.
Suggested Enhancements
To further elevate the platform, I recommend considering:
Client Portal: A secure area where booked guests can upload passport copies, sign indemnity forms, and view their final travel vouchers.
Interactive Map: A custom-coded map showing the locations of the camps and the typical travel routes between them.
WhatsApp Integration: A floating chat widget for real-time inquiries, which is highly effective for the Southern African travel market.