Product Import Export for WooCommerce

Description

The Product Import Export for WooCommerce plugin exports and imports WooCommerce simple, grouped, and external/affiliate products to and from CSV (variable products are only supported in the premium version). It is super simple!

Major Features

  • Export WooCommerce products into CSV.
  • Import products from CSV to WooCommerce.
  • Supported product types – simple, grouped, external/affiliate.
  • Export and import products with images.
  • Export and import product reviews along with ratings.
  • Export and import products by category/tags/selected products/status.
  • Export and import product attributes, taxonomies, price, stock, and more.
  • Bulk edit products.

Additional Features

  • Import/export in batches with custom batch count.
  • Set CSV delimiter for import.
  • Select from multiple import/export methods.
  • Export and import column mapping.
  • Easy recurring import/exports using pre-saved configurations.
  • List of all past imports and exports with option to re-run them.
  • View import log for easy debugging.
  • Tested OK with WooCommerce 5.7

Compatible Plugins

Setup Guide – Product Import Export for WooCommerce

For learning more about the set up of the Product Import Export plugin for WooCommerce, refer to its setup guide.

You can also check out this video to get a quick understanding of the plugin.

How Does the Plugin Work? (Import of WooCommerce Products using CSV)

The WooCommerce Product Import Export Plugin takes CSV (Comma-Separated Values) file as input. You must create a CSV ( UTF-8 Encoded ) file and enter the product details in a structured format.

This is to match each field of CSV file to the field of a particular product which otherwise Admin need to input manually. For example, the post_title field gets mapped to the product name and the regular_price field gets mapped to the regular price of the product.

You can create the CSV from scratch or you can export products to get the format of CSV. You can use a spreadsheet program, such as LibreOffice, Microsoft Excel, OpenOffice, or Google Spreadsheets for creating and modifying the CSV file. Save this file with extension “.CSV”.

After entering all details about products in a spreadsheet, you can import products to your WooCommerce store. With this plugin, you can also export and download product details as a CSV.

Premium Version Features

Product Import Export Plugin for WooCommerce is the leading tool for the export and import of WooCommerce products. Check out its features.

✅ Export/Import simple, group, external, custom and variation product types.
✅ Export/Import custom fields(meta) and hidden meta.
✅ Choose from XML/CSV format for import/export.
Various filter options for exporting products
Map and transform fields during import
Bulk edit/evaluate data during import
✅ WPML support for simple products.
✅ Import/Export file via FTP/SFTP.
Import from URL.
✅ Automatic scheduled import and export.
Third party plugin customization support.

Please visit Product Import Export Plugin for WooCommerce for more details.

Product Import Export Plugin for WooCommerce (Pro)

Following are some of the use-cases supported by the Product Import Export for WooCommerce premium version.

WooCommerce export products (all product types are supported)

There are multiple cases where one needs to export WooCommerce products. It could be either for sending the details to someone else or integrating with a third-party system. With the plugin, you can import all product types including custom product types such as subscription and bundled products.

WooCommerce import products (all product types are supported)

WooCommerce bulk product upload is one of the main use cases where WooCommerce product import functionality is used. With the plugin, you can import products from any XML or CSV into WooCommerce. This saves a lot of time and minimizes errors.

WooCommerce export and import products with images (supports simple & variation images)

The plugin facilitates the easy import of images related to a product. When the products are imported using the plugin, the first image related to a product in the image column of the CSV file is taken as its featured image. If there are multiple images in the same column, the image(s) after the first one is taken as the gallery images of the product.

Related plugins from WebToffee

Other useful plugins from WebToffee for migrating WooCommerce/WordPress data:

🔸 Import Export WordPress Users/Customers: Import and export the users in WordPress and customers in your WooCommerce store using a CSV file with the help of this plugin.
🔸 Order/Coupon Import-Export for WooCommerce: Import and export orders and/or coupons from your WooCommerce store using CSV with the plugin.
🔸 WordPress Comment Import Export: Easily import and export comments from one WordPress site to another.
🔸 WordPress Backup & Migration: Quickly migrate and backup entire WordPress site or selected files from one location to another. Backup to FTP, Google drive, Amazon S3 or local storage and easily restore them back.

About webtoffee.com

WebToffee creates quality WordPress/WooCommerce plugins that are easy to use and customize. We are proud to have millions of customers actively using our plugins across the globe.

Screenshots

  • General settings for WooCommerce product import export plugin

  • Export method for WooCommerce product export plugin

  • Export mapping for for WooCommerce product export plugin

  • Filter products for WooCommerce product export plugin

  • Export batch limit for WooCommerce product export plugin

  • Save export template for WooCommerce product export plugin

  • Export complete for WooCommerce product export plugin

  • Import method for WooCommerce product import plugin

  • Import mapping for WooCommerce product import plugin

  • Import taxonomies and attribute mapping for WooCommerce product import plugin

  • Evaluation options for WooCommerce product import plugin

  • Advanced options for WooCommerce product import plugin

  • Save import template for WooCommerce product import plugin

  • Import logs for WooCommerce product import plugin

  • Import Export history for Product Import Export for WooCommerce

Installation

  1. Upload the plugin folder to the /wp-content/plugins/ directory.
  2. Activate the plugin through the Plugins menu in WordPress.
  3. That’s it! you can now configure the plugin.

FAQ

Does this plugin support export/import of images?

Yes. You can import or export product images along with other details

Which is the best free CSV editor suggested?

LibreOffice.

Does this plugin support importing taxonomy and attributes to WooCommerce?

Yes. You can import product taxonomy and attributes into WooCommerce using the plugin.

Can I export products by category using this plugin?

Yes. You can export products by category using the category filter within the plugin.

Is it possible to import grouped and external products to WooCommerce using the plugin?

Yes. You can import grouped, affiliate/external products in addition to simple products using the plugin.

Reviews

སྤྱི་ཟླ་བཅུ་པ། 20, 2021
It does what it should. Thank you for the easy plugin fro export and import.
སྤྱི་ཟླ་བཅུ་པ། 7, 2021
you are the best
Read all 245 reviews

Contributors & Developers

“Product Import Export for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

“Product Import Export for WooCommerce” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “Product Import Export for WooCommerce” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

2.0.9

  • WC 5.7 tested OK.
  • Product categories and tags export and import option added.

2.0.8

  • Fix: Product review import.

2.0.7

  • Product review import export support added.

2.0.6

  • Tested OK with WC 5.6.

2.0.5

  • Tested OK with WP 5.8.
  • Bug fix: Product attribute update issue.

2.0.4

  • Tested OK with WC 5.5.
  • Added external/affiliate and grouped product support.

2.0.3

  • Bug fix: WC 3.8 compatibility.

2.0.2

  • Tested OK with WC 5.4.

2.0.1

  • Custom taxonomy support updated.

2.0.0

  • Heads up! This version has been revamped majorly. The new version update will not automatically adopt the existing settings.
  • Please make sure you record/note the existing plugin settings and redo them in the new version after an update.
  • Improved UI for better user experience
  • Export/Import options: via a pre-saved template or a quick(standard columns) export/import
  • Option to export/import selective columns
  • Option to reorder columns during export
  • Import: Support for different types of delimiters
  • Export/Import options: Batch option with configurable batch count
  • History of all the Import/Export process
  • Dedicated logs for debugging failures

1.9.3

  • Bug fix:- Delete temp file after import

1.9.2

  • Tested OK with WC 5.2.2

1.9.1

  • Tested OK with WC 5.2.0

1.9.0

  • Tested OK with WC 5.1.0 and WP 5.7.0

1.8.9

  • Tested OK with WC 5.0.0 and WP 5.6.1

1.8.8

  • Tested OK with WC 4.9.2
  • Enhancement: product image import.

1.8.7

  • Bug Fix: Handling of ‘onbackorder’ value for ‘stock_status’.

1.8.6

  • Tested OK with WC 4.8.0 and WP 5.6
  • Enhancement: product_page_url export.

1.8.5

  • Tested OK with WC 4.7.1 and WP 5.5.3
  • New filter options added in product export.

1.8.4

  • Tested OK with WC 4.6.0

1.8.3

  • Tested OK with WC 4.4.1 and WP 5.5.1
  • Bug Fix:js error when click select all/ unselect all button in export page.

1.8.2

  • Tested OK with WC 4.3.1
  • Bug Fix: Issue with importing multiple image when images are in different folder.

1.8.1

  • Tested OK with WC 4.2.2 and WP 5.4.2

1.8.0

  • Update:- Compatible with meta ‘_purchase_note’.

1.7.9

  • Tested OK with WC 4.1.0 and WP 5.4.1

1.7.8

  • Bug Fix:- Problem with activating plugin in multisite.
  • Bug Fix:- Warning when open fails.

1.7.7

  • Tested OK with WP 5.4

1.7.6

  • Tested OK with WC 4.0.1

1.7.5

  • [Improvement] Security

1.7.4

  • Security fix.

1.7.3

  • Tested OK with WC 3.9.2

1.7.2

  • Tested OK with WP 5.3.2
  • Content Update.

1.7.1

  • Tested OK with WC 3.8.1 and WP 5.3
  • provision to export for Super Admin user.

1.7.0

  • Bug Fix: Price issue with scheduled sales imports. (@derickcpt)

1.6.9

  • Bug Fix: Postmetas not getting imported/updated
  • Tweak: Filter name changed from “woocommerce_csv_product_postmeta_defaults” to “woocommerce_wf_csv_product_postmeta_defaults”.
  • Tested OK with WP 5.2.4

1.6.8

  • Bug Fix: Duplicating SKU when updating product with ID
  • Tested OK with WC 3.7.1

1.6.7

  • Content Update.

1.6.6

  • Content Update.
  • Tested OK with WP 5.2.3

1.6.5

  • Enhancement: Added ‘tab’ and ‘space’ delimiter support for import CSV.
  • Bug Fix: Improved error handling for file upload issues.
  • Plugin update information hook added.

1.6.4

  • Tested OK with WC 3.7.0

1.6.3

  • Tested OK with WC 3.6.5

1.6.2

  • Tested OK with WC 3.6.4 and WP 5.2.2
  • Content update.
  • Bug Fix.

1.6.1

  • Tested OK with WC 3.6.3 and WP 5.2
  • Content update.

1.6.0

  • Tested OK with WC 3.6.2

1.5.9

  • Tested OK with WC 3.6.1
  • Bug Fix: SKU check.

1.5.8

  • Banner Update.
  • Content Update.

1.5.7

  • Updates: Tested OK with WC 3.5.7
  • Bug Fix:- Image import.
  • Support GlotPress(translate.wordpress.org).

1.5.6

  • Updates: Tested OK with WC 3.5.6 and WP 5.1.1
  • Bug Fix:- Updating Stock status based on stock quantity.

1.5.5

  • Updates: Tested OK with WC 3.5.5 and WP 5.1
  • Bug Fix:- Import process getting stuck randomly.

1.5.4

  • Updates: Tested OK with WC 3.5.4
  • Bug Fix:- Importing hierarchical category
  • Content Update.

1.5.3

  • Updates: Tested OK with WP 5.0.3 and WC 3.5.3
  • Bug Fix:- Image Thumbnail Regeneration error reporting.
  • Content Update.

1.5.2

  • Updates: Tested OK with WP 5.0.2 and WC 3.5.2
  • Optimized product image import.

1.5.1

  • Content update.

1.5.0

  • Tested OK with WC 3.5.1
  • Image importing process optimised
  • Bug fix.

1.4.9

  • Tested OK with WC 3.5.0
  • Compatible with new meta ‘_low_stock_amount’ which introduced in WC3.5.0

1.4.8

  • Tested OK with WC 3.4.6
  • Content Update.

1.4.7

  • Tested OK with WC 3.4.5
  • Review link added in footer.
  • Bug fix.

1.4.6

  • Tested OK with WC 3.4.4
  • Bug fix:importing date.
  • Bug fix:- JSON_HEX_APOS on ajax post.

1.4.5

  • Tested OK with WC 3.4.3
  • Image import process improved.

1.4.4

  • Sample CSVs are updated.
  • Enhancement: Improved parsing.
  • Updates: Tested OK with WP 4.9.6 and WC 3.4.2
  • Fixed warnings.

1.4.3

  • Updates: Interface updated.
  • Updates: Tested OK with WC 3.3.3

1.4.2

  • Updates: Tested OK with WP 4.9.4 and WC 3.3.1

1.4.1

  • Minor content updates

1.4.0

  • Updates: Tested OK with WP 4.9

1.3.9

  • BugFix: Invalid argument for foreach loop

1.3.8

  • BugFix: Product not importing at 100n. n=1,2…

1.3.7

  • Fixed conflict with Plus version.

1.3.6

  • Fixed some warnings.

1.3.5

  • Minor Content Change.

1.3.4

  • Updates: Added video tutorial.

1.3.3

  • BugFix: Same title product import message update.

1.3.2

  • Minor content change.

1.3.1

  • Function modified for Woocommerce 3.0 Compatibility.

1.3.0

  • Woocommerce 3.0 Compatibility.

1.2.4

  • Marketing Content Changed.

1.2.3

  • New Icon Updated.

1.2.2

  • Minor content change.

1.2.1

  • Optimization: Image URL parsing.

1.2.0

  • Enhancement: German Translation updates.

1.1.9

  • Enhancement: WPML Support updates.

1.1.8

  • Enhancement: Security improvements and bug fix.

1.1.7

  • Enhancement: Security improvements.

1.1.6

  • Enhancement: Sample CSV updated.

1.1.5

  • Bug fix: Improved parsing.

1.1.4

  • Bug fix: Removed deprecated function.

1.1.3

  • Bug fix: Empty check validation updated.

1.1.2

  • Minor content change.

1.1.1

  • Enhancement: Import products that have same title.

1.1.0

  • Italian Translation added.

1.0.9

  • Hungarian Translation added.

1.0.8

  • Minor content change.

1.0.7

  • Enhancement: Updated support forum links and contact details.

1.0.6

  • Bug Fix: fixed issue with SKU while exporting.

1.0.5

  • Feature: Added Multilingual support and French Translation.

1.0.4

  • Bug Fix: Improved Evaluation field and help message in mapping section.

1.0.3

  • Bug Fix: Sorting priority Set to ID by default while exporting.

1.0.2

  • Bug Fix: Improved parsing while importing product price with currency symbol and thousand separator.

1.0.1

  • Bug Fix: Fixed issue with Evaluation field with single quotes.
  • Bug Fix: Option to import gallery images.
  • Enhancement: Improved help text for Post name and Stock quantity.
  • Enhancement: Improved label text for Product type, category , tags and shipping class.
  • Enhancement: Included links to Documentation and sample CSV.

1.0.0

  • Import /Export WooCommerce Products.