So you operate a WooCommerce store but are looking to level up your knowledge and skills around exporting your data? Look no further than this post as I show you how to export WooCommerce orders, products and customers to a CSV.
Why bother exporting your WooCommerce data? As you continue to generate sales, your database of information relating to your orders, customers, and products will continue to grow, resulting in a multitude of opportunities to use this data to grow your WooCommerce business. This boils down to 3 main areas:
So now you understand the why, let’s explore the what. The main datasets you are going to be exporting to a CSV are:
That’s a great question. There are many different options, some free, some paid, some limited in their ability and some which offer you many great features. Let me break it down for you…
WordPress/WooCommerce has free but limited exporting options built into it:
Any built-in option suffers from the same flaws, it is either very complicated and requires serious coding knowledge to gain meaningful information, or is very basic and does not provide any meaningful insights, eg: you can only export all data, or one very small specific segment.
Both free and paid plugins can be a suitable solution in specific situations. Free plugins generally offer very limited functionally and often require to pay for a pro version with the full feature set. And while they may be a perfectly good solution in the early stages of your WooCommerce store (100 orders per month), when you begin to reach thousands and tens of thousands of orders a month, you may run into significant performance issues that could crash your site.
WordPress.org’s plugin repository is not short of options. Some of the most popular free ones we’ve tried include:
But as you can see, it requires 3 separate plugins, each with their own UI and settings, to be able to export orders, products and customers from WoocCommerce. Not a very user-friendly experience.
For premium paid plugins, a couple of options come to mind:
Both of these paid plugins offer many more features than their free counterparts, however still suffer from:
If you are ready to become a pro-level WooCommerce data exporter, Metorik may be the answer for you.
Metorik’s key exporting features include:
Metorik securely connects to your WooCommerce store and stores all your sites data on a separate server. What does this mean for you? If you get gutsy one day and export 250,000 orders, there will be no impact on your WooCommerce store and importantly, the potential customers shopping on it while you export.
Exporting tens of thousands of orders, customers, products, etc. takes moments rather than hours.
You can infinitely segment data before you click export. Remember the example above where we wanted to segment customers by location, total spend, and last ordered over 30 days ago? With Metorik, it’s a piece of cake.
Here we’ll apply some segment filters:
And after exporting the CSV file, this is what we’re given:
Automatic recurring exporting
Schedule exports to happen automatically every day/week/month at a custom time to email and/or Slack. For example:
Above we touched on how frustrating it can be to export WooCommerce orders, products and customers through both the built-in solutions and plugins available. Built-in solutions are often ineffective or require expertise in coding. While a cohesive plugin solution, which is able to export data for orders, customers and products will require at least 3 different plugins. Both will invariably suffer from performance issues as your store continues to grow. Neither of these solutions are elegant or convenient in my experience.
With Metorik, you have a single interface to view, segment, and export all data (immediately or automatically recurring), including:
To learn more about exporting with Metorik, check out our section on exporting in the Metorik Docs.
Zapier, if you aren’t already familiar with it, is a fantastic tool you can use for integrating different apps and automating tasks. For example, every time someone subscribes to your MailChimp mailing list, add them to a separate Google Sheets spreadsheet.
Currently, there isn’t a Metorik integration directly with Zapier (although it’s planned!), but a few creative customers emailed us recently to inform us that Metorik already integrates with Zapier. How? Through automatic exports!
So basically, Zapier can automatically read the CSV file sent with an automatic export and do practically anything with that data.
For example, it could send the CSV to Google Drive or Dropbox. Or you could automatically build a Facebook Custom Audience through customer exports.
To do this, you’ll want to use Zapier’s new email parser tool. We’ll elaborate on how you can combine Metorik and Zapier and do exactly this in a post soon.