xfive | 20 Years of Trust

Data Architecture and AI-Driven Migration for ACO USA

See how we did
Industry:
Manufacturing

ACO USA manufactures precision drainage and water management solutions across multiple industries. Their catalog had grown without a clear content architecture.

Product data was scattered across legacy spreadsheets, technical files were disconnected from the products they covered, and there was no way to filter by the parameters engineers actually use to specify products. The sales team was fielding questions that the website should have answered on its own.

xfive was brought in to fix the data, not just the website.

Project Scope

xfive consolidated years of fragmented product data into a single system of record. With AI we resolved conflicts across multiple legacy spreadsheets at a scale that would have otherwise significantly stretched the timeline. On top of that, we built filtering and lead capture that match how engineers actually work.

What?

Data Architecture

How?

We built a single system of record where every product, document, and distributor relationship is stored once and connected automatically.

What?

AI-Driven Data Migration

How?

We used AI to align inconsistent legacy spreadsheets and validate import scripts at scale, keeping the project within budget.

What?

Parameter-Based Filtering

How?

Engineers filter by load class, material or outlet configuration, with intersecting logic that never returns zero results.

What?

WordPress

How?

Built on WordPress with custom post types, giving product managers full control to add SKUs and update the catalog without developer involvement.

What?

ZIP-Code Distributor Locator

How?

Buyers find their nearest distributor by ZIP code, with inquiry forms that pass product context directly into HubSpot.

Features

Parameter-Based Filtering for Engineers

Engineers filter by load class, material, outlet configuration, or certification standard, and the system cross-references all selected criteria at once. Combining multiple filters never returns zero results.

Dual-Path Content Architecture

Two entry points into the same catalog, one for engineers working from technical parameters, one for facility managers starting from the application they need to solve for.

AI-Supported Data Migration

ACO USA's product data had accumulated across inconsistent spreadsheets, legacy exports, and static files with conflicting values. xfive used AI to align the data sources and validate import scripts at scale, keeping the project on timeline and within budget.

ZIP-Code Distributor Locator and HubSpot Integration

Buyers find their nearest distributor by ZIP code. Inquiry forms capture what the user was looking at and pass that context into HubSpot so sales reps receive warm, specific leads rather than generic contact requests.

Technical Breakdown

Project Type
B2B Product Catalog Rebuild, Data Architecture, Platform Modernization
CMS and Tech
WordPress, Custom Post Types, Relational Taxonomies
Integrations
HubSpot CRM, ZIP-Code Territory Mapping API
Key Process
AI-supported data mapping and import from legacy spreadsheets