E-Commerce Faceted Search

Overview

This project rebuilt product discovery around fast, AJAX-enabled faceted search for a high-traffic e-commerce platform.

The goal was straightforward: help shoppers narrow the catalog without waiting on full page reloads, slow queries, or confusing filter behavior. Better search meant better discovery, and better discovery meant more completed purchases.

Client: Major retailer, via Fusion Alliance
Industry: E-commerce
Duration: 3 months
Role: Senior Consultant
Stack: ASP.NET MVC, JavaScript/AJAX, SQL Server, caching

Built for

• Large product catalogs with many filter combinations.
• Shoppers who need fast, responsive product discovery.
• Retail teams that need conversion impact, not just a nicer search UI.
• Peak traffic periods where query performance matters.

What made it hard

Faceted search looks like a UI problem until the catalog grows.

Every filter combination can create a new query shape. Result counts need to update quickly. Mobile behavior has to stay usable. Caching helps, but only if invalidation does not create stale product states.

The challenge was to make search feel instant while keeping the system maintainable.

What I built

AJAX filtering experience

Implemented dynamic filter updates without full page reloads, including loading states and progressive enhancement.

Query optimization

Improved database indexes, query patterns, and pagination behavior for common product discovery paths.

Caching strategy

Added caching for frequently used filter data and result paths while preserving correctness when product data changed.

Responsive behavior

Designed the interaction path to work across desktop and mobile shopping flows.

Measurement loop

Connected performance improvements to conversion and user experience metrics so the work could be evaluated after launch.

Why I built it this way

Search is one of the places where backend performance turns directly into revenue.

If filters feel slow, shoppers stop exploring. If counts are wrong, trust drops. If the interface reloads the whole page on every change, the catalog feels heavier than it is.

The right solution was not just “add AJAX.” It was to treat product discovery as a system: UI behavior, query shape, cache design, and business metrics all working together.

Impact

• 15% conversion uplift from improved product discovery.
• 60% faster result times through query optimization and caching.
• Smoother user experience with dynamic filtering and fewer page reloads.
• Scalable architecture for high-traffic shopping periods.
• Maintainable implementation with clear separation between UI behavior and server-side query logic.

Related content

• Case Study: E-Commerce Faceted Search
• MockForge for testing API behavior around product and search integrations