Redirect mapping

There are currently 25,000 broken URLs (returning a 404 response) on a client site.
We need to plan redirects to the most relevant resolving category pages to ensure that these broken pages are not visited.
Redirects should be mapped to their closest equivalent non-parameter, resolving (returning a 200 status code) category pages.
Redirects from the UK site need to be mapped to the UK site and from the IE site need to be mapped to the IE site.

In the document the following apply:
Yellow highlight - kids category, will need to be mapped to most relevant kids subcategory
Orange highlight - womens category will need to be mapped to most relevant kids subcategory