🔧 Quick Info: This tool bulk-updates prices in your Shopify catalogs (B2B price lists and market-specific pricing) from a spreadsheet. Upload a file with SKU and prices, map your columns to catalogs, and we’ll update all matching variants. Set regular prices and optional compare-at prices for multiple catalogs in one run.
What It Does
The Catalog Price Updater lets you set prices for your Shopify catalogs (the price lists you use for B2B customers or specific markets) in bulk by uploading a single file. You upload a spreadsheet that has one row per product variant, identified by its SKU. For each catalog you choose, you map a column from your file to that catalog. The tool then finds the matching variant in your Shopify store and writes the new fixed price (and, optionally, a compare-at price) into that catalog’s price list. You can update more than one catalog in a single upload, and you can update both the price and the compare-at price for each catalog.
When Should You Use This?
Use this tool whenever you need to update catalog prices in bulk. Common scenarios include selling to B2B customers or different markets and needing to refresh prices across one or more catalogs at once, managing pricing in a spreadsheet and wanting to push those numbers into Shopify without editing variants one at a time, needing to set or clear compare-at (was/strikethrough) prices for a catalog in bulk, or wanting to remove a variant’s fixed price from a catalog so it falls back to its default price.
Before You Get Started
- Your Shopify store must be connected to your account.
- You need at least one active catalog with a price list in Shopify. Only active catalogs appear as options to map.
- Have a CSV or Excel file ready with a header row (the first row holds your column names).
- Your file must include a SKU column, plus at least one column of prices for a catalog.
- The SKUs in your file must match the SKUs on your Shopify product variants. Anything that doesn’t match is reported back to you and skipped.
How to Use It
1 Open the Tool
Navigate to the Catalog Price Updater tool in your Your Store Wizards dashboard for your connected Shopify store.
2 Upload Your File
On the Upload Catalog Price Updates step, make sure your file’s first row contains a SKU column and your catalog price columns. Upload your CSV or Excel file (or provide it from the available import source).
Your file must include a SKU column (to identify variants) and at least one price column for a catalog.
3 Map Your Columns
Once the file is read, a Match to column section appears. Map your file’s columns to the matching fields:
- Map your SKU column to SKU (required)
- For each catalog you want to update, map a column to Catalog: <name> (Price)
- Optionally map a column to Catalog: <name> (Compare At Price) for that same catalog
Select at least one catalog price column – the tool won’t let you continue without one.
4 Confirm Email Address
On the email delivery step, confirm the address that should receive the completion notice. Your own email is filled in by default.
5 Start the Update
Submit. The update runs in the background as a job, so you can leave the page. When it finishes, you’ll get an email letting you know the price update has completed. Any rows that couldn’t be updated are reported so you can correct and re-upload them.
File and Field Reference
Your file needs a header row. Map these fields during the upload step.
| Column | Required? | Notes |
|---|---|---|
| Catalog: <name> (Compare At Price) | No | Optional compare-at price for the same catalog. It only applies when that catalog also has a price for the row. Currency symbols and commas are cleaned automatically. |
| Catalog: <name> (Price) | At least one required | One of these appears for every active catalog in your store. The value becomes the variant’s fixed price in that catalog. Currency symbols and commas are cleaned automatically. Put delete to remove the variant’s fixed price and fall back to default pricing. |
| SKU | Yes | Identifies which product variant to update. Must match a variant SKU in your Shopify store. |
Notes on Values
- Currency symbols and commas are cleaned automatically – values like
$1,299.00or£49.99are accepted. - To remove a variant’s fixed price from a catalog, put
deletein that catalog’s price column. The variant falls back to its default pricing for that catalog. - A compare-at price needs a price in the same row for the same catalog. If you provide a compare-at value with no price, that catalog is skipped for that row.
- A blank or zero compare-at value clears the compare-at price when the price is updated.
Troubleshooting
A SKU “was not found in Shopify Store”
The SKU in your file doesn’t match any variant in your store. Check for typos, extra spaces, or leading zeros, and confirm the variant actually exists in Shopify.
Nothing happened for one of my catalogs
Make sure you actually mapped a column to that catalog’s (Price) field and that the column has values. Rows where both the price and compare-at are blank are simply skipped.
My catalog isn’t in the list of options
Only active catalogs that have a price list are offered. Activate the catalog in Shopify, then reopen the tool.
I provided a compare-at price but it didn’t apply
A compare-at price only takes effect when there’s also a price for that catalog on the same row.
Where do my results go?
The job runs in the background and emails you when it’s done. Any rows that couldn’t be updated are reported so you can correct and re-upload them.