Best WooCommerce Product CSV Import Suite

Importing and exporting products in a WooCommerce store is often essential for creating backups or migrating data. A dedicated product import plugin is the easiest way to handle this. This article highlights the features and capabilities of the WebToffee Product Import Export plugin for WooCommerce.

Managing a WooCommerce store involves importing and exporting products, especially as your business grows. Whether you’re refreshing product catalogs, transferring data between sites, or creating backups of product details, these activities help keep your WooCommerce store running efficiently and up-to-date.

Importing products is especially beneficial when adding items in bulk, adjusting prices, or overseeing stock levels in a large inventory. Conversely, exporting product data is vital for creating backups, sharing information with third-party platforms, or moving products between stores or platforms.

Tools like the Product Import Export plugin from WebToffee make importing and exporting products easier. Given that reviews are essential for any WooCommerce store, this plugin also allows you to transfer both products and their reviews smoothly, enhancing product management efficiency.

This article will help you learn more about the plugin and how it works.

📌

Key Takeaways:

  • Importing and exporting products is crucial for maintaining a WooCommerce store and helps update catalogs, transfer data, and create backups.
  • When migrating products between WooCommerce stores, it’s crucial to migrate the associated reviews, as they are essential for online customers and influence their purchasing decisions.
  • The Product Import Export plugin from WebToffee simplifies the process by allowing you to transfer both products and reviews, streamlining overall product management.

WebToffee Product CSV Import Suite Plugin for WooCommerce

The WooCommerce Product Import Export plugin allows a WooCommerce store owner to import, export, and update products. Using the plugin, you can import products from a CSV file into a WooCommerce store and export the products of a WooCommerce store to a CSV file.

The plugin is designed to make product management easier by automating the import-export process, saving you time and reducing errors. Whether you operate a small or large WooCommerce store, this tool ensures seamless data handling and enhances your store’s overall efficiency.

This plugin does more than just import and export basic product data. It manages everything from product images, reviews, categories, tags, and other product attributes. Store owners can import or export hundreds or even thousands of products at once, including essential product images and reviews that build customer trust and engagement.

💡

Did You Know? WebToffee’s WooCommerce Product Import Export plugin boasts an incredible 4.8/5 rating on wordpress, powering over 90,000 active customers. Source: WordPress.com

Smooth and Easy Product Migrations

Easily import and export products, reviews, and more.

Get Plugin Now

How the WooCommerce Product CSV Import Suite Make it Easy to Import Products?

Product Import Export Plugin for WooCommerce is the best import suite for importing products into a WooCommerce store. The plugin is fully packed with features and gives you much control over which products are imported and how the products are imported.

The Product Import Export Plugin for WooCommerce takes input from a CSV file. The importing CSV file should be UTF-8 encoded. You can create a CSV file using any spreadsheet program.

📖

Quick Note – The importing CSV file should be UTF-8 encoded. Read the documentation – How to Save CSV and Excel Files as UTF-8 Encoded?

After you have prepared the file, importing the products from the file is a piece of cake. You can choose to upload a file from your computer that contains all the products that need to be imported.

For a smooth import, you only need to ensure that the headers of the columns in the CSV file are correctly mapped to the proper WooCommerce product data fields.

The plugin can also automatically match your CSV data fields to WooCommerce fields, reducing the time spent on manual adjustments. This feature helps avoid common issues, like mismatched or incomplete product data, leading to a more seamless import-export process.

After a successful import, all the products in the CSV file are added to the WooCommerce store.

  • Import CSV from different locations – Whether your CSV/XML file is located in a remote FTP server or needs to be uploaded from a URL or your local computer, the plugin offers those functionalities. Choose from local, URL, Existing files, or FTP to upload the input file.
Screenshot showing the selection of different import locations
  • Choose CSV, XML, TSV, or Excel for import – You can import products into your store using CSV, XML, TSV, or Excel files. 
  • Import different product types – If your CSV contains different product types, including simple, variable, grouped, subscription, external/affiliate, bundled products, etc., you can easily import them to your store and their related data. 
  • Import custom fields/metadata – If the CSV contains custom fields created by different third-party plugins, you can easily import them to your store. 
  • Import product reviews – Along with products, you can import their reviews to the WooCommerce store and associate them with the correct products. You can import the reviews with verified user tags, ratings, author names, dates, etc. You can also edit the contents of the reviews if you wish to.
  • Automated import of products – Using this plugin, you can set up a scheduled import of the products from a remote server, also known as Cron Job. You can also export the products to a location on the remote server at regular intervals using Cron Job.
  • Update existing products – You can easily update products with any available spreadsheet program or use the evaluation fields section within the plugin. 
  • WPML Support – The plugin supports French, German, Danish, and Arabic right out of the box.
  • Plugin compatibility – The plugin is tested and verified to be compatible with plugins that are popular and most commonly used by WooCommerce stores.

View the complete list of compatible plugins

How to Export Products using WooCommerce Product Import Export Plugin 

Product Import Export Plugin for WooCommerce also helps you to export the products and reviews into a CSV/XML file. The plugin allows you to keep a record of all your products and their related data by exporting them into a CSV file.

To export the products, you only need to configure the plugin’s settings according to your needs and then export. It will download the CSV file to your computer, or you can export the files on a regular basis to the remote server using Cron Job.

This allows you to easily create backups, share product information with third-party platforms, or move products between different WooCommerce stores.

  • Export all the product types – You can easily export products belonging to all the different product types (simple, variable, grouped, external/affiliate, subscription, bundled, etc) in your WooCommerce store to a CSV/XML file.
  • Export products of your choice – You can export products selectively based on certain criteria. For example, you can export products that belong to a certain category, you can export products that belong to a certain product type, or you can have a partial export of products.

Update Products using Product Import Export Plugin for WooCommerce

Besides its import and export features, the WooCommerce Product Import Export plugin makes it simple to update product details like prices, stock levels, and descriptions throughout your entire store. This is crucial for keeping your product catalog accurate and current.

This functionality can significantly benefit store owners, particularly those handling extensive inventories or regularly updating product information, which helps:

  • Automates updates, reducing manual work.
  • Refresh hundreds or thousands of products simultaneously.
  • Improves efficiency and maintains catalog consistency.
  • Enhances the customer experience, leading to increased sales.

How the Product Import Export Plugin for WooCommerce Simplifies Product Management?

The following is a list of features that make managing your store’s products easy.

Import & export multiple product types to and from your store

You can export and import products belonging to different product types (simple, grouped, external/affiliate products) to your WooCommerce site using a CSV file. This makes product management more versatile and efficient. 

dropdown showing multiple product types for export

By accommodating these diverse product types, the plugin provides a versatile and complete solution for WooCommerce store owners, simplifying product data management across multiple categories and formats.

Export only the products you need

Instead of exporting your store’s entire list of products, the different export filters available within the plugin make it easy to export only the selected ones. This feature saves time and makes data management easier by allowing you to filter products based on specific criteria such as categories, tags, stock status, or product types.

By focusing on just the relevant products, you can avoid the hassle of exporting unnecessary data, minimize file size, and streamline your workflow. You can use these filters alone or in combination with other filters while exporting products. It will be helpful when you need to update or back up a specific list of products in your store.

Following are the filters you can find within the plugin.

  • Export by selected products

You can choose one or more categories from your store to export products belonging to that category only.

  • Export by tags 

With this filter, you can export products using selected tags. You can add one or more tags to the field and export products associated with those tags only.

  • Export by category 

Apart from tags, you can choose the specific products from your store to be exported to the CSV.

  • Exclude selected products from exporting

While the above filter allows you to export selected products, it also allows you to exclude selected products from your store from exporting.

  • Export by product status

Your store can have products with different statuses, such as published, draft, private, and pending products. With this filter, you can export products belonging to one or more statuses from your store.

filtering of products by different criteria

Update products with less effort

With the plugin, you can either update products in bulk or update only the selected items (using the above filters).

You can update products using the plugin in two ways. The first is by exporting products to any spreadsheet program like Google Sheets and updating data manually within the sheet before importing them back to your store.

The next one helps you update data during import. It is called evaluation fields. Using evaluation fields, you can update product data by adding it to the corresponding product data field during import mapping.

Import only the product data you need

A product has many associated data, such as price, stock, inventory, attributes, etc. Sometimes, you may not want all this data imported into your store. This Product Import Suite plugin allows you to import only the required data by deselecting the respective columns during import mapping. 

As a result, this selective import capability helps you streamline your data management, ensuring that only relevant information is added to your catalog without cluttering it with unnecessary details.

Import and Export of Product Reviews Using WooCommerce Product Import Export Plugin 

When customers buy products online, they mainly look for product reviews. Reviews help customers a lot before buying a product. They are very helpful for customers in deciding on whether or not to buy a product.

Since reviews are important to a WooCommerce store, they must be migrated as well when products are migrated from a store. There should be an easy way to migrate the reviews of different products from one store to another.

The Product Import Export Plugin for WooCommerce helps you import product reviews from a CSV file to a WooCommerce store and export the reviews of the products into a CSV file.

Import Product Reviews

The Product Import Export Plugin for WooCommerce imports all the product reviews in a CSV file into the store and associates them with the corresponding product. The plugin requires a UTF-8 encoded CSV file to import the product reviews into the store.

importing product reviews

You can create a CSV file in the proper format using any of your preferred spreadsheet programs. When you have your CSV file at hand, you can easily import it. You only need to map the column headers of the CSV file to match the WooCommerce data fields.

Export Product Reviews

Instead of creating a CSV file from scratch, you can export the product reviews from the WooCommerce store using the Product Import Export Plugin for WooCommerce. This plugin allows you to export the reviews of the selected product into a CSV, XML, TSV, or XLS file, which will then be downloaded to your local computer.

exporting product reviews

By simplifying review management, this feature helps store owners save valuable time that would otherwise be spent manually gathering, organizing, and formatting reviews.

Main features:

  • Export and import product reviews from CSV, XML, TSV, and XLS files.
  • Update existing product reviews.

Conclusion

I hope that by reading the above article, you have found a solution for all the product migration, backup, and update-related issues of your WooCommerce store.

Efficient store and product management leads to a better user experience and, thus, increased sales and revenue. So get started with the Product Import-Export plugin today. The plugin also has a free version available in the WordPress Plugin library that offers basic product import-export features.

If you have any questions or feedback, comment below, and we will gladly assist you.

Article by

WebToffee Team is a group of WordPress and WooCommerce enthusiasts consisting of expert developers, testing engineers, technical support engineers, and SMEs.

Got any query? Please leave a comment or reach out to our support

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