Posted on

WooCommerce export – How to export orders, customers, and everything else from WooCommerce


Importing and exporting product details, customer details, and sales data frequently is a reality for many e-commerce store owners.
Sometimes you need to export WooCommerce store data for accounting purposes or to publish your products on another site.

Although you can add the functionality of moving products and other types of data into WooCommerce, many sellers get confused while using the export functionality.

Let’s see how to export orders, customers, and sales data from WooCommerce easily and quickly.

What EXPORT functionality is in-built within WooCommerce and what’s not?

Sadly, EXPORT is not an in-built, core WooCommerce function.
You might think, it’s a necessity and it must be. But it isn’t built-in!

In WooCommerce, you can only export products directly. So in order to export orders, customers or anything else, you need to put in a plugin.
I will be covering all the details below.


The ONLY in-built export functionality-
WooCommerce Export – Products

How to export products in WooCommerce?

Step 1: Login into your WordPress backend. Go to WooCommerce > Products.

Step 2: Click on the “Export” button at the top.


Step 3: The form (or screen) for exporting the products will get displayed.’

Step 4: You can export all products to all columns or specify columns by using the dropdown menu.

Step 5: Do the same for product types and product categories.

That’s it. That’s how simple it is to export products.

Benefits of exporting WooCommerce product list

  • Upload the file on Google Drive or OneDrive and keep it as a backup.
  • Upload products detail to another WooCommerce website to increase product visibility.
  • Import the data into an analytics tool and gain product-level and category-level insights.

WooCommerce Export – Orders

This is one of the most demanded exports ever – WooCommerce order export.
WooCommerce store owners often require exporting orders for various reasons like-

  • Accounting
  • Analysis
  • For taking critical marketing and strategic decisions

However as mentioned above, WooCommerce doesn’t provide this export in the core.

So you need to add a plugin to your website in order to export the order list.

The most recommended plugin for exporting orders is from our folks at SkyVerge.
It’s a paid plugin and it’s priced at $79 for a single website.

Here’s how you can use this plugin to export WooCommerce orders from store.

Step 1: Login into your WordPress backend. Go to WooCommerce > Export
Step 2: Select the output type as per your needs. Mostly, you will need a CSV format.

Step 3: Select “Orders” in the export type.
Step 4: Select a predefined or custom format and provide a filename of the export file.
Step 5: Check “mark as exported” if you want to exclude the same data from future exports.

Step 6: Use the “Export Options” section to filter the type of orders you want to export and only include particular orders. The visible options will change based on your selected options.

Things you can do once you export the WooCommerce order list:

  • Find the top 5 most popular (highest sold) items and take actions to boost their sales
  • Find the products that are frequently ordered together, build a product combo offer.
  • Find the top 5 least popular (lowest sold) products — plan to promote them in a better way.

More strategies related to WooCommerce order export.


WooCommerce Export – Customers

After products, orders comes customers.
Storeowners need to value their customers and exporting their customer list on a regular basis can help them keep a tab on a couple of things.
But before getting into that, let’s see the steps for exporting customers in WooCommerce.

How to export customer details in WooCommerce?

You will need to purchase a paid extension named WooCommerce Export to enable this functionality.

It will cost you $79 for a single website.

If you already have the extension purchased and installed; you can follow the steps:
Step 1: Login into your WordPress backend. Go to WooCommerce > Export
Step 2: Select the output type as per your needs. In most cases, you will need CSV.
Step 3: Select “Customers” in the export type.

Step 4: Select a predefined or custom format and provide a filename of the export file.
Step 5: Check “mark as exported” if you want to exclude the details of the existing customers from future exports.
Step 6: To filter and only include details of specific details, Use the “export options” section.

Things you can do once you export customers from your WooCommerce store

  • Send a gift card to the customers who order more frequently.
  • Import the data into CRM to better engage with customers.
  • Import the data into email marketing tools to send offers and birthday emails.

Is $79 worth for EXPORT? Per Site?

I’m sure you have asked this question yourself.

Is paying $79 justifiable? That too, just for adding the export functionality for a single website?

The logical answer to that is NO, it’s not!

So what’s the other option? Is there something better for less?

Yes, there is…Putler.

Let’s conclude

Running a successful eCommerce store isn’t just limited to listing your all products online and managing the inventory.

You may need to move various data such as product details, order details, and customer details while moving your store to another domain or uploading products to the comparison engine. So export is a really big feature.

But the process of installing extensions and exporting WooCommerce data is too complicated and lengthy, so you can try out one-click WooCommerce export using Putler.

Connecting your WooCommerce store/ stores to Putler takes less than 5 minutes and the WooCommerce export takes only a single click. Give Putler a try today!

Try Putler – It’s FREE

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.