How to make a lot of 301 redirects?

Question

Search Engine Optimization

Good afternoon!
I am updating the site. The structure of a site with a large number of products has changed, but the products themselves have remained the same with the same description.
https://yandex.ru/support/webmaster/recommendation...
I'm going to transfer a new site instead of the old one, but I don't know how to make such a number of redirects (there will probably be 500 of them)
Advise how to create a large list of 301 redirects from the old structure site to a new one.

Answer 1

1 you collect a file in Excel with 500 urls what and where.
2. https://donatstudios.com/RewriteRule_Generator
that's all.
If there is a logic like change 1 part of the url, for example, for 400 products, replace /catalog with /product
THEN attach the file here, I will make regular expressions for repeating elements.

Answer 2

Programmatically. Make a URL mapping table and programmatically issue the desired redirect when accessing the original URL.

Answer 3

Compiled by exporting from CMS and working with formulas in Excel. I spent 3-4 hours compiling 700 links.