Hi there,
On one of your sites the index suddenly didn't return any products anymore (according to the customer after they started translating products). After some investigation we found that the index data no longer contained the Active field (Luke.net didn't show it anymore). Since our query had a condition of Active == true, no products were returned.
We then tried to figure out why the field was no longer in the index, and eventually found the issue. It was this record in EcomProductField:
As soon as I deleted that field and updated the index, the Active field came back in the index and products were returned on the frontend again.
What I don't know is:
- How did that field end up in that table? AFAIK, it's not integrated on our end in the UI you can't set it as standard. And judging by its ID it was created by Dynamicweb. Could this somehow be related to creating languages / translations.
- Why does this break the indexing?
- Should this field ever be in EcomProductField or should standard fields never be there?
Note, we're running on a slightly older 9.9.5 version.
Thanks!
Imar
