Skip to the guide

WooCommerce · Update prices & stock

Update WooCommerce prices and stock from a new price list

Compare a fresh store export with your new price list. Review the differences by SKU and choose the price and stock fields to update.

Runs in your browser · No files uploaded · Never connects to your store

Update files: free, any size

Synthetic demo data

A reviewed demo update

SKUPlanned change
DK-LAMP-01Regular price 49 → 52
DK-LAMP-02Stock 6 → 4
DK-RUG-02Regular price 289 → 299, Stock 2 → 5

4 products change; 3 stay unchanged. Nothing is created or deleted.

Try the demo

What you need

You provide
A fresh store export and a supplier price list as CSV or Excel
You get
A change plan and CSV files containing only the fields that changed
  1. A fresh store export: Products → Export, with at least the columns ID, Type, SKU, Parent, Regular price, Sale price, Stock, Backorders allowed?. It tells the tool what the store holds now; an old export gives an old comparison.
  2. The new supplier price list: CSV or Excel, in the supplier’s own columns. You map its SKU, price and stock columns as in Prepare supplier file.

Example: what you get

The synthetic demo of the checker: a store export of 8 products and a new price list with Spanish headers (Código → SKU, Precio → Regular price, Existencias → Stock).

CódigoDescripciónPrecioExistencias
DK-LAMP-01Lámpara de mesa Oslo52.0014
DK-LAMP-02Lámpara de pie Oslo119.004
DK-RUG-01Alfombra de lana 120×170189.003
DK-RUG-02Alfombra de lana 160×230299.005
DK-CUSH-01Cojín de lino arena29.0022
DK-CUSH-02Cojín de lino musgo29.0015
DK-THR-01Manta de algodón59.0011
DK-NEW-01Jarrón de vidrio24.0010

Compared with the export, with Regular price and Stock chosen:

4 products change:

SKUChange
DK-LAMP-01Regular price 49 → 52
DK-LAMP-02Stock 6 → 4
DK-RUG-02Regular price 289 → 299, Stock 2 → 5
DK-CUSH-02Stock 0 → 15
  • 3 products are unchanged (same price and stock), so they are not written.
  • 1 SKU of the price list (DK-NEW-01) is not in the export: it is reported, not created.
  • 1 store product (DK-BSK-01) is missing from the price list: it is reported and keeps its price and stock. It is not set to zero and not deleted.

The update files, one per set of changed fields:

FileRecords
update-regular-price+stock.csv1
update-regular-price.csv1
update-stock.csv2

How to use it

  1. Export the store again and choose that export with the new supplier price list.
  2. Match SKU and the price or stock fields, then compare the files.
  3. Review the differences and excluded rows. Download the files only when the current result is ready.
  4. Test a small update and import each CSV separately with Update existing products.

Why several files, and how to import them

The importer writes every column of a file into every product of that file, so a product whose stock did not change must not be in a file with a Stock column. That is why there is one file per set of changed fields. Import each file with Products → Import and “Update existing products” ticked; the ZIP also has the files as parts of up to 500 records, with the order to import them.

Limits and risks

Nothing is created or deleted. Test a small update, then import each CSV yourself with “Update existing products”. The comparison is only as current as your export.

  • The comparison is only as current as the export: export again right before each update.
  • An export without a column (for example no Sale price) cannot be used to update that field: the page says which columns are missing.
  • There is no store connection and no scheduled sync: each update is export → compare → import.
  • Details: Update in the documentation.

What changes, and what does not

  • Only the fields you choose: Regular price, Sale price, Stock. Each file holds SKU and exactly the columns it updates.
  • Descriptions, images, categories, attributes and reviews are not written.
  • An empty cell in the price list keeps the current value. Only Sale price has an option to clear it. A 0 is a value, not an empty cell.
  • Stock management and backorder settings are not switched: a variation whose stock is managed on the parent is reported, not changed.

Fixed automatically

Price formats such as 1 299,50 are normalized by the mapping rules you choose.

Reported for you to decide

SKUs not found in the export, SKUs that match only when letter case is ignored, duplicate SKUs, and sale prices not lower than the regular price.

Needs data from your store

Everything about the store comes from the export you supply. The free WordPress plugin reads the current catalog of your store directly instead.

What is free

The comparison on screen, its report and the update files are free, for any number of changed products — as in the free WordPress plugin. No CatalogDock Pass is needed to update prices and stock; the Pass is only for catalogs prepared from a supplier price list. See Pricing. The demo pair is also in the CSV templates.

All free limits and the shared Pass

Other tasks

See the same task for Shopify (beta)

Common questions

What happens when a supplier price is invalid?

The entire product row is blocked and excluded from the update, including other fields in that row. Correct the source or mapping, then compare again.

Why are there several update files?

Each CSV contains SKU and the exact set of fields changed for its products. Unpack the ZIP, follow IMPORT-ORDER.txt and import each CSV separately with Update existing products.

Start with a free result

Review the result before choosing a full download. You import the files into your store yourself.