Now turn your sad 404 Opencart pages to SEF / User Friendly product pages.
If you have VQmod installed + Opencart 1.5+
Then 404 SEO Opencart is for you.
Please download the attached and install it, using readme.md file.
Download:404_seo for opencart
Open Cart 404 to SEO Search Extension :VqMod Supported