Creating 301 Redirects By Re-Constructing URLs

Hey Folks,

I am in the process of migrating a website from a Zen Cart shopping cart system to BigCommerce, which involves redirecting old URLs to new ones. I need to create a spreadsheet that maps the existing URLs that comprise the existing website to new ones that will make up the new website: Old URL -> New URL.

The new store product pages have been set up on the new site, but the BigCommerce team didn't set up the Old URL field correctly. They used the default Zen Cart URL structure to create the old URLs rather than what's actually published on the website. The "Old URL" formats that BigCommerce created won't be of any benefit, because they are not recognized or indexed by search engines.

I'm trying to figure out if there is a simple way in Excel to fix the URL structure that BigCommerce created and map it back to what the current URL structure looks like.

Here is an example of one of the product URLs.

Old URL: http://www.robbinssports.com/prodown...11-p-5402.html
This is the current URL used on the website.

BigCommerce URL: http://www.robbinssports.com/index.p...oducts_id=5402

This is BigCommerce's attempt at representing the "Old URL". This format for URLs has never

New URL: http://www.robbinssports.com/pro-dow...26l-200232811/
This is what the new URL will look like once it's published on the new site.

I have been working with the Excel string functions (concatenate, mid, right, etc.) trying to create a bridge from the old URLs to the new ones using the BigCommerce URLs (which contain some of the information from the Old URLs), but I haven't been able to figure out how to use Excel to map from old to new.

Can anyone help me with this?

Thank you,

Richard Robbins

Hi thetechnologyvault,

Old	New
http://www.robbinssports.com/prodown-collegiate-shield-16w-x-26l-200232811-p-5402.html	http://www.robbinssports.com/prodown-collegiate-shield-16w-x-26l-200232811/

this is what you are trying to achieve. use the formula

Please Login or Register  to view this content.

Old URL	BigCommerce URL	New URL
http://www.robbinssports.com/pro-down-collegiate-shield-16w-x-26l-200232811/	http://www.robbinssports.com/index.php?main_page=product_info&cPath=25_247&products_id=5402	Formula

Formula:

Please Login or Register  to view this content.