Import & export layout
WooCommerce product CSV importer columns
WooCommerce built-in product CSV importer/exporter columns.
The WooCommerce products layout has 29 columns; the required column is Name.
WooCommerce ships a product CSV importer and exporter in core, under Products → Import and Export. Its column names are human-readable (Regular price, In stock?, Weight (kg)) and the importer shows a mapping screen, so a file with slightly different headers can still be matched by hand. Fileshape produces the exact default names so that screen needs no changes.
Product structure is explicit: the Type column is simple, variable, grouped or external, and variation rows point to their parent through the Parent column. Categories use “Parent > Child” for hierarchy and commas between several categories; Images is a comma-separated list of URLs, the first one being the featured image.
Import rules to know
- Images: the first URL in the Images column becomes the featured image; WooCommerce downloads each image into the Media Library.
- Published is 1 (published), 0 (private), -1 (draft) or 2 (pending review).
- Weight and dimensions use the units set in WooCommerce settings. The default column names say kg and cm.
- Updating existing products matches on ID or SKU, so keep SKUs unique.
Columns
| Column | Required | Example | Notes |
|---|---|---|---|
| ID | |||
| Type | simple | ||
| SKU | |||
| Name | Yes | ||
| Published | 1 | ||
| Is featured? | |||
| Visibility in catalog | visible | ||
| Short description | |||
| Description | |||
| Tax status | |||
| Tax class | |||
| In stock? | 1 | ||
| Stock | |||
| Backorders allowed? | |||
| Weight (kg) | |||
| Length (cm) | |||
| Width (cm) | |||
| Height (cm) | |||
| Sale price | |||
| Regular price | |||
| Categories | Clothing > Tshirts | ||
| Tags | |||
| Shipping class | |||
| Images | Comma-separated URLs | ||
| Parent | |||
| Attribute 1 name | |||
| Attribute 1 value(s) | |||
| Attribute 1 visible | |||
| Attribute 1 global |