How to Migrate WooCommerce Products to a Different Website
On the source site, go to WP All Export › New Export, select WooCommerce Products from the dropdown list, then download the exported bundle file with all products. On the destination site, go to WP All Import › New Import and upload the bundle file. Follow the steps to migrate all products.
Step 1: Create Export Bundle to Migrate WooCommerce Products
Go to the export site, navigate to All Export › New Export and choose to export WooCommerce Products. You can Add Filtering Options here to control which products to migrate.
You can also customize and select which data fields to migrate. To do so, choose Customize Export File. Otherwise, click Migrate Products to continue.
On the next screen, click either of the Confirm & Run Export buttons to export all of your WooCommerce products.
After the export is complete, click the Bundle blue button to download a compressed ZIP file that contains all products along with a settings file for WP All Import.
Step 2: Understanding WooCommerce Products Migration
To migrate WooCommerce products, you need both of our core plugins, WP All Import Pro and WP All Export Pro, along with the WooCommerce Import and Export Add-Ons.
You can migrate simple, variable, grouped, and external/affiliate products. You can also migrate physical or virtual/downloadable products. By using the bundle ZIP file, all import settings are filled in when you migrate these WooCommerce products to the new site.
The migration process moves everything contained in the products such as title, description, custom fields, taxonomies, images, galleries, etc. If you don't want to migrate certain pieces of data, you can remove them from either the export template while exporting in Step 1 or in Manage Exports › Edit, or from the import template while importing in Step 3 or in Manage Imports › Edit.
When you migrate WooCommerce products, keep in mind that new product IDs are generated upon import. This is out-of-the-box behavior with our import plugin and WordPress.
That said, you can use custom code along with our API to attempt to use an old ID instead of generating a new one. See Keeping the Same Product ID When Migrating WooCommerce Products. Just keep in mind that this is only an attempt to use the old ID because if the requested ID is used, a new product ID gets generated.
Step 3: Import WooCommerce Products Bundle
On the import site, go to All Import › New Import and upload the bundle ZIP file that you exported in Step 1.
You can modify the import template (to make any changes) by clicking on Continue to Step 2.
However, in most migrations, changes are unnecessary, so click Skip to Step 4 to let the bundle file configure everything for you.
Next, the Import Settings screen appears. Here you can Configure Advanced Settings (such as changing the import name or the number of records processed per iteration), or set Scheduling Options.
To continue and finish the import, click on Continue and then click Confirm & Run Import on the following screen.
Step 4: Check Migrated WooCommerce Products
Once you finish migrating your WooCommerce Products, you can verify and review the results via Products › All Products.
If some of your products aren't migrating correctly, it could be due to either the export or the import site. Below are the best practices:
Review the export site first:
- Confirm that you followed the instructions from Step 1.
- Check the export template via Manage Exports › Edit.
- Solve whatever problems you find.
- Repeat the migration.
If the issue is not in the export site, review the import site:
- Confirm that you followed the instructions from Step 3.
- Check the import template via Manage Imports › Edit.
- Solve whatever problems you find.
- Repeat the migration.
You may need to delete the wrongly imported products. To do so, use Manage Imports › Delete.
In some cases, it works to erase everything and perform the migration again from scratch, as that can solve any outstanding issues.
However, if the steps above don't help, you can message us via our Support form, or by emailing us at [email protected]. Make sure to replicate the problem on a debug site (www.wpallimport.com/debug/) and include that site's URL along with a brief description of what's wrong.
Migrate WooCommerce Products Advanced Topics
Variable Products created as Simple Products
In some stores, there are variable products that contain only 1 variation. While those products don't have issues during the migration, the bundle file has an option enabled by default that turns any variable products without variations (or only one variation) into a simple product.
To avoid this (and ensure that variable products with only one variation get processed as a variable product), navigate to the Variations tab in the WooCommerce Add-On section and disable the option Create products with no variations as simple products.
Keeping the Same Product ID When Migrating WooCommerce Products
Out of the box, new product IDs are assigned when importing the products to the destination site.
For a working example, see Keep old IDs when migrating products or posts. Keep in mind that this is only an attempt. That is, if the requested ID is already used, it can't be used and a new product ID gets generated instead upon import.
Scheduling a WooCommerce Products Migration
With both WP All Export and WP All Import, you can set up Step 1 and Step 3 from this guide to occur regularly at a scheduled time. To schedule the whole migration, make sure to set it up so that the export finishes before the import starts. These are the available scheduling options:
- Cron jobs. See Manual Scheduling.
- Our optional and paid Automatic Scheduling Service (which can be set up directly from the plugin's interface). See Automatic Scheduling.
Make sure to set up both the export and the import process with either of the options shown above. Also, instead of uploading the Bundle file in Step 3, use the Bundle URL:
In the Download a file › From URL option:
Frequently Asked Questions
How Do I Bulk Edit WooCommerce Products?
This guide focuses on how to migrate WooCommerce products from one site to another. However, if you want to perform mass changes to products on the same site, you can use the bulk edit process instead. Here's what to do:
- Export the WooCommerce products that you want to modify.
- Open and modify the exported file in spreadsheet software such as Microsoft Excel, Numbers, or Google Sheets. That way, it's easy to perform bulk changes using copy and paste, search-and-replace, etc.
- After making the changes to the exported file, re-import it back to apply the bulk changes.
To learn more, please see How to Bulk Edit WooCommerce Products in Simple Steps.
Can I Convert Simple Products into Variable Products?
There's no official way to convert simple products into variable products. As a workaround, you can try the following (though make sure to backup your site and database before making any changes):
- Export all of the products using the Migrate Products button in WP All Export.
- Using any spreadsheet software, add a parent product for each variation set. Make sure that the parent product row is just above all of the variations that belong to it.
- Edit all of the product information to make sure they're variable products with variation attributes, then re-import the file using Import with WP All Import: https://www.wpallimport.com/documentation/bulk-edit/.
You can see examples of how the variable products should look in Example XML & CSV Files.
Export WooCommerce products into a CSV or XML file with WP All Export.
Import WooCommerce variable products from CSV, Excel, or XML files using WP All Import.
Execute custom code to modify imported WooCommerce product data on the fly.