Contact person: Business Client

Phone:Show

Email:Show

Location: Istanbul, Turkey

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Project Overview
We currently manage our yacht inventory through an internal Excel file that includes up-to-date availability dates, pricing, capacities, ports, and other key details. When preparing offers, our team manually extracts data from this file and creates quotation emails.
We want to transform this workflow into a secure, internal web-based backend system that will only be accessible to company staff. The system will serve as a centralized yacht database with availability management, advanced filtering, and automated quotation email generation.
This is not a public-facing website, but a staff-only admin panel/backend tool integrated into our existing website environment.

Project Goals
Replace Excel-based workflow with a structured backend system
Manage yacht data, pricing, and availability via an admin panel
Search and filter yachts based on date and multiple criteria
Automatically generate professional quotation email drafts

Core Features & Requirements

1) User Authentication & Access Control
Secure login system
Staff-only access (no public users)
Role-based permissions (Admin / Staff)
User management (create, edit, deactivate users)

2) Yacht Database Management
Each yacht record should include at least the following fields:
Yacht name
Yacht type (gulet, motor yacht, sailing yacht, catamaran, trawler, etc.)
Number of cabins
Guest capacity
Home port / embarkation port (and optional alternative ports)
Central Agency status (CA / non-CA)
Central agency notes
Contact phone number
Contact email
Internal notes / special conditions
Full CRUD functionality (create, edit, delete, duplicate yachts).

3) Pricing Module
Monthly pricing structure (e.g. May–October)
Price type (weekly / nightly)
Currency support
Optional season labels (Low / Mid / High Season)
Easy editing and clear overview per yacht

4) Availability Calendar
Yacht-based calendar view
Status types: Available / Booked / Option / Maintenance
Date range selection (start–end)
Visual calendar interface
Ability to quickly block or free dates
Optional notes per booking/block

5) Advanced Search & Filtering Engine
Search yachts based on:
Date range (availability check)
Guest capacity
Number of cabins
Port / embarkation location
Yacht type
Price range
Central agency status
Results should show:
Matching yachts only
Clear availability indication
Key summary info for fast comparison

6) Quotation Email Generator
Select one or multiple yachts from search results
Auto-generate a structured quotation email draft including:
Yacht name
Dates
Price
Capacity & cabins
Port
Notes
Editable before sending
Copy-to-clipboard and/or downloadable format (PDF or text)
Email sending itself can be optional (draft generation is mandatory)

7) Admin Panel & UX
Clean, fast, and intuitive backend UI
Optimized for daily operational use
Desktop-first (mobile responsiveness is a plus)
Technical Expectations
Backend-focused solution (framework open to suggestion)
Secure authentication and data handling
Scalable database structure
Clean, well-documented code
Ability to migrate/import existing Excel data (CSV import is sufficient)
Deliverables
Fully functional backend system
Admin panel with all modules listed above
Deployment-ready version on our server or staging environment
Basic documentation (setup + usage)

Nice to Have (Optional)
Excel/CSV import & export
Activity logs (who changed what & when)
Future API readiness for possible CRM/website integration" (client-provided description)