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:
Tab
What you do
Filter Products
Choose which products go in the file.
Select Fields
Tick which columns to include.
Format & Export
Pick 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 ID
Product Type
Slug
Image
Gallery
Categories
Regular Price ▲▼
Sale Price
Stock Status ▾
Stock
CW-TS-001
Classic Crew T-Shirt
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1201
Simple
classic-crew-t-shirt
3 imgs
T-Shirts Edit
$19.00
$
In Stock
64
CW-TS-002
V-Neck T-Shirt
Edit ↗ | Duplicate | Draft ✎ |Delete
AV
1202
Variable
v-neck-t-shirt
2 imgs
T-Shirts Edit
$19.00 – $22.00
—
3 / 3 in stock
—
CW-SH-010
Oxford Shirt
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1210
Simple
oxford-shirt
Set
Shirts Edit
$39.00
$32.00
In Stock
28
CW-KN-020
Merino Crew Sweater
Edit ↗ | Duplicate | Draft ✎ |Delete
AV
1220
Variable
merino-crew-sweater
4 imgs
Knitwear Edit
$59.00
—
6 / 6 in stock
—
CW-KN-021
Cable Knit Cardigan
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1221
Simple
cable-knit-cardigan
Set
Knitwear Edit
$69.00
$
Low stock
3
CW-OW-030
Rain Jacket
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1230
Simple
rain-jacket
2 imgs
Outerwear Edit
$89.00
$
In Stock
17
CW-OW-031
Wool Overcoat
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1231
Simple
wool-overcoat
Set
Outerwear Edit
$149.00
$
Out of Stock
0
CW-BT-040
Slim Fit Jeans
Edit ↗ | Duplicate | Draft ✎ |Delete
AV
1240
Variable
slim-fit-jeans
3 imgs
Jeans & Trousers Edit
$49.00
—
9 / 9 in stock
—
CW-BT-041
Chino Shorts— Draft
Edit ↗ | Duplicate |Publish ✓|Delete
A
1241
Simple
chino-shorts
Set
Shorts Edit
$29.00
$
In Stock
40
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 ID
Product Type
Slug
Image
Gallery
Categories
Regular Price ▲▼
Sale Price
Stock Status ▾
Stock
CW-TS-001
Classic Crew T-Shirt
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1201
Simple
classic-crew-t-shirt
3 imgs
T-Shirts Edit
$19.00
$
In Stock
64
CW-TS-002
V-Neck T-Shirt
Edit ↗ | Duplicate | Draft ✎ |Delete
AV
1202
Variable
v-neck-t-shirt
2 imgs
T-Shirts Edit
$19.00 – $22.00
—
3 / 3 in stock
—
CW-SH-010
Oxford Shirt
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1210
Simple
oxford-shirt
Set
Shirts Edit
$39.00
$32.00
In Stock
28
CW-KN-020
Merino Crew Sweater
Edit ↗ | Duplicate | Draft ✎ |Delete
AV
1220
Variable
merino-crew-sweater
4 imgs
Knitwear Edit
$59.00
—
6 / 6 in stock
—
CW-KN-021
Cable Knit Cardigan
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1221
Simple
cable-knit-cardigan
Set
Knitwear Edit
$69.00
$
Low stock
3
CW-OW-030
Rain Jacket
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1230
Simple
rain-jacket
2 imgs
Outerwear Edit
$89.00
$
In Stock
17
CW-OW-031
Wool Overcoat
Edit ↗ | Duplicate | Draft ✎ |Delete
A
1231
Simple
wool-overcoat
Set
Outerwear Edit
$149.00
$
Out of Stock
0
CW-BT-040
Slim Fit Jeans
Edit ↗ | Duplicate | Draft ✎ |Delete
AV
1240
Variable
slim-fit-jeans
3 imgs
Jeans & Trousers Edit
$49.00
—
9 / 9 in stock
—
CW-BT-041
Chino Shorts— Draft
Edit ↗ | Duplicate |Publish ✓|Delete
A
1241
Simple
chino-shorts
Set
Shorts Edit
$29.00
$
In Stock
40
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:
Column
Format in the file
Type
The product type, plus flags, comma-joined — e.g. simple, variable, or simple, downloadable, virtual.
Categories
Full paths written as Parent > Child, multiple categories separated by commas.
Tags / Brands
Names, comma-separated.
Images
The featured image URL first, then gallery image URLs, comma-separated.
Sale dates
Date sale price starts / ends as Y-m-d (simple products only; blank for variable/grouped).
Attributes
Numbered columns — Attribute 1 name, Attribute 1 value(s), visible, global, and swatch(es) for colour swatches — one set per attribute.
Downloads
Numbered Download 1 name / Download 1 URL columns.
Linked products
Upsells, 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.