This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there anyway to make a keyword search not fuzzy. For example, a search for a sku 123456 will return 123457, 223456 etc… I would have though the keyword search would have been exact.

Screenshot 2024-09-02 at 16.35.04.png

In this instance I have a field like: 123456,246793,26758 so an exact search wouldn’t match.

The value of the SKU field is exactly "123456,246793,26758" ?

Context: I have a field with alternative skus/oems from multiple manufactures. It seems the keyword search is fuzzy and people are complaining that what should return 1 result returns 100.

I see, so you probably want something like "Contains exact"

it seems keyword and fuzzy do the same thing.

I think keyword is probably your best bet

If you have a fuzzy matcher in your search fields I would probably remove it for that field

Fuzzy checks for spelling mistakes, which probably won't be necessary for ID numbers / SKUs

Keyword is like "contains" but I honestly don't know if it does substring checking

but "big,red,ball" - I don't know if red would match

it seems to be fuzzy. I’ll re-index the site. it seems like it will also match bit, fed and hall.

Yeah I would generally avoid fuzzy or, at least, do what I have done here and put it at the bottom

There wasn’t anything fuzzy in there. Just keyword searches.

I don't see how 123456 could match 123457 then. You haven't mentioned 123456 in another field (eg description)?

Hold the phone. I have a “starts with”. I think that’s what’s going on. Must be losing my mind.