Catalog Price Updater Tool for Shopify
🔧 Quick Info: Bulk-update your Shopify catalog (B2B / market) prices from a spreadsheet, matched by SKU.
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 to use it
- You sell to B2B customers or different markets and need to refresh prices across one or more catalogs at once.
- You manage pricing in a spreadsheet and want to push those numbers into Shopify without editing variants one at a time.
- You need to set or clear compare-at (was/strikethrough) prices for a catalog in bulk.
- You want to remove a variant’s fixed price from a catalog so it falls back to its default price.
Before you start
- 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.
Step-by-step
1 Open the Catalog Price Updater tool for your connected Shopify store.
2 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).
3 Once the file is read, the Match your file’s columns screen appears. Match your file’s columns to these fields (the catalogs are listed together under Catalogs):
- 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.
4 Select at least one catalog price column — the tool won’t let you continue without one. (A compare-at column on its own does not count.)
5 Continue to the email delivery step and choose whether you’d like a completion notice by email — delivery is off by default, and your own email is prefilled if you turn it on.
6 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 (if you turned email delivery on).
File / field reference
Your file needs a header row. Map these fields during the upload step:
| Column | Required? | Notes |
|---|---|---|
| SKU | Yes | Identifies which product variant to update. Must match a variant SKU in your Shopify store. |
| Catalog: <name> (Price) | At least one catalog price required | One of these appears for every active catalog in your store. The value becomes the variant’s fixed price in that catalog. |
| 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. |
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 and noted in your results.
- A blank or zero compare-at value clears the compare-at price when the price is updated.
Troubleshooting / FAQ
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 (if you set email delivery to “Yes”). Any rows that couldn’t be updated are reported so you can correct and re-upload them.