Image & Data
Update WooCommerce Prices from a Supplier CSV
Turn supplier costs into WooCommerce regular prices using markup, target margin, floors, review limits, and safe rounding.
Price & stock update
Drop your store export and the supplier's price list — everything runs on this device.
Loading the workbench…
Share this tool
Referencing this tool on a website?
Copy an attribution link. It is optional and does not change free access.
Transparent methodology
What the result includes—and what it does not
Built for wooCommerce merchants recalculating hundreds of regular prices when a supplier publishes a new cost tariff.
Calculation method
- 1Supplier costs are matched to the current WooCommerce export by SKU or ID and parsed with decimal comma or point support. Empty or unreadable cells remain exceptions instead of becoming free products.
- 2The price can use cost multiplied by markup, cost plus a fixed amount, or target margin. Target margin uses cost divided by one minus the margin rate, so a 40% margin is not confused with multiplying cost by 1.40.
- 3Optional price floors and always-up .95, .99, integer, or cent rounding protect the chosen minimum. User-set increase and decrease limits place unusual changes in a separate review list.
- 4The output contains only ID, SKU, and Regular price for changed existing rows. Product content, stock, sale price, tax, attributes, images, SEO, and publication data are excluded.
Assumptions and limits
- The calculation uses the supplier cost column selected by the user; it does not infer freight, duty, tax, payment fees, returns, or overhead that are absent from that file.
- A target margin below 100% is required. Rounding and a price floor can make the achieved margin higher than the entered target.
- Unmatched store products and new supplier references are report-only. The price CSV does not create products or change a row whose cost is unreadable.
- Use WooCommerce's Update existing products option and test a small import or staging copy before applying a large tariff.
Worked example
Convert supplier cost to a 40% target margin
Input: SKU ABC-001 costs 10.00, currently sells for 12.95, and uses a 40% target margin with cent rounding.
Output: A proposed Regular price of 16.67, a +28.73% review flag when the increase limit is 20%, and one minimum ID/SKU update row.
How to use it
Three steps. One clear answer.
- 1Enter or paste the values requested by the tool.
- 2Review the input units and choose any relevant options.
- 3Calculate, then copy or download the result you need.
Built for trust
Useful without the friction.
- No registration or paywall before your result.
- Responsive controls for phone, tablet, and desktop.
- Clear assumptions and warnings where estimates have limits.
Frequently asked questions
What is the difference between markup and margin in WooCommerce pricing?
A 40% markup multiplies a 10.00 cost by 1.40 and produces 14.00. A 40% target margin divides 10.00 by 0.60 and produces 16.67 because cost must be 60% of the selling price.
Can I round WooCommerce prices to .95 or .99 without losing margin?
Yes. Psychological endings always round upward to the next valid .95 or .99 rather than to the nearest one. That prevents rounding from pushing a calculated price below the configured rule.
What happens when a supplier cost is blank or not a number?
The product is skipped and listed in the no-price review. The engine does not interpret a blank as zero, copy an unrelated column, or write a zero Regular price into WooCommerce.
Can I review large WooCommerce price increases before importing?
Yes. Set separate percentage limits for increases and decreases. Changes beyond either limit remain in the update plan but also appear in the Extreme prices worksheet so you can investigate or adjust the rule first.
Does the price update change WooCommerce sale prices or product content?
No. This mode exports ID, SKU, and changed Regular price values only. Sale price, stock, titles, descriptions, images, categories, attributes, SEO, and publication status are not included.
Keep solving
Related image & data tools
WooCommerce Price & Stock Update
Match a WooCommerce product export with a supplier file, review price and stock changes, and download a minimum update CSV for existing products only.
Image & DataImage Compressor
Compress JPEG, PNG, or WebP images locally with adjustable quality.
Image & DataImage Resizer
Resize an image to exact dimensions while preserving aspect ratio.
Image & DataQR Code Generator
Create downloadable QR codes for text, links, Wi-Fi, or contact data.
Image & DataCompress Images to 100 KB or Any Target Size
Compress whole batches of JPG, PNG, or WebP images to 50 KB, 100 KB, 200 KB, or any custom maximum size locally.
Image & DataRemove Image Metadata
Remove EXIF, GPS, and other metadata from whole photo batches without re-encoding a single pixel.
Image & Data