How to export WooCommerce Subscriptions

Here is a quick guide on how to export Subscriptions from the WooCommerce Subscriptions Plugin.

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.

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   ★ ★ ★ ★ ★


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