Introduce an seo_url_history DB table
Usually, SEO URLs will be generated from product titles. This is a brilliant idea as long as there will be no changes: If the customer changes the title of a product item, the URL changes as well (in case of typos, when re-indexing? Untested, please check first). It becomes a mess with regular imports when titles of items change on a regular basis.
For these cases, it is good to have a so called seourlhistory table in the database which will be checked first and redirects via 301 to the new location.
Even if one imports from another system, URLs could be imported to the seourlhistory table redirecting to the new location, no matter how these may look like ;)
BTW: Accept of OXID, nobody else might have a feature like this ;)
-
URL changes are already redirected - so this is already in place