Magento – Product not showing in frontend search/category view

May 2020: This solution is for an old version of Magento. I have had comments that it no longer works on the current version. You may want to try anyway. If you have a better solution, please reply in the comments and I will publish your link. Thankyou to Ashley Schroder for helping [...]