Last weeks I have found that some products which are not assigned in a certain category are appearing in frontend in that category.
For example product with id 43543 is not assigned in category id 1685. But in frontend I see it inside this category (id 1685). This is only an example. It happens with other categories also.
Till now I have found certain products which have same issue. So I believe in not randomly but something is stuck
What I have done:
- Check all database tables related with categories. All these products are assigned fine to their categories and not assigned in cat id 1685
- Cleared all caches, varnish, magento. I even tested with caches off. Same issue
- Check indexer tables. Again these products seems right assigned and not assigned to that category
- Check opensearch indices data. I didn’t found wrong data also.
- Did reindex several times. No errors
- No errors in logs related to this
I have spent hours and I can’t identify the issue.
Any help will be much appreciated
