The Scenario
A Shopify store just relaunched with new product URL handles and a restructured collection hierarchy. The SEO consultant sent over an Excel workbook: 180 rows, old URL path in column A, new destination in column B. She needs all 180 redirects created in Shopify by end of the day, before the next scheduled crawl picks up the 404s and starts damaging the store's search rankings.
The store owner has never created a redirect in Shopify. She found the redirect screen. She's created four. She has 176 to go and a store to run.
The bad version:
- Open Shopify's Navigation section, URL redirects, click Add URL redirect.
- Enter the old path, enter the new target, save.
- 180 times. Each one two text fields and a click. For two hours.
Search rankings have been built over three years. Every 404 that sits unresolved costs something.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the URL mapping and creates each Shopify redirect via the API, writing the confirmation back so you have a record of what was created.
Read my URL Migration Excel sheet and create Shopify redirects for all rows where column C is blank — write the new redirect ID into column C
What You Get
- A Shopify URL redirect created for each row where column C is blank, using the old path in column A and the new target in column B.
- The redirect ID written back into column C for each successfully created redirect.
- All 180 redirects live in Shopify and serving the new destinations before the crawl runs.
What If the Data Is Not Quite Ready
Some old paths already have conflicting redirects in Shopify from the previous migration attempt
Read my URL Migration Excel sheet and create Shopify redirects for all rows where column C is blank — if the old path in column A already has a redirect in Shopify, update the target to column B — write the redirect ID and 'created' or 'updated' into column C
Paths are missing the leading slash in the workbook
Read my URL Migration Excel sheet and create Shopify redirects for all rows where column C is blank — add a leading slash to each old path in column A if it doesn't already start with one — write the redirect ID into column C
Redirects are split across two worksheets — product URL changes and collection URL changes
Create Shopify URL redirects for all rows in my Product Redirects Excel sheet (old path column A, new path column B, blank column C) and all rows in my Collection Redirects Excel sheet (same structure) — write the redirect ID into column C of whichever sheet each row came from
Normalize paths, detect and update conflicts, create from both sheets, confirm with timestamp
For each row in my URL Migration Excel sheet and Collection Redirects sheet where column C is blank, create a Shopify URL redirect using the old path in column A (add leading slash if missing) and new target in column B — if the old path already exists, update the target instead — write the redirect ID, 'created' or 'updated', and the timestamp into columns C, D, E
Resolving conflicts in the same pass as creation means you don't need a separate pre-check before running the migration.
Try It
Get the 7-day free trial of SheetXAI and open the URL migration workbook the SEO consultant sent over, then ask SheetXAI to create all 180 redirects before the next scheduled crawl. Future platform migrations will use the same workbook structure. Also worth reading: how to export your product catalog for the next store relaunch, or the hub overview for all Shopify workflows.