Skip to content
apexvow.

Systems & logic

Complex filtering

Catalogue filtering that stays fast at thousands of entries and shows something useful instead of "no results".

Scope
04 / 04
on the scope scale
Typical timing
2–5 weeks
Usually built with
WordPress, SQL, REST API

When you need this

Your catalogue is too big to browse. Vehicles, properties, courses, parts, an archive of finished work. The visitor arrives knowing what they need and expects the handful of items that match, straight away. If they have to scroll past everything else, they go to another site.

Two things go wrong, always. Speed: filtering built the easy way runs one lookup per filter, and at a few thousand entries it crawls. And the dead end: the visitor picks four filters, sees “no results”, and leaves. A filter that can end in nothing with no way forward is a leak, not a feature.

What I actually build

  • Filtering that asks the database once, tested against the real size of your catalogue rather than a demo set of ten.
  • A count next to every option, so the visitor can see a combination is empty before choosing it.
  • A link that remembers the filters. Your salesperson sends a customer exactly the six vans they discussed; the customer bookmarks it, comes back tomorrow, and the same six are there.
  • A useful “nothing found”: the nearest matches, and one filter to loosen.
  • Results that still appear on an old phone or a slow connection, and that Google can read.

Where this shows up in my work

A course catalogue that has to work in three languages: 113 courses split first by the decision people make first — in person or online — then searched from the header, in three languages. One hundred and forty-two churches on one map: a live search beside the map for people who already know the name of the town.

What you get

Filtering that keeps its speed as the catalogue grows, a link for every filtered view that your team can paste into an email, and no visitor left at a dead end.