The Scenario
The store relaunch went live with a new URL structure. 180 old product handles now return 404s. Your SEO agency sent over a mapping spreadsheet — old path in column A, new path in column B — and asked you to get all the redirects created in Shopify before the end of the week, or the search rankings you've built over two years start eroding.
You've never created a redirect in Shopify before. You've now created five, manually. 175 to go.
The bad version:
- Open Shopify's Navigation section, find URL redirects, click Add URL redirect.
- Enter the old path, enter the new target, save.
- 180 times. One by one. Each one requiring two field entries and a save click.
Your SEO agency is watching the crawl errors. Every hour of delay is indexed.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the URL mapping and creates each Shopify redirect via the API, batch by batch, writing the confirmation back so you have a record of what was created.
Create a Shopify URL redirect for each row in my SEO Redirects sheet using the old path in column A and the new target in column B — write the redirect ID into column C
What You Get
- A Shopify URL redirect created for each row, with the redirect ID written back into column C.
- Any rows that fail — usually because the old path is already in use by another redirect — get an error message in column C so you can resolve conflicts specifically.
- All 180 redirects live in Shopify immediately and begin serving the new destinations for any incoming traffic.
What If the Data Is Not Quite Ready
Some old paths already have conflicting redirects in Shopify
Create Shopify URL redirects for each row in my SEO Redirects sheet where column C is blank — if the old path in column A already has a redirect, update the target to column B instead of creating a new one — write the redirect ID into column C
Paths are missing the leading slash
Create Shopify URL redirects for each row in my SEO Redirects sheet — prefix each value in column A with '/' if it doesn't already start with one — use column B as the target — write the redirect ID into column C
Redirects come from two tabs — product URL changes on one, collection URL changes on another
Create Shopify URL redirects for all rows in my Product Redirects sheet (old path in column A, new path in column B) and all rows in my Collection Redirects sheet (same structure) — write the redirect ID into column C of whichever tab each row came from
Normalize paths, detect conflicts, create or update, and log full status
For each row in my SEO Redirects sheet where column C is blank, create a Shopify URL redirect using old path in column A (add leading slash if missing) and new target in column B — if the old path already exists in Shopify, update the target — write the redirect ID and 'created' or 'updated' into column C
Handling the conflict detection and the creation in a single pass means you don't need a pre-check run to find which paths already have redirects.
Try It
Get the 7-day free trial of SheetXAI and open the redirect mapping your SEO agency sent over, then ask SheetXAI to create all 180 redirects before the crawl bot runs again. Future migrations will use the same prompt. Also worth reading: how to export your full product catalog for the next relaunch, or the hub overview for all Shopify workflows.