Update Shopify prices by SKU from a supplier price list
A supplier sends a new price list and you have hundreds of products to update. Shopify's import can't use it as it is, because Shopify matches rows by URL handle, not by SKU. Add the price list and your product export: the tool matches every line to the right variant by SKU or barcode, shows each cost increase, works out new prices if you want, and builds the Shopify import file that bulk updates Cost per item and Price. You don't edit the export by hand or build a VLOOKUP.
1Supplier's price list
Excel (.xlsx, .xls) or CSV, as the supplier sent it. A title or logo above the table is fine.
Copy the table from Excel, Google Sheets or a PDF and paste it here, with its header row.
2Your Shopify product export
In Shopify: Products › Export › All products › CSV for Excel or plain CSV. It's only read here, to find each variant.
3Your cost per unit
Turns the list price into what one unit costs you. Leave anything that doesn't apply.
4New prices (optional)
Only products whose cost changed are repriced, except with the supplier's RRP.
5Check the changes and download
Add the price list and your product export.
Everything is worked out in this browser tab. Nothing is uploaded.
How to update Shopify prices from a supplier's price list
- Export your products from Products › Export. This gives the tool your URL handles, option columns, SKUs, barcodes, prices and current Cost per item.
- Add the supplier's file as it came. Check the columns the tool picked: supplier code, cost, and pack size or RRP if the list has them.
- Turn list prices into unit costs: divide case prices by the case quantity, take off your discount, and convert the currency if needed.
- Look at what went up. Rises above your threshold are highlighted, so you can decide what to reprice and what to question with the supplier.
- Download the import file and import it from Products › Import with Overwrite products with matching handles ticked. Try one product first.
Why a supplier's file can't be imported into Shopify directly
Shopify's product CSV import finds products by URL handle, and variants by their option values. A supplier's list has its own codes instead, so someone has to look up every line. Doing it with VLOOKUP or XLOOKUP works, but small differences break it: a stray space, a lower-case letter, a dash, or a code stored as a number that lost its leading zeros. This tool matches through those and tells you which lines it couldn't place.
The file it builds holds only the products on the list, with their handle, title and option columns (Shopify needs them to keep your variants) and the columns you're changing. Every variant of each product is written, with its current value where the list has no new one. Descriptions, images, stock and everything else stay as they are.
How to update Shopify prices by SKU
Shopify's own import can't do it: it needs the URL handle and option values of each variant, and ignores a file that only has SKUs and prices. The usual workarounds are a paid bulk-editor app, or exporting your products and looking up each SKU in the supplier's file with VLOOKUP. This tool does that lookup for you and writes the result in the format Shopify's import expects, so you only import one file.
It keeps every variant row of each product it touches, with current values where nothing changed. Shopify's help doesn't say what an overwrite import does with variants that are missing from the file, and merchants have reported them being deleted, so leaving rows out isn't worth the risk.
Shopify bulk price increase: three ways to set the new price
- Keep the margin. New price = old price × new cost ÷ old cost. A product that made 60% still makes 60%.
- Fixed markup. New price = cost × markup, the same rule for every product. Simple, but it can move prices that were set by hand for a reason.
- Supplier's RRP. Many brands publish a recommended retail price; following it keeps you in line with other stockists.
Whichever you pick, round up to your usual ending (.99, .95 or a whole number) so rounding never eats the margin. Our guide on repricing when supplier costs rise covers when to pass a rise on and when to absorb it.
Questions merchants ask
Can I import a supplier's price list straight into Shopify?
No. Shopify's product import matches rows by URL handle, not by SKU or barcode, and a supplier's file has neither your handles nor your option columns. Each line has to be matched to the right variant first, which is what this tool does.
How do I bulk update prices in Shopify with a CSV?
Export your products, change the Price column, and import the file from Products › Import with Overwrite products with matching handles ticked. Keep the URL handle, Title and option columns, and leave out the columns you don't want to change, because a blank cell overwrites a value with a blank.
How do I bulk update cost per item in Shopify?
For a few products, use the bulk editor with the Cost per item column. For many, import a product CSV that has the handle, title, option columns and Cost per item. This tool builds that file from a supplier's price list.
How do I raise prices when a supplier puts costs up?
Decide the rule first: keep each product's current margin, use a fixed markup, or follow the supplier's recommended retail price. Then round up to your usual price ending. The tool can apply any of these and never lowers a price unless you tell it to.
What if my SKUs don't match the supplier's codes?
Codes that differ only in case, spaces, dashes or leading zeros are matched and marked so you can check them. If your SKUs are completely different, match by barcode instead, or store the supplier's code in your SKU or barcode field (see supplier SKUs in Shopify).
Can it read Excel price lists?
Yes: .xlsx and .xls files are read in your browser, and you can pick the sheet. CSV files and cells pasted from a spreadsheet work too.
How do I increase all prices on Shopify by a percentage?
Shopify's bulk editor has no percentage option: you type each price. For one percentage across the store, export your products, multiply the Price column in a spreadsheet, and import it back, or use a bulk price editor app. When the increase comes from a supplier, this tool raises each product by its own cost rise instead, which keeps every margin where it was.
Is it safe to add my product export?
Nothing is uploaded. The page reads both files in your browser and builds the import file there.
Next: add freight and duty to the cost with the landed cost calculator, and read how cost per item works in Shopify.