Epi search, no partial hits

Mattias Bomelin

Vote:

Hi,

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?

#162098

Oct 10, 2016 22:36

Mattias Bomelin

Vote:

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

#162099

Oct 10, 2016 22:37

Quan Mai

Vote:

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

#162111

Oct 11, 2016 10:44

Mattias Bomelin

Vote:

Hi,

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.

/Mattias

#162117

Oct 11, 2016 11:54

Quan Mai

Vote:

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?

#162119

Oct 11, 2016 12:11

Mattias Bomelin

Vote:

Hi,

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.

#162120

Oct 11, 2016 12:15

Mattias Bomelin

Vote:

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

#162125

Oct 11, 2016 12:56

Quan Mai

Vote:

It works with code ;)

#162129

Oct 11, 2016 14:05