How to match url from old and new site?

Question

Search Engine Optimization

Given:
an old site that has about 400 products, the urls of which are formed like this: name-transliterated-id (product id in cms)
a new site that has all the same products, but with slightly different names, because of which the urls change (well and of course the id of the goods is completely different)
It is necessary:
​​to compare the names of the goods from 2 tables and, by correspondence, display the value of the old and new URL (for example, in excel) and, based on this data, register 301 redirects.

Answer 1

In general, I solved the problem a little differently. Maybe it will come in handy for someone
1. Unloaded goods from sites in excel
2. Made 2 tables with a list of names and urls
3. Using the fuzzy lookup add-on with different approximations, compared the value of the names and displayed the matches in a separate table with new and old urls
4. Threw all the matches here and got the necessary redirects

Answer 2

If the old and new products are in different infoblocks
, add a property with the id of the new product. in the infoblock settings we use the same paths.
and on the page where this component will lead, you need to make a redirect:
if you use a standard component, then make a redirect to the result_modifier.php of the template, if the component is self-written, then in the code of the component itself.
If there is only one infoblock, then it’s a little problematic. I think that you will need to write the rules in urlrewrite yourself, but then, as described above