Skip to content
fileshape

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

ColumnRequiredExampleNotes
ID
Typesimple
SKU
NameYes
Published1
Is featured?
Visibility in catalogvisible
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
CategoriesClothing > Tshirts
Tags
Shipping class
ImagesComma-separated URLs
Parent
Attribute 1 name
Attribute 1 value(s)
Attribute 1 visible
Attribute 1 global

Guides