🆕 Module Highlights

• Search contacts by full or partial phone number
• Automatic phone normalization (removes spaces, dashes, parentheses)
• Works with any format: (828)-316-0593, 828-316-0593, 8283160593
• Lightning-fast search with PostgreSQL indexes
• Optional phone uniqueness enforcement
• Prefix and suffix search support

🔍 Smart Phone Search

• ✓ Type any phone number format to find contacts
• ✓ Search by full number: 8283160593
• ✓ Search by partial: 828, 828316
• ✓ Works with dashes: 828-316-0593
• ✓ Works with parentheses: (828)-316-0593
• ✓ International formats supported

⚡ Lightning Performance

• ✓ PostgreSQL text_pattern_ops indexes for instant search
• ✓ Stored computed fields (phone_clean, mobile_clean)
• ✓ Reversed fields for suffix search
• ✓ Works with millions of contacts
• ✓ No performance degradation

🛡️ Data Integrity

• ✓ Optional phone uniqueness enforcement
• ✓ Prevent duplicate numbers
• ✓ NULL-safe and empty-safe constraints
• ✓ Detects duplicates across formats
• ✓ Configurable via Settings

⚙️ Flexible Configuration

• ✓ Settings accessible in General Settings
• ✓ Minimum digits for search trigger (default: 3)
• ✓ Enable/disable uniqueness checking
• ✓ Show phone in search results dropdown
• ✓ Strip leading zero option (Gulf/Saudi numbers)
• ✓ No complex configuration needed

📞 Phone Normalization

The module automatically normalizes all phone numbers:

• (828)-316-0593 → 8283160593
• 055 123 4567 → 551234567 (with strip leading zero enabled)
• 00966-55-123-4567 → 966551234567

Removes all spaces, dashes, parentheses, and handles international prefixes (00). Leading zero stripping is configurable for regional needs.

🎯 Smart Search Priority

1. Exact Match: Finds exact normalized number
2. Prefix Match: Finds numbers starting with search term
3. Suffix Match: Finds numbers ending with search term
4. Name Fallback: Standard name search if not a phone number

• 📞 Call Centers: Find customer records instantly when they call by typing their phone number.
• 💼 Sales Teams: Quickly lookup leads and opportunities using mobile numbers from business cards.
• 🛒 E-commerce: Search for orders and customers using phone numbers during customer support.
• 🏥 Healthcare: Find patient records by phone number for appointment scheduling.
• 🏨 Hospitality: Search reservations and guest profiles using contact numbers.
• 🚚 Logistics: Locate delivery addresses and customer details via phone lookup.
• 📱 CRM Systems: Universal contact search across all modules using phone numbers.

📦 Installation

1. Install from Odoo Apps Store or upload manually
2. Click Install - all dependencies are automatic
3. Module is ready to use immediately
4. Existing phone numbers are automatically normalized

⚙️ Configuration

Navigate to: Settings → General Settings → Contact Search by Phone

• Minimum Digits: Set how many digits trigger phone search (default: 3)
• Enforce Unique Phones: Enable to prevent duplicate phone numbers
• Show Phone in Search: Display phone number alongside contact name
• Strip Leading Zero: Remove leading 0 from numbers (e.g., 0551234567 → 551234567)

🔧 Technical Requirements

• ✓ Odoo 18.0
• ✓ PostgreSQL 12+ (for text_pattern_ops indexes)
• ✓ contacts module (base dependency)
• ✓ No external libraries required

How to Search by Phone

1. Go to any contact selection field (Customer, Vendor, Partner, etc.)
2. Type a phone number - full or partial
3. Example searches:
   • 828 - finds all numbers starting with 828
   • 8283160593 - finds exact number
   • 828-316 - normalized automatically
   • (828)-316-0593 - any format works
4. Contact appears instantly in dropdown
5. Select the contact to proceed

Search Examples

⏱️ Save Time

Find contacts in seconds instead of minutes. No more scrolling through long lists or remembering exact name spellings.

📈 Improve Productivity

Call center agents, sales teams, and support staff can handle more customers per hour with instant phone lookup.

🎯 Reduce Errors

Automatic normalization prevents duplicate contacts with different phone formats. Maintain clean data integrity.

💰 Better ROI

Increase customer satisfaction with faster response times. Reduce training time for new employees.

✅ Comprehensive Test Coverage:

• 53 automated tests included
• Phone normalization tests (15 tests)
• Search functionality tests (17 tests)
• Uniqueness constraint tests (11 tests)
• Strip leading zero tests (10 tests)
• Run tests: ./odoo-bin -c odoo.conf -d dbname -u contact_search_by_phone --test-enable