How to Export WooCommerce Subscriptions

Here is a quick guide on how to export Subscriptions from the WooCommerce Subscriptions Plugin into various file formats like CSV, TSV, and Excel spreadsheets. We will look at exporting specific Subscription export fields, custom field labeling, batch exporting, and finally uploading the exported file to Google Sheets.


Step 1

Quick exporting Subscriptions

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

WooCommerce quick export Subscriptions

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

WooCommerce quick export data settings

Generating a quick export of all Subscriptions and their data is super easy. We just have to make sure that the Subscription option is selected, then click Quick Export.

That's all you need to do for a quick export!

In the next step we will cover customising your WooCommerce Subcriptions export using export filters, export field selections and altering export field labels.


Step 2

Customising Subscription export fields

We are able to get our work done quicker by taking advantage of the wide customization options that are included in the Store Exporter Deluxe Plugin.

Now let's take a look at the Subscription Fields section below.

Select WooCommerce fields to export

Here we will simply select which data fields we would like in our export file. It's always good practice to uncheck any unnecessary fields for the sake keeping things simple.

Customizing labels

In the above screenshot you'll notice the arrow pointing to the configure option. Click configure to go to the field editor.

Customize fields in WooCommerce for exporting

From the Field Editor we are able to customize the name of any field. As an example, I'll label the subscription_id 'My subscription ID label'. This field will be renamed automatically in our export when it runs.

The 'hidden' checkbox is purely for the sake of keeping the setting screen simple. We usually check the 'hidden' boxes of any fields we don't regularly export.

Adding custom Subscription export fields

Export custom subscription meta fields WooCommerce

We are even able to export any custom subscription fields used on the WooCommerce store. Add the custom meta fields as described on the page. You can find more information in our documentation.


Step 3

Data Filtering

We are able to further customize our WooCommerce Subscriptions export using filters.

Filter specific export data for WooCommerce Subscriptions

The Subscriptions filter settings allow us to select the type of data to export. You may only require an export of all active/cancelled subscriptions, specific subscription products, or certain customers only. Mix and match the filters to suit your needs.

I want to export all the data from my WooCommerce demo store, so I'll leave the options blank.


Step 3

Choose your export file type

In the Export Options menu let's choose the file type we need. CSV (comma separated values) is the most common file type for exporting and importing WooCommerce data into other applications. We can also export directly as an Excel file to use with Microsoft Office.

Export WooCommerce as CSV, Excel, TSV

Batch exporting for large WooCommerce stores

The best practice for dealing with large data sets is to split up the export. As an example, let's say we have 10,000 records. We'd split up the export into 2 batches to ease the server usage.

The first batch we want to limit to 5,000 records. When that's finished, we want to set volume offset to 5,000. This means that the export will skip the first 5,000 records, which we previously exported.


Step 5

Use with Google Sheets

WooCommerce Subscription export to Google Sheets

CSV files are perfect for importing into Google Sheets and Microsoft Office. Simply drag and drop your export file into the upload section of your choosen app and you are done!

Edit WooCommerce data in Google Sheets

As you can see our custom label for 'subscriptions_id' has been inlcuded in our exported CSV file.

That's it!

We have successfully customized and imported our WooCommerce Subscription data into Google Sheets. We can now use the data for editing, bookkeeping, or even importing into another platform. Migrating WooCommerce data into apps like Shopify or Easy Digital Downloads can be fast and simple by using Store Exporter Deluxe.

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

Thanks for reading!

If you'd like to import Prouducts with as much ease as our exporter, see our Product Importer Deluxe Plugin.

Store Exporter Deluxe for WooCommerce

★ ★ ★ ★ ★

Single Site

Setup automated exports today!

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

Unlimited Sites

Perfect for developers

$149
  • Free future updates
  • Automatic Plugin updates
  • Developer Support
Add to cart

Recent Reviews

Amazing! Fantastic support from the author as well.

Highly recommend.

KR Ben, 2 months ago

We have tried several export Plugins out there, and this one is by far the best Plugin out there!

The support is out of this world, seriously.

FR FabelMedia, 2 months ago

Great Plugin, and even better Support!

Michael worked with me to help implement the Plugin, and was so great about it.

AU Dallas, 3 months ago

(close)

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