Hello,
We're seeing an issue in our Netsuite account where global search does not return a complete result set when searching items.
A little background:
It is our convention to combine 4 different attributes into the display name and sales description fields.
We sell wine, so our display names are structured like this: Producer WineName Vintage Bottle Size
e.g. Drouhin Chambolle-Musigny 1er Cru 16 750
where Drouhin is the producer, Chambolle-Musigny 1er Cru is the name of the particular wine, 16 is the vintage, and 750 is the bottle size.
Each of these distinct data points are stored in separate custom fields as well.
We are relatively new to Netsuite, having switched from a legacy ERP system in August 2018. Prior to go live, we imported 20,000+ item records.
***
We can use global search like this:
ite: Drouhin
to get a list of all the wines made by the producer Drouhin.
--or--
we can use global search like this:
ite: Drouhin 16
to get a list of all the wines made by producer from the 2016 vintage.
The problem is with the first search:
ite: Drouhin
It is returning results from several different vintages, but it is omitting the two latest vintages in inventory (2016 and 2017).
To get results from 2016 or 2017, users must specify 16 or 17 explicitly.
***
Can anyone suggest a way to look into clearing global search caching or determining whether the indexing job behind global search is working properly? Can you suggest any other options or possible solutions?