My product has the id 541 and the URL is https://example.com/catalog/product/view/id/541/s/presse-marburg/. Now when I open the URL, it always gives me a 404.
The product is activated, visible and I cleared the cache and reindexed several times. The product can not be found by searching, even though its visible in catalog and search.
Any ideas what might be causing this?