Update WooCommerce prices and stock from a new price list
The two files
- 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. - 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.
A real example: 8 store products, a Spanish price list
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ódigo | Descripción | Precio | Existencias |
|---|---|---|---|
| DK-LAMP-01 | Lámpara de mesa Oslo | 52.00 | 14 |
| DK-LAMP-02 | Lámpara de pie Oslo | 119.00 | 4 |
| DK-RUG-01 | Alfombra de lana 120×170 | 189.00 | 3 |
| DK-RUG-02 | Alfombra de lana 160×230 | 299.00 | 5 |
| DK-CUSH-01 | Cojín de lino arena | 29.00 | 22 |
| DK-CUSH-02 | Cojín de lino musgo | 29.00 | 15 |
| DK-THR-01 | Manta de algodón | 59.00 | 11 |
| DK-NEW-01 | Jarrón de vidrio | 24.00 | 10 |
Compared with the export, with Regular price and Stock chosen:
4 products change:
| SKU | Change |
|---|---|
| DK-LAMP-01 | Regular price 49 → 52 |
| DK-LAMP-02 | Stock 6 → 4 |
| DK-RUG-02 | Regular price 289 → 299, Stock 2 → 5 |
| DK-CUSH-02 | Stock 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:
| File | Records |
|---|---|
| update-regular-price+stock.csv | 1 |
| update-regular-price.csv | 1 |
| update-stock.csv | 2 |
Update prices and stock
Open the checker in “Update catalog” and choose your two files, or load the two demo files above.
Runs in your browser · No files uploaded · Never connects to your store
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.
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
- 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 is free
The comparison on screen and its report are always free. The update files are free while they change at most 50 products in total. An update of more products is one of the 3 results of a CatalogDock Pass ($19, one-time, 30 days): a pass is not a subscription, and each larger update with new changes is a new result. See Pricing. The demo pair is also in the CSV templates.