Product Import Export for WooCommerce – Import Export Product CSV Suite

Description

Easily import/export WooCommerce products (simple, grouped, external/affiliate) via CSV. Transfer product data, including images, reviews, categories, and tags. Now featuring ChatGPT API integration, the plugin auto-generates product descriptions for you.

WooCommerce Import Export Plugin for Hassle-free Transfers

Export and import your WooCommerce products (simple, grouped, external/affiliate) in a super simple way using CSV files.

Inventory updates, syncing products, data filtration, and automatic column mapping are some of the main peculiarities of this product importer plugin.

With the latest update, we have integrated ChatGPT API into our plugin. Now, the plugin will automatically generate product descriptions for products with missing descriptions. Thanks to Generative AI!

To import and export variable products, upgrade to the premium version of WooCommerce Product Import Export.

PRODUCT IMPORT EXPORT FOR WOOCOMMERCE – FREE IMPORT EXPORT PLUGIN

The free version of the Product Import Export for WooCommerce plugin imports and exports the following WooCommerce product types:

• Simple
• Grouped
• External/Affiliate products

With this plugin, you can export and import WooCommerce products to and from a CSV, and you can do basic import-export operations with this 100% free WooCommerce CSV import export plugin.

MAJOR FEATURES

• Export products from WooCommerce into CSV.
• Import products from CSV to WooCommerce.
• Bulk add products
• Supported product types – simple, grouped, external/affiliate.
• Auto-generate product descriptions during import using ChatGPT API.
• Export and import WooCommerce products with images (featured product image and gallery images).
• Export and import WooCommerce product reviews along with ratings.
• Export and import WooCommerce products based on category/tags/selected products/status/stock.
• Export specific products
• Export and import WooCommerce products with attributes, taxonomies, price, stock, and more.
• Bulk edit products, categories, price, stock, attributes
• Import, export or bulk add product categories, attributes, and tags.
• Export products based on stock status (In Stock, Out of Stock, On backorder).

ADDITIONAL FEATURES

• You can control the pace of the import/export process by doing it in custom batches.
• Let’s you set a CSV delimiter of your choice 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 with the drag-and-drop UI.
• Rename CSV column header names as you like before exporting.
• Save frequently used import/export configurations as templates and use the template for future imports and exports.
• The plugin stores all the past imports and exports and lets you re-run them when needed.
• Easy debugging: View and download import log for debugging purpose.
  ✅ Tested OK with WooCommerce 9.3.3

COMPATIBLE PLUGINS

• Yoast SEO
• Cost of Goods
• WebToffee WooCommerce Product Feed & Sync Manager

KEY USE CASES HANDLED BY PRODUCT IMPORT EXPORT PLUGIN

Following are some of the use cases supported by the Product Import Export plugin for WooCommerce.

Migrate Products (simple/external) Between Two WooCommerce Sites

Import and export your WooCommerce store products from one store to another in just a few steps. Advanced features like data filtration, automatic column mapping, and more simplify your product import and export operations.

Update Stock and Price of Existing Products

Using the advanced options, you can easily update the stock, price, and similar details of the existing products on import.

Import/Update Product Images – Featured Image and Gallery Images

Now you can import or update the product images of multiple WooCommerce products simultaneously with ease. With the plugin, you can import/update all the gallery images of a product along with the product image, also known as the featured image.

Export Products with Images

Quickly export products and their corresponding images with just a few clicks. The plugin lets you export all the product images, including featured and gallery images, making it ideal for product updates, store migration, or backups.

Import Categories and Assign Products to Them

By default, during import, the products will be imported with categories (includes both multiple and hierarchical categories).

• Sample CSV of products with categories

However, if you want to import only the product categories of a WooCommerce store, you can do so under the post type: Product Category.

• Sample CSV of product Categories

Filter Product Exports By Category, Stock status, and Other Criteria

Export WooCommerce products based on your requirements. You can filter the product data and export the products based on multiple data filtration criteria, such as category, stock, status, product type, and more.

SETUP GUIDE – PRODUCT IMPORT EXPORT FOR WOOCOMMERCE

To learn more about setting up the Product Import Export plugin for WooCommerce, refer the setup guide.

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

HOW DOES THE PLUGIN WORK? (WOOCOMMERCE CSV IMPORT)

The free version of the plugin lets you import and export: Products, Product Reviews, Product Tags, and Product Categories.

DOWNLOAD

• Sample CSV of Products
• Sample CSV of Product Reviews
• Sample CSV of Product Tags
• Sample CSV of Product Categories

The WooCommerce CSV importer plugin takes a 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 a CSV file to the field of a particular product, which otherwise the Admin needs 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 export products to get the format of the CSV. You can use a spreadsheet program, such as LibreOffice, Microsoft Excel, OpenOffice, or Google Sheets, to create and modify the CSV file. Save this file with the 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.

PRODUCT IMPORT EXPORT PLUGIN FOR WOOCOMMERCE (PRO)

The WooCommerce Product Import Export Plugin Pro for WooCommerce is the leading tool for the export and import of WooCommerce products.

PREMIUM/PAID VERSION FEATURES

✅ Export/Import simple, variable, grouped, external, subscription, and custom product types.
✅ Export/Import WooCommerce bookings.
✅ Export/Import custom fields(meta), third-party plugin fields and hidden meta.
✅ Choose from XML/CSV/Excel 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.
✅ Export product images as a separate zip file.
✅ Import from URL.
✅ Automatic scheduled import and export.
✅ Compatible with various third-party plugins.

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

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 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.
🔸 WebToffee WooCommerce Product Feed & Sync Manager: Generate WooCommerce product feed for Google, Facebook and Instagram Shops and sync WooCommerce products with Facebook catalog.

About WebToffee

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

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

Import of attributes not working using the WooCommerce export CSV?

The product import export plugin lets you import the CSV exported using WooCommerce default export tools by mapping all default fields automatically. However, due to the data format difference in the CSV, attribute fields aren’t supported at the moment. To successfully import the attributes, you can alter the attribute columns.

For more details, refer: How to import product attributes exported using WooCommerce export tool?

Does this plugin support variable products?

No, the free version of the plugin does not support variable products. To import and export variable products, get the premium version.

Does this plugin support export/import of images?

Yes, you can import and export product images along with other details. For more information, refer to: How to import WooCommerce products with images.

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. Refer to the mapping section of the import process or more details.

Can I export products by category using this plugin?

Yes, you can export products by category using the category filter option in the plugin. For more details, refer to the Filter data section of the export process.

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. Refer to:How to import and export WooCommerce products for the same.

Reviews

Excellent plugin

David Robinson November 14, 2024

A plugin that just worked perfectly from start to finish. You have to pay attention to a few settings, as you are mass updating potentially many products, but it works so well. Some people have given this 1 star because the free version doesn’t support variable products. The developers are VERY clear about this, both here on www.ads-software.com and also once you install the plugin.

Always helpful!

mattcnc November 5, 2024

Always works as expected!

Can’t export VARIABLE products

adamford November 5, 2024 1 reply

You of course have every right to charge for your plugin how you see fit, but designing a plugin that can’t export ANY variable products in the free version, and by nowhere actually stating this in your documentation is just deliberately wasting people’s time. Is there a woocommerce site anywhere on earth that doesn’t have variable products? So even if I wanted a paid plugin, I would not be buying this one because the creators engage in unethical business practices and have wasted half an hour of my unpaid time now for no reason.

abc

mavi7265 October 1, 2024

cdgftt

You should be ashamed of releasing such an incomplete free version of plugin

mareks2h October 1, 2024 3 replies

I was almost fired because of using free version of this plugin which doesn’t exported half of the products while I indicated that each product type was set to be exported. Install other product export plugins – it’s a money grab.

Work well!

fabriziocolombo September 27, 2024

Tahnk you! A+++

Contributors & Developers

Changelog

2.4.8 2024-11-07

• [Compatibility]- Tested Ok with WooCommerce 9.3.3
• [Compatibility] – Tested OK with WordPress 6.6.2

2.4.7 2024-10-22

• [Add]- Added Support for Global Unique identifier Import and Export.
• [Compatibility]- Tested Ok with WooCommerce 9.3.3
• [Compatibility] – Tested OK with WordPress 6.6.2

2.4.6 2024-08-30

• [Compatibility]-Tested Ok with WooCommerce 9.2.3
• [Compatibility] – Tested OK with WordPress 6.6.1

2.4.5 2024-07-15

• [Compatibility]-Tested Ok with WooCommerce 9.1.2
• [Compatibility] – Tested OK with WordPress 6.6

2.4.4 2024-05-09

• [Compatibility]-Tested Ok with WooCommerce 8.8.3
• [Compatibility] – Tested OK with WordPress 6.5.3

2.4.3 2024-03-26

• [Improvement] – Implemented a user interface update for the import/export screen, transitioning to a card-based layout for post type selection.
• [Compatibility]-Tested Ok with WooCommerce 8.7.0
• [Compatibility] – Tested OK with WordPress 6.5

2.4.2 2024-02-28

• [Fix] – Added Image extension restriction in product category.
• [Compatibility]-Tested Ok with WooCommerce 8.6.1

2.4.1 2024-02-08

• [Fix] – Invalid Filetype CSV.
• [Compatibility]-Tested Ok with WooCommerce 8.5.2
• [Compatibility] – Tested OK with WordPress 6.4.3

2.4.0 2024-01-17

• [Fix] – Invalid Filetype CSV.
• [Compatibility]-Tested Ok with WooCommerce 8.5

2.3.9 2023-12-28

• [Fix] – Invalid Filetype CSV in Windows OS/Firefox.

2.3.8 2023-12-19

• [Compatibility] – Tested OK with WooCommerce 8.4
• [Compatibility] – Tested OK with WordPress 6.4.2
• [Fix] – File type validation on the ‘upload_import_file’ function.

2.3.7 2023-11-21

• [Compatibility] – Tested OK with WooCommerce 8.3

2.3.6 2023-11-13

• [Compatibility] – Tested OK with WooCommerce 8.2.2
• [Compatibility] – Tested OK with WordPress 6.4.1

2.3.5 2023-10-17

• [Add] – Compatibility with WebToffee WooCommerce Product Feed & Sync Manager Plugin.
• [Compatibility] – Tested OK with WooCommerce 8.2
• [Compatibility] – Tested OK with WordPress 6.3.2

2.3.4 2023-09-19

• [Add] – ChatGPT error log.
• [Compatibility] – Tested OK with WooCommerce 8.1

2.3.3 2023-08-22

• [Fix] – Post author import not working.
• [Compatibility] – Tested OK with WooCommerce 8.0.2
• [Compatibility] – Tested OK with WordPress 6.3

2.3.2 2023-07-13

• [Fix] – ‘null’ value exported to the stock column if manage stock is disabled
• [Fix] – Variable products are converted as simple products when updating
• [Update] – Tested OK with WooCommerce 7.8.2

2.3.1 2023-06-12

• [Fix] – Importing custom CSV with a colon in the column heading.
• [Fix] – Auto delete history option does not delete import logs
• [Add] – Generate product descriptions for products without description in the importing CSV from product title using ChatGPT API
• [Add] – Support for importing images from URL without extension.
• [Update] – Tested OK with WooCommerce 7.7.2

2.3.0 2023-05-15

• Add: Support for product image import from Google Drive public image URL
• Add: HPOS compatibility
• Update: Tested OK with WooCommerce 7.7
• Fix: Disable import log generation function not working

2.2.9 2023-04-11

• Update: Tested OK with WooCommerce 7.5, WordPress 6.2 & PHP 8.2

2.2.8 2023-03-21

• Update: Tested OK with WooCommerce 7.5
• Fix: Unable to update product categories using just the term_ID without category slug

2.2.7 2023-01-01

• WooCommerce 7.2 Tested OK.
• Enhancement: Removed the default attribute column from the export CSV for simple products.

2.2.6 2022-11-24

• WooCommerce 7.1 Tested OK.
• WordPress 6.1 Tested OK.
• Enhancement: Revised import mapping screen.

2.2.5 2022-10-20

• WooCommerce 7.0 Tested OK.
• Enhancement: Set Min and Max limit for import and export default batch count in General setting page.

2.2.4 2022-08-26

• Bugfix: Product – Filter data does not work on product tags/categories for non-latin languages
• Bugfix: Category – Child category import with parent connection
• WooCommerce 6.8 Tested OK.

2.2.3 2022-08-09

• Enhancement: Product – total sales count in export/import.
• Bugfix: Delimiter reset when using the re-run option from the History section.
• WooCommerce 6.7 Tested OK.

2.2.2 2022-07-05

• Enhancement: Export to CSV option to Bulk Action drop-down menu in WC Product listing page.
• Enhancement: Import progress screen improvements.
• WooCommerce 6.6 Tested OK.

2.2.1 2022-05-26

• WordPress 6.0 Tested OK.
• WooCommerce 6.5 Tested OK.
• Enhancement: Option to choose delimiter when exporting.

2.2.0 2022-05-12

• WC 6.4 Tested OK.
• Enhancement: Bulk delete import logs.

2.1.9 2022-04-11

• WC 6.3 Tested OK.
• General settings – Option to Include BOM(Byte order mark) in export file to have better special character support.
• Fix: Category and Tag name contains & is exported to the CSV as “&amp”

2.1.8

• Enhancement: Category export and import.
• Enhancement: Performance and UI improvements, text corrections.
• Compatibility: WooCommerce Cost of Goods.

2.1.7

• Bugfix: CSV mapping issues.

2.1.6

• WP 5.9 Tested OK.
• Bug Fix: Issue with exporting SKU with + symbol.

2.1.5

• Add – Supports auto mapping of default fields from the CSV exported using default WC export tool.
• Add – Option to include Taxonomies (categories/tags/shipping-class), attributes in quick export.

2.1.4

• WC 6.1 tested OK.
• Enhancement – Export all language products if WPML is active and the language selected is all.
• Enhancement – Inform user when no products to export instead of empty CSV.
• Add – Export products based on stock status.

2.1.3

• WC 6.0 tested OK.

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.www.ads-software.com).

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

• Export and Import WooCommerce Products.