Product Import Export for WooCommerce

Descripción

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.
  • Import and export product categories [New].
  • Import and export product tags [New].

Additional Features

  • Import/export in batches with custom batch count.
  • Set CSV delimiter for import.
  • Select from multiple import/export methods.
  • Easily import products from other eCommerce platforms such as Shopify, Magento, etc., with import column mapping.
  • Organise and structure CSV columns in the export file just as you want with the drag and drop UI.
  • Rename CSV column headers as you like.
  • 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.9

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.

Capturas

  • 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

Instalación

  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

Why am I getting empty CSV while exporting?

The plugin supports simple, grouped, and affiliate/external product types only. Hence, if you export variable products with the plugin the resulting CSV will be empty.

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.

Reseñas

27 de noviembre de 2021
time saver but tricky. if you get server error just press import again and again until finish. some of my server error were because I was trying to upload 1MB images.
27 de noviembre de 2021
Works very well for import / export of simple products even in the free version, thanks for the plugin!
Leer todas las 253 reseñas

Colaboradores y desarrolladores

«Product Import Export for WooCommerce» es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Colaboradores

«Product Import Export for WooCommerce» ha sido traducido a 1 idioma local. Gracias a los traductores por sus contribuciones.

Traduce «Product Import Export for WooCommerce» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

2.1.2

  • WC 5.9 tested OK.
  • Bug Fix: Category import and Tag import – name update issue fix.

2.1.1

  • FAQ updates
  • Bug Fix: Upload timeout issue.

2.1.0

  • WC 5.8 Tested OK
  • Improvements: Added filter wt_import_csv_parser_keep_bom for escaping Cyrillic letters.
  • Fixes: Keeping previously selected options when e-running the export/import and wp_max_upload_size(), mb_detect_encoding() related issues.
  • Improvements: Product image data like alt text, desc, title etc importing.
  • Bug fix: Cannot update or delete product attribute by importing.
  • Improvements: Product tags and categories import export optimisation and fix for cyrillic letters.

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.