How to Export WooCommerce Products to CSV, Excel, or XML

To export your products, go to All Export › New Export and select WooCommerce Products. Build your product export file by using the drag & drop tool. Run the export, then download your file.

Step 1:  Create a New Export for WooCommerce Products

Go to All Export › New Export and choose a post type of WooCommerce Products. To continue, click Customize Export File.

New Export WooCommerce Products

Step 2: Customize Your WooCommerce Products Export File

In most cases, you don't need to export all of your WooCommerce product fields. WP All Export's simple Drag & Drop interface allows you to select the exact fields that you need.

To add a field to your product export, simply drag it from the Available Data section on the right to the column selection area:

Customize WooCommerce Product Export Columns

Dragging a column out of the selection area and dropping it on another part of the interface removes the column from the export.

WooCommerce Product Export Fields

The available export fields are divided into the following sections: Standard, Product Data, Media, Taxonomies, Custom Fields, and Other.

WooCommerce Standard Data

Standard data is found under Available Data › Standard.

  • ID: The post ID, a unique number given to every post in WordPress.
  • Title: The title or name of the WooCommerce product.
  • Content: A description of the product.
  • Short Description: Similar to the excerpt for posts, usually a summary of the content section.
  • Date: The date the product was published, in y-m-d format.
  • Post Type: The post type being exported, which is product in this case.
  • Permalink: The URL of the product.
  • Parent Product ID: WooCommerce variable products are attached to a parent product, and this exports the post ID of that parent product (a 0 is exported for products without a parent).
Export WooCommerce Products Standard Section

WooCommerce Product Data

More detailed WooCommerce product data is in Available Data › Product Data:

  • Sku: A product code used to reference and differentiate products.
  • Price: The product's current price, which is the regular price unless the sale price is active and lower.
  • Regular Price: The regular, full price of the product.
  • Sale Price: The sale price of the product.
  • Stock Status: One of several preset values. The default WooCommerce stock statuses are instock, outofstock, and onbackorder.
  • Stock: The number of products currently in stock and available for sale.
  • External Product URL: The affiliate link for external products.
  • Total Sales: Number of times the product has been sold.
  • Attributes: This will export the attribute's name, value, if it's is used in variations, if it's visible, and if it's a taxonomy or not. This data is more easily exported in the Attributes section.
  • Shipping Class: If configured, it exports the name of the product's shipping class.

If your product has attributes like size or color, they will be automatically detected and added to the Attributes section at the bottom of Product Data.

Export WooCommerce Products Product Section 2

WooCommerce Media

Images and file attachments associated with your WooCommerce products are in Available Data › Media. Images and files are treated the same by WordPress. There are two sections inside the Media section: Images and Attachments (not shown in the image below due to a lack of space). Both contain the same types of fields:

  • URL: The URL of the file or image.
  • Filename: The filename of the file or full-size image.
  • Path: The path, or location on the server of the file or image.
  • ID: The attachment ID of the file or image, similar to a post ID.
  • Title
  • Caption
  • Description
  • Alt Text
  • Featured: The URL of the featured image
Export WooCommerce Products Media Section

WooCommerce Taxonomies

The categories and tags attached to the products are in Available Data › Taxonomies. By default, there are only two but all custom taxonomies will be automatically detected and available here.

  • Product categories
  • Product tags
Export WooCommerce Products Taxonomies Section

WooCommerce Custom Fields

Custom fields are in Available Data › Custom Fields. For example, data added to Yoast SEO would appear here.

Export WooCommerce Products Custom Fields Section

WooCommerce Other

Other, less used product data is in Available Data › Other. This is an incomplete list with only the more important export fields:

  • Status: Similar to the post status. The default product statuses are publish, draft, and private.
  • Slug: The database friendy name of the WooCommerce product, used in the product URL.
  • Downloadable: Whether the product is downloadable or not.
  • Downloadable Files: Contains the files for that product if the product is downloadable.
  • Sale Price Dates From: When the sale date starts.
  • Sale Price Dates To: When the sale date ends.
  • Manage Stock: If the WooCommerce product handles stock or not, exports yes or no.
  • Up-Sells
  • Cross-Sells
  • Tax Status
  • Tax Class
  • Weight
  • Length
  • Width
  • Height
Export WooCommerce Products Other Section

Step 3: Download Your WooCommerce Product Export

After you've configured your product export, click Continue to verify your export settings. When you're ready to run your export, click Confirm & Run Export.

Once the export is complete, you will have two options to download your export file, both shown in the Click to Download section. One is the selected file type for your export (in this case, the default file type of CSV). The other is the Bundle option, which downloads a zip file that contains the export file and an import template. You can use the import template to migrate WooCommerce products to another site using WP All Import.

Confirm and Run

Here's a quick look at a typical WooCommerce product export:

Sample Product Export

Advanced Product Export Topics

Exporting to Different File Types

By default, WP All Export exports to a CSV file format. To export to Excel instead, do the following in the Drag & Drop interface:

Change Export Type to Excel
  1. Expand the Export Type panel just below the Advanced Options panel.
  2. Select Spreadsheet as your main export type.
  3. Select either Excel File XLS or Excel File XLSX as your specific file format.

Prefer XML?

Change Export Type to XML
  1. Expand the Export Type panel.
  2. Choose Feed.
  3. Select either Simple XML Feed or Custom XML Feed.

Note, the Simple XML Feed creates a simple, single-level XML feed of your product data that will work for most cases. If you need something more sophisticated, the Custom XML Feed option lets you fully customize the structure of your XML file (including nested elements), control the names and order of the XML elements, and easily add static data to the feed. For more information on XML, see exporting WordPress data to XML.

Finally, there is a Google Merchant Center Product Feed option that lets you easily upload WooCommerce Products to the Google Merchant Center. WP All Export extracts all of the necessary information from your WooCommerce products to satisfy this feed format, with options to map categories and configure other options that are specific to Google.

Export WooCommerce Products Advanced Options

The Advanced Options panel is found just above the Export Type panel:

Export WooCommerce Products Advanced Options

Use this panel to control various settings for the export file. For CSV files, these include:

  1. The field separator. The most common choices here are either the comma or the pipe (I) separator.
  2. Whether to include header row and column titles in the export.
  3. Settings for exporting product variations, all of which are self-explanatory.

Excel files only support the produce variations options, while XML files support both product variations options and CData tags.

Filtering WooCommerce Product Exports

Often, a user wishes to export only a subset of WooCommerce products. This subset can be based on product categories, stock availability, or any of the export fields described in the previous sections of this tutorial.

To filter your products, expand the Add Filtering Options panel near the bottom of the New Export screen, then select an Element, Rule, and Value:

Export WooCommerce Products Filter

In this example, you are setting:

Element = Product categories

Rule = In Product Cat

Value = classic

This is the same as saying, “Export WooCommerce products with a product category of 'classic'."

You can also combine multiple filters. For example, to export products with a product category of "classic" and that are currently in stock, set your filters like this:

Export WooCommerce Products Multiple Filters

Product filters can be as complex as you need them.

Frequently Asked Questions

How Do I Import Products Into WooCommerce?

  1. Go to All Import -> New Import in the WordPress main menu.
  2. Choose how you want to import your data (i.e. upload file, download a file from a URL, etc.).
  3. Select your import file.
  4. Choose your import target (i.e. WooCommmerce Products).
  5. Map incoming fields to your WooCommerce target fields using drag & drop.
  6. Run the import.

For a full list of import features, see Import WooCommerce Products.

How Do I Migrate WooCommerce Products to Another Website?

  1. Export a set of products. When downloading your export file, choose the "Bundle" option. In addition to the exported products, a bundle contains an import template.
  2. When importing products on the other site, upload the bundle file.
  3. WP All Import will automatically import products in a bundle file based on its import template.

For additional information, see Migration Overview.

How Do I Schedule My Product Exports?

To schedule your exports, see How to Schedule WordPress Exports.



Use WP All Export to obtain WooCommerce orders in a CSV or XML file.

Learn more about exporting WooCommerce customers with WP All Export.

Export your WooCommerce reviews using WP All Export.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross