Try our conversational search powered by Generative AI!

Epi search, no partial hits



We're currently migrating a project from 7.5 to 9.

In 7.5 we are able to search for partial sku codes in Commerce Manager. However in epi 9 we are only able to search for complete sku codes, partial codes gives no hits.

Is this a configuration or is it by design that you can't search for partial keywords? Any workaround?

Oct 10, 2016 22:36

Forgot to mention, search in Commerce Catalog UI does not give any hits on partial codes either.

Oct 10, 2016 22:37

I'm pretty sure that you can search with partial sku codes. However did you try to rebuild the search index after upgrading?


Oct 11, 2016 10:44


We have tried reindexing. Actually we have the same experience in two other solutions that are not upgrade projects. We can not search for part of sku code, we can however search for partialword* and get hits on the title. We have tried partial codes with and without * both in the query field and the code field in CM but no hits.


Oct 11, 2016 11:54

The search by code/Id field uses SQL internally, so you can't search with partial word

But I'm testing with the search by keyword and it works:

Which search provider are you using?


Oct 11, 2016 12:11


I was checking with sql profiler, are you sure it uses SQL in epi 9?

We're using Lucene. In epi 7 we could search for partial sku code in CM.

Oct 11, 2016 12:15

By the way, when you search for extralarge as shown you're actually getting hits on the name, and not the code.

Oct 11, 2016 12:56

It works with code ;)

Oct 11, 2016 14:05
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.