WooCommerce Product Import Export Plugin helps you to easily export and import products in your store. This plugin lets you import/export all types of products including product variations. It is super simple!
- Export Products ( Simple, Group, External and Variations ) and Reviews into a CSV file.
- Import products ( Simple, Group, External and Variations ) and Reviews in CSV format into WooCommerce Store.
- WPML Supported. French and German ( Deutschland ) language supported out of the box.
- Scheduled Import and Export via FTP using Cron Job.
How does it work?
The WooCommerce Product Import Export Plugin takes CSV ( Comma-Separated Values ) file as input. You must create a CSV file and enter the product details in a structured format as explained in the Setting Up Product Import Export Plugin For WooCommerce
. This is to match each field of CSV file to the field of a particular product that 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 your product. For the plugin to work correctly, you must map headers of all of the column correctly and you must ensure that all of the fields you enter must be in the correct format.
You can create the CSV from scratch or you can export the product to get the format of CSV. You can use a spreadsheet program, such as Excel, 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 product to your online store. With this plugin, you can also export and download product details as a CSV file.
Export Products: Export and download product data in CSV file format. Plugins supports,
- Simple Products
- Variation Products.
- Group Products.
- External Products.
Using this plugin, you can even export certain product types other than the WooCommerce standard ones. There is also an option to add custom product types easily with a hook.
In addition, the plugin helps you export Categories, Tags, Products and other Product details into WooCommerce. You can export prices, descriptions, images etc apart from the custom fields (meta), taxonomies and attributes.
Import Products: You can use the import functionality to:
- Import by selecting file from your computer
- Import by providing file path on the server
- Import from file in a remote server via FTP
Export Variable Products: Once you export variable product, you will have a simple single CSV which will have both variable and it’s parent details. It will help you to do any changes easily and enables faster import to any WooCommerce site.
Import Variable Products: Importing Variable products is made easy using this plugin. It imports all variable products and it’s properties from a single CSV file. This single CSV file will have both variable and parent data.
Export Products by Category: You can even choose desired product categories from the Plugin Settings Page and those Products belongs to selected categories will be exported.
Export Products by Type: You can selectively export products belonging to specific product types. All you need to do is choose the required product types from the plugin settings page while exporting.
Merge Products: This feature is useful for adding more information to existing products, for example when your existing products get modified. To get the modified product details into your online store, you can update the current product by importing modified product CSV file.
Map and Transform: You can map the fields ( WooCommerce fields ) with column headings ( CSV file header ). To map, select the required field under “Map to Column” by using drop-down list for a particular column heading. An Evaluation field is used to fix/update the required value for the particular field.
Cron Job / Scheduled Import Export: WooCommerce Product Import and Export plugin facilitates to schedule the Import and Export of the products. You can auto import the products at regular intervals from CSV which is present on FTP Server by providing starting time and intervals between import. There is an option to skip new products in scheduled import too. You can also auto export the products to FTP in a CSV file at regular intervals. There is also option to use saved mapping files for auto export.
- Supports WooCommerce Product Bundles Plugin.
- Supports Yoast WooCommerce SEO Plugin.
- Supports WooCommerce Google Product Feed Plugin.
- Supports Scheduled Cron Job.
WooCommerce Product Reviews Export Import
The plugin helps you export your product review and also import it back.
WooCommerce Product Import Export Plugin helps you to easily import reviews from one store to other through a CSV file. During import, you can edit the ratings, author name, date, verified tag and content of the reviews.
Product Review Features:
- Extension for Import/Export all Product Reviews.
- Import Products Reviews and Rating using CSV file.
- Change values of the import fields from admin using Evaluation Field feature.
- Bulk edit before importing by opening CSV file in Excel.
- Export Woocommerce Products Reviews and Rating.
- Filter using various parameters while Export.
- Update Existing Products reviews and rating.
- Import / Export through FTP.
- Scheduled Import and Export via FTP using Cron Job.
- Support export & import of the reviews created using WooCommerce Product Reviews Pro Plugin.
The WooCommerce Product Import Export Plugin should work automatically for popular review services. However, for other services you might need to format your CSV file to match the format of this example CSV file.
You Want To Try It For Yourself? Check out the Live Demo.
Check Live Demo
Check out our documentation on Setting Up, Trouble-shooting, FAQs & Code Snippets.
Want to Consult Us on a Unique Case or Got a Question? Contact us. We will be Quick!
Review Export – FTP / Cron
Product Page with Reviews
Last Updated: 24-November-2017
= 3.5.10 =
* [Bugfix] When product categories and type was getting selected then some products was getting duplicated
= 3.5.9 =
* [Improvement] Added option to provide delimiter in cron product import
* [Improvement] Provided the option to give filename of exported csv
* [Improvement] Category option display has been improved in both manual and cron export, now it will display the category including parent category
* [Improvement] Included option to import file in cron and bugfix in cron credentials and compatibility issue with php5.6.31.
= 3.5.5 =
* [Improvements] Option to provide path for ftp export (for product only), Option to update images details like (alt, caption, desc, title), Bugfix - product attribute(like color, size)
= 3.5.4 =
* [New Feature] Option to delete the product which are not available in CSV (For Manual Import), Provided Category filter and include hidden metadata in cron job. Added Filter "woocommerce_csv_parsed_product" passes two parameters single parsed row, CSV Single row
= 3.5.3 =
* [New Feature] Added option to give port and Test FTP button
= 3.5.2 =
* [Improvement] - Export product title in review export
= 3.5.1 =
* [Improvement] Added option to increase or decrease price,stock ... by Percentage, for example +10% or -10%
= 3.5.0 =
* [ New Feature ] Automatically update the stock status when stock status is not given explicitly in csv and manage stock is on.
= 3.4.0 =
* [New Feature] Added option to export product sku while exporting product review and Import product review using product sku or product id, BugFix : Log was not getting updated correctly for review , and review was not updating while merging.
= 3.3.7 =
* Fixed warnings and Thai Language support.
= 3.3.6 =
* Compatiblity for WC 2.2.11
= 3.3.5 =
* Made comatible with older version of WooCommerce v2.1
= 3.3.4 =
* call to member function get_permalinkon a non-object
* Product Import Export Warning
* Auto export failing for some columns fixed
= 3.3.3 =
* fixed the conflict with Basic version
= 3.3.2 =
* Bug fixed in review import page (via ftp)
= 3.3.1 =
* Option to skip new products in scheduled import
= 3.3.0 =
* Save export mapping - Auto export saved mapping
= 3.2.6 =
* New Features:
* Export Product By Product Type.
* Custom product Type can easily added to export types with hook provided.
* Some product types other than WooCommerce standard types are included out of the box.
= 3.2.5 =
* Feature: Support for WooCommerce Simple Auction Product.
= 3.2.4 =
* Filter for additional data on product import.
= 3.2.3 =
* Select all / Unselect all options for columns while export.
= 3.2.2 =
* Video tutorial on plugin activation.
* Transient cache clearing updates.
= 3.2.1 =
* Total_sales issue fixed.
= 3.2.0 =
* WC RC Compatibility added.
= 3.1.5 =
* Feature:Option to skip new products on import.
= 3.1.4 =
* Added Filter for modifying CSV row and data before export and import.
= 3.1.3 =
* Bug fix for FTP settings.
= 3.1.2 =
* Bug fix for filters.
= 3.1.1 =
* Review with Reply Option Implemented.
= 3.1.0 =
* Added a new Post Password Column into the CSV File.
= 3.0.1 =
* Bug Fix for Scheduled Export.
= 3.0.0 =
* Merged Product and Review Import Export plugins.
= 2.3.4 =
* Bug Fix: CSV parsing backward Compatibility to below PHP 5.3.
= 2.3.1 =
* Bug Fix: Removed redundancy of every 100th product in export.
= 2.3.0 =
* Fixed a security issue.
* Updated Licence Code.
= 2.2.7 =
* WPML Support.
* Licensing Support Integrated.
* Minor Content Change.
= 2.2.1 =
* Product Categories Filter Introduced in Export.
= 2.1.9 =
* German ( Deutsch) language support added.
* Array empty warning fixes
= 2.1.7 =
* New Feature to export Product(s) from WooCommerce Product Listing Page.
* Products with same title are allowed to import.
* Parse CSV column data escape quotes.
= 2.1.3 =
* Fixed a compatibility issue with older version of WooCommerce.
= 2.1.2 =
* New feature Cron Job - Initial version.
= 2.1.1 =
* Product Bundle Plugin Support Added.
* Multi lingual option and French translation.
= 2.0.8 =
* Bug Fix: Fixed issues with variation attributes while importing.
= 2.0.7 =
* Bug Fix: Improved parsing of Taxonomies.
= 2.0.6 =
* Feature: Introduced Cron Job( WordPress Scheduled Task) to schedule Export Products into an FTP location in a specific time interval automatically.
= 2.0.5 =
* Feature: Introduced a provision to save multiple mapping profiles.
* Bug Fix: Improved Evaluation field.
= 2.0.4 =
* Enhancement: Provided options for Sort and Delimiter while exporting products.
= 2.0.3 =
* Bug Fix: Improved parsing while importing product price with currency symbol and thousand separator.
= 2.0.2 =
* Bug Fix: Fixed issue while importing grouped product.
= 2.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.
= 2.0.0 =
* Improved UI and UX.
* Mapping Option while Export.
= 1.1.0 =
* Updated Export fields including product url link for simple product and variants csv.
* Updated transform and map feature.
= 1.0.0 =
* Initial version.
Only logged in customers who have purchased this product may leave a review.