How to Export and Import Your WooCommerce Customers, Orders and Subscriptions

If you use WooCommerce, likely there will come a time, for various reasons, that you need to export and import some or all of your WooCommerce data.

In this post, I’d like to I show you how I moved my WooCommerce customers and subscriptions from one site to another. I’m not talking about migrating an entire site, but simply moving some data.

The scenario: I used to have WooCommerce on this site, which handled different services sold over the years.  And, more recently, it ran my premium plugin shop where I showcased many of the plugins I have done posts on, all of them, obviously, having affiliate links.

Since then I have made some changes. In a nutshell, I moved all of those plugins to a new site, with WooCommerce trailing it. And when I moved to GiveWP for my BobWP Backers, there was no reason to keep WooCommerce on this site.

But there were a few subscriptions baked into WooCommerce and I didn’t want to lose them. I wanted to move those over to the new site as well instead of hassling with having people  set up a new subscription here. I also wanted to move my customers who have the subscriptions (and their orders).

First, I want to move my customers and orders, so I am using the WooCommerce Customer / Order CSV Export extension.

Exporting WooCommerce Customers and Orders

I will make sure I have the export settings correct for both.

For Orders, here is the export format. There are a few options for the Customer Export Format. The Customers export settings are similar to this one:

Orders export settings

When exporting, I export the orders first:

export orders

Then I export the customers:

customers exported

Once they are done, I can download them from the Export List.

Importing the Customers and Orders on WooCommerce

Now it’s time to import the orders. I am using the Customer / Order / Coupon CVS Import Suite extension.

I have installed it on my other site and now I can simply  import my customers, their orders and, if needed, the coupon options.

import customers and customer orders

Importing Customers on WooCommerce

If I choose to start with importing customers, it will ask me where to import the data from. Since I exported them as CVS files, that is what I choose.

import data from

Once I choose and upload the file, I some options to preview the import.

import customer options and preview

Next I can make any adjustments as far as mapping the fields on my import. This allows me to do a dry run or an actual import.

map fields on import

If I choose a dry run, I get these results. It looks good to me.

dry run import customers

Doing the live import I get a little different results, but this was not a concern for me.

customer import done

Checking my user settings, I see that all my customers have been imported successfully.

Importing Customer Orders

Next I will do the orders. As with customers, it gives me the same option of where to import them from. After choosing the file and starting the process, I again get the preview but with some other options specific to orders.

import orders options and preview

And again, you have options for mapping the fields.

map fields for orders

And we can do a dry run and an actual import. I ran the import as I did with the customers and everything came through fine.

Export and Import WooCommerce Subscriptions

I am using the WooCommerce Subscriptions extension. In order to export and import my subscriptions, I am using a free extension for this that you can get on GitHub.

Exporting the Subscriptions

You can export specific subscription statuses as well as payment methods. In my case, I am only exporting my active subscriptions.

export subscriptions

Importing Subscriptions

Not much to do here with just a couple of options, so going to import it now.

import subscriptions

Similar to the other extension, you can map any fields to column names.

map your subscription import

Then, once you click on import your subscriptions, you can connect to the appropriate customer and order.

That’s it.

Because there can be things that go sideways with all of this, make sure to follow the documentation closely. And good luck!

do the woo weekly news

Get weekly news on and around the WooCommerce community. Updates to our podcast, news from our weekly roundup and extra news from within and outside the WooCommerce space.  I write this myself and it is delivered to your inbox every Saturday morning.