Complete documentation for the maintenance services workflow in Odoo
The Swimming Pool Maintenance Module is a custom Odoo implementation designed for companies providing swimming pool products, installation, and maintenance services. This documentation covers the complete workflow from customer inspection to contract completion.
Use the sidebar navigation to explore different sections of the workflow. Click on any diagram to view it in full screen with zoom capabilities.
Comprehensive 95-page documentation of the actual current business operations, workflows, pain points, and system requirements before Odoo implementation.
January 3, 2026: Updated with Installation Coordinator workflows, two-system problem documentation, search dysfunction issues, and material returns root causes - all verified from meeting transcripts.
End-to-end view of the maintenance services process
Follow the flow from top to bottom. Each box represents a step, diamonds are decision points, and arrows show the sequence.
Customer contacts company → Quotation created → Paid → Worker inspects pool → Report submitted
Sales order from inspection → Package selected → Paid → Contract auto-created
Visits generated → Employees assigned → Approval requested → Worker notified
Items requested if needed → Check-in → Work done → Check-out → Manager confirms
Who does what in the maintenance services workflow
| Role | Tasks | Reports To |
|---|---|---|
| 🧑💼 Sales Person | Create quotations, sales orders, select packages, review reports | Sales Manager |
| 🧑💻 Accountant | Create invoices, process payments, track records | Finance Manager |
| 👨💼 Maintenance Manager | Create orders, assign workers, generate visits, confirm completion | Operations Director |
| 👷 Worker | Perform inspections, execute visits, check-in/out, request items | Maintenance Manager |
| 📦 Inventory Keeper | Review requests, check stock, approve/reject, issue items | Warehouse Manager |
Initial customer contact and pool inspection process
Customer reaches out requesting pool maintenance services
Sales person creates and sends quotation for initial inspection
Sales PersonCustomer accepts or rejects the quotation
Accountant creates invoice, customer pays
AccountantMaintenance Manager creates the order and assigns worker
Maintenance ManagerWorker visits site, assesses pool, submits findings
WorkerThe inspection report is critical - it determines the maintenance contract details.
Converting inspection results into a maintenance contract
Ensure the following are completed:
Sales person reviews the completed inspection report to understand pool condition and requirements.
Based on inspection findings, create a new quotation for maintenance services.
Choose the appropriate package based on customer needs and budget.
Email the quotation to customer for review and approval.
Customer reviews and accepts the quotation, or requests modifications.
Convert the accepted quotation to a confirmed sales order.
Generate invoice from the sales order for customer payment.
Record customer payment against the invoice.
System automatically generates the maintenance contract upon payment confirmation.
Always attach the inspection report PDF to the quotation email so customers can see exactly what services are included.
Never confirm a sales order before customer approval. This ensures accurate revenue recognition and prevents contract disputes.
For premium customers, consider offering the 12-month package with a discount. Use the "Discount %" field in the order line.
| Document | Status After Phase 2 | Next Action |
|---|---|---|
| Sales Order | Confirmed | Linked to Contract |
| Invoice | Paid | Archived |
| Maintenance Contract | Active | → Phase 3: Visit Planning |
Scheduling and assigning maintenance visits
Ensure the following are completed:
Navigate to the maintenance contract to begin visit planning.
System generates all visits based on the package selected (12, 24, or 48 visits).
Review the automatically generated visit schedule and make adjustments if needed.
Assign appropriate workers to each visit based on location, skills, and availability.
Define the expected time window for each visit.
Send the visit schedule to Upper Manager for approval.
Upper Manager reviews the visit plan and approves or requests changes.
Assigned workers receive notifications about their scheduled visits.
Assign the same worker to a customer consistently. This builds rapport and the worker becomes familiar with the pool's specific needs.
Always check worker availability before assigning. Overloading workers leads to rushed jobs and lower quality service.
Group visits by geographic area to minimize travel time. Use the map view in Odoo to visualize customer locations.
| Item | Status After Phase 3 | Next Action |
|---|---|---|
| Contract | Active | Monitor visit execution |
| Visits | Scheduled | → Phase 4: Execution |
| Workers | Notified | Prepare for visits |
The actual maintenance visit process
Ensure the following are completed:
Worker reviews their assigned visits for the day in the mobile app or Odoo dashboard.
Review if any special materials are needed for the visit. If materials are required, submit an inventory request.
Proceed to the customer's address using the navigation integrated in the app.
Upon arrival, perform check-in to record the start time and location.
Execute the standard maintenance checklist for the pool.
Record all tasks performed and any issues found during the visit.
If any problems are found that require attention, document them.
Complete the visit by performing check-out to record end time.
Maintenance Manager reviews the work report and confirms visit completion.
Always take before and after photos. This provides proof of work quality and helps track pool condition over time.
Never skip the check-in process. GPS verification ensures accurate attendance records and protects both the company and workers.
If the customer is not home, take extra photos and leave a service completion note. Document any access issues in the visit notes.
| Item | Status After Phase 4 | Next Action |
|---|---|---|
| Visit | Completed | Archived in history |
| Contract Visits Count | Decremented | Remaining visits updated |
| Inventory | Adjusted | Materials deducted |
| Work Report | Saved | Available for customer view |
How workers request and receive items for maintenance
Workers should submit inventory requests when:
Worker identifies materials required for upcoming visit or current job.
Submit a formal request through Odoo for the needed items.
Inventory Keeper receives notification and reviews the request.
Verify if requested items are available in warehouse.
Make decision on the inventory request.
Inventory Keeper prepares the approved items for worker collection.
Worker picks up approved items from warehouse.
Submit requests at least 24 hours before needed. This gives the warehouse team time to prepare and ensures items are ready when you need them.
Always return unused items to inventory. This keeps stock records accurate and prevents waste.
For emergency requests (same-day needs), call the warehouse directly after submitting the Odoo request to expedite processing.
| Status | Meaning | Next Action |
|---|---|---|
| Draft | Request created but not submitted | Worker submits request |
| Pending | Awaiting Inventory Keeper review | Inventory Keeper reviews |
| Approved | Request approved, preparing items | Items being staged |
| Ready | Items ready for pickup | Worker collects items |
| Issued | Items collected by worker | Complete |
| Rejected | Request denied | Worker reviews reason |
Manager approval process for scheduled visits
The following actions require Upper Manager approval:
After creating the visit schedule, submit for Upper Manager approval.
Upper Manager accesses the pending approvals dashboard to review.
Upper Manager makes the final decision on the request.
Maintenance Manager reviews feedback and makes corrections.
After approval, the system automatically notifies assigned workers.
Submit approval requests at least 48 hours before the scheduled start date. This gives managers time to review thoroughly and allows for revisions if needed.
Never notify workers before getting approval. This prevents confusion and ensures all schedules are properly authorized.
When resubmitting after rejection, add a note explaining what changes you made. This helps the reviewer approve faster.
| Status | Description | Who Can Change |
|---|---|---|
| Draft | Schedule created, not yet submitted | Maintenance Manager |
| Pending Approval | Waiting for Upper Manager review | Upper Manager |
| Approved | Schedule approved, workers notified | - |
| Rejected | Schedule rejected, needs revision | Maintenance Manager (to revise) |
Available maintenance package options
We offer three maintenance packages designed to meet different customer needs. Each package includes scheduled weekly visits for pool cleaning and maintenance.
| Feature | 3 Months | 6 Months | 1 Year |
|---|---|---|---|
| Duration | 3 months | 6 months | 12 months |
| Total Visits | 12 visits | 24 visits | 48 visits |
| Visit Frequency | Weekly | Weekly | Weekly |
| Best For | New customers | Regular customers | Premium customers |
| Value | Trial period | Standard | Best value |
| Commitment | Low | Medium | High |
| Priority Support | Standard | Priority | VIP |
For first-time customers, we recommend starting with the 3-month package to experience our service quality, then upgrading to the 1-year package for maximum value.
To select a package: Sales → Quotations → Create → Select "Maintenance Contract" → Choose Package
Document and visit status transitions
Status tracking is essential for monitoring progress, identifying bottlenecks, and ensuring accountability. Each document and visit moves through a defined lifecycle from creation to completion.
Documents include Inspection Orders, Quotations, and Contracts. Here's how they progress:
| Status | Description | Triggered By | Next Actions |
|---|---|---|---|
| Draft | Document created, not finalized | User creates new document | Edit, Submit, or Cancel |
| Pending | Awaiting customer or manager action | Document submitted for approval | Approve, Reject, or Request Changes |
| Confirmed | Document approved and confirmed | Manager or customer approves | Proceed to next phase |
| Active | Contract is active and visits ongoing | Payment received, service starts | Execute visits until completion |
| Completed | All visits completed successfully | All contract visits finished | Archive or Renew |
| Cancelled | Document cancelled before completion | User or customer cancels | None (archived) |
Each maintenance visit goes through these status changes:
| Status | Description | Triggered By | Next Actions |
|---|---|---|---|
| Draft | Visit created but not yet scheduled | System generates from contract | Schedule and assign worker |
| Scheduled | Visit scheduled and worker assigned | Manager approves schedule | Worker performs check-in |
| In Progress | Worker on-site, performing tasks | Worker checks in at location | Complete work and check out |
| Pending Confirmation | Work done, awaiting manager review | Worker checks out | Manager confirms completion |
| Completed | Visit confirmed and archived | Manager confirms completion | None (archived in history) |
| Rescheduled | Visit moved to a different date | Manager changes date | Returns to Scheduled status |
| Cancelled | Visit cancelled | Manager or customer cancels | May be rescheduled or credited |
Monitor the "Pending" and "Pending Confirmation" statuses daily. Items stuck in these states may indicate process bottlenecks.
Visits can only be marked "Completed" after the worker checks out AND the manager confirms. Both steps are required.
Use Odoo's filter feature to quickly view all items in a specific status. Go to the list view and add a filter: Status = [desired status]
How the maintenance module integrates with Odoo
The Swimming Pool Maintenance module doesn't operate in isolation. It connects with multiple Odoo modules to provide a seamless experience - from customer management to inventory control to financial reporting.
Customer relationship and quotation management
Materials and supplies management
Financial transactions and reporting
Employee and workforce management
| Action in Maintenance | Triggers In | Result |
|---|---|---|
| Create Inspection | Sales | New lead/opportunity created |
| Confirm Contract | Sales, Accounting | Sales order confirmed, Invoice generated |
| Schedule Visits | HR | Calendar events, Worker assignments |
| Request Materials | Inventory | Stock picking order created |
| Complete Visit | Inventory, Accounting | Stock consumed, Revenue recognized |
| Worker Check-in | HR | Attendance recorded with GPS |
Changes in customer information should be made in the Sales/CRM module. The maintenance module inherits this data automatically.
Always record actual materials used during visits. This ensures accurate inventory levels and proper cost allocation to contracts.
Users only see integration data relevant to their role. Workers see inventory, managers see financials, accountants see full cost analysis.
The customer's experience throughout the service lifecycle
The customer journey maps every touchpoint between the customer and our service - from initial inquiry to contract renewal. Understanding this journey helps us deliver exceptional service at every stage.
Customer learns about our services and makes initial contact.
Technical assessment of the customer's pool.
Customer receives and evaluates service options.
Contract is confirmed and service begins.
Weekly maintenance visits throughout the contract period.
Contract renewal and ongoing relationship.
| Touchpoint | Channel | Handled By | Response Time |
|---|---|---|---|
| Initial Inquiry | Phone, Website, WhatsApp | Sales Person | Same day |
| Inspection Scheduling | Phone, SMS | Sales Person | Within 24 hours |
| Quotation Follow-up | Email, Phone | Sales Person | Within 48 hours |
| Visit Notifications | SMS, WhatsApp | System (Automated) | 24h before visit |
| Service Issues | Phone, WhatsApp | Maintenance Manager | Within 4 hours |
| Billing Questions | Phone, Email | Accountant | Within 24 hours |
| Renewal Reminder | Phone, Email | Sales Person | 30 days before |
Keep customers informed at every stage. Proactive communication about schedules, changes, and service completion builds trust and loyalty.
When problems arise, respond immediately. A quick resolution to issues can turn a negative experience into a positive one.
Regularly ask customers for feedback after visits and at contract renewal. Use insights to continuously improve service quality.
Updated workflow based on comprehensive stakeholder interviews - January 2026
Based on comprehensive interviews with stakeholders across Installation, Periodic Maintenance, and Emergency departments, this v2.0 documentation replaces the original workflow with how the business actually operates, including newly identified roles, processes, and three distinct business lines.
| Aspect | v1.0 (Original) | v2.0 (Actual Reality) | Status |
|---|---|---|---|
| Business Lines | Single "Maintenance" workflow | 3 separate lines: Installation, Periodic Maintenance, Emergency | New |
| User Roles | 5 generic roles | 14 specific roles with clear responsibilities | Changed |
| Inspection Phase | Always required for all services | Conditional - only for new installations without plans (90% of cases) | Changed |
| Contract Timing | Created immediately on payment | Created AFTER first visit for periodic maintenance | Changed |
| Visit Approval | Upper Manager pre-approval required | Teams self-manage schedules, post-verification only | Changed |
| Coordinator Role | Not documented | CRITICAL - Central hub managing 100+ contracts each, 3 coordinators | New |
| Team Assignment | Random per visit | Geographic permanence - same teams serve same areas | Changed |
| Materials Process | Worker requests items per visit | Supervisor requests bulk materials weekly/bi-weekly, distributes to teams | Changed |
| Customer Sources | Generic inquiry | 3 distinct sources: Installation handover (80%), Emergency referral (20%), Direct inquiry | New |
| Renewal Process | Not documented | Accountant creates demand, Coordinator follows up with customer calls | New |
New Pool Installation Projects
Contract-Based Maintenance Services
One-Time Repairs & Inspections
| Role | Department | Key Responsibilities | Criticality |
|---|---|---|---|
| Coordinator (المنسق) | Periodic Maintenance | Customer-facing, visit tracking, renewal monitoring, team assignment, capacity management (3 coordinators × 100+ contracts each) | CRITICAL |
| Installation Coordinator | Installation | Project tracking, scheduling, materials coordination, multi-stage execution management | CRITICAL |
| Installation Ops Supervisor | Installation | Material release verification (contract vs drawing, stock, codes, pricing) | CRITICAL |
| Wijdan (Administrative Assistant) | Periodic Maintenance | Receives handovers, coverage validation, quotation prep, contract creation | CRITICAL |
| Salem (Quotation Reviewer) | Installation | Quality gate for all installation quotations before customer delivery | CRITICAL |
| Khalid (Customer Relations Officer) | Periodic Maintenance | Signature workflow, contract distribution, archive management | Important |
| Accountant | Support | Enhanced role: Payment verification, activation triggers, first visit recording, renewal invoices | Important |
Current Tools (Must Replace): Individual Excel files, WhatsApp photo documentation, phone calls for renewals
Metrics Owned: Active customers per coordinator, stopped/paused customers, contract renewal rate, team utilization rate
Complete end-to-end installation process from inquiry to handover
90% require site inspection (150 SAR). Engineer Hamoud conducts visit, creates specifications, Salem reviews quotation.
50% down payment required before work order creation. Accountant confirms payment triggers execution.
4 stages: Internal piping, External connections, Electrical, Equipment install. Common 1-6 month customer delays between stages.
Supervisor pre-inspection required. Final quality check, customer signature, handover to Periodic Maintenance via WhatsApp group.
When Customer Service selects a filter size, the system automatically includes: Filter unit, sand bags (quantity based on size), matched pump, valves, pressure gauges, spotlights, accessories, fittings, control panel, pipes.
Quality Gate: Salem reviews all quotations to verify filter size, included accessories, pricing, and timeline before customer delivery.
Reasons: Villa construction not complete, plastering/painting pending, pool needs filling, customer financial delay
Problem: Cloud deletes historical reports after 90 days. After 3-6 month delay, customer calls for status but coordinator cannot access old data.
Current Workaround: Coordinators manually save reports to local laptop
System Requirement: Permanent historical record storage, not cloud-based auto-deletion
Gate 1: Contract-Drawing Match (Stop if mismatch: Contract says Skimmer but Drawing shows Overflow)
Gate 2: Stock Availability (Problem: Contracts don't verify stock before finalization)
Gate 3: Item Code Validation (Problem: Contracts use 3-4 year old codes, procurement updated numbers)
Gate 4: Price Verification (Common: Contract 100 SAR vs Actual 1600 SAR - who pays difference?)
Contract-based maintenance services for 300-400+ active customers
Flow: Payment → Accountant activation → Coordinator assigns team → First visit executed → Team sends photos via WhatsApp → Coordinator confirms → Accountant records actual start date → THEN contract created
Why? Customer may not be available on planned date, pool may need repairs, new construction not ready, emergency referrals have pending work
Real Example: Payment Jan 1, First Visit Jan 20 (customer not ready). Contract period: Jan 20, 2026 - Jan 19, 2027 (not Jan 1 - Dec 31, avoiding charging for 19 days of no service)
| Aspect | Original Documentation | Actual Process |
|---|---|---|
| Approval | Pre-approval required before each visit | NO approval needed - Teams self-manage based on predetermined schedule |
| Schedule | Created per visit | Teams know assigned areas, specific days for each neighborhood, bi-weekly frequency |
| Verification | Pre-visit check | POST-visit verification via WhatsApp photos - Coordinator reviews quality |
| Equipment Faults | Team repairs | Team ONLY observes, reports to Coordinator, escalated to Emergency Maintenance |
| Customer Not Available | Not documented | Team calls Coordinator → Coordinator tries alternate numbers → WhatsApp notification → Reschedule |
View 1: Active Customers - Filter by status (Active/Stopped/Expiring), team, zone. Show customer name, location, team assigned, contract dates, visit dates
View 2: Visit Tracking - Today's visits (completed/pending/customer not available), weekly view, pending confirmations, alerts
View 3: Team Capacity - Utilization per team (capacity status: green/yellow/red), geographic coverage map, overtime tracking
View 4: Renewals - Expiring in 30/15/7 days, expired (grace period), renewal status tracking
Cross-department handovers and support processes
Customer inquiry → Site inspection 150 SAR → Quotation & contract → Installation project 2-6 months → 2-year warranty → Handover to Periodic Maintenance
Emergency inspection 150 SAR → Pool assessment → If suitable: Referral to Periodic Maintenance → Ongoing contract service
Equipment problem → Repair service → One-time payment (no contract)
Key changes and system requirements for Odoo implementation
| Area | Current Pain Point | System Requirement | Priority |
|---|---|---|---|
| Coordinator Dashboard | Individual Excel files, no central visibility | Centralized dashboard: Active customers, visit tracking, team capacity, renewals | CRITICAL |
| WhatsApp Handover | No tracking, manual re-entry, photos scattered | Odoo handover module: Auto data transfer, photo storage, coverage validation | CRITICAL |
| Historical Records | Cloud deletes after 90 days, coordinators save locally | Permanent storage: All project history accessible indefinitely | CRITICAL |
| Contract Timing | Risk of inaccurate start dates | Contract auto-generated AFTER first visit confirmation | CRITICAL |
| Material Quality Gates | Manual verification, old item codes, price mismatches | Automated validation: Stock check, current codes, price verification | High |
| Renewal Tracking | Dual monitoring (Coordinator Excel + Accountant system), risk of missed renewals | Unified system: Auto alerts 45/30/15/7 days, task assignment, outcome tracking | High |
| Bundled Products | Exists and appreciated | Maintain and enhance: Auto-add complete product sets based on filter size | High |
| Geographic Coverage | Manual validation by Wijdan | Auto-detect: Address validation against covered zones, auto-reject uncovered | Medium |
Technical implementation mapping for Odoo developers
These diagrams show exactly what needs to be built in Odoo. Each step is color-coded to indicate whether it uses Standard Odoo, the Custom Maintenance Module (already built), or requires New Customization.
Uses built-in Odoo features (Sales, CRM, Accounting, Inventory). No custom development needed.
Already built custom module. Handles contracts, visits, assignments after payment confirmation.
Requires new development: fields, views, reports, scheduled actions, or security groups.
Physical or external processes (WhatsApp, phone calls, paper documents). Not in Odoo.
| Category | Items | Status |
|---|---|---|
| Standard Odoo | Sales Quotations, Invoicing, Payments, CRM Leads, Inventory Transfers | Ready |
| Custom Module | Contracts, Visits, Coordinator Assignment, Visit Completion | Built |
| New Fields | Area/Zone, Secondary Phone, Lead Source, Contract Status, Photo Attachments | To Build |
| New Views | Coordinator Dashboard, Relations Dashboard, Team Assignment View | To Build |
| New Reports | Contract PDF (QWeb), Performance Report | To Build |
| Scheduled Actions | Contract Expiry Check (ir.cron), Email Alerts | To Build |
| Security Groups | Coordinator, Supervisor, Admin Assistant, Customer Relations, Customer Service | To Build |
End-to-end process showing what to build in Odoo
New: Lead Source Field, Area/Zone Field in CRM
Odoo: CRM Leads, Lost/Qualified status
Odoo: Sales Quotations, Orders, Invoicing, Payments
No customization needed
Custom Module: Contract creation, Coordinator assignment, Visit scheduling
Already built
New: QWeb Report Template, Contract Status Field, Attachment Field
Custom Module: Visit scheduling, completion
New: Visit Status (no-access), Photo Attachments
New: ir.cron for expiry check, Email templates
Odoo: Accounting for renewal invoices
Security groups and permissions to implement
| Role | Type | Permissions Needed |
|---|---|---|
| Sales Person | Odoo Standard | Odoo Sales → Sales Group |
| Accountant | Odoo Standard | Odoo Accounting → Accountant Group |
| Warehouse Staff | Odoo Standard | Odoo Inventory → Inventory Group |
| Maintenance Manager | Custom Module | Full access to Maintenance module |
| Worker Team | Custom Module | View/Edit assigned visits only |
| Coordinator | New | Dashboard view, Customer assignment, Visit tracking |
| Supervisor | New | Area-based scheduling, Team management |
| Admin Assistant | New | Limited access, Contract PDF generation |
| Customer Relations | New | Contract routing, Coordinator assignment |
| Customer Service | New | Communication access, Send quotations |
Lead acquisition and quotation process
Add selection field to CRM Lead: Installation Handover, Emergency Maintenance Referral
Add Many2one field to Partner/Lead for coverage validation
Use standard Odoo CRM stages - no customization needed
Use standard Odoo Sales - no customization needed
Physical contract generation and routing workflow
Create contract PDF template with auto-filled customer data, duration, value, visits count
Selection: Pending Relations → With Coordinator → With Supervisor → Signed
Kanban view for Customer Relations to see pending contracts
Binary field to upload scanned signed contract
Area-based scheduling and visit completion
Many2one field for area-based filtering (North, South, East, etc.)
Additional phone field for alternate contact numbers
Add "No Access" status to track unreachable customers
Binary field for visit completion photos
Action button to escalate equipment faults to Emergency Maintenance
Daily operations and customer management
Kanban/list view showing today's visits, my customers, pending actions
Many2one linking customers to assigned coordinator
Store primary, secondary, alternate phone numbers
Chatter integration for communication history
Dashboard widget showing contracts expiring in 30 days
Report view showing visits completed, customer satisfaction
Contract expiry monitoring and renewal workflow
Daily job to check contracts expiring in 30 days
Renewal reminder email sent to coordinators
List view filtered by expiry date range
Field to mark non-renewed customers as inactive
Use standard Odoo Accounting - no customization
Existing custom module handles contract renewal
Supervisor-based material requests and distribution
View to calculate material needs based on active contracts
Form to request multiple products at once
View to distribute materials to teams by route
Acknowledgement field for team material receipt
Notification when team reports low stock
Use standard Odoo Inventory operations
Understanding colors used throughout the diagrams
Built-in Odoo features - no development needed
Already built custom module
Requires new development
Physical processes outside Odoo
Comprehensive analysis comparing the implemented system vs. actual business operations
There is a FUNDAMENTAL DISCONNECT between the implemented system and actual operations. The system was designed for an idealized workflow that does NOT match reality.
| Metric | Finding |
|---|---|
| Missing Critical Roles | 4 roles (Coordinator, Customer Relations Officer, Administrative Assistant, Installation Coordinator) |
| Process Mismatches | 8 major workflow differences |
| Manual Workarounds Required | 7 documented workarounds |
| System Bypass Rate | Estimated 60-70% of operations happen outside the system |
| Primary Tools Actually Used | WhatsApp (90%), Excel (80%), Word (70%) |
| System Adoption Rate | Estimated 30-40% |
For each gap identified, we document the following attributes:
| Attribute | Description |
|---|---|
| Gap ID | Unique identifier (e.g., GAP-ROLE-001) |
| Severity | Critical / High / Medium / Low |
| Category | Role / Process / Data / Integration / UX |
| Current State | What actually happens in operations |
| Implemented State | What the system provides |
| Gap Description | The specific mismatch |
| Business Impact | Effect on operations, revenue, efficiency |
| Workaround | How staff currently handle this |
| Recommended Fix | What needs to be implemented |
| Priority | P0 (Critical) / P1 (High) / P2 (Medium) / P3 (Low) |
| Gap ID | Financial Impact | Annual Estimate (SAR) |
|---|---|---|
| GAP-PROC-005 | Missed renewals | 375,000 |
| GAP-DATA-001 | Inefficient operations | 150,000 |
| GAP-INT-001 | Triple data entry waste | 200,000 |
| GAP-ROLE-001 | Coordinator inefficiency | 100,000 |
| GAP-UX-002 | WhatsApp dependency risks | 50,000 |
| TOTAL | ~875,000 SAR/year | |
| Impact Category | Severity | Description |
|---|---|---|
| Staff Productivity | 🔴 Critical | 60-70% of work happens outside system (Excel, WhatsApp) |
| Data Quality | 🔴 Critical | Fragmented data, no single source of truth |
| Customer Experience | 🟠 High | Manual processes lead to delays, errors |
| Management Visibility | 🔴 Critical | Cannot answer basic questions about business |
| Scalability | 🔴 Critical | Cannot grow business with current manual processes |
| Risk & Compliance | 🟠 High | WhatsApp dependency, no audit trails |
Detailed analysis of the 4 missing critical roles in the current implementation
The MOST CRITICAL operational role in periodic maintenance is completely missing from the system design. This role is the hub of all coordination between customers, teams, supervisors, accountants, and management.
Role does not exist in the system. System only has: Sales Person, Maintenance Manager, Worker, Accountant, Inventory Keeper
Critical project coordination role missing. Installation projects require dedicated coordinators to manage complex multi-stage workflows (payment → inspection → materials → installation → handover).
Critical gatekeeper role missing. Administrative Assistant is the first filter for periodic maintenance customers.
The signature collection process is a multi-step physical workflow not supported by the system.
Forward: Admin → Khaled → Coordinator → Supervisor → Team → Customer
Reverse: Customer → Team → Supervisor → Coordinator → Khaled → Archive
System creates contract IMMEDIATELY on payment. Reality: Contract created 2-3 WEEKS LATER after first visit confirmed.
Customer pays: January 1
First visit: January 20 (customer not ready until then)
Contract created: January 22
Contract should be: January 20 - January 19 (next year)
System would create: January 1 - December 31
Result: Customer billed for 19 days of no service
No renewal workflow exists in system. Renewal is a DISTINCT PROCESS from new customer acquisition.
Complete blueprint for implementing the swimming pool maintenance system in Odoo
Root Cause: Current implementation was designed for an idealized workflow that does not match actual business operations in 8 critical areas.
| Business Area | Implementation Gap | Business Impact | Odoo Solution |
|---|---|---|---|
| User Roles | 4 critical roles missing | 70% work outside system | Create custom user groups with specific permissions |
| Workflow Logic | 8 process mismatches | Manual workarounds for 60% of operations | Customize Sales, Project, and Field Service modules |
| Contract Timing | Immediate vs. After First Visit | Customer disputes, billing errors | Custom contract workflow with approval states |
| Visit Management | Pre-approval vs. Self-managed | Would create 800+ unnecessary approvals/week | Remove approval, use post-visit confirmation |
| Materials Process | Per-visit vs. Bulk distribution | 600-800 redundant requests/week | Custom material request workflow for supervisors |
| Renewal Process | Non-existent | 375,000 SAR/year lost revenue | Automated renewal workflow with alerts |
| Team Assignment | Random vs. Geographic permanence | Customer dissatisfaction, inefficiency | Custom geographic assignment logic |
| Data Integration | Dual systems (Oracle + Cloud) | Triple data entry, 90-day deletion | Unified Odoo with permanent retention |
Access Rights:
Menu Access:
Menu Access:
Notifications:
Geographic Restrictions:
Menu Access:
Business Logic:
Quality Gates (System Enforced):
Goal: Fix critical gaps that prevent basic system usage
Deliverables:
Success Criteria:
Goal: Drive user adoption across all roles
Deliverables:
Success Criteria:
Goal: Fine-tune and optimize workflows
Deliverables:
Success Criteria:
| Priority | Gap ID | Fix | Effort | Business Impact |
|---|---|---|---|---|
| P0-1 | GAP-ROLE-001 | Create Coordinator role with dashboard | 3-4 weeks | Unblock 60% of operations |
| P0-2 | GAP-PROC-001 | Fix contract timing (after first visit) | 2 weeks | Prevent customer disputes, accurate billing |
| P0-3 | GAP-PROC-005 | Implement renewal workflow with alerts | 2-3 weeks | Recover 375,000 SAR/year lost revenue |
| P0-4 | GAP-DATA-001 | Build unified customer database | 4-5 weeks | Single source of truth, eliminate Excel dependency |
| P0-5 | GAP-DATA-003 | Automated expiry alerts | 1-2 weeks | Prevent missed renewals |
| P0-6 | GAP-INT-001 | Migrate from dual system to unified Odoo | 8-12 weeks | Eliminate triple entry, permanent data retention |
| P0-7 | GAP-ROLE-002 | Create Installation Coordinator role | 2-3 weeks | Installation project tracking |
Total P0 Effort: ~22-35 weeks (5-9 months)
Complete understanding of the actual business structure and roles
Services:
Services:
Services:
| Role | Count | Key Responsibilities | Status |
|---|---|---|---|
| Customer Service Representative | 4 | Receive inquiries, create quotations, send via WhatsApp, receive payments | ✅ Exists |
| Installation Coordinator | 3 | Regional project management, material requests, timeline tracking, currently use Excel | 🔴 MISSING |
| Lead Engineer | 1 | Site inspections, pool specifications, equipment requirements | ✅ Exists |
| Quotation Reviewer | 1 | Quality gate: Reviews ALL quotations before sending, final approval authority | 🟠 Partial |
| Installation Operations Supervisor | 1-2 | CRITICAL QUALITY GATE: Material release verification, pre-installation inspection | 🔴 MISSING |
| Role | Count | Key Responsibilities | Status |
|---|---|---|---|
| Administrative Assistant | 1 | Receives handovers, coverage validation, quotation prep, contract creation | 🔴 MISSING |
| Coordinator | 3 | MOST CRITICAL: Customer contact, visit tracking, renewals, team assignment (100+ contracts each) | 🔴 MISSING |
| Supervisor | 2-3 | Link to teams, bulk materials distribution, quality visits, mid-week training | ✅ Exists |
| Field Teams | 12-14 | Execute visits (6 days/week), bi-weekly service, geographic fixed areas | ✅ Exists |
| Customer Relations Officer | 1 | Contract signature workflow, distribution chain management, archives | 🔴 MISSING |
| Zone | Coordinator | Teams | Notes |
|---|---|---|---|
| Zone 1: East Riyadh + Part North | Mohammed | 4-5 teams (8-10 workers) | 20+ neighborhoods divided by days |
| Zone 2: Complete North Riyadh | Colleague 2 | 4-5 teams (8-10 workers) | ⚠️ OVERTIME ZONE - High-density area, maximum capacity |
| Zone 3: West + South Riyadh | Ibrahim | 3-4 teams (6-8 workers) | Growing area, room for expansion |
Villages (قرى), Remote Provinces, Uncovered Areas - customers in these locations are automatically rejected during coverage validation.
3 Coordinators × 100+ contracts each = 300-400 total active contracts managed. This role is the hub of all coordination between customers, teams, supervisors, accountants, and management.
Complete end-to-end installation process from inquiry to handover
Two Options:
Quality Gate: Salem reviews ALL quotations before sending to customer
| Activity | Details |
|---|---|
| Measurements |
|
| Equipment Requirements |
|
| Special Features |
|
| Site Challenges |
|
When Customer Service selects a filter size, the system automatically adds ALL related components. This saves significant time and reduces errors.
Quote: "If we didn't see anything, there will be a lot of mistakes"
Check: Compare contract specifications vs. drawing specifications
Common Mismatches:
If Mismatch: ❌ STOP - Cannot release until resolved. Coordinate with Drawing Manager and Contract Creator.
Check: All items in stock?
Problem: Contracts don't verify stock before finalization. Supervisor discovers missing items HERE.
If Missing: ⚠️ Find alternatives, wait for restock, or request contract change.
Check: Product codes current?
Problem: Contracts use 3-4 year old codes. Procurement updated numbers. Old codes not in system.
If Invalid: ⚠️ Search by item NAME, find current equivalent, update request.
Check: Contract price vs. current item cost
Common Issues:
If Mismatch: ❌ STOP - Get Accounts approval for price difference.
Material released to warehouse. Technician can collect and proceed with installation.
Complete periodic maintenance process from customer acquisition to renewal
Wijdan validates location:
Contract NOT created until AFTER first visit. This is fundamentally different from v1.0 implementation.
| Reason | Explanation |
|---|---|
| Actual Start Date Confirmation | System needs REAL activation date, not estimated |
| Customer Availability | Customer may not be available on planned date |
| New Construction | Customer may not be moved in yet. Request delay: "at end of month" |
| Pool Readiness | Pool may need repairs, cleaning, or filling before maintenance can start |
| Emergency Referrals | Pool may still have pending repairs |
Teams self-manage based on predetermined schedules. This is a MAJOR difference from v1.0 which required approval for every visit (would create 600-800 approvals/week!).
Example: Team 65
Both Coordinator AND Accountant track expiry dates manually. Risk: If both miss, renewal lost. Estimated 375,000 SAR/year lost revenue from missed renewals.
80% of periodic maintenance customers come from installation handovers. The system does NOT currently support this workflow.
Complete 95-page documentation of actual current operations before Odoo implementation
All information verified from meeting transcripts with cross-referencing to ensure accuracy.
Business Lines
Installations, Periodic Maintenance, Emergency Maintenance
Use Cases
Real scenarios from actual operations
Critical Roles
Including coordinators, supervisors, engineers
Pain Points
System issues and operational challenges
Complete org chart with roles, responsibilities, and team divisions
End-to-end processes for installations, periodic & emergency maintenance
Oracle + Cloud system problems, Excel workarounds, WhatsApp communication
Two-system problem, search dysfunction, material returns, manual tracking
Contract terms, warranty periods, payment schedules, service packages
20+ real scenarios from new customer to renewal process
The complete 95-page documentation is available in Google Docs for easy access, commenting, and collaboration.
💡 Tip: Use Google Docs for commenting, suggesting edits, and collaborative review. Download the markdown version for offline access.