Lots of users will turn to WooCommerce in order to run a full-featured online store using WordPress. The general “flow” involves bringing assets, products, and content into both of these platforms. However, you can also use WooCommerce to export products too.

There are many reasons for why you’d do this. Most often, you’ll have some administration to carry out, such as fixing entries in bulk. However, you might also export products if you choose to move your web hosting.

Regardless, knowing how to export your products — and the steps involved — is a powerful arrow to have in your quiver.

For this tutorial, we’re going to show you how to use WooCommerce to export products. We’ll round up some plugins to help you and offer you a step-by-step tutorial to carry out the job.

First, let’s talk about use cases for exporting, and also the import process, in brief.

Check Out Our Video Guide on How To Use WooCommerce To Export Products

Why You’d Want to Export WooCommerce Products

Your entire stock and inventory is within WordPress — specifically, WooCommerce. Exporting these products means generating a list whereby you can work on the data in another program, away from your store’s installation.

A spreadsheet showing a list of products from a WooCommerce store.
A spreadsheet of a product export.

You’ll often export these products into some kind of spreadsheet format, whether that’s a comma-separated values (CSV) file, an Excel spreadsheet, or even a plain text file.

While it might seem like a drastic thing to do, in reality, you’ll often export your products for a number of mundane and routine reasons:

  • Efficiency: It’s more straightforward and familiar to batch edit your inventory through a spreadsheet rather than the WooCommerce interface. Plus, you can use the dedicated functionality of the spreadsheet app to save some time and effort to boot.
  • Global error correction: There may be an issue with your product list that you’ll need to sort on a global level. For example, you could have an error with your stock keeping unit (SKU) values. Exporting your WooCommerce products lets you solve this issue, and re-import the list in a flash.
  • Migration simplicity: You might even want to upgrade your hosting to something more robust and feature-specific for your needs. If you export your WooCommerce products, it takes nothing to import the entire list into a new installation, or onto a new server.

Speaking of importing, it’s worth knowing how to do this before you get into the export process. This will give you a good understanding of how entries relate to the “inside” and “outside” worlds (with regard to WooCommerce, at least).

How To Import WooCommerce Products and Orders

On the surface, the import process for WooCommerce products and orders seems simple. In fact, there are lots of cogs that make up the whole wheel.

Over the next few sections, we’ll talk about some of the “need-to-know” elements, and show the exact process to import products into WooCommerce.

Basics of a CSV File

Although we call it a “CSV file,” it’s not really a file type — it’s a file format. This is despite CSV files having the .csv extension.

You’re able to read CSV formats using almost any app that can parse and display text. Most users will open a CSV within a spreadsheet app because this will offer related functionality to work with the values within. However, there’s nothing wrong, in a technical sense, with using a text editor or some other solution.

The key aspect of a CSV file is its use of a “delimiter.” In basic terms, this is a separator and the default is a comma — hence the format displaying “comma-separated values.” When you use the CSV format, the “translation” software (in our case, WooCommerce and a spreadsheet app) will understand that every chunk of information separated by a comma is a unique, individual piece of data:

A text editor showing WooCommerce product data values separated by commas.
User names separated by commas.

Without the comma delimiter, you’ll see the data smashed into one cell:

A text editor showing all of the data within merged into
A dataset merged due to the lack of a delimiter.

The beauty of the CSV format is how it’s agnostic to not only the program you use to read the data, but also the program you import into. If an app can work with CSV values, you can move that data almost anywhere — as long as you can map the data appropriately to the program you import it to.

How WooCommerce Uses CSV Data

WooCommerce uses CSV data in a similar way to other programs. You have a number of fields within WooCommerce that designate the values for your products:

The admin panel for WooCommerce, that shows a list of products and the corresponding data fields.
A list of WooCommerce products and data fields.

When you import a set of products from a CSV file, each value will be collated under a header — an SKU, product name, variable value, and more. However, those headers will need to correspond to an appropriate value within WooCommerce.

For example, you couldn’t import data from an Engine Type header if your WooCommerce product list doesn’t use that header value. Let’s talk about this in relation to the import process in general.

Importing WooCommerce Products and Orders from a CSV File

The good news is that despite all of the background information, the import procedure for WooCommerce products and orders is straightforward. This is thanks to WordPress’ friendly interface.

You’ll need a CSV file to do this, and we’re going to use the WooCommerce sample data. It’s available for free, although you’ll need to download the WooCommerce plugin file from WordPress.org. Within, you’ll find a folder called sample-data which contains files to use:

A macOS Finder window showing three files: sample_products.csv, sample_products.xml, and sample_tax_rates.csv.
WooCommerce’s three sample data files.

There are a few ways to import products into WooCommerce. If you have a new installation and run through the Onboarding Wizard, you can import a CSV file during that process:

The WooCommerce Onboarding Wizard, showing four options, including an "Import via CSV" link.
The WooCommerce Onboarding Wizard asking you to import products.

However, this will only be an option for brand-new stores with no products. We’ll next show you how to update your WooCommerce product data, which also covers the import process using a CSV file.

Updating Existing Orders and Products Using a CSV File

The best (and recommended) way to import WooCommerce products is through the Products > All Products screen within WordPress. If you select Start Import, you will see a dialog to choose a CSV file:

The WooCommerce Import Products screen, showing a button to choose a CSV file from your local computer and a checkbox to update existing products.
Choosing a file from the WooCommerce import dialog.

If you click the Show advanced options button here, you can see some optional settings for the path of your CSV file as well as the option to use previous mapping settings. Most important is the option to choose your file’s delimiter. This is going to help if your file doesn’t use commas:

The Show advanced options settings, including a path to a remote CSV file, the option to set the file's delimiter, and a checkbox to use old column mapping settings.
The Show advanced options dialog.

In general, the process here is simple: Choose a CSV file from your computer, then click Continue.

However, the extra checkbox here is how you’ll update products.

The tooltip explains, but it will compare products with a matching ID or SKU and update the information to whatever your CSV file shows. What’s more, lines in the sheet that do not match with an existing product — i.e. new products — won’t import. This means you can update the file with whatever data you need, then import it to update your inventory, all using one checkbox.

Mapping Product Columns

The Column Mapping screen is how you’ll relate the columns within your CSV file to WooCommerce product headings. In fact, WooCommerce does a “best guess” on this — if you use the sample data or import a file that has origins as an export, this is going to either be exact or close enough:

The WooCommerce Column Mapping screen, showing spreadsheet values on the left, and drop-down menus relating to WooCommerce fields on the right.
The WooCommerce Column Mapping screen.

Once you check these columns and make any necessary changes to help you map columns with accuracy, you can scroll down and click the Run the importer button. From here, WordPress will do the necessary, which may take a while depending on the size of your CSV file.

However, you’ll see a success screen once the process completes:

The WooCommerce Product Import screen showing a success message and a button to view the imported products within WooCommerce.
The WooCommerce Import Complete screen.

This is all you need to do to import products using the native functionality. Next, we’ll take a look at what WooCommerce offers with regards to exporting too.

How To Use WooCommerce to Export Products

To export from WooCommerce, you’ll want to head to the Products > All Products screen. Once you have products within your installation, there will be an extra Export button:

The WordPress Products screen, showing the "Add New", "Import", and "Export" buttons.
The WooCommerce “Export” button.

However, if you click this without selecting products, nothing will export. You’ll first need to choose the products you want to export using the checkboxes in the list, then click the Export button.

This will bring you to a screen that shouldn’t need much input from you — the Export Products dialog:

The "Export Products" dialog, showing three options to select columns to export, and the "Generate CSV" button.
The WooCommerce “Export Products” dialog screen.

Here, select the options from the dropdowns that correspond to the data you’d like to export. When you finish, click the Generate CSV button to start the process and save the CSV to your computer.

From here, you can review your CSV using any program you’re comfortable with. For example, Excel is popular, as is Google Sheets.

However, while this native process is quick and simple, it’s not the most flexible or powerful. We’ll talk about this in more depth next.

Limitations of WooCommerce Native Functionality

The limitations of WooCommerce’s native export functionality — and that of the import process — won’t show themselves in lots of day-to-day use cases.

This is a double-edged sword. On the one hand, you’ll be able to achieve almost everything you need in lots of situations.

On the other hand, though, there are a few limitations that won’t be apparent until you encounter them. For example, you might not be able to import specific types of custom data and complex products in the most optimal way.

This is where a plugin can help by bridging the gap between the native export process and something tailored to your needs. Automattic recognizes this, which is why they released the Product CSV Import Suite WooCommerce extension.

The extension goes above and beyond the basic native functionality in a number of ways:

  • You have more support for other WooCommerce extensions, such as WooCommerce Photography, WooCommerce Bookings, and Google Product Feed.
  • There’s a way to import, export, and update custom and complex information. Whether you assign products to vendors, add brand names to products, or anything else, you’re able to still work with this data within your CSV file.

However, there are more choices than only first-party WooCommerce extensions. You can also use third-party plugins to help export WooCommerce products. We’ll discuss this, and how to export using a plugin, in the final section.

How To Export WooCommerce Products and Orders With a Plugin

Given that a plugin might offer a better way to export WooCommerce products, you’ll find a number of them on the market. Next, we’re going to run down a number of plugins on the market to give you a flavor of what’s on offer.

From there, we’ll get into how to export WooCommerce products using one of these solutions, comparing this to the native approach.

Plugins for Exporting WooCommerce Products

There are myriad plugins available at all price points to help you export WooCommerce products. You’ll also find that despite the number of plugins available, a chunk of them do something different to the rest.

A plugin such as WP All Import is more of an all-purpose exporter plugin. The standout feature here is the drag-and-drop editor. This gives you the opportunity to build complex products using an interface similar to a page builder. You can even design the XML scheme using drag-and-drop, which is fantastic if you shudder at the thought of breaking out your text editor.

The WP All Import plugin's schema editor, showing XML code along with user-defined values and parameters within the code.
The WP All Import XML Editor.

Product Import Export is another plugin that supports CSV and XML formats and has high-compatibility with third-party plugins and WooCommerce extensions. It also has another trick up its sleeve.

A green-blue panel for the Product Import Export plugin that lists some of the key features, and includes a WooCommerce logo.
The Product Import Export plugin.

The plugin enables you to set up multiple Secure File Transfer Protocol (SFTP) channels in order to schedule your imports and exports. This has two benefits: First, you can transfer data in an efficient way through SFTP; second, you take a “hands-off” approach that will reduce errors and increase your efficiency.

While both of these solutions are premium plugins, you might not want to shell out for a solution. WooCommerce Store Exporter is a free plugin with a minimalist focus.

A spreadsheet mockup showing WooCommerce products on a purple background with a text
The WooCommerce Store Exporter plugin.

You can also export to remote SFTP formats, as well as using POST. This is a development-level feature that will help you if you need a custom export solution. However, if you want to use the plugin as a simple export tool, there’s a one-click option available to output a spreadsheet that contains your data.

The final plugin is one we’re going to demonstrate in the next section. Advanced Order Export for WooCommerce is just as straightforward as WooCommerce Store Exporter, with greater flexibility with regards to its output settings.

The WordPress dashboard, showing the "Export Orders" options, including numerous filters, data range options, and output formats.
The Advanced Order Export plugin’s dashboard.

You get a plethora of output settings that, depending on your needs, you’ll value. The usual suspects are there — CSV, XML, and XLS formats — and there are also PDF and HTML formats available.

You also get a tab-separated values (TSV) file format. While this isn’t as flexible as the ability to set the delimiter, it does give you a permanent option if you enjoy using that format for your data.

How To Export WooCommerce Products Step by Step

Of course, the process you’ll take to export WooCommerce products will be different depending on the plugin you choose. We’re going to use the Advanced Order Export for WooCommerce plugin here, and we’ll discuss some of the general steps for the process.

Once you install and activate the plugin, you’ll want to look for the relevant profile settings. In most cases, a plugin will let you create a dedicated export profile. This enables you to save a unique setup to use again.

For Advanced Order Export for WooCommerce, it’s under the WooCommerce > Export > Profiles section:

The WordPress back end, showing the Profiles section to export orders. There is a list of columns, complete with information on formats and data ranges, and also an actions icon menu.
The Export Profiles section of the plugin.

We can work with the Copied from “Export Now” profile — if you click it, you’ll come to a detailed screen with the fields you need in order to complete an export to your liking:

The full profiles screen, showing export data ranges, bulk action settings, filter settings, and more within WordPress.
The Export Orders screen showing a single profile.

From here, you’ll want to alter settings based on the following:

  • Date range: There should be a date range that matches the data you want to export, and no more.
  • Output format: You’ll want to choose the appropriate output format. CSV will be the default for most applications, although you might want a copy in XML too.
  • Columns: The filters let you choose the columns you export, so this should be where you spend the bulk of your attention.

Advanced Order Export for WooCommerce has myriad filters for you to choose the exact range of your output data. For example, we have filters for item weight, whether the product is a backorder (as a custom field value), variable attribute, and more:

The Export Order dialog, showing a list of filters and range values, along with format output options, and custom date settings.
Editing product filters in WordPress.

However, this doesn’t restrict the number of columns you’ll see in your spreadsheet. For this plugin, you’ll open up the “Set up fields to export” menu:

A list of green fields with attributes for an individual product, and a purple "Remove all fields" button.
The Field Export list in WordPress.

Once you set these, it’s a good idea to save your changes and profile for future use. From there, you can run an export.

For this plugin, you’ll use the WooCommerce > Export Orders > Export Now screen if you want a quick general export, or the Export button at the bottom of a profile if you need that particular one:

The bottom of an export profile, showing a number of buttons including the Export option.
The Export button within WordPress.

This will save a CSV file to your computer that contains the data export:

A Google Sheets document showing the data export from WordPress, including the columns set in the export dialog screen.
A Google Sheets document that contains the export data from WordPress.

Once you carry out your changes, you can save and import the spreadsheet back into WooCommerce and WordPress without fuss.

Summary

The ability to get data out of and into WooCommerce is a fundamental and essential one. As such, WooCommerce offers native ways to do both. While the built-in importing process is straightforward, intuitive, and relatively error-free, the native export functionality isn’t always the best approach.

This post has looked at using plugins to export WooCommerce products, and the good news is there are lots of solutions available. Once you have your CSV file, you can open it in Google Sheets, Excel, or even a text editor to review it. From there, you can import the file back into WooCommerce and update your products.

Do you export WooCommerce products often, and if so, what’s your strategy? Let us know in the comments section below!

Salman Ravoof

Salman Ravoof is a self-taught web developer, writer, creator, and a huge admirer of Free and Open Source Software (FOSS). Besides tech, he's excited by science, philosophy, photography, arts, cats, and food. Learn more about him on his website, and connect with Salman on Twitter.