Exporting orders or products from WooCommerce takes three steps. However, you can export WooCommerce customers in only two steps! In this article, we’ll explain how to do this and introduce an alternative method of how to automate exports of customers from WooCommerce at the desired frequency.
What are the options to export WooCommerce customers?
Basically, there are two ways to export customers from WooCommerce:
- Manual – this allows you to export WooCommerce customers as a CSV file, which you can later open in a spreadsheet app or upload to another software.
- Automated – this allows you to export customers from WooCommerce to a spreadsheet app or a database automatically on a schedule, say every day or every hour. It’s implemented with the help of the WooCommerce integration designed by Coupler.io.
Coupler.io is a popular data analytics and automation platform that can help you move your data automatically and create self-updating reports. In particular, it can extract data from 70+ business apps and transfer it to spreadsheets, data viz tools, and databases automatically on a schedule.
Also, some users consider the option of installing a WordPress plugin to do the export. However, we recommend you stay away from this since, as you know, the more plugins you install, the worse the performance of your WP website is.
How to export customers from WooCommerce automatically
In this example, we show you how to automatically export customer information from your WooCommerce store. To do so, you will need to connect WooCommerce to the destination app of your choice (for example, a spreadsheet app). This process takes just a few minutes and requires no special knowledge on your side. Also, you will only need to do this once – after this, Coupler.io will keep exporting your WooCommerce customers automatically on a schedule.
Here’s how to do this.
1. Extract your customer data
Sign up to Coupler.io, then select a source app, WooCommerce, and a destination app of your choice. It can be Google Sheets, Excel, Looker Studio, Power BI, or BigQuery.
In our example, we set up a WooCommerce export to Excel.
Then, follow the instructions in the wizard to connect your WooCommerce account. Select Customers as a data entity to export. Optionally, you can filter your customer data before exporting.
2. Preview and transform your data
Coupler.io allows you to actually see data that you are about to export. So you can check if everything is okay, and also edit and transform your data, including:
- Hide unnecessary columns – they won’t be exported
- Rearrange columns – just drag and drop them
- Rename, merge, and split columns
- Add new columns, including formula-based ones
- Filter and sort your data
- Merge data from several accounts or from different sources
If everything looks good, click Proceed and connect your Microsoft account to import the extracted data to Excel.
3. Manage your data and automate updates
Since we want to automate exports of customers from WooCommerce, we need to enable the automatic data refresh and configure the schedule. Once this is done, Coupler.io will automatically update your customer information in the spreadsheet.
Then, Save and Run the importer.
Here is what the imported data looks like in Microsoft Excel:
Export customers from WooCommerce manually
- Go to Customers.
- Click the Download button. A CSV file with information about your WooCommerce customers will be downloaded to your computer.
That’s the end of the story 🙂 This exporting method is rather fast and simple, but it’s not the only option you can use.
Can I auto export WooCommerce customers as CSV?
You can’t automate the export of WooCommerce customers’ data with the native exporting option, but you can using Coupler.io.
Why would one need to do this? Imagine that you monitor the customers’ information daily in a separate spreadsheet, which you can share with your team. To update information in this spreadsheet, you’d have to export WooCommerce customers as CSV daily and add this data to your spreadsheet. This manual work will take 2 minutes of your time every day. Not much at first glance, but this will result in 14 minutes every week (if you work on weekends as well), or 1 hour every month, or 12 hours every year! Instead, you could automate exports to save time and focus on some proper WooCommerce analytics instead.
Although you can’t do this with the native functionality, Coupler.io provides a WooCommerce integration to schedule exports of customers from WooCommerce. It will let you optimize your workflow in literally less than 2 minutes. We already explained how to do this at the beginning of the article.
WooCommerce customer export: CSV vs. Coupler.io
We’ve introduced two methods to export customers from WooCommerce: the manual one as a CSV file and the automated one using Coupler.io. In addition to their core difference, they also differ in the data you get out of WooCommerce.
The CSV file offers a limited set of columns for your data. At the same time, it returns all the customers, including guests, i.e., those who made a purchase without sign-up. In our example, we’ve got 9 rows (including the title row) and 12 columns:
Coupler.io provides way more details about your customers, but it only returns the ones who signed up. In our example, we’ve got only 5 rows (including the title row) and 47 columns:
Which one is best? Hmm…it depends on what data you need. For example, the CSV option displays total orders per customer, which is not available in the data set exported with Coupler.io. At the same time, Coupler.io returns the entire billing information and metadata. Below, you’ll find some differences in the data you can export with both of the options.
How to export customers and phone numbers from WooCommerce?
Well, to get the billing details of your customers, Coupler.io seems to be the best option. It allows you to get all the contact details, including phone numbers.
How to export WooCommerce customers by product?
The CSV option can only give you information about the total orders per customer. But that’s not the customer by product. When you export WooCommerce customers with Coupler.io, you won’t see such breakdowns as well. But hold on!
Coupler.io also allows you to export other types of data, including products, orders, etc. This could be the solver. Check out the next section to learn the details.
Export WooCommerce customers who purchased a certain product
We already explained how to do this in the How to export customers automatically section.
Then connect your WooCommerce account and select Orders as a data entity to export.
You can either export all of your WooCommerce orders and get information about the customers per order and what products they purchased. Or you can filter the orders and customers per product right away.
For example, we want to get information about customers who purchased sunglasses. For this, enter ‘sunglasses’ as a search string to the respective field in the Advanced settings.
Then, finish setting up the importer – preview your data, connect your destination account, and run the importer. Here’s what the exported data looks like:
Can you export customers from WooCommerce to XML?
For some WooCommerce data entities, such as Products or Orders, there is another exporting option available. You can export these as XML if you go to Tools => Export. Unfortunately, you can’t export WooCommerce customers this way.
If you do need to export customers from WooCommerce in this format, the only option you have is a WordPress plugin, for example, WooCommerce Customer / Order / Coupon Export. There are also other alternatives.
Streamline your data analytics & reporting with Coupler.io!
Coupler.io is an all-in-one data analytics and automation platform designed to close the gap between getting data and using its full potential. Gather, transform, understand, and act on data to make better decisions and drive your business forward!
- Save hours of your time on data analytics by integrating business applications with data warehouses, data visualization tools, or spreadsheets. Enjoy 200+ available integrations!
- Preview, transform, and filter your data before sending it to the destination. Get excited about how easy data analytics can be.
- Access data that is always up to date by enabling refreshing data on a schedule as often as every 15 minutes.
- Visualize your data by loading it to BI tools or exporting it directly to Looker Studio. Making data-driven decisions has never been easier.
- Easily track and improve your business metrics by creating live dashboards on your own or with the help of our experts.
Try Coupler.io today at no cost with a 14-day free trial (no credit card required), and join 700,000+ happy users to accelerate growth with data-driven decisions.Start 14-day free trial
Which method to export WooCommerce customers should you choose?
Both the native and automated methods for exporting customers’ data from WooCommerce are quite actionable. However, each of them is a good fit for a specific purpose.
The manual way of getting data in CSV works best for one-time export, for example, to move your customer details to another app.
The automated method with the help of the WooCommerce integration by Coupler.io is a good choice for different analytical or reporting purposes. For example, you can schedule exports of customers’ data from WooCommerce to Google Sheets, say every day, and share the spreadsheet with the stakeholders. This way, you will know that they have access to the most recent records from your WooCommerce store.
So, make a smart choice based on your needs. Good luck with your data!Back to Blog