Case study: building a fast and accurate “Find a Technician” search tool for a certification organization

Case study: building a fast and accurate “Find a Technician” search tool for a certification organization

Issue background

A certification organization partnered with Freshy to modernize their “Find a Technician” feature — a searchable database that allows the public to locate certified professionals by name, state, or ZIP code. The organization’s existing search tool was outdated, slow, and dependent on a third-party geolocation API that frequently timed out or returned incomplete results.

As part of their upcoming national site launch, the client needed a replacement search system that was both faster and self-contained, reducing dependency on external services while maintaining accurate geographic filtering.

Additionally, the system needed to hide technicians with expired licenses to ensure compliance and public trust in certification validity.

Diagnosis

Freshy’s development team reviewed the legacy search logic and uncovered several major issues that impacted reliability and scalability:

• Third-party API dependency: The old system relied on an external geocode service for every search query, slowing down response times and occasionally breaking when rate limits were reached.
• Unindexed database queries: Searches ran through multiple meta queries on the WordPress usermeta table, making each lookup unnecessarily heavy.
• Missing expiration logic: The system displayed all users, even those with expired or inactive certifications.
• Front-end limitations: The UI was minimal and lacked mobile responsiveness, requiring a new layout consistent with the organization’s refreshed website design.

Because the new website was being rebuilt in WordPress, Freshy aimed to deliver a PHP- and JavaScript-driven solution using localized data tables and AJAX-based filtering.

Resolution steps

The development process focused on optimizing both speed and accuracy without introducing unnecessary external dependencies.

1. Created a localized latitude/longitude table

Freshy implemented a custom geocode table within the WordPress database, mapping ZIP codes to their corresponding coordinates.

• This eliminated the need for third-party geocoding services, reducing latency and external API risk.
• The table can be manually updated periodically to maintain accurate geolocation data.

2. Built a PHP + JavaScript hybrid search system

• The search form allows users to look up technicians by name, ZIP code, or state, pulling results instantly via AJAX requests without page reloads.
• PHP handles the query logic while JavaScript dynamically renders the results for a smooth, responsive experience.
• Indexed database queries were added for major searchable fields to improve performance on large datasets.

3. Added license expiration filtering

• Developed conditional logic to automatically exclude any user with an expired certification date.
• This ensures that only currently certified technicians appear in search results, aligning with the organization’s professional standards.

4. Enhanced front-end design

• Rebuilt the user interface with a clean, accessible layout that works seamlessly across desktop and mobile devices.
• Incorporated intuitive search prompts, result highlighting, and state-based filtering to make the feature more user-friendly.

5. Testing and deployment

• Conducted thorough testing with imported user data and several simulated queries.
• Verified instant load times and accurate sorting.
• The new system was successfully deployed to production ahead of the organization’s official launch date.

Final outcome

The new Find a Technician search tool is now live and fully functional, providing lightning-fast, accurate results without reliance on third-party APIs.

Key results:

• Search load times decreased by over 70%, even with large datasets.
• Zero external API calls, improving reliability and cost-efficiency.
• Automated filtering ensures only valid, active certifications appear publicly.
• Modern, responsive interface enhances usability for both desktop and mobile visitors.

The new system gives the organization full control over its search functionality, ensuring faster lookups, better data security, and an improved experience for users nationwide.

Need a custom search solution for your WordPress site?

If your website relies on slow or unreliable search features, Freshy can help you design a fast, secure, and scalable system tailored to your data structure.
👉 Contact Freshy to optimize your search functionality and streamline user access today.