A useful first step. No signup.

WooCommerce Product CSV Template and Import Checker

Download a working template for simple, variable, grouped, external or downloadable products. Then check your file for the mistakes that import without an error.

Free to useNo email requiredYour entries stay in this page

Your store's settings

The same file can import differently on two stores, so the template and the check both use these. Find them under WooCommerce → Settings, on the General and Products tabs.

Download a template

Each file has the columns WooCommerce's importer recognises and working example rows. Replace the rows, or delete the columns you don't need. Every product is set to draft, so nothing goes live by accident.

Check a CSV before you import it

Find rows that will fail, and values that import without an error but end up wrong. The file is read in this page and never uploaded.

Rules read from the WooCommerce 11.2.1 importer source code and checked by importing test files through it. This tool can't see your store, so it can't tell whether a SKU or parent already exists there.

Mistakes WooCommerce won't warn you about

The importer's success screen only tells you which rows failed. These are the ones that succeed and leave the wrong data behind. Each comes from how the importer's code reads a cell.

A comma in a price can multiply it by 100

WooCommerce keeps only your store's decimal separator and strips other punctuation. On a store that uses a dot, 19,99 imports as 1999, and 1.299,00 imports as 1.299. Weights and dimensions are read the same way. This is common when a file comes from a spreadsheet in a European locale.

"no" in the In stock? column means in stock

The column understands 1, 0 and backorder. Any other text counts as true, so no, false and outofstock all mark the product as in stock. An empty cell does the opposite: with no stock quantity, it marks the product as out of stock.

A filled Stock column overrules In stock?

When a row has a quantity, WooCommerce turns on stock management and works out the status itself. A row with In stock? = 1 and Stock = 0 ends up out of stock.

"yes" in the Published column means private

The importer converts this cell to a number. Words become 0, and 0 means private. Use 1 for published, 0 for private, -1 for draft and 2 for pending. An empty cell means draft.

"yes" in Backorders allowed? means no

Only 1, 0 and notify are understood. Everything else becomes "do not allow".

Dates depend on where you are

PHP reads slashes as month/day/year, so 01/02/2026 is January 2, and 31/12/2026 is not a date at all, so it's dropped. A plain number is treated as a Unix timestamp, so a spreadsheet's date serial number lands in January 1970. Use 2026-12-31.

A variation can quietly match everything

If a variation names an attribute its parent doesn't have, WooCommerce drops it, and the row becomes an "any" variation that matches every combination. If the attribute exists but the value isn't in the parent's list, the variation is created but shoppers can never select it.

Spreadsheets damage long codes

Excel can turn 4006381333931 into 4.00638E+12 and remove the leading zero from a UPC. Once the file is saved as CSV like that, the digits are gone. Format those columns as Text before you paste, and re-export from your source if it has already happened.

Column reference

Column names aren't case-sensitive. The importer also accepts Title or Product Title for Name, Price for Regular price, Quantity for Stock, and Parent SKU for Parent.

ColumnWhat to enter
IDLeave empty for new products. To update, use an existing product's ID.
Typesimple, variable, variation, grouped or external. Add virtual or downloadable after a comma. Empty means simple for new rows.
SKUUnique across all products and variations.
GTIN, UPC, EAN, or ISBNThe barcode number. In 11.2.1 this column isn't matched automatically, so choose it on the mapping screen.
NameProduct name. Leave empty on variations.
Published1 published, 0 private, -1 draft, 2 pending.
Is featured?1 or 0.
Visibility in catalogvisible, catalog, search or hidden. If the column exists, an empty cell fails the row.
Short description, DescriptionText or HTML. Wrap the cell in double quotes if it contains commas or line breaks.
Date sale price starts, endsYYYY-MM-DD.
Tax statustaxable, shipping or none.
Tax classThe slug of a tax class. Empty means standard.
In stock?1, 0 or backorder. Ignored when Stock is filled.
StockA whole number. Empty turns off stock management for that product.
Low stock amountA whole number.
Backorders allowed?1, 0 or notify.
Sold individually?1 or 0.
Weight (kg), Length (cm), Width (cm), Height (cm)Numbers in your store's unit. The unit in the name must match your store's setting for the column to map automatically. Values aren't converted.
Allow customer reviews?1 or 0.
Purchase noteText shown after purchase.
Sale price, Regular priceNumbers with your store's decimal separator and no thousands separator. The sale price must be lower for a sale to run.
CategoriesCommas separate categories and > nests them: Clothing > Shirts, Sale. Missing categories are created. Write \, for a comma inside a name.
TagsSeparated by commas.
Shipping classThe class name.
ImagesFull URLs or media library file names, separated by commas. The first is the main image.
Download limit, Download expiry daysWhole numbers. Used by downloadable products.
ParentFor a variation: the parent's SKU, or id:123.
Grouped products, Upsells, Cross-sellsSKUs or id:123 values, separated by commas.
External URL, Button textFor external products.
PositionMenu order, as a number.
Attribute 1 nameFor example, Colour. Use 2, 3 and so on for more attributes.
Attribute 1 value(s)On a parent, all values separated by commas: Red, Blue. On a variation, one value, or empty to mean "any".
Attribute 1 visible1 shows it on the product page.
Attribute 1 global1 uses a global attribute, 0 a custom one for this product only.
Attribute 1 defaultOn a variable parent, the value selected by default.
Download 1 name, Download 1 URLThe file's label and location.
Meta: your_keyA custom field. The part after Meta: is the meta key.

Import safely

  1. Back up your store, and use a staging site if you have one.
  2. Open Products → All Products → Import and choose your file. Leave "Update existing products" unticked unless that's what you intend.
  3. Import 2 or 3 rows first, including a variable product and its variations if you have them.
  4. On the mapping screen, check any column set to "Do not import".
  5. Open the imported products and check the price, stock status, attributes and images on the front end.
  6. Then import the rest. Very large files are easier to handle in batches.

Building many variations by hand? The variation CSV generator makes every combination for you.

Frequently asked questions

What format does the WooCommerce product CSV need?

A comma-separated file saved as UTF-8, with a header row and one product per row. Variations each get their own row, with the parent's SKU in the Parent column. Only the columns you want to set are needed.

Where is WooCommerce's own sample CSV?

WooCommerce includes one at wp-content/plugins/woocommerce/sample-data/sample_products.csv. It's built around a demo catalogue, so the templates here are smaller and easier to adapt.

Why did my import say it succeeded but my prices are wrong?

The most common cause is a decimal comma on a store that uses a dot. WooCommerce strips the comma, so 19,99 becomes 1999. Check your file above, or set the store's decimal separator before importing.

Why are my variations not showing after import?

Usually the parent row isn't type variable, or the attribute name or value on the variation doesn't match the parent's. The checker tests each variation against its parent when both are in the same file.

Why are products skipped with 'A product with this SKU already exists'?

That SKU is already in your store, or appears earlier in the file. To change existing products, tick 'Update existing products' on the import screen. To create new ones, give them new SKUs.

Is my file uploaded anywhere?

No. The check runs in your browser using JavaScript, and the file doesn't leave your computer.

Which versions does this work with?

The rules were read from the WooCommerce 11.2.1 importer source code, then checked by importing test files through that importer. The core columns have been stable for a long time, but always try a small test import on your own version first.

Take the next step

Skip the CSV for variable products.

Quick Variable Products lets you pick attributes, generate every variation in one click, then set price, SKU and stock per row, right inside WooCommerce.

Explore Free and Pro →Read the step-by-step guide

More free tools

Free browser tool

Inventory count sheet

Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.

Open tool →
Free browser tool

EOQ calculator

Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.

Open tool →
Free browser tool

SKU generator

Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.

Open tool →