Skip to main content
Updates / How to Export and Import WooCommerce Products
← All updates
 
Blog

How to Export and Import WooCommerce Products

Are you looking to export and import WooCommerce products?

Whether you’re migrating to a new store, updating multiple products at once, or syncing with external platforms, knowing how to export and import WooCommerce products is a crucial skill for any store owner.

In this guide, I’ll walk you through how to export products to CSV, Excel, and XML feeds, then show how to import product catalogs automatically without manual column mapping. I’ll also cover advanced workflows including Google Merchant Center integration, variation management, and automated import scheduling.

How to Easily Export WooCommerce Products

export WooCommerce products using WP All Export

When you own a WooCommerce store, you will likely need to export your products at some point.

You may need to create product feeds for other sales platforms so that you can list your products in as many places as possible.

Or perhaps you’ll want to export your products, make bulk changes to them, and then import those changes back into your store to avoid many hours of manual editing through the WooCommerce interface.

Whatever your goal, it always helps to know your options.

Your Options to Export WooCommerce Products

Option #1 — Use the Default WooCommerce Export Tool

Unlike with WooCommerce orders, there is a built-in tool for exporting products, which you can access by going to Products › All Products and clicking the Export button:

WooCommerce Products Listing

This will open the following screen, which we’ve populated in advance:

WooCommerce Products Default Export Tool

As you can see, there are not a lot of options here. You can choose your columns, though you can’t control the column layout. You can filter by product type and/or product category. And you can opt to include custom metadata.

Unfortunately, you can only export data to a CSV file format.

As it outputs only flat CSV files without layout controls, this native tool operates as a basic data dump. It’s okay if you just want to export data to a spreadsheet for analysis or to move an exact copy of product data from one WooCommerce store to another, but it lacks the sophistication required for other product export tasks, especially generating a proper data feed for an external system.

Furthermore, the native product export tool lacks export scheduling, meaning recurring inventory feeds cannot be automated.

For more information on this tool, see WooCommerce Product Exporter.

Option #2 — The Product CSV Import Suite

Many WooCommerce users who find the built-in product export tool too limited are directed to the WooCommerce Product CSV Import Suite add-on:

WooCommerce Product CSV Import Suite

The biggest advantages of this add-on over the default export tool are:

  1. It does a better job of handling product variations.
  2. It automatically recognizes the fields of other official WooCommerce add-ons, such as WooCommerce Bookings, WooCommerce Subscriptions, WooCommerce Composite Products, and WooCommerce Brands.

But, to be honest, this tool is still far too limited. As you can see from the screenshot above, it has even less filtering capability than the default tool. It doesn’t allow you to truly control the output format of variable products. You can’t automatically schedule your product exports, which means every export, even those needed daily or weekly, remains a manual task. And it still forces you to use the CSV file format, which is unfortunate because many external systems require XML data feeds.

At $59 per year, this tool only handles product data, forcing you to purchase separate extensions if you ever need to export orders or customers. Managing multiple disjointed extensions with separate interfaces quickly complicates ongoing store maintenance.

For more information on this tool, see the Product Import Suite. But, frankly, there is a better option.

Option #3 — WP All Export – The Best WooCommerce Product Export Plugin

WP All Export is the best WooCommerce product export plugin because it exports products, variations, and custom fields to CSV, Excel, or XML through a single drag-and-drop interface.

The core product gives you the ability to:

  • choose exactly the columns and column layout that you need.
  • build any filter, no matter how complex.
  • export to CSV, Excel, or XML.
  • manipulate your export data on the fly, including the use of PHP formulas and conditional logic.
  • schedule your exports.
  • integrate your exports with 1000s of external applications using Zapier.
  • generate exports in multiple languages.

To address issues specific to WooCommerce products, there is also a product export add-on:

WP All Export WooCommerce Products

Among other things, this add-on allows you to:

  • control every aspect of product variation data, including exact layouts, which can be extremely important for integrating with external systems
  • build custom XML product feeds — another must for external integrations
  • generate a product feed for the Google Merchant Center using easy-to-follow templates

Perhaps the biggest selling point of this combined solution is that it will handle all your export needs using the same interface and the same basic process — no need to ever acquire or learn other tools. This will save you not only money but also a great deal of time.

To see this plugin in action, let’s do a basic walkthrough.

Step-by-Step: Export WooCommerce Products

Step 1: Download and Install the WP All Export Plugin

Download and install the base WP All Export plugin and its WooCommerce Export Product add-on. Alternatively, you can use this free online sandbox. Just choose the WooCommerce Store option and click Create Sandbox.

Step 2: Create a New WooCommerce Order Export

Go to All Export › New Export, select Specific Post Type, and choose WooCommerce Products from the dropdown. Then click the Customize Export File button:

Create WooCommerce Product Export

Step 3: Choose Your WooCommerce Product Export Fields

When exporting WooCommerce products, most users need only a subset of the available fields. WP All Export simplifies this requirement with a simple Drag & Drop interface.

The available product tables and fields are displayed in the Available Data section on the right. To export a field, drag and drop it into the column selection area on the left:

Customize WooCommerce Product Export

To remove a field, simply drag and drop it outside the column selection area.

To change the column layout, just drag the selected columns into the order that you want them. You can also click any mapped column header to rename it to match external feed requirements.

You can select fields from all of these categories:

  • WooCommerce Standard Data
  • WooCommerce Product Data
  • Media
  • Taxonomies
  • WooCommerce Custom Fields
  • All other WooCommerce product fields

Finally, you can change the export type to Excel (.xls or .xlsx) or XML in the Export Type section of this screen.

Step 4: Download the WooCommerce Product Export File

Once you’ve completed setting up your product export, click Continue, then verify the export settings. To run the export, click Confirm & Run Export. You can then click either the CSV or Bundle button in the Click to Download section. Note, that if you change the export type to Excel or XML, the label for the CSV button will change accordingly.

Confirm and Run Product Export

The bundle file contains both your exported product data and an import template that allows WP All Import to migrate your catalog to a new site with zero manual mapping. This is extremely helpful if you’re trying to copy WooCommerce products from one site to another.

And that’s it. That’s how you perform a basic WooCommerce product export!

Advanced WooCommerce Products Export

Some of the instructions in this section require the Pro version of the plugin, which you can read about at Export WooCommerce Products. In case you do not have this version, you can use either the free online sandbox or just follow the visuals below.

Export WooCommerce Products to a Different File Type

The preceding example exported products to a CSV file, but you can quickly change this to Excel simply by changing the export type in the Drag & Drop interface:

Export WooCommerce Products to Excel

Prefer XML?

Export WooCommerce Products XML

Note, that you can export WooCommerce products to a Simple XML Feed or a Custom XML Feed. With a Custom XML Feed, you can construct nested parent-child nodes and use XPath tags to meet any complex merchant feed schema.

Apply Powerful Filters to Your WooCommerce Product Export

Applying filters to your WooCommerce product export is easy. You can do this in the Add Filtering Options section of the New Export screen:

Export WooCommerce Products Simple Filter
  1. Expand the Add Filtering Options section.
  2. Select the Element that you want to use in the filter.
  3. Select the Rule.
  4. Enter the filter Value.
  5. Click the Add Rule button.

In this example, our filter is equivalent to saying, “Export WooCommerce products with a product category of ‘classic’.”

You can also combine filters. In this next screenshot, we’ve added the condition that the Stock Status field must equal “instock”:

Export WooCommerce Products Combination Filter

You can even write your WooCommerce product export filters using PHP:

function exclude_drafts_from_gmc_export($articles, $options, $export_id) {

    // Only filter GMC exports.

    if ($options[“xml_template_type”] == “XmlGoogleMerchants”) {

        // Process every exported product.

        foreach ($articles as $key => $article) {

            // If IDs aren’t set to be exported, do nothing.

            if ( ! empty($article[‘id’]) ) {

                $post_id = $article[‘id’];

                $parent_id = wp_get_post_parent_id($post_id);

                // Check the parent’s Status.

                if ( get_post_status($parent_id) == “draft” ) {

                    // Don’t export variation if parent is ‘draft’.

                    unset($articles[$key]);

                }

            }

        }

    }

    return $articles;

}

add_filter(‘wp_all_export_csv_rows’, ‘exclude_drafts_from_gmc_export’, 10, 3);

Export Your WooCommerce Products to the Google Merchant Center

To export WooCommerce products to the Google Merchant Center, just change your product export type to Google Merchant Center Product Feed, as shown below:

WooCommerce Product Export Google Merchant Center

The plugin will respond by presenting the Google Merchant Center options divided into various sections:

Google Merchant Center Product Export Options

You can modify the settings for each of these sections. For example, here are the typical settings for the Basic Product Information panel.

Basic Product Information

And here’s a typical setup for the Availability & Price panel:

Availability and Price

For complete instructions on exporting WooCommerce products to the Google Merchant Center, please see the dedicated documentation article, How to Export WooCommerce Products to the Google Merchant Center from WP All Export.

In addition to guiding you through this special export process, WP All Export will create an export file that is automatically set up for submission to the Google Merchant Center. And what happens if submission requirements change? No problem. WP All Export will change right along with them.

This plugin also allows you to:

  • Use WP_Query to create queries that can’t be created any other way, at least not efficiently
  • Use WPML to export your products in different languages
  • Bulk edit your Woocommerce product data
  • Automatically schedule your WooComerce product exports
  • Split large product exports into different batches and files
  • Integrate with Zapier to send WooCommerce product exports to 1,000s of external apps

How to Import WooCommerce Products

WP All Import plugin to import WooCommerce product data

If your WooCommerce store has external suppliers, you will probably want to import their products, and not just once. You’ll likely need to import product data on a regular basis to keep your store in sync with the latest supplier updates. The alternative is to spend an enormous amount of time creating and updating your product information by hand.

Your Options to Import WooCommerce Products

You have the same basic options for importing WooCommerce products as you do for exporting them:

Default WooCommerce Import Tool

The argument in favor of WooCommerce’s built-in tool to import products is a little stronger than its export counterpart in that you can selectively import specific data elements and also map those data elements to specific WooCommerce product fields.

In theory, then, you can use the default tool to successfully import products from a supplier file, and even use the data from subsequent files to update existing product information. However, the built-in importer cannot filter records, cannot alter incoming values on the fly, and fails when supplier spreadsheets use non-standard column headers. And if you’re receiving product files from multiple suppliers, what are the odds that they’re all going to just magically line up with your existing product data requirements? Very low.

Product CSV Import Suite

The advantages of WooCommerce’s Product CSV Import Suite over the default import tool are roughly the same as for exports. It still does a better job of handling product variations and recognizing the custom fields of some key WooCommerce add-ons. But its field mapping capability merely equals that of the default import tool, without any ability to manipulate incoming data on the fly. It also lacks any kind of filter.

Furthermore, importing variable products requires two independent CSV files and two separate import runs: one file for parent products, and a second file for child variations.

So, again, you’re left hoping for a perfect match in terms of data requirements.

WP All Import – Best WooCommerce Product Import Plugin

WP All Import is the best WooCommerce product import plugin because Automatic Setup maps catalog data automatically without enforcing rigid column headers.

Instead of requiring manual column matching, WP All Import’s Automatic Setup inspects incoming CSV, XML, Excel, or Google Sheets files, detects product types, and sets up your field mappings on upload.

The fields of all third-party themes and plugins are automatically detected and immediately accessible.

You can import categories, tags, and anything else stored in either WordPress or WooCommerce.

You can import images regardless of where they are stored (your server, another server, FTP, etc.).

You can import from multiple file types up to 256 MB, including CSV, Excel, XML, and shareable Google Sheets URLs.

You can import data to multilingual sites.

Finally, you can set up your imports just once and then schedule them to run automatically from that point on.

To address issues specific to WooCommerce products, there is also a product import add-on:

Product Import for WooCommerce Add-On

This add-on provides the most in-depth support for importing variable products. In short, you can import variable products regardless of how their data is organized in the import file.

You can also import External/Affiliate products and Grouped products.

You can import products from a URL, which is ideal if you’re trying to sync your store with supplier updates that are hosted elsewhere.

Finally, you get the same consistent interface and process regardless of whether you’re importing WooCommerce products or WordPress posts, pages, taxonomies, etc.

Step-by-Step: Import WooCommerce Products — The Basics

Step 1: Download and Install the WP All Import Plugin

Download and install the base WP All Import plugin and its WooCommerce Import Product add-on. Alternatively, you can use the same free online sandbox that we used for the product export walkthrough. Just choose the WooCommerce Store option and click Create Sandbox.

Step 2: Start a New WooCommerce Product Import

From your WordPress dashboard, navigate to All Import › New Import and click the Set up automatically banner at the top of the screen.

WP All Import automatic setup banner

The Automatic Setup modal provides four import sources:

  • Upload File: Drag and drop CSV, XML, Excel, or ZIP archives up to 256 MB.
  • Download from URL: Pull a live file feed from an external URL or Google Sheets link.
  • Existing File: Choose from previously uploaded files on your server.
  • FTP/SFTP: Connect directly to a remote supplier storage server.

After uploading your file, select WooCommerce Products, and click Start Automatic Setup.

Step 3: Review the WooCommerce Products Import File

WP All Import inspects your catalog columns and displays a progress screen tracking product type detection, matching analysis, and variation attribute mapping.

When analysis finishes, a summary card displays the import type, status, total records, number of fields mapped, and an overall confidence score.

You can scroll down the Field Mappings section to confirm that core product fields, pricing, inventory SKUs, and attributes mapped accurately. If everything looks good, you can proceed directly to running your import without manual template configuration.

Step 4: Review WooCommerce Products Mapped Data

If your file requires custom adjustments, click Review Import Configuration to open the pre-filled template editor. In its basic use, you simply drag the incoming data elements from the panel on the right to the appropriate target fields on the left:

The template editor comes pre-populated with data tags assigned by Automatic Setup across all panels, including Title & Description, WooCommerce Add-On, Images, and Custom Fields.

Each section can contain a significant number of target fields and options related to those fields. For example, here’s a look at just part of the General panel of the WooCommerce Add-On section:

Product Import WooCommerce Add-On Section

And here’s a look at part of the Inventory panel:

Product Import WooCommerce Inventory Section

Notice all the little settings related to product prices, stock status, and backorders in these two panels (outlined in red)?

WP All Import provides scores of these settings, allowing you to specify exactly how you want product information to be imported.

In most cases, you won’t have to use these settings. The defaults should suffice. But compare the sophistication of these interfaces to WooCommerce’s default import tool or the Product CSV Import Suite. They’re not even in the same universe. With this plugin, you are guaranteed to be able to handle any product import, no matter how complex or challenging.

Step 5: Configure the WooCommerce Product Import Settings

The next screen in the process is the Import Settings screen.

WooCommerce Product Import Settings

The most important task on this screen is to check the unique identifier for your incoming products. You can do this manually if you wish, but the plugin actually does a great job of automatically selecting a unique identifier if you click the Auto-detect button near the top.

Why is this important? Because the unique identifier is used to distinguish between products. It’s what helps it identify duplicate products. And if you run this import again (i.e., as an update), it is the basis for matching incoming data to existing products already in your database.

The other settings in the top panel of this screen (those introduced by, For each record in this import file, every time the import is run…) tell the plugin how to handle data during re-runs of this import, i.e., whether to update existing products with new information, remove or modify products that are no longer present in the file, etc.

This screen also contains two other panels in its lower half. The Scheduling Options panel is where you can set up a schedule to automatically run your product import on a recurring basis, which is great for synching product data with supplier updates. The Configure Advanced Settings panel lets you do things like break your import into batches and implement other speed optimization features.

When you’re finished with this screen, click Continue.

Step 6: Run the WooCommerce Product Import

The next screen in the process is the Confirm & Run screen:

WooCommerce Product Import Confirm and Run

The Import Summary section of this interface gives you one last chance to review what will happen before you proceed. This is especially important with import processes, as you will be altering your WordPress and/or WooCommerce data. If you spot something wrong at this point, there is an or go back to Step 4 link (not shown) immediately below the Confirm & Run Import button.

For now, click that button to proceed. When the import is complete, you should see a confirmation screen like this:

WooCommerce Product Import Complete

Step 7: Verify the Imported Products

There is a saying in war: no battle plan survives contact with the enemy.

The same is true when exporting or importing data, where the enemy is known as Mr. Murphy.

To combat this phenomenon, always verify the success of your imports.

In this case, that means navigating to Products › All Products in the WordPress menu to confirm that everything is as you expect:

WooCommerce Verify Product Import

Import WooCommerce Products — Advanced Topics

Some of the instructions in this section require the Pro version of the plugins, which you can read about at Import WooCommerce Products. If you do not have this version, you can use either the free online sandbox or just follow the visuals below.

Product Import File Types and Filters

WP All Import can import many different types of files, including CSV, Excel, and XML. You don’t have to do anything special to work with different file types: just select the file in question and the plugin will automatically detect the type.

You may notice that the interface looks slightly different if you’re importing an XML file versus a CSV, but these differences are not important. The same basic import process applies regardless of the file type.

As for filters, the import filter tool is not significantly different from its export filter counterpart. The process is slightly different, but the principles are the same.

Scheduling a WooCommerce Product Import

As mentioned earlier in this article, a common requirement is the ability to schedule your WooCommmerce product imports. This is especially important for automatically synchronizing your product catalog with supplier updates.

To set up a schedule, the first requirement is that you must download your data from a URL or a file that already exists on your server:

WooCommerce Product Import Download From URL
  1. Select Download a file and choose From URL.
  2. Specify the URL.
  3. Select New Items.
  4. Choose WooCommerce Products.
  5. Click Continue to Step 2.

The reason for this requirement is that the plugin must have access to the product import file at the scheduled date/time without the need for anyone to log in or interactively upload anything.

As for the scheduling process itself, you have two options:

  1. Use cron jobs on your server to schedule the import manually.
  2. Schedule the import using WP All Import’s Automatic Scheduling service.

You can set up your scheduling in the Scheduling Options section of the Import Settings screen. In the example below, we are using Automatic Scheduling:

WooCommerce Product Import Scheduling
  1. Expand the Scheduling Options section.
  2. Select Automatic Scheduling.
  3. Choose the Every week on… option.
  4. Choose the day of the week for the import to run. In this example, we have selected Tuesday.
  5. Specify the time for the import to run.
  6. Select a time zone.
  7. To use this service, you must first subscribe to it.

And that’s it. Your product import will now run every week on Tuesday at 1:00 a.m.!

Import WooCommerce Products With Images

One of the potentially tricky aspects of importing WooCommerce products is handling images.

This is managed through the Images tab of the Drag & Drop interface.

Import WooCommerce Product Images

In this scenario, images are stored at an external URL (say, the supplier’s server), the image URLs are complete, and there is only one image per product, so all you have to do is:

  1. Select Download images hosted elsewhere.
  2. Drag and drop the incoming imageurl data element into the edit box.

WP All import will then download the images, upload them to the Media Library, and take care of all the necessary linkages.

But what if there are multiple images stored in the same data element? No problem. The plugin will use the separator defined in the …or separate them with a… option to separate them.

What if images are stored on an external server, but only the image name is included in the import file? In that case, you can use something like this: “http://example.com/folder/{image[1]}.jpg”

…where you manually type “http://example.com/folder/.jpg” and then just drag and drop the {image[1]} data element before the “.jpg” portion of your entry.

What if there are multiple image names in the incoming data element, and they all need to have an external URL prepended to the image names? Fortunately, there is a code snippet for that.

What if there are a variable number of images for each product? Again, no problem. There are multiple options to handle that scenario, too.

The point is that images can get complicated, but WP All Import can address every scenario.

For example, if you look at the top section of the preceding screen, you will see that you can also draw your images exclusively from the Media Library or from a folder on your server where you have uploaded them in advance.

In the Image Options section, you can give the plugin specific instructions on how to handle a number of different scenarios, such as searching the Media Library to avoid downloading duplicate images or setting products to Draft if an image fails to download.

WooCommerce Product Import Image Options

Below this, you can choose how to handle image metadata:

WooCommerce Product Import Image SEO Options

When you see how much there is to consider with just this one aspect of WooCommerce product imports, you quickly realize how improbable it is to meet all of your product import needs with tools that only offer one configuration panel to address everything. That’s the difference between a professional data import tool versus a pretend tool.

For more information on importing images, WP All Import has dedicated documentation articles:

Import Export WooCommerce Products — Frequently Asked Questions

Can you import any product type into WooCommerce with WP All Import?

WP All Import supports all standard WooCommerce catalog types, including simple, variable, grouped, external/affiliate, and subscription products. Automatic Setup inspects your file to detect the product type automatically on upload, while the template editor’s WooCommerce Add-On panel provides dedicated settings for virtual and downloadable goods.

How do you migrate WooCommerce products to another website?

To migrate WooCommerce products to another website, export your catalog using WP All Export’s Bundle option. The downloaded zip archive packages your raw product data alongside a pre-configured import template. On the destination store, upload this bundle into WP All Import; the plugin recognizes the template and executes the migration with zero manual field mapping.

How do you bulk edit WooCommerce products using spreadsheets?

To bulk edit WooCommerce products using spreadsheets:

  1. Navigate to All Export › New Export in WP All Export and export the products you want to edit.
  2. Open the exported CSV or Excel spreadsheet and make your edits to pricing, stock, or descriptions.
  3. Upload the edited spreadsheet to WP All Import under All Import › Manage Imports using the original import template.
  4. WP All Import matches products by their unique identifier and updates only the modified fields, leaving the rest of your catalog untouched.

Can you export custom WooCommerce product data and extension fields?

WP All Export automatically detects all custom metadata added to WooCommerce products by themes, custom plugins, and third-party extensions. This includes custom fields managed by Advanced Custom Fields (ACF), Meta Box, and JetEngine, as well as data from official extensions like WooCommerce Subscriptions and Bookings. All detected fields appear under the Available Data panel in the export editor.

Can WP All Export handle complex XML product feeds?

WP All Export can produce any custom XML export structure through its Custom XML Feed editor. Store owners and developers can write custom XML root tags, nest parent and child variation elements, and insert dynamic XPath expressions or PHP functions to match the exact schema required by external marketplaces or supplier feeds.

How do you export WooCommerce product categories?

To export WooCommerce product categories:

  1. Navigate to All Export › New Export and choose WooCommerce Products as the export type.
  2. Click Customize Export File to open the drag-and-drop export editor.
  3. Expand Available Data › Taxonomies in the right-hand panel.
  4. Drag the Product Categories field into the active export columns on the left.
  5. Click Confirm & Run Export to download your product file with hierarchical category terms intact.

How do you export WooCommerce products with images?

To export WooCommerce products with images using WP All Export:

  1. Create a new export under All Export › New Export and select WooCommerce Products.
  2. Click Customize Export File and expand Available Data › Media › Images.
  3. Drag your desired image fields—including Image URL, Image Filename, Alt Text, and Product Gallery—into the column selection area.
  4. Click Confirm & Run Export to generate a CSV, Excel, or XML file containing public image URLs and metadata for all featured and gallery images.

How do you export WooCommerce product attributes?

To export WooCommerce product attributes:

  1. Start a new export under All Export › New Export and select WooCommerce Products.
  2. Click Customize Export File and open the Available Data › Product Data › Attributes section.
  3. Drag individual attribute tags (such as Color, Size, or Material) or the all-attributes element into your export layout.
  4. Run the export to download your catalog with global attribute terms and custom product-level attributes cleanly separated.

How do you schedule WooCommerce product exports to run automatically?

You can schedule WooCommerce product exports to run automatically using either server cron jobs or WP All Export’s built-in Automatic Scheduling service. In the export settings screen, select Automatic Scheduling, choose your execution frequency (such as daily or weekly on specific days), and set the run time. WP All Export generates the updated export file in the background without requiring manual intervention.

Can you import WooCommerce products without manual field mapping?

Yes. WP All Import includes an Automatic Setup feature that inspects incoming CSV, Excel, Google Sheets, or XML files on upload. The plugin automatically detects product types, identifies variation structures, and maps incoming columns to WooCommerce product fields, displaying a summary card with a confidence score before you run the import.

Get Oxygen

Build it your way with Oxygen.

$199.50 once — unlimited sites, no renewal

Not per year, not per site, not per seat. 60 day money back guarantee.