The Scenario
Seasonal sale starts Thursday. The store manager built the repricing math in Excel — 150 product variants, new prices in column B, compare-at prices in column C, variant IDs in column A. The workbook is accurate and approved by the merchandise team.
Getting all 150 updates into Shopify is someone's job. That job has arrived.
The bad version:
- Try the Shopify product CSV export route — download, edit prices in Excel, save, reformat columns to match the import spec, re-upload.
- Check the import report and find that the re-upload overwrote compare-at prices on 30 products that weren't in the export file.
- Spend an afternoon figuring out what broke and manually reversing it in the admin.
The sale banner goes live Thursday morning. The pricing needs to be right before that.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the repricing data and pushes each variant update to Shopify via the API — no export-reimport cycle, no field collision risk.
Read my Price Update Excel sheet and update every Shopify variant listed in column A with the new price in column B — write 'updated' in column D for each success
What You Get
- Every variant updated in Shopify with the new price from the workbook — only the price field, nothing else touched.
- Column D updated with "updated" for each success and an error message for any variant that couldn't be found.
- Compare-at prices, inventory, and all other variant fields remain unchanged.
What If the Data Is Not Quite Ready
Compare-at prices also need to be pushed for the sale display to work
For each row in my Price Update Excel sheet, update the Shopify variant in column A — set price to column B and compare_at_price to column C — write 'updated' in column D
Some prices in the workbook are formatted as text with currency symbols
For each row in my Price Update Excel sheet, update the Shopify variant in column A — strip any currency symbols or commas from column B before setting it as price — write 'updated' in column D
The repricing logic differs by product category and lives on two separate worksheets
Update Shopify variants for all rows in my Apparel Pricing sheet (variant ID column A, new price column B) and all rows in my Accessories Pricing sheet (same structure) — write 'updated' in column C of whichever sheet each row came from
Normalize prices, push both price fields, skip rows already updated, and timestamp confirmations
For each row in my Price Update Excel sheet where column D is blank, update the Shopify variant in column A — set price to ROUND(column B, 2) and compare_at_price to ROUND(column C, 2) if not blank — write 'updated' and the timestamp into column D
Rounding inline means the prices that land in Shopify are exactly what the finance team signed off on, not floating-point artifacts.
Try It
Get the 7-day free trial of SheetXAI and open the repricing workbook your merchandise team finalized, then ask SheetXAI to push all 150 variant updates before the sale banner goes live on Thursday. Next season's repricing will use the same prompt. Also worth reading: how to export inventory and pricing data for a margin analysis, or the hub overview for all Shopify workflows.