The 5 Best WooCommerce Product Import Plugins

Adding products is one of the first steps when setting up a WooCommerce store.

It is a good idea for store owners to learn how to do this manually, if for no other reason than to become familiar with all the WooCommerce product options and features. But, eventually, you're going to want to automate the process, especially if you start receiving product lists and updates from your suppliers.

When you first start out, you can take an initial step toward automation by using WooCommerce's built-in import tool, which you can access on the Products page.

This will allow you to select an import file, as well as choose whether to update existing products or only import new ones. It will also let you map the incoming data elements to target fields, which you can see here.

But as you'll soon discover, this tool is far too limited for real-world scenarios. For example:

• There is no filtering ability, so if your store only sells a subset of a supplier's product list, you'll have to either modify the input file before you import it or delete unwanted products afterward.
• The data mapping feature assumes that supplier data elements will line up with WooCommerce product fields on a one-to-one basis, which doesn't always happen.
• It also assumes that the content contained in supplier data elements is formatted correctly for WooCommerce product fields, which is another frequent source of error.
• The import process uses an all or nothing update approach, which lacks the nuance you'll need when, say, you just want to update price and stock levels because you previously customized descriptions and don't want to overwrite them.

We could add another half-dozen bullet points to this list of shortcomings, but you get the idea. To maintain product info in a real-world WooCommerce store, you're going to need more advanced product import features. To get those, you'll need a product import plugin.

In this article, we'll share the five best WooCommerce product import plugins on the market.

5 Best WooCommerce Product Import Plugins

For each plugin, we'll explore in-depth details and key features, comparing their strengths and capabilities. This comprehensive overview will help you make an informed decision for your WooCommerce store.

Here’s a quick comparison table of the five plugins we will discuss in this article.

Feature	WP All Import	Product Import Export	Woo Import Export	Product Importer Deluxe	Product CSV Import Suite
Starting Price	$99	$69	$229	$79	$79
Free Version Available	✔	✔	✖	✖	✖
Supported File Formats	CSV, XML, XLS, XLSX, Google Sheets, JSON	CSV, XML, XLS	CSV, XML, Excel, JSON	CSV, TXT, TSV	CSV
Scheduled Import	✔	✔	✔	✖	✖
Variable Products Support	✔	✔	✔	✔	✔
Data Modification	✔	✖	✖	✖	✖
Custom Field Mapping	✔	ACF & Meta Box not supported	✔	✔	ACF & Meta Box not supported
Image Import	✔	✔	✔	✔	✔
Data Filtering	✔	Basic	✔	✖	✖
Partial Updates	✔	✔	✔	✔	✖

1. WP All Import

WP All Import is unquestionably the best product import plugin in the WooCommerce and WordPress landscape. It comes with a drag-and-drop mapping interface that makes the product import process easier, even for those who are new to WooCommerce.

It divides the whole process into five easy steps and allows you to import thousands of WooCommerce products in just a few minutes.

Simply upload your import file, review and filter the data, map the incoming elements to WooCommerce fields, configure your preferred import settings, and run the import!

Its core features allow you to:

• Import product data from a wide variety of file formats, including CSV, XML, Google Sheets, and Excel; you can also download data via a URL or FTP/SFTP.
• Filter incoming product data in whatever manner is necessary.
• Modify incoming product data on the fly, including combining or splitting field values, changing their formats, and generally customizing them as needed.
• Use incoming data to update any product fields that you want, from all fields down to individual fields; for example, you can update just price or stock levels while leaving the other fields alone. You can also import only new products or delete existing products if they are not present in the import file.
• Import image information regardless of how that information is formatted or where the images are stored.
• Import or update variable products regardless of how the incoming product variations are handled.
• Automatically schedule your product imports.

In addition to all this, WP All Import will automatically detect and handle the fields of most 3rd-party themes and plugins, as well as most custom fields added in other ways. You can also import data to multilingual sites.

Another advantage of this plugin is that you can use it to import every other type of WooCommerce data (orders, customers, subscriptions, etc.) and WordPress data (users, categories, tags, etc.) using the same convenient drag-and-drop interface.

This means that you can buy one import plugin and you'll never have to buy another, regardless of what you're trying to import.

Finally, if you pair this plugin with its sister plugin, WP All Export, you can perform product bulk edits and migrations with no configuration required for the import part of the process.

WP All Import Pricing

WP All Import is available to download as a free plugin from WordPress.org with limited features. To access advanced features, you can get the pro version, which starts at $99/year for unlimited installations.

2. Product Import Export for WooCommerce

Product Import Export for WooCommerce lets you import products from an XML or CSV file, as well as download them via a URL or FTP/SFTP.

Using this plugin, you can filter your imports and schedule them to run automatically. You can also choose to update existing products, skip new products found in the CSV while importing (in case you just want to perform an update), or delete existing products that are not present in the CSV, much as you can with WP All Import, though with considerably less control at the field level.

Because you can also export products with this plugin, it can be used for both product bulk edits and migrations, similar to the combination of WP All Export and WP All Import.

The biggest limitation with this plugin is that you can't modify data on the fly, so if there's a disagreement between the format of an incoming data element and its target field, you'll either have to modify the import file or do some custom programming. That's not exactly convenient. The filtering feature is also basic. It only allows you to filter based on the product status.

This plugin is also not compatible with leading plugins like Advanced Custom Fields (ACF), Gravity Forms, Toolset Types, etc., so if you've used those plugins to modify your site, you won't be able to import data into their fields.

Another major flaw is that while Product Import Export for WooCommerce can be paired with other Webtoffee plugins to import most WooCommerce data types, there is no combination that allows you to import/export most WordPress data types. So, if you suddenly find yourself in need of that, you'll have to add yet another plugin (or more) into the mix.

It is primarily for these limitations that we rank this plugin behind WP All Import.

Pricing

Product Import for WooCommerce has a free version that can be downloaded from WordPress.org. The pro version starts at $69/year for a single site license and includes the advanced features.

3. Woo Import Export

Similar to the previous plugin, you can import and export all WooCommerce data with the Woo Import Export plugin, and some but not all WordPress data.

It has good coverage of a range of file formats, including CSV, XML, Excel, and JSON. It provides good filter and scheduling capabilities. And it's compatible with Advanced Custom Fields (ACF) and both WPML and Polylang for language support, but not with Gravity Forms or Toolset Types.

Our biggest hesitation with this plugin is that its customer ratings are below that of both WP All Import and Webtoffee, with the most common complaints revolving around code quality (bugs) and customer service.

Pricing

There's no free version of Woo Import Export available. The Pro version with advanced features costs $229 for a single site license.

4. Product Importer Deluxe

Product Importer Deluxe allows you to add products from an Excel, CSV, TXT, or TSV file (but not XML) or to download a file via a URL or FTP.

It lets you map incoming data elements to WooCommerce product fields but lacks the ability to modify incoming data on the fly. Because of this, as with Webtoffee's plugin, you'll have to handle data mismatches either by manually modifying the import file beforehand or by custom programming a solution.

As with all the preceding plugins on this list, this plugin lets you control whether you want your import to only import new products, change existing products, or delete products that no longer apply. It also does a great job of handling product images and attributes/variations.

So what are its drawbacks?

There are three main ones:

• It lacks filtering capabilities. As mentioned in the introduction to this article, this can be highly problematic if you're trying to import a subset of a supplier's import file.
• It lacks scheduling capabilities, turning every product import into a manual task.
• Unlike the preceding three plugins, it's narrowly focused. Even if you buy its sister plug, WooCommerce — Store Explorer, you're still left with some gaping import/export holes on the WooCommerce side of the equation, let alone the WordPress side.

Together, these drawbacks have pushed this plugin into the #4 position.

Pricing

There's no free version available. The Pro version costs $79/year for a single site license.

5. WooCommerce Product CSV Import Suite

WooCommerce Product CSV Import Suite is an extension meant to compensate for some of the shortcomings of the default product import tool. It achieves this mainly by doing a better job of handling variable products and recognizing the custom fields of some popular WooCommerce add-ons.

However, this plugin still has significant limitations, including:

• You can only import products from CSV files.
• You still can't filter your import file.
• You're still limited to one-to-one mapping between the incoming data elements and product fields.
• There is no ability to modify incoming data elements on the fly.
• There is no scheduling ability, turning every product import or update into a manual process.

Also, similar to the Product Importer Deluxe, the focus of this plugin is so narrow that, should you need to import WooCommerce orders and customers, not to mention WordPress data types, you'll find yourself trying to patch together multiple plugins to cover all your import needs, each with its own interface, instructions, etc.

Pricing

WooCommerce Product CSV Import Suite is a premium only plugin and it costs $59/year.

Best WooCommerce Product Import Plugins - Wrap-Up

If you want to handle all aspects of importing WooCommerce products, as well as every other WooCommerce and WordPress data type, there is only one plugin on this list that will meet your needs: WP All Import.

Add WP All Export into the mix, and you have complete import/export coverage for all data types in the WooCommerce and WordPress landscape, all while using the exact same interface and processes.

That's our preferred model, which is why we use WP All Import/Export on this site.

After that, your choice is really a matter of compromise. If you want an import/export plugin with as much coverage of the WooCommerce data types as WP All Import/Export, you'll find yourself in a tug of war between Webtoffee's Product Import Export for WooCommerce vs Woo Import Export. Webtoffee has a better reputation for code quality and customer service, but Woo Import Export has that valuable embedded function feature that allows you to modify data on the fly. That's a bit of a coin toss.

The Product Importer Deluxe is an excellent choice if a) you're only concerned with product imports and b) you can live without filtering and scheduling. But that obviously depends on your needs.

Lastly, the Product CSV Import Suite isn't really on this list because of its strengths. It's on it because so many people opt to go from the default import tool to this suite (due to its association with WooCommerce) that we wanted to describe it for you and put it in the context of more capable tools.

We hope this information helps you.

WooCommerce Product Import - FAQs