Moving from test server to live site

Hi there,

We used an 3rd party service to export a client’s old X-cart site to Woocommerce. Part of the export included automatically generating 301 redirects with your plugin … which it did do, however, it used the URL of our testing server and ignored the fact the old site’s shopping cart was not in the main directory, it was in a folder named /shop2/.

So basically from this automation, we have source links that look like:

/testingsitedirectory/product.php?productid=965

…and target links that look like:

/testingsitedirectory/product/new-product-link

What we really need is:
(source) /shop2/product.php?productid=965
(target) /product/new-product-link

Now, we can run a search and replace script on our database to get rid of /testingsitedirectory/ in one go, but, that wouldn’t put the old site’s folder of /shop2/ on the source link. We’re not super familiar with MySQL commands but are hoping maybe there’s a way to do an insert command where we can drop /shop2/ into to every entry in the first column of the _redirection_items” database field. There’s over 3000 redirects, so that’s why we’re looking for an easier option than going one-by-one by hand.

Thanks