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:
When exporting, I export the orders first:
Then I export the customers:
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.
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.
Once I choose and upload the file, I some options to preview the import.
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.
If I choose a dry run, I get these results. It looks good to me.
Doing the live import I get a little different results, but this was not a concern for me.
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.
And again, you have options for mapping the fields.
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.
Not much to do here with just a couple of options, so going to import it now.
Similar to the other extension, you can map any fields to column names.
Then, once you click on import your subscriptions, you can connect to the appropriate customer and order.
Because there can be things that go sideways with all of this, make sure to follow the documentation closely. And good luck!
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.