Product Import Export Plugin For WooCommerce – Setup Guide

Exporting/Importing products from a WooCommerce store is often necessary for various reasons, such as migrating products to another store, creating backups, or making bulk edits. While WooCommerce offers a built-in import/export feature, it has certain limitations. The Product Import Export Plugin for WooCommerce by WebToffee streamlines the process and ensures a more flexible export/import experience. The plugin allows you to import/export all product types—including simple, variable, grouped, and external products—along with their associated categories and tags in a single go.

From the WordPress admin panel, navigate to the WebToffee Import Export (Pro) menu.

1. Click on Export and specify the post type as Product.
2. In Step 2, you can choose the Quick export method and click on Export to download the file.

3. Alternatively, navigate to Advanced Options/Batch Export/Scheduling to select the file format for export. In this example, we chose CSV because it clearly displays columns for better understanding. The same approach applies if you have selected the Advanced Export method.

4. Click Export to finalize the process. A CSV file will be generated and automatically downloaded to your computer. This file includes all product types—simple, variable, downloadable, grouped, and external—along with their respective tags and categories.

5. Click Export to finalize the process. A CSV file will be generated and automatically downloaded to your computer. This file includes all product types—simple, variable, downloadable, grouped, and external—along with their respective tags and categories.

Note:

The plugin doesn’t export product reviews while exporting products. Product reviews need to be exported separately.

For more detailed step-wise procedures for export, refer to How to export WooCommerce products.

We have selected CSV as the preferred input format because it is straightforward and easy to understand. WooCommerce stores can offer a diverse range of product types, and our sample CSV file includes data for simple, variable, grouped, downloadable, affiliate, bundled, and linked products. All these product types are imported seamlessly with the plugin’s default settings. Additionally, the plugin brings in associated tags, categories, and reviews, ensuring that your store’s data is comprehensive and well-organized.

1. Using the same exported file for import is preferred to ensure that the column names match the product fields. The plugin cannot automatically map the columns during import if the names differ.
2. Ensure that the product tags are separated by “|” when there are multiple tags for a product.
3. Also, Ensure that the product categories are separated “ | “if the product belongs to multiple categories
4. When the product belongs to a sub-category, check whether the parent and the child categories are Separated by “ > “.

Sample CSV : Sample CSV of Product

As a first step, you need to choose the Post type as Product.

Choose Advanced import as your Import option. This option will take you through a detailed process of filtering, column mapping, advanced options, batch importing, and Scheduling options that may be required for your import.

Step 3: Map import columns 

By default, the plugin automatically maps CSV columns if the header names match, leaving blank values when no match is found. If your CSV headers are different or you need to change the mapping, navigate to the appropriate Product field column, click on the File column, and choose the correct column name from the list displayed. We will now proceed with the default settings, as the plugin has mapped the fields correctly.

In this step, you can set filters to import products that meet certain conditions, such as matching products by their SKU or ID. We will now proceed with the default options. With the Default settings,

• The products will be imported based on their ID,
• New products in the CSV will be imported,
• If there is an ID conflict then the product will be skipped, and
• Finally, products existing in the store will also be skipped.

You can import the products directly into your store or schedule the import using FTP. In this example, we will directly import the CSV. To know more about scheduling, read the article : Cron scheduled export/import. Click on Import/Schedule to finish.