Developer forum

The data is in the index. So if it is in the index, you have the data somewhere. So I would check your database for bad data. maybe using data health tool

Hi Nicolai,

Thank you very much for this suggestion. I was not aware of the Data Health.

I will try it out. It seems awesome so far.

Thank you.

Adrian

Hi Nicolai,

I have used the Health tool (which is awesome) and I could not find any relevant issues. Apart from a few orphaned records in the Orderlines (products that have been deleted) nothing that could have a connection to the variants in question.

I have also searched the entire database for the values displayed in the Facet options and the values were find only in the statistics table,. Which I know is just a coincidence because of the values.

I have checked the Index and the VariantID, VariantOptions, VariantOptionsInStock values are consistent with what is defined in DW. No weird values there. (see my attach)

This makes me think that the Facet is the one with an issue.

I have checked the Facet file and I have found some values stored for the options (see my attach).

I have deleted the values and they are now correct;y displayed.

The question still remains. Why were these values wrong? Why were they not updated at some point?

Thank you,
Adrian

The values are in the index of the result coming out of the index. Otherwise they cannot be in the facet.

Filtering the search result after they come out of the index? Checked your variant combinations?

Do a debug true and have a look at the query.