Guide
How to update WooCommerce prices from a supplier price list
A supplier sends a new price list. Your store has hundreds of their products, each with a retail price you set against the old cost. This page shows the shortest safe path from that file to updated prices.
Short answer
Upload the price list as it arrived, let the system read it into rows and match each row to your WooCommerce product by EAN, SKU or name, review the new cost next to your current retail and the margin it leaves, then push only the rows you approve. Every push keeps the previous prices, so it can be undone.
The manual alternative is opening each product in WooCommerce. The spreadsheet alternative is export, VLOOKUP, re-import, and it works only when the file is already clean and shares a code with your catalogue. Below, the same three rows go through the four steps.
The price list, as it arrived
Pick a row. Three of 214.
Matched to your product
By the strongest key available.
Matched by SKU
Ceramic mug 350 ml
- Store SKU
- DEMO-103
- Supplier code
- AX-2231
The supplier code equals the SKU you keep in WooCommerce. Exact match.
Review
New cost, your retail, the margin left.
Suggested by your rule: cost × 2.2, rounded to .90
€9.9058.6%
0 of 3 approvedOnly approved rows ever reach the store.
Apply 0 changesStep by step
The four steps, in order
Each step depends on the one before it. The review is the product; the other three exist so the review has something honest to show.
Upload the file exactly as it arrived
PDF, Excel or CSV, in the supplier's own layout. Drag it in or forward the supplier's email to your import address. Nothing is edited by hand first. The system reads it into rows with a code, a name, a unit and a cost, and marks each row as certain or worth checking.
Match every row to a WooCommerce product
In strict order: barcode (EAN) first, then your SKU, then name similarity above a threshold. Whatever is left you match by hand once, and the pairing is kept for every future price list from that supplier.
Review cost, retail and margin side by side
Each row shows the old cost, the new cost, your current retail and the margin left if you change nothing. Your pricing rule proposes a new retail. Rows that fall under your margin threshold come first. Accept row by row or in bulk.
Push only what you approved, with undo
The button always states how many changes will be sent. Before writing, the previous prices are stored and the store is re-read to confirm nothing moved. After writing, every price is read back. One click restores the previous state.
Compared
Manual, CSV, an importer plugin, or Pricebreeze
All four work. They differ in what they ask of the file and of you.
| What you need | By hand in WooCommerce | Export, Excel, re-import | Importer plugin | Pricebreeze |
|---|---|---|---|---|
| Reads a PDF or a messy Excel as it arrived | Yes | No | No | Yes |
| Matches rows without a shared code | Yes | No | No | Yes |
| Shows the margin each new cost leaves | No | No | No | Yes |
| Undoes a whole import in one click | No | No | No | Yes |
| Handles hundreds of rows in minutes | No | Yes | Yes | Yes |
CSV import and importer plugins are the right tool when the supplier already sends a clean file with your SKUs in it. The problem this page is about starts when they do not.
What it does not do
What Pricebreeze does not do
It never pushes without your approval
There is no fully automatic mode. A price list that arrives at night waits on the review screen until someone approves it.
It does not create products in WooCommerce
Rows in the price list that are not in your store appear in a separate list you can export. Creating products stays a decision you take elsewhere.
It is not a live feed
If your supplier offers an API or an hourly CSV feed, a sync plugin is the better tool. Pricebreeze is for files that arrive by email.
Questions people ask before trying it
Related guides
The same price list usually raises more than one of these.
Guide
Getting a supplier PDF price list into WooCommerce
The five things that break copy-paste and Excel conversion, and what a reader that expects them does with each.
Read the guideGuide
When your supplier sends part numbers instead of your SKUs
How a row with no common code still finds its product, and why you only match it by hand once.
Read the guideGuide
How to compare an old and a new supplier price list
Increases, decreases, new and discontinued items in one table, with what each change does to your margin.
Read the guide
Try it on your own price list, not ours.
Start the 14-day trial, connect your store and upload the last file a supplier sent you. Nothing is written to WooCommerce until you approve it.
No card. Every change can be undone.