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.

Check out the documentation of Store Export Deluxe for a full breakdown of features.

Happy exporting!

Thanks for reading!

Meet our happy customers

Trusted by WooCommerce store owners, developers and professionals.

One of the best support we'd ever get!!!

Very fast response (Cpt. Kirk would say Warp speed) :-) No, really, thanks for helping us in a fast and successful way. best regards from Germany

Rolf Richter   ★ ★ ★ ★ ★

Good plugin. I recommend!

Very handy for updating many prices on its website. The support is excellent. I had a special request and the support was very responsive in finding the solution.

Hoguin   ★ ★ ★ ★ ★

So pleased with this Plugin as it delivers everything it promises.

Very happy clients as they are able to export whatever data they need easily.

Jaynie   ★ ★ ★ ★ ★

Definitely recommend this Plugin.

Really happy with the plugin and the support provided by Visser Labs.

Indigo Johns   ★ ★ ★ ★ ★

Thanks Visser Labs!

Great Plugin and even better support!

Alex   ★ ★ ★ ★ ★

Thank you for this great product

Wow!!! - where to begin.- you are AWESOME!!!! 1. One of the best support after a plugin was purchased 2. Amazingly fast response time on tickets/mails 3. Insanely patient and kind And the plugin works better than I thought.

Dorette   ★ ★ ★ ★ ★

(close)

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