Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
read more
Posted on July 15, 2023

The 5 Best WooCommerce Product Import Plugins

hello world!

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:

WooCommerce Product Import Plugin -  Products Import Button

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:

WooCommerce Product Import Plugin -  Default Import Products Tool

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

  • There is no filter 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 describe the five best WooCommerce product import plugins on the market.

1. WP All Import

WooCommerce Product Import Plugin - WP All Import

WP All Import is unquestionably the top import plugin in the WooCommerce and WordPress landscape.

Its core features allow you to:

  • Import product data from a wide variety of file formats, including CSV, XML, 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.

For more information, see Import WooCommerce Products from CSV, XML, or Excel.

2. Product Import Export for WooCommerce

WooCommerce Product Import Plugin - Webtoffee

This plugin lets you import products from a CSV or XML 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.

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.

To learn more, see Product Import Export for WooCommerce.

3. Woo Import Export

WooCommerce Product Import Plugin - Woo Import Export

Similar to Webtoffee, you can import and export all WooCommerce data with this 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.

For additional information, see Woo Import Export.

4. Product Importer Deluxe

WooCommerce Product Import Plugin - Product Importer Deluxe

This plugin allows you to upload a CSV, Excel, 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.

To learn more, see Product Importer Deluxe.

5. WooCommerce Product CSV Import Suite

WooCommerce Product Import  Plugin - WooCommerce Product CSV Import Suite

This is a WooCommerce 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.

WooCommerce Product Import  Plugin - WooCommerce Product CSV Import Suite Interface

However, this plugin still has significant limitations, including:

  • You can only import 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.

To additional information, see Product CSV Import Suite.

WooCommerce Product Import 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.

Related Info

The 5 Best Plugins for WooCommerce Product Import from CSV

The 5 Best Plugins for WooCommerce Product Import from XML

The 5 Best Plugins for WooCommerce Product Import from Excel

The 5 Best WordPress CSV Import Plugins To Speed Up Your Workflow in 2024

The 5 Best WooCommerce Product Export Plugins in 2024


Leave a Reply

Your email address will not be published. Required fields are marked *

Get Oxygen Today

Lifetime, unlimited site license

Copyright © 2024 Soflyy
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram