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
- 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.
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ó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 |
How to use it
- Export the store again and choose that export with the new supplier price list.
- Match SKU and the price or stock fields, then compare the files.
- Review the differences and excluded rows. Download the files only when the current result is ready.
- 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.
Other tasks
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.