How to Update Hundreds of Product Prices Without Retyping Them

Suppliers change prices more often than most sellers update their store to match — and every month that gap sits unaddressed is either lost margin (your price is stale-low) or lost sales (your price is stale-high relative to competitors who did update). The bottleneck is almost never deciding what to charge; it's the mechanical work of getting a new price list into your store correctly.

Here are the four realistic ways to do it, roughly in order of how much data you're updating.

1. Manual editing (fine for under ~30 products)

Shopify's product list lets you bulk-edit prices inline; WooCommerce has a similar quick-edit flow. This is genuinely the fastest option for a small, occasional update — a dozen products where you already know the new numbers. Past 30 or so rows, manual editing gets slower than any of the other options below, because you're now cross-referencing a supplier PDF or email against a live grid, one row at a time, with no systematic way to catch a skipped or duplicated row.

2. Your platform's native bulk price editor

Shopify's bulk editor and WooCommerce's quick-edit-multiple flow both support percentage or flat adjustments across a selected set of products — "increase all prices in this collection by 8%." This is the right tool when every affected product needs the same adjustment. It falls apart the moment your supplier's price changes are per-product and non-uniform, which is the normal case with a real supplier price list.

3. Manual CSV editing in a spreadsheet

Export your products, open the CSV in Excel or Google Sheets, and manually update the price column by cross-referencing the supplier's list, then re-import. This scales better than clicking through a UI, but the join step — matching your store's SKU or barcode to the supplier's item code — is still manual, which is exactly where errors creep in on anything past a hundred rows: a misaligned row after a sort, a SKU with inconsistent leading zeros, a formula reference that didn't update when you inserted a row.

4. Automated matching by barcode or SKU

This is the option that scales to hundreds of rows without the manual join step being the weak link. Upload your store export and the supplier's price list to a matcher — like the Supplier Price List Matcher — and it joins the two files by barcode or SKU automatically, applies your margin and rounding rule, and gives you back a ready-to-import CSV plus a clear list of anything that didn't match on either side.

This is the right default once you're doing this more than once a quarter, because the time cost doesn't scale with row count the way the manual options do — matching 40 rows or 4,000 rows takes about the same amount of your time.

A concrete example

A supplier sends a 300-line price update. Forty items are new SKUs you don't stock yet; twelve of your current products aren't in the new list at all (discontinued by the supplier). Doing this by hand means noticing all 52 of those exceptions while also correctly updating the other 248 rows — a task that's tedious in a way that reliably produces mistakes, not because anyone's careless, but because sustained manual cross-referencing at that scale is genuinely hard to do error-free. An automated match surfaces exactly those 52 rows as "unmatched" on either side, so you review the exceptions instead of re-deriving them.

Getting set up

If you haven't run a matched price update before, our step-by-step guide walks through exporting your store, uploading the supplier file, and setting your margin and price-ending rule in the Supplier Price List Matcher — entirely in your browser, with nothing uploaded to a server.