SKSolveKit

Neither file is uploaded

WooCommerce · Prices

Update WooCommerce Prices from a Supplier CSV

Needs two files: your WooCommerce products export and the supplier's CSV or XLSX. Turns supplier costs into regular prices using markup, target margin, floors, review limits and safe rounding.

Versión en español

Runs on this device

You need two files

  1. Your WooCommerce products export

    CSV or XLSX, exported from your store admin.

  2. The supplier's file

    Any CSV or Excel layout, read as it comes.

Your store export

Supplier price list

Preparing the local workbench: it reads both files in this tab, matches them by SKU or barcode and writes a WooCommerce update file for prices.

Nothing is uploaded — both files are open only in this tab.

Before you import it

Exactly which columns reach your store.

The file contains

ID · SKU
Identity only — used to find the row, never rewritten.
Regular price
Only for matched rows whose price your rules changed.

Nothing else is emitted at all: a row that does not match an existing ID or SKU never reaches the file, so the importer cannot create or overwrite anything you did not review.

It never touches

  • Titles and descriptions
  • Images
  • SEO, URLs and handles
  • Categories and attributes
  • Publication status
  • Products and variants: none created or deleted

Every change is reviewed on screen before a file exists.

How it decides

The method, in three steps.

  1. 01Supplier 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.
  2. 02The 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.
  3. 03Optional 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.
  4. 04The 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.

What it assumes

Said before you upload, not after.

  • 01

    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.

  • 02

    A target margin below 100% is required. Rounding and a price floor can make the achieved margin higher than the entered target.

  • 03

    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.

  • 04

    Use WooCommerce's Update existing products option and test a small import or staging copy before applying a large tariff.

A real run

Convert supplier cost to a 40% target margin

Goes in

SKU ABC-001 costs 10.00, currently sells for 12.95, and uses a 40% target margin with cent rounding.

Comes out

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.

Same engine, different job

If this is not the one you needed.

Questions people ask

Before trusting it with a catalog.

01What 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.

02Can 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.

03What 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.

04Can 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.

05Does 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.

Where the rules come from

Checked against the importer's own documentation.

Reviewed

Share this tool

Referencing this tool on a website?

Copy an attribution link. It is optional and does not change free access.

Useful next stepWooCommerce Price & Stock UpdateNeeds two files: your WooCommerce products export and the supplier's CSV or XLSX. Review price and stock changes and download a minimum update CSV for existing products only.