How to Export and Import WooCommerce Products Between Sites

Table of Contents

Back to Blog

Moving a WooCommerce catalog between sites involves complex database relationships. A single variable product relies on connected records across post meta, taxonomy terms, and media tables to keep variations, galleries, and custom attributes linked properly.

Default WooCommerce CSV importer frequently fails on complex variable products. An incomplete export easily decouples product variations or wipes out custom field data across your store.

In this article, we’ll show you how to export and import WooCommerce products between sites using WooCommerce product export and import plugins that package your catalog into an automated migration bundle, keeping every variation, image, and custom field intact.

Step-by-Step: Export and Import WooCommerce Products Between Sites

Migrating WooCommerce products between stores requires moving data accurately without breaking database relationships. Several plugins handle catalog data, but coordinating an export with a matching import is where most store owners run into errors.

The most reliable approach is to use the WP All Export plugin on your source site and the WP All Import plugin on your destination site:

  • WP All Export compiles your complete catalog on the source site. It packages simple products, variable child items, gallery images, taxonomies, and custom post meta into a single migration Bundle zip file containing both your data and an import template.
  • WP All Import receives that package on the destination store. Its automated setup engine reads the bundled template, maps catalog fields on upload, and reconstructs product hierarchies without manual configuration.
migrate woocommerce products

We will break the migration into two different sections: exporting products from your source store, then importing them into your destination site.

Export Products From the Source WooCommerce Site

For the export phase, the WP All Export plugin gives you complete control over catalog data. It extracts standard WooCommerce fields, third-party plugin metadata, and variable product structures into an automated migration package.

Here is the step-by-step process for exporting products from your source site.

1. Install WP All Export and the WooCommerce Add-on

WP All Export requires the WooCommerce Export Add-On to recognize store-specific data types like product variations, attributes, stock statuses, and gallery images.

Install WP All Exports Pro plugin
  1. Upload and activate the WooCommerce Export Add-On.
  2. Navigate to Plugins › Add New in your source WordPress dashboard.
  3. Upload and activate the WP All Export Pro plugin zip file.

2. Initiate a New WooCommerce Product Export

Once activated, start the export process:

  1. Navigate to All Export › New Export.
  2. Select Specific Post Type from the initial options.
  3. Choose WooCommerce Products from the dropdown menu.
select WooCommerce products as export type

The plugin scans your catalog and displays the total number of products detected on your store.

3. Filter Products for Export (Optional)

If you only need to migrate a specific subset of products, expand the Add Filtering Options panel:

  1. Select an element from the dropdown, such as Product Category, Stock Status, or Date.
  2. Choose a rule operator, such as equals or greater than.
  3. Enter your target value and click Add Rule.
specify the rule to add to your export

You can combine multiple criteria using AND and OR logic to filter products down to exact inventory groups before exporting.

4. Configure Export Fields and Select File Format

Click Customize Export File to open the drag-and-drop export interface. The right-hand panel organizes your catalog data into logical sections, including Standard, Media, Attributes, and Custom Fields.

Export Drag and Drop page

Because we are migrating products to another store, click Add All at the bottom of the column list. This ensures every product field, image link, taxonomy term, and custom meta key is included in the export file.

Add all product fields in a single click

Under the Export Type panel, you can choose between spreadsheet formats (CSV, Excel) and XML feeds. Keep the format set to CSV for standard product migrations.

change export product file type

5. Execute the Export and Download the Migration Bundle

Click Continue to review export settings, then click Confirm & Run Export. The plugin processes your catalog rows in batches to prevent server memory overloads.

When the export finishes, the download screen provides two options:

  • CSV: Downloads a standard spreadsheet file suitable for manual editing in Excel or Google Sheets.
  • Bundle: Downloads a specialized zip package containing your product data file along with a pre-configured WP All Import template.
download the product export bundle file

Click the Bundle button to download the zip file to your computer. This migration package eliminates manual column mapping on the destination store.

Import WooCommerce Products to the Destination Site

On the destination website, the WP All Import plugin processes the migration file. Its automated setup workflow reads the migration bundle and configures product relationships without requiring manual field mapping.

Here is the step-by-step process for importing products into your destination site.

1. Install WP All Import and the WooCommerce Add-on

Before importing, install the companion plugins on the destination site:

  1. Navigate to Plugins › Add New in your destination WordPress dashboard.
  2. Upload and activate the WP All Import Pro plugin zip file.
  3. Upload and activate the WooCommerce Import Add-On.
Install WP All Import plugin

2. Upload the Migration Bundle with Automatic Setup

To start the import:

  1. Navigate to All Import › New Import in your destination WordPress admin.
  2. Click the Set up automatically banner at the top of the screen to open the automated setup wizard.
setup automatically banner WP All Import
  1. Under the Upload a file tab, select the migration bundle zip file downloaded from your source site.
choose import file WP All Import
  1. The setup wizard inspects the package, detects the bundled import template, and automatically selects WooCommerce Products under the import type dropdown.
choose WooCommerce then products as import type

If you have specific instructions for how product fields should be processed, expand the optional Add Setup Instructions box to enter plain English guidance.

Click Start Automatic Setup. The plugin extracts the package, matches the catalog schema, and configures all field relationships.

3. Review Pre-Mapped Product Fields in the Template Editor

As the migration bundle includes a pre-configured template, WP All Import automatically populates all product fields and opens directly into the template editor.

You do not need to drag and drop elements manually. You can review the pre-configured sections to verify your catalog structure:

  • Title and Description: Confirm that product titles, full descriptions, and short descriptions are populated with their corresponding data tags.
  • WooCommerce Add-On Panel: Expand this section to review the General tab (regular and sale prices), the Inventory tab (SKUs, stock status, and stock quantities), and Attributes. For variable products, the Variations tab automatically retains the exact parent-child matching rules from your source site.
  • Images: Confirm that product featured images and gallery image URLs are configured to download and register directly in your destination WordPress media library.
  • Custom Fields: If your source catalog used custom post meta from plugins like ACF or SEO tools, verify that those meta keys and values appear inside the Custom Fields panel.
woocommerce add on fields mapping

Once you have verified that your catalog settings are mapped accurately, scroll down and click Continue to Import Settings.

4. Confirm the Unique Identifier and Import Settings

The next screen configures how the plugin distinguishes between individual products in your database. Because you are using a migration bundle, the Unique Identifier is assigned automatically. The plugin uses this unique key to link simple products and pair child variations to their exact parent records without creating duplicates.

This step also controls record handling rules. If you are migrating into an existing catalog, you can specify whether to update existing products, add new items, or delete records missing from the file. For a fresh store migration, leave the default settings intact, then click Continue to move to the final confirmation screen.

review unique identifier

5. Execute the Product Import

The final screen displays a complete summary of your import, including your target post type, file name, and total record count.

confirm and import screen WP All Import

Click Confirm & Run Import to start the process. WP All Import executes the import in managed batches, downloading gallery images, generating variation combinations, and updating stock tables without triggering server timeouts.

import complete wp all import

When the import finishes, navigate to Products › All Products in your WordPress dashboard. Open a few simple and variable products to confirm that prices, variation dropdowns, image galleries, and custom attributes display correctly across your store.

Final Thoughts – Export and Import WooCommerce Products

Migrating WooCommerce products with the default CSV tool often leads to broken variations, lost image attachments, and missing custom fields. Manual database imports require hours of spreadsheet adjustments to match parent-child relationships and taxonomy terms.

WP All Export and WP All Import provide the easiest way to export and import WooCommerce products by packaging complete store data into an automated migration bundle. The WP All Export plugin compiles product records, attribute hierarchies, gallery URLs, and custom meta keys alongside a pre-configured import template. On the destination site, the WP All Import plugin detects the bundle file, maps catalog fields on upload, and updates database tables without manual column selection.

This hands off your catalog straight to the template editor with all settings populated, letting you confirm pricing, variation hierarchies, and media rules in seconds. Running the import then reconstructs your products in safe background batches, ensuring every child variation, image gallery, and custom field appears on your new store exactly as it did on the source site.

Frequently Asked Questions – Export and Import WooCommerce Products

How do I export specific products from WooCommerce?

WP All Export filters products by category, stock status, date, or price using conditional rules. Expand the Add Filtering Options panel during export setup, select your criteria, and click Add Rule to export only the matching catalog items.

Can I migrate variable products between WooCommerce sites?

Yes. WP All Export and WP All Import preserve parent-child product relationships during migration. The export bundle includes all attributes, variation SKUs, and stock quantities, automatically reassembling variable products on the destination site without manual configuration.

How do I import WooCommerce products with custom fields?

WP All Export captures all post meta keys registered by plugins like Advanced Custom Fields, Meta Box, and Yoast SEO. When importing on the destination site, WP All Import detects these meta keys automatically and maps them to their corresponding custom fields.

What is a WooCommerce product migration bundle?

A migration bundle is a specialized zip file generated by WP All Export containing your product data and an import template. When uploaded to WP All Import, the plugin reads the template instructions and maps all catalog fields automatically.

Can I export and import WooCommerce orders and customers?

Yes. Both plugins support complete WooCommerce migrations, including orders, customer accounts, reviews, and coupons. You can follow the same bundle workflow by selecting WooCommerce Orders or WooCommerce Customers during export and import setup.

Editorial Staff
WPCodeBox Editorial Staff creates practical, well-researched content for WordPress professionals who want to write cleaner code, replace unnecessary plugins, and build faster with reusable snippets.

The best import export plugin for WordPress & WooCommerce.

Complete, granular control of your data with an easy to use drag & drop interface.
90 Day Money Back Guarantee
Unlimited Installs
Lifetime Licence
Fast, World-Class Support

Get WPCodeBox, the most powerful WordPress Code Snippet Manager.

Save hours when customizing WordPress sites.
WPCodeBox is a WordPress Code Snippets Manager that allows you to share your WordPress Code Snippets across your sites.