Posted on

How to Export Customers (Users) in WooCommerce?

Last updated on March 19, 2021

With Smart Manager’s Export feature, you can export all of your WooCommerce customers’ (users) data into a CSV file.

This article will help you understand what kind of customer data you can export, how to export customers data and how to get the filtered data and export it as per your requirements using Smart Manager.

What data do you get from WooCommerce customers export?

From Smart Manager’s Users Dashboard, you can export any customer record based on search, date and column filters. Following are some of the important data you get:

  • Orders per customer
  • Customer lifetime value
  • Billing first & last name
  • Order status
  • Total order amount
  • Order date

and many more…

Why should you export customers?

As a WooCommerce store owner, you will always be overwhelmed with all the customer data present on the dashboard.

So, to make things organized, export customers’ data into a file where you can find all the information in one place. It becomes easy to refer to it whenever you need it for other purposes like segmented email marketing.

How to export customers using Smart Manager?

1. To simply export all the records

woocommerce export customers
  • Go to WordPress Admin > Smart Manager. Select post type ‘Users’ from the drop-down list
  • Click on ‘Export CSV’ to save all the customer data as a CSV document
  • The file will be downloaded and saved on your device

Try the live demo

2. To export filtered data

woocommerce export customers based on search filters
  • Go to WordPress Admin > Smart Manager. Select post type ‘Users’ from the drop-down list
  • Click on the ‘Advanced Search’ toggle on the Smart Manager dashboard
  • You can add conditions using the drop-down list where you will find all the particulars title and their condition. (For example – Order Subtotal < 500)
  • Similarly, you can enter as many conditions as you want.
  • Once you’re done entering all, click on ‘Search’.
  • To download the data, click on ‘Export CSV’

Try the live demo

3. To export data by enabling / disabling admin columns

woocommerce customer export based on admin columns filters

To help you get the specific column records you want, Smart Manager gives you the option to add/eliminate admin columns while exporting your customer data.

By enabling and disabling certain columns, you can go as specific as you want to when it comes to acquiring the data of your customers.

Steps for customers export based on column filters

  • Go to WordPress Admin > Smart Manager. Select post type ‘Users’ from the drop-down list
  • Click on the ‘Columns’ icon on the right corner
  • You can simply drag the options to the enabled list which you wish to download
  • Similarly, you can drag the items from enabled list to the disabled list which you don’t wish to download
  • Rearrange the columns by dragging them above or below
  • Click on ‘Update’ once you’re done.
  • The refreshed list will appear on your dashboard now
  • Click on ‘Export CSV’ to download it

Try the live demo

Why is this feature so important for your WooCommerce store?
For targeted marketing!

For example, to get to know which customer is making a purchase of what items and up to what price limit, you can enable the columns – ‘customer name’, ‘customer email’, ‘order details’ & their ‘order total’.

Export the data and use it for targeting them while running any offers/discount coupons in the future. This gives you the power to reach the right customers at the right time.

To conclude

If you’re looking for ways to conveniently filter any customer record you wish to and get it sorted quickly and easily, Smart Manager is what you need.

You can also export CSV files of WooCommerce products, orders or any other type based on search, date and column filters.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.