Move sub-category, generate URL redirects for all products

My website:

I want to move the category /socks to under /misc, so it will be /misc/socks.

URLs for all the products will change from /socks/black-silk-socks.html to /misc/socks/black-silk-socks.html. So all links from other sites that were going to /socks/black-silk-socks.html will break.

How do I create URL redirects for /socks/black-silk-socks.html to go to /misc/socks/black-silk-socks.html for hundreds of products?

Is there an extension that can manage moving the category and automatically create the redirects?

If not, could I use SQL and insert all these redirects into the Magento url redirect table?

submitted by /u/kentwang
[link] [comments]