Skip to content
Wow Chat for Woo

Why your WooCommerce search misses sales (and how a FULLTEXT index fixes it)

Default WooCommerce search scans post titles with LIKE queries. Here is what that misses, why it gets slow, and how a dedicated index with word-form matching and SKU priority changes the results.

2 min read ThinkMatic

  • search
  • woocommerce
  • guide

If you have ever typed a product you know you stock into your own store’s search box and watched it return nothing, this post is for you.

What default search actually does

Out of the box, WooCommerce search is WordPress search. For a query like “waterproof boots” it builds a SQL query along the lines of WHERE post_title LIKE '%waterproof%' AND post_title LIKE '%boots%' (plus content and excerpt), then orders by date or relevance heuristics. Three things go wrong:

  1. It doesn’t know that “boots” and “boot” are the same word. A product titled “Ridgeline Waterproof Hiking Boot” will not match “boots”.
  2. It ignores the vocabulary your catalog is built from. Categories, tags, brands and attributes — “gore-tex”, “oak”, “size 10” — are exactly what shoppers type, and LIKE on the title doesn’t see them.
  3. It scans. LIKE '%term%' cannot use an index, so every search reads through your posts table. On a few hundred products you won’t notice. On ten thousand, with a busy shop, you will.

There is also the SKU problem: a trade buyer who types 6205-2RS wants exactly that part, first, not a fuzzy list.

What a dedicated index changes

Wow Chat for Woo builds its own index table for products and ranks queries with MySQL FULLTEXT. That single design decision fixes most of the above:

  • Word forms — the index understands that boots, boot and booted belong together.
  • Dictionary — the search vocabulary is generated from your categories, tags, brands and attributes, so your catalog’s own words become searchable.
  • Exact SKU wins — an exact SKU match is ranked above everything else.
  • Useful ordering — in-stock and recently updated products come first, so the top result is something the shopper can actually buy.
  • Speed — queries hit the index, not the posts table, and results appear as the shopper types with no page reload.

Search and chat share an engine

One consequence we like: when a chat message doesn’t match an FAQ entry, it becomes a catalog search through the same index and comes back as product cards. Improving your titles, tags and attributes improves both surfaces at once.

A checklist for better results

Whatever search you use, these help:

  • Name products the way shoppers do. Check your top searches report; if people type “hoodie” and you sell “sweatshirts”, add the word to a tag or attribute.
  • Fill in attributes. Colour, size, material and use-case attributes feed the dictionary.
  • Keep SKUs on every product. Trade and repeat buyers search by them.
  • Watch the zero-result queries. They are either a naming gap or a product you should stock.

Placing it

Add the Wow Search block wherever shoppers expect a search box, use the [wow_chat_for_woo_search] shortcode in classic themes, or let Wow Search take over your theme’s search form in settings so every search on the site uses the index. The instant search docs cover each option.