Check out Better Category SEO URL's
HOW IT WORKS
Better product SEO URL's is designed to turn your product URL's into a standard structure throughout your site, with all the breadrumbs working exactly the same regardless of how you get to a product, and all links to a product identical regardless of where you're linking from. This is ideal for getting all of your facebook likes and page rank to one page for optimal search engine performance
Normally, clicking a product link on the home page for say an iMac on the demo/default store would link to
Where as if you clicked the product from the category DESKTOPS > MAC
it would show
The first would show the breadcrumb
Home » iMac
where the second shows
Home » Desktops » Mac » iMac
This inconsistency is confusing for customers and for the general store that only has one category per product, it makes more sense to show the latter version of them. This mod does just that, linking to the full category for a product globally and consistently
Utilises VQMOD, so no file changes required - Required (2.1 or above - latest always recommended)
URL's are still editable from the admin as they normally are
Caches query results on each page to reduce overhead
Auto redirects incorrect URL's to corrected URL
Largely reduces Sitemap XML size due to less URL's
Q: What happens if I have more than one category?
A: By default, it will select the category with the lowest sort order value, so if Category A has sort order 1 and category B has sort order 2, then Category A will be used globally. That said, this is recommended more for your general store with only one category per product, as most are
Q: Do I need SEO Url's enabled to use this?
A: Yes, this simply extends on OpenCart's default SEO URL's, so you will need to enable them as per the instructions, renaming the .htaccess.txt file to .htaccess and enabling SEO URL's in the Settings page
Q: Why doesn't my store show rewritten URL's?
A: Make sure that you give your products and categories keywords under the DATA tab of each one in their editors. NOTE: This mod does not auto generate the keywords for you