Posted on

How to Export Customers (Users) in WooCommerce?

This post explains how easily you can export WooCommerce customers' data into a CSV file. Apply search, date, column filters & get data on lifetime value, order total, etc.

Last updated on August 27, 2021

As your business grows, keeping track of your exponentially growing customer data can be a tedious task, and it’s easy to get stuck.

In such cases, exported data helps you keep your data organized and analyze it whenever required. But default WooCommerce allows only product export. So how can you get neat WooCommerce customers’ export data?

This article will help you understand what customers’ data you can export, how to export customers’ data and how to export filtered data as per your requirements.

A better way to import and export customers in WooCommerce

Migrating to a new site, combining customers’ data from different WooCommerce stores, setting up multiple customer lists for targeted email marketing, or just backing up data, you need to import and export customers’ data.

If you are looking out for a better WooCommerce plugin to import your customers’ data, you can have a check with Customer/Order/Coupon CSV Import Suite plugin.

Now talking about export, as mentioned, default WooCommerce is limited to products. WordPress export deals with XML files that are difficult to analyze. And running an SQL query is prone to errors and fear of data deletion.

So, what’s left? WooCommerce export plugins.

But which plugin to choose? Will it justify the cost? Does it have the features needed? Above all, will that plugin be reliable and easy to use?

If you are looking for a plugin that answers all the above questions, Smart Manager is what you are looking out for.

How to export customers or users using Smart Manager?

Smart Manager plugin organizes all your WooCommerce data into an Excel-like spreadsheet. So you can manage all your customers, orders, products, coupons, any WordPress post type from a single place.

Bulk edit records, make inline edits, apply filters, add / duplicate / delete records, export data to CSV and a lot more.

With Smart Manager, you can export all your customers’ data or data based on filters into a CSV file. This gives you crucial information like orders per customer, customer lifetime value, customers’ personal details and other information. There’s also no limit on the number of export you can make.

Here are the three major ways you can export customers data –

Export all customer data

  • 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.

List of all fields you can export for customers (users)

WooCommerce export customers data using Smart Manager

Export data using advanced 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 Total > 1500 & Order Count > 30)
  • WooCommerce export customers based on search filters
  • Similarly, you can enter as many conditions as you want.
  • Once you’re done entering all conditions, click on Search. Your data will be shown.
  • Now click on Export CSV to download the data

That’s it.

Export data by enabling / disabling admin columns

To help you get the specific admin 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 to export customers data 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
  • Smart Manager Users admin columns management.png
    Smart Manager Users admin columns management
  • Click on Update once you’re done.
  • The refreshed list will appear on your dashboard now
  • Click on Export CSV to download it
woocommerce customer export based on admin columns filters

As you see from the above image, we selected only the required columns to export as CSV.

Here, you get to know which customer is making a purchase of what items and up to what price limit. Use this data to reach the right customers at the right time.

Try Smart Manager live demo

Other benefits of using Smart Manager export

  • Export WooCommerce customers for any date range
  • Set up Excel-like custom views for customers and then export data to CSV
  • Export orders, products, posts, pages, coupons, any WordPress post type. That means you can also export subscriptions, bookings, memberships, SEO fields, etc.
  • Use multiple search conditions, apply bulk edit or do other operations and then export data
  • Very convenient to identify customers based on user role, top purchasers, etc.

Start exporting customers data today

So, to make things organized, WooCommerce customers export is a much-needed thing. It becomes easy to refer to it whenever you need it.

Not just any export, but the flexibility to export based on your requirements and convenience. That’s where Smart Manager stands out.

Beyond export, it provides you tons of features to manage your WooCommerce store faster and boost productivity.

Get Smart Manager plugin now

One thought on “How to Export Customers (Users) in WooCommerce?

  1. Hi Akshat,
    This is a SUPER great tool – Brilliant.
    Just what I was looking for. I’ve been using Smart Manager for a while now and this is so welcome.

    Keep up the good work.


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.