Search by Product Code not working

[lesliekirk]

If you search by Product Code CB-117 https://www.ascuteasabutton.com/SRCH.html?Search=CB-117 produces No products matched your search criteria but if you happen to know that button's Product Name is Clear Green Glass Flower Button, it will pull up results.

I have checked the User Interface > Search Settings. The Searchable Fields Product Code is selected.

What else should I look for?

[alphabet]

I don't know how your search algorithm is set up but I've had problems with hyphenated item codes.

Some, if not most, server settings see the hyphen as a non alphanumeric character so the search may ignore the hyphen thus creating two short strings of CB and 117.

The other problem may be the search's minimum word length which typically defaults to 4 so the search will ignore any two or three character strings such as CB and 117.

That is probably why a search for NRO-230 doesn't show up but K-B501 does.

Another possibility to be aware of is each server has a stop_word_list that it will use to ignore in search.

Changing the default server settings would most likely break other ASCII driven functions.

[Mark Hood]

Do you have the use Database Full-Text Searching selected? If so then try turning it off and see what happens.
I noticed issues with it for our site.

[lesliekirk]

Is there a way to adjust the search's minimum word length?

[alphabet]

I just did a search for 117 and it produced search results so it may not be the fts_min_word_length

CB 117 produced a better search result but CB117 produced nothing.

[lesliekirk]

Do you have the use Database Full-Text Searching selected? If so then try turning it off and see what happens.
I noticed issues with it for our site.

I think that may have done the trick.

[alphabet]

Can you create a PREACTION_SRCH page and test:

<mvt:assign name="g.search" value="glosub( g.search, asciichar(45), asciichar(32) )" />

Then add the PREACTION to the search form

<input type="hidden" name="PreAction" value="PREACTION_SRCH" />

[alphabet]

LOoks like you got it :)