How to update Shopify prices from a supplier CSV

The rest of this guide explains each step and the mistake it prevents.

Why a supplier price update is harder than it looks

Shopify’s product CSV import does not look up variants by SKU. When you choose to overwrite existing products, Shopify matches each product by its handle, and the variants inside a product are identified by their option values (such as size or color). Your supplier only knows SKUs, so each supplier SKU first has to be connected to the right handle and option values in your store.

Product CSV imports also have side effects worth respecting. A blank cell in an included column can clear that field. Missing or changed option columns can delete variants and create new ones, which gives them new IDs. And there is no undo button for an import. None of this is a reason to avoid CSV updates. It is a reason to work from a fresh export and change as little as possible.

Step 1: Export a fresh product CSV and keep a backup

In Shopify admin, go to Products, click Export and export all products as a CSV file. Do this right before the update, not from an export you made last month: prices, variants and options may have changed since.

Keep two copies. One is your working file. The other is a backup you never edit. If something goes wrong, the backup is how you know what the prices were before (see how to undo a Shopify CSV price import).

Work with complete products. If a product has six variants, all six rows belong in your file. A hand-shortened list of variants is one of the easiest ways to lose variants during an import.

Step 2: Check the supplier file before you trust it

Open the supplier CSV and look for these before you use any number in it:

• A SKU column. Every row should have a SKU, and each SKU should appear only once.
• A price or a cost. Know which one you have. A suggested retail price (RRP or MSRP) can be used directly. A wholesale cost needs a markup or margin rule.
• One currency. If the supplier prices are in a different currency from your store, convert them on purpose before you start. Mixed currencies in one file cause silent errors.
• The number format. “1.234,50” and “1,234.50” are the same price written in two locales. Remove thousands separators and know whether the decimal separator is a comma or a dot.
• Delimiter and encoding. Some regional spreadsheet settings save CSV files with semicolons instead of commas. Save as UTF-8, so product names with accents survive.

A warning about spreadsheets: opening a CSV in Excel and saving it again can quietly change the data. Leading zeros can disappear (00123 becomes 123) and long numeric codes can turn into scientific notation. If your SKUs look like numbers, import that column as text, or check a few rows after saving.

Step 3: Match supplier SKUs to Shopify variants

In your Shopify export, the SKU sits on each variant row. The column is called SKU in current exports and Variant SKU in older ones. For every supplier row, find the one variant with exactly the same SKU.

Three situations should stop you instead of being guessed around:

• No match. The supplier SKU is not in your store. Skip it. A price list is not a reason to create products.
• Duplicate SKUs. Two variants in your store share a SKU, or the supplier lists a SKU twice. A first-match lookup such as VLOOKUP will silently pick one of them. Fix the duplicate at its source.
• Near matches. “ab-100” and “AB-100”, or a SKU with a trailing space. Treat a case-insensitive or trimmed match as a decision you make on purpose, not a default.

In a spreadsheet, XLOOKUP or VLOOKUP can pull the supplier price next to each variant. That works for small catalogs, as long as you check for duplicates first, because the formula will not warn you.

Step 4: Choose one pricing rule

There are three common ways to turn a supplier file into retail prices:

• The supplier’s suggested price: use the RRP as your price.
• Markup on cost: price = cost × (1 + markup). A 40% markup on a $12.00 cost gives $16.80.
• Target gross margin: price = cost ÷ (1 − margin). A 40% margin on a $12.00 cost gives $20.00.

Markup and margin are easy to confuse, and the difference is real money: $3.20 a unit in this example. The guide to Shopify markup vs margin explains both, and the free markup and margin calculator does the arithmetic for a single product.

Round each result to your currency’s precision (cents for USD or EUR) and decide how halves are rounded. If you use price endings such as .99, apply them the same way everywhere and recheck your margins afterwards.

Step 5: Review the changes before anything reaches your store

Put the current price and the proposed price side by side and look at the difference, both in money and in percent. Sort by the biggest changes first. These deserve a second look:

• Large increases. A supplier typo, such as an extra zero, shows up here first.
• Price drops. A lower supplier cost does not always mean you want a lower price.
• Prices below cost, or a margin too thin to cover fees, shipping and discounts.
• Variants whose current price is zero, where a percentage change means nothing.
• Unusually high prices.

For reference, Supplier Update Guard warns about changes of 20% or more by default. It asks for an individual decision on changes of 35% or more, drops of 20% or more, prices below cost and gross margins under 10%. Your thresholds can differ. What matters is that you choose them before you look at the data, not after.

Approve changes on purpose. Anything you are unsure about can wait for the next update.

Step 6: Build a minimal import file and test it on one product

The safest import file changes as little as possible:

• Include only the products you are changing, and for each of them, all of its variant rows.
• Keep the handle, title and option name and value columns exactly as exported.
• Change only the price. Leave out columns you do not intend to change, rather than leaving them blank.
• Import only the clean file. Never import your working spreadsheet or a report with extra columns.

Then import one small product first. In Shopify admin, go to Products and click Import, choose the file and select Overwrite products with matching handles. Read the preview carefully, and cancel if it says it will create new products or variants. After the import, open that product in Shopify admin and confirm that only the price changed: the options, images, inventory and status should be exactly as before. Then import the full file the same way.

Watch out for unit pricing. If a product shows a unit price (for example, per 100 ml), a price-only import can switch its unit price display off. Update those products directly in Shopify admin.

Step 7: Keep a rollback file

Before the full import, make a second file in the same format, for the same products, with the original prices. If a supplier error slips through, importing this file puts those prices back. It is not a full restore: it does not undo other edits made in the meantime. The rollback guide covers what it can and cannot fix.

Doing this with Supplier Update Guard

Supplier Update Guard is a browser tool that does steps 3 to 7 with you. You load your Shopify export and the supplier CSV, map the columns, and choose a direct price, a markup on cost or a target gross margin. You then review every change with its risk reasons, approve what you intend, and download four files: a Shopify import file that changes only prices, a readable change report, a rollback file with the original prices, and a review summary.

It does not sync stock, create products or write to your store: you import the file yourself, with Shopify’s own importer, after checking it. If you want prices and stock synced automatically on a schedule, a Shopify app connected to your store is a better fit. The tool guide lists the supported formats and limits.