SmartSearch not able to find all results

Probably there is a syntax thing... a number containing a character, accidental spaces or non visiual characters.

Since you can't find it in the preview it might not be indexed correctly, can you find the product at all on any other property?

If you really want to be sure if it's actually in the index you can have a look at application called "Luke"

https://code.google.com/archive/p/luke/

it allows you to check what is actually in lucene index files itself! Note you need to install Java, and there is not a lot of documentation. The version above should still work, but you can also check a newer take of same product: https://github.com/DmitryKey/luke

Are the product pages all of the same page type, in the same location? I would check that the index setup, the allowed content covers all the pages. Then, what is the analyzer used? And just to be sure, when you search for SKUNumber lets say 123, you will get desired result. But when you search for SKUNumber 456, you do not get any results?

I have products that are of the same type. When I search using SKUNumber or other fields from COM_SKU this one product (and potentially others) will not return. I do see the product in the database and through the application on it's product page. I did use the Luke tool mentioned above and I did find that SKUNumber. I am also able to pull the document using the API. It is only using SmartSearch that I am not able to retrieve this product.

DocumentQuery docs = DocumentHelper.GetDocuments("CMSProduct.Transmission") .Path("/Products/", PathTypeEnum.Children) .WhereLike("SKUNumber", "1241D30097818");

since you could find it in Luke... did you try searching the query you had above:

+_culture:([en-us TO en-us] [invariantifieldivaluei TO invariantifieldivaluei]) +productobjecttype:transmissions +(SKUNumber:(1241D30097818)) cond=+ProductObjectType:transmissions

it should give you the exact result Kentico get's back from the index.

I wouldn't be surprised if the character/capital "D" in your skuNumber is causing an issue...

Yes, I have tried that query in "Search Preview" for the Index. It brings back "No Results were found" Other SKUNumbers bring back results.

If it happens for this value only, have you tried re-saving it or recreating the page? Maybe there is some whitespace character somewhere...

We are seeing this issue for many of the pages/products. They are in the database, but SmartSearch does not find them. It works find for many other products using the same search identifiers.

This is really strange. We would need to know the steps how to reproduce the issue using a default Kentico installation. Could you please install a fresh copy of Kentico and reproduce the issue there and then tell us all the configuration details and steps? There is something strange going on I have never seen before. Or, when you create a testing index from scratch, are you still able to reproduce the issue?

I am still not sure why some of the products did not appear for smart search, but I deleted the bad documents and re-imported them, and everything is working fine now. Thanks very much for looking at this.