Reputation: 13594
This is really strange. Some of the products from the catalog gives 404 error, even if targeted directly.
The product can be seen in admin and is enabled with stock set. I checked the URL rewrite section but couldn't find anything. Also, tried reindexing everything, but couldn't resolve the issue. Even flushed the cache still nothing.
After searching the issue, I found a solution saying running an SQL command. I did that but it said the entry already exists.
Even when I search the product in catalog, nothing returns. The item is there but its just redundant and not showing.
Upvotes: 0
Views: 2467
Reputation: 688
Re-indexing may help you to resolved the issue.
Go to admin panel System > Index Management. Here select all and do re-indexing. After doing re-indexing try to clear your magento cache and check.
Upvotes: 0
Reputation: 10114
You can check that the product is...
I have highlighted point 1 as it does tend to catch people out in a multi store environment.
Also, you may need to reindex/clear cache etc.
Finally, double check you are using the correct suffix if relevant i.e. you may have to add .html to the url.
Upvotes: 2