How to export WooCommerce Products

In this guide we look at exporting WooCommerce Products to CSV, TSV, or Excel files.

Step 1

Quick exporting Products

Store Exporter Deluxe can export a wide amount of WooCommerce data but for this guide we will focus on exporting Products.

WooCommerce quick export Products

From the WordPress Administration open the WooCommerce » Store Export menu and select the Quick Export tab. Let's run a quick Product export.

With the Products Export Type selected simply hit the Quick Export button to export all WooCommerce Products to a file on your computer.

Step 2

Exporting Products with specific export fields

Need a custom Product export? Scroll down and look at some of the WooCommerce Product export fields available for use in customising Product exports.

Export WooCommerce Product fields

Here we specify which WooCommerce Product fields we wish to export, in this case all of them. Simply check or uncheck Product fields as needed then click Export Products.
All export fields can be re-sorted, just drag and drop the fields to your liking then click Export Products.

Filtering Product exports by Product Type

Filter WooCommerce Products for exporting

We may only require an export of Products belonging to certain Product Categories or Product Type, for instance:

  • A Product export of Variable Products and their Variations, or
  • Products belonging to a specific Product Category

Using the Product filter options it is possible to mix and match different Product filters to suit your export needs.

Export Options

Further customization can be done through the Export Options section. The recommended settings are already set by default.

Export Products from WooCommerce as CSV, TSV, Excel, XML and RSS 2.0

You can change the default Product export file type from the Export Format setting. Supported Product export file types include:

  • CSV (Comma Separated Values)
  • TSV (Tab Separated Values)
  • Excel (XLS, Excel 97-2003)
  • Excel (XLSX, Excel 2007-2013)
  • XML (EXtensible Markup Language)
  • RSS 2.0 (XML feed in RSS 2.0 format)

Bulk and batch Product exports

Having difficulty downloading your Product exports in one go? Use the batch export function - Limit Volume and Volume Offset - to create smaller exports.

Set the Volume Limit field to the number of records to export in each batch (e.g. 200), then set the Volume Offset field to the starting record (e.g. 0). After each successful export, increment only the Volume Offset field (e.g. 201, 401, 601, 801, etc.) to export the next batch of records.

Export custom Product details

Export custom WooCommerce Product fields

We can export custom Product details or even custom Attributes without leaving the Quick Export screen, enter the custom Product detail name (known as Post meta name in WordPress lingo) into the Product Meta or Custom Attribute fields.

When you click Save Custom Fields the saved custom details will appear as new Product export fields that can be selected from the Product Fields list.

Run the customized Product export

How to quick export WooCommerce Products

Now that you have set your required settings it is time to run the export. Scroll back up to the top of the Quick Export screen and click Quick Export or the Export Products button from within the Product Fields section.
The quick Product export process will now run using your settings and when ready will appear as file download in your browser.

That's it! We now have our Product export file downloaded. :)

Thanks for reading!

If you would like to import Products with as much ease as our exporter, see our Product Importer Deluxe Plugin.

Store Exporter Deluxe for WooCommerce

★ ★ ★ ★ ★

Single Site

Setup automated exports today!

  • Free future updates
  • Automatic Plugin updates
  • Premium Support
Add to cart

Unlimited Sites

Perfect for developers

  • Free future updates
  • Automatic Plugin updates
  • Premium Support
  • Unlimited Storefronts
Add to cart

Recent Reviews

Highly recommended!

This is a great plugin, I got the bundle with Store Importer Deluxe and Store Exporter Deluxe. When I had questions about exporting and importing subscription product variations, support was quick to reply and was able to help me resolve my issue.

IE Robert Tilton , 7 days ago

10 out of 10 - highly recommended.

This is a really great plugin, does exactly what it says and works without a hitch. Easy to set up, and when I had a support question it was answered super quick and efficiently.

ZA Anni Bisson , 1 month ago

Store Exporter Deluxe works nice and can manage WooCommerce TM Extra Product Options plugin's data

I'm grateful to Byron because he could solve those issues which may be not his tasks. He could maximize opportunities of Store Exporter Deluxe which could meet my special needs. Byron answers very quickly, and i'm sure, that he can solve everything. I need to export subscription's data from WooCommerce which Store Exporter Deluxe can't handle in the basic version. Stroke of Byron's genius it can do it :-)

IE Lajos Papp , 1 month ago


Log In

 Forgotten Password? 

Register Sign Up

When you register you can easily:

  • Manage your Plugin downloads
  • Raise support requests with Visser Labs
  • Interact with the Visser Labs community