Skip to the guide

WooCommerce · Prepare a supplier file

Import a supplier price list into WooCommerce

Map your supplier’s columns to WooCommerce fields and get a checked CSV for Products → Import: new products are prepared here, and the prices and stock of products you already sell are updated with Update.

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

Free: up to 50 records · Pass: $19

Synthetic demo data

A prepared demo catalog (synthetic)

SKUTypeRegular price
TS-ORGvariable—
TS-ORG-S-BIAvariation19.90
TS-ORG-S-BLUvariation19.90

18 records prepared from 15 supplier rows: 3 products with 15 variations. The check finds the one code the supplier repeated. Retail price is kept separate from cost.

Try the demo

What you need

You provide
A supplier price list as CSV or Excel
You get
A new-products CSV (free up to 50 records) and a report of the prepared file
  • Your supplier sends a price list in their own columns (any of 12 header languages), and you import new products with the built-in WooCommerce importer.
  • A CSV (UTF-8, comma or semicolon) or an Excel workbook (.xlsx, .xlsm), up to 50,000 records and 50 MB.
  • For variable products: a column that says which rows belong together (for example a model number), so parents can be built by that key.
  • To update prices and stock of products that are already in your store, use Update catalog instead.

Example: what you get

This is the synthetic demo file of the checker: 15 rows of a fictional Italian clothing supplier, one row per size and colour (semicolons and decimal commas, as Italian Excel saves them). It has two price columns: Prezzo al pubblico is the retail price, Prezzo acquisto the purchase price.

CodiceModelloProdottoTagliaColorePrezzo acquistoPrezzo al pubblicoGiacenzaCategoria
TS-ORG-S-BIATS-ORGT-shirt cotone organicoSBianco7,4019,9012Abbigliamento > T-shirt
TS-ORG-S-BLUTS-ORGT-shirt cotone organicoSBlu7,4019,908Abbigliamento > T-shirt
TS-ORG-M-BIATS-ORGT-shirt cotone organicoMBianco7,4019,9015Abbigliamento > T-shirt

“Suggest rules from headers” gives these rules; you review each one before the check:

Supplier columnWooCommerce field
CodiceSKU
ProdottoName
(constant) TagliaAttribute 1 name
TagliaAttribute 1 value(s)
(constant) ColoreAttribute 2 name
ColoreAttribute 2 value(s)
Prezzo al pubblicoRegular price
GiacenzaStock
CategoriaCategories

Prezzo acquisto is not suggested for any field: headers that name a purchase, wholesale or cost price are kept out of Regular price. Two more settings are yours to choose, and the demo chooses them: the decimal comma of the prices (19,90 → 19.90), and parents and variations built by Modello, so the rows of one model become one variable product.

TypeSKUParentNameAttribute 1 nameAttribute 1 value(s)Attribute 2 nameAttribute 2 value(s)Regular priceStockCategories
variableTS-ORGT-shirt cotone organicoTagliaS, M, LColoreBianco, BluAbbigliamento > T-shirt
variationTS-ORG-S-BIATS-ORGT-shirt cotone organicoTagliaSColoreBianco19.9012Abbigliamento > T-shirt
variationTS-ORG-S-BLUTS-ORGT-shirt cotone organicoTagliaSColoreBlu19.908Abbigliamento > T-shirt

The check of the prepared file: 18 records (3 products, 15 variations), 9 mapping rules, and one supplier mistake: the code FL-ZIP-M-GRI is on two rows. WooCommerce would create the first and skip the second; the check names both rows. The 2 products without the mistake (11 records) are a free download. Once the code is corrected, the whole file is free too: it has fewer than 50 records.

How to import a supplier price list into WooCommerce

  1. Get the price list. Download it from the supplier’s portal or ask for the current list as CSV or Excel. Keep the supplier’s column names: nothing needs to be renamed by hand.
  2. Map the columns. Choose the file in CatalogDock; for Excel, review the sheet, range and header row. “Suggest rules from headers” maps the supplier’s code, name, retail price, stock and other columns to WooCommerce fields, and you review each rule. Save a supplier profile if the same layout comes again.
  3. Choose what the import does. For new products, Prepare writes a WooCommerce product CSV, with parents and variations built from rows that belong together. For the prices and stock of products you already sell, Update compares the price list with a fresh store export by SKU and writes only the values that changed. The free WordPress plugin makes the same update files inside WP admin when the price list already uses the WooCommerce column names.
  4. Check and download. Review the report of the checked file. For new products, the check, the report and a free part of up to 50 records are free; for an update, every update file is free.
  5. Import it. In WooCommerce, Products → Import, choose the CSV. Keep “Update existing products” off for new products and turn it on for update files. Try a few products on a staging copy of the store first.

What the mapping does

  • Header languages: typical supplier headers in 12 languages (English, German, French, Spanish, Italian, Polish, Dutch, Portuguese, Turkish, Chinese, Ukrainian, Russian) are recognized. Only the header names are read; the interface is in English.
  • Cleanup rules: trim spaces, normalize numbers (1 299,50 becomes 1299.50), join or split cells, map values, set constants.
  • Reusable supplier profiles: save the mapping, cleanup rules and grouping in this browser, or export them as JSON. When the supplier changes the headers, the changes are shown and you confirm the mapping again.
  • Parents and variations: when each row is one variation, choose a group key and a parent SKU rule; parents are built by that key, never because names look alike. Generated parents count toward the record limit. More on variations: variations not linking.
  • Excel pictures: pictures placed over cells come as a ZIP with manifest.csv; you upload them to your store yourself. See Excel embedded images.

Fixed automatically

Suggestions from the headers and the cleanup rules you choose; nothing is applied without your review.

Reported for you to decide

Columns that are mapped twice, values a rule could not convert, groups that cannot be built, and every problem of the prepared CSV.

Needs data from your store

SKUs and global attributes already in your store. A store export or SKU list can be supplied to find SKU conflicts; global attribute settings are compared only by the free WordPress plugin.

Limits and risks

Creates new products for the built-in importer. Review the report, test a small file and import it yourself with Products → Import.

  • A column whose header does not say what it holds cannot be recognized: map it yourself.
  • Values are not translated, and product texts are not written for you.
  • The output is for the built-in importer (Products → Import), not WP All Import or other importers.
  • A passing check is not a test import: try a few products on a staging copy of your store first. Details: Prepare in the documentation.

What is free

The check, the report and a free part of up to 50 records (whole product groups) are free. A prepared result of at most 50 records is free in full. A larger prepared result is one of the 10 results of a CatalogDock Pass ($19, one-time, 30 days). See Pricing. Example files to practice with: CSV templates.

All free limits and the shared Pass

Other tasks

See the same task for Shopify (beta)

Common questions

Can I update only the prices and stock from the supplier price list?

Yes, with Update: it compares the price list with a fresh store export by SKU and writes files with only the changed Regular price, Sale price and Stock. Nothing is created or deleted.

Can I reuse the supplier mapping?

Yes. Save a supplier profile with the column mappings, transformations and grouping. Importing a profile saves it; use Apply to choose when it changes the current file.

Does downloading create products in my store?

No. Review the report, download the free part and test it in a staging store. You import the CSV yourself with Products → Import.

Start with a free result

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