Import / Export
Export Products
The Export button in the grid header downloads your products as a file — CSV, JSON or XML. You choose which products to include, which fields to export, and the format. The columns and value formats match WooCommerce's own product CSV, so a file you export here can be edited in a spreadsheet and imported straight back, or moved between stores.

The three steps

Click ⇓ Export to open the modal. It has three tabs:

TabWhat you do
Filter ProductsChoose which products go in the file.
Select FieldsTick which columns to include.
Format & ExportPick CSV / JSON / XML and download.
Export Products
Collapse
PRO
Product Editor
Sale Manager
Categories
Brands
Tags
Coupons
Attributes
Attribute Editor
Templates
Bulk Attribute Editor
Bulk Attribute Remove
Filters
Filter Editor
Filter Widgets
Widget Styles
Export
Import
Settings
Documentation
CategoriesSearch name, SKU or ID…×SPBTFilter SetsRows 50ColumnsBatch Utilities+ Add New Product
All (1,284)|Published (1,197)|Draft (87)|Bin (0)
SKU ▲▼Product Name ▲▼Product IDProduct TypeSlugImageGalleryCategoriesRegular Price ▲▼Sale PriceStock Status ▾Stock
CW-TS-001
Classic Crew T-Shirt
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1201 Simpleclassic-crew-t-shirt 3 imgsT-Shirts Edit$19.00$In Stock64
CW-TS-002
V-Neck T-Shirt
Edit ↗ | Duplicate | Draft ✎ | Delete
AV
1202 Variablev-neck-t-shirt 2 imgsT-Shirts Edit$19.00 – $22.00—3 / 3 in stock—
CW-SH-010
Oxford Shirt
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1210 Simpleoxford-shirt SetShirts Edit$39.00$32.00In Stock28
CW-KN-020
Merino Crew Sweater
Edit ↗ | Duplicate | Draft ✎ | Delete
AV
1220 Variablemerino-crew-sweater 4 imgsKnitwear Edit$59.00—6 / 6 in stock—
CW-KN-021
Cable Knit Cardigan
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1221 Simplecable-knit-cardigan SetKnitwear Edit$69.00$Low stock3
CW-OW-030
Rain Jacket
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1230 Simplerain-jacket 2 imgsOuterwear Edit$89.00$In Stock17
CW-OW-031
Wool Overcoat
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1231 Simplewool-overcoat SetOuterwear Edit$149.00$Out of Stock0
CW-BT-040
Slim Fit Jeans
Edit ↗ | Duplicate | Draft ✎ | Delete
AV
1240 Variableslim-fit-jeans 3 imgsJeans & Trousers Edit$49.00—9 / 9 in stock—
CW-BT-041
Chino Shorts — Draft
Edit ↗ | Duplicate | Publish ✓ | Delete
A
1241 Simplechino-shorts SetShorts Edit$29.00$In Stock40
Save Changes
«‹1of 26›»
Showing 1 to 50 of 1,284 products
Delete Selected
Export Products
×
Filter ProductsSelect FieldsFormat & Export
CSV
Compatible with Excel, Google Sheets and most import tools.
JSON
Structured format. Best for developers and integrations.
XML
Extensible markup, widely supported.
CloseExport

Filtering which products are exported

On the Filter Products tab you can narrow the export by Categories, Brands and Tags (each a multi-select), and by Stock status, Product type and Status. Categories include their child categories automatically. Multiple taxonomy filters combine with AND (a product must match each group you set); leaving everything empty exports the whole catalogue. Only top-level (parent) products are queried — variations come out attached to their parent (see below).

Export — Filter Products tab
Collapse
PRO
Product Editor
Sale Manager
Categories
Brands
Tags
Coupons
Attributes
Attribute Editor
Templates
Bulk Attribute Editor
Bulk Attribute Remove
Filters
Filter Editor
Filter Widgets
Widget Styles
Export
Import
Settings
Documentation
CategoriesSearch name, SKU or ID…×SPBTFilter SetsRows 50ColumnsBatch Utilities+ Add New Product
All (1,284)|Published (1,197)|Draft (87)|Bin (0)
SKU ▲▼Product Name ▲▼Product IDProduct TypeSlugImageGalleryCategoriesRegular Price ▲▼Sale PriceStock Status ▾Stock
CW-TS-001
Classic Crew T-Shirt
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1201 Simpleclassic-crew-t-shirt 3 imgsT-Shirts Edit$19.00$In Stock64
CW-TS-002
V-Neck T-Shirt
Edit ↗ | Duplicate | Draft ✎ | Delete
AV
1202 Variablev-neck-t-shirt 2 imgsT-Shirts Edit$19.00 – $22.00—3 / 3 in stock—
CW-SH-010
Oxford Shirt
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1210 Simpleoxford-shirt SetShirts Edit$39.00$32.00In Stock28
CW-KN-020
Merino Crew Sweater
Edit ↗ | Duplicate | Draft ✎ | Delete
AV
1220 Variablemerino-crew-sweater 4 imgsKnitwear Edit$59.00—6 / 6 in stock—
CW-KN-021
Cable Knit Cardigan
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1221 Simplecable-knit-cardigan SetKnitwear Edit$69.00$Low stock3
CW-OW-030
Rain Jacket
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1230 Simplerain-jacket 2 imgsOuterwear Edit$89.00$In Stock17
CW-OW-031
Wool Overcoat
Edit ↗ | Duplicate | Draft ✎ | Delete
A
1231 Simplewool-overcoat SetOuterwear Edit$149.00$Out of Stock0
CW-BT-040
Slim Fit Jeans
Edit ↗ | Duplicate | Draft ✎ | Delete
AV
1240 Variableslim-fit-jeans 3 imgsJeans & Trousers Edit$49.00—9 / 9 in stock—
CW-BT-041
Chino Shorts — Draft
Edit ↗ | Duplicate | Publish ✓ | Delete
A
1241 Simplechino-shorts SetShorts Edit$29.00$In Stock40
Save Changes
«‹1of 26›»
Showing 1 to 50 of 1,284 products
Delete Selected
Export Products
×
Filter ProductsSelect FieldsFormat & Export
Choose which products to include. Leave all filters empty to export everything. Several choices in one filter match any of them; different filters must all match.
Product Filters
CategoriesKnitwear, Outerwear
BrandsAll Brands
Tagswinter
Product TypeAll Types
Stock StatusIn Stock
StatusPublished
Check CountReset Filters312 products match
CloseExport

What gets written — the column reference

Whatever fields you select, the export writes them with WooCommerce-compatible names and value formats:

ColumnFormat in the file
TypeThe product type, plus flags, comma-joined — e.g. simple, variable, or simple, downloadable, virtual.
CategoriesFull paths written as Parent > Child, multiple categories separated by commas.
Tags / BrandsNames, comma-separated.
ImagesThe featured image URL first, then gallery image URLs, comma-separated.
Sale datesDate sale price starts / ends as Y-m-d (simple products only; blank for variable/grouped).
AttributesNumbered columns — Attribute 1 name, Attribute 1 value(s), visible, global, and swatch(es) for colour swatches — one set per attribute.
DownloadsNumbered Download 1 name / Download 1 URL columns.
Linked productsUpsells, Cross-sells and Grouped children written by SKU (falling back to id:123 if a linked product has no SKU).
Custom fields(If included) each public meta key as its own column. Private keys (those starting with _) and WooCommerce internal keys are skipped.

Variations

If you include Variations, each variation of a variable product is written as its own row beneath its parent, with its own SKU, price, stock and the specific attribute values that define it — the same shape the importer expects.

The download

The file is named with a timestamp, for example pmp-export-2026-06-04-141530.csv. CSV is the most portable (and the natural choice for editing in a spreadsheet and re-importing); JSON and XML carry the same data for tooling or feeds.

⚙
Round-trips with the importerBecause the column names and formats match what Import Products reads — category paths, the numbered attribute and download columns, images as URL lists, linked products by SKU — an export edited in a spreadsheet imports back cleanly. It's also compatible with WooCommerce's built-in product CSV.