Description
Aren’t you petrified of writing down all products one by one? Luckily for you, those days are long gone!
Product Import for WooCommerce with WooCommerce Product Excel Importer Exporter PRO THAT lets you manage your Eshop Easily – no more CSV problems!
KEY BENEFITS
Import/Update Product Import for Simple+Variable Products with Images!
Instead of uploading products individually, with this plugin you have the opportunity to upload UNLIMITED products at a single time. You can upload simple products or variables, along with product attributes and their features Image & Product Gallery. You can also Update existing products by ID, SKU or TITLE.
Product Export in Excel for WooCommerce
If you want to keep records of the products you have imported, there is no reason to worry. You can easily export Simple and Variable Products with all Supported Fields, even Images URL’s. Backup has never been easier & you also get the appropriate Format of Excel for later Updating Existing Products easily!
Data mapping from Excel Columns!
What could be easier than drag and drop of data? Rather than figuring out how to import the info on Excel columns, drag and drop what you want to upload. As simple as that!
The form is submitted through AJAX, so there is no page reloading.
Handle Unlimited Products with Ease!
Our script runs on the background with Ajax technology and is all well optimized to run forever! No more Server or PHP timeouts. You can therefore import and update as many products you want with no issues!
Supported Fields
There is great flexibility, in terms of the supported fields of WooCommerce Product Excel Importer Exporter PRO. Besides the Title, Content & Excerpt, you can also import Status, Author ID, Slug, Product Categories and Tags, Custom Taxonomies like brands, SKU and Weight, Regular and Discounted prices, Stock available, Dimensions (width, length, height) , Downloadable, Virtual, Featured Image, Product Gallery, Upsell IDS, Crossell IDS, Purchase Note, Variation Description, Product Attributes. The latter includes colors, sizes etc.
ACF Custom Fields Supported!
Is your Eshop Multilingual? We now provide support for Advanced Custom Fields and other plugin’s post meta fields.
The only prerequisite is that you have already created manually a product and pressed ‘PUBLISH’ after you installed and created fields with ACF or other Similar plugin, so that the entry of this custom field exists in the database.
WPML MULTILINGUAL support
Now you can import Product Translations easily with the power of Excel. You just need to define the Initial Title and the correct language code for the translation.
More Features
NEW- Import Variable Product with 1 excel row!
If your product variations share same data (price,image,stock etc) you can just import using attribute values comma separated and make process super fast! more info here
NEW- Choose attributes Variations
If importing Variable products you can choose which attribute will be used for your Product Variations, as simple as checking a checkbox! more info here
NEW – Update by SKU
You can now update by SKU, ID, or TITLE – updating by SKU is a new valuable feature, many times requested by business owners
Product Import WooCommerce Categories
In a similar pattern, you are able to import multiple product categories and subcategories. This allows you to complete your work a lot quicker, without missing out on important stuff such as e-shop categories.
Delete Feature
Just like you can import multiple categories & products, you can delete them as well. You can delete Products by ID or Product Title. Even if you can do it using WordPress on its own, why not take full advantage of the plugin and complete your work in one place?
Product Import with Images
Superb flexibility here also! You can import the product images locally or choose to import them from any URL. Last but not least, you are free to refer to the image name from your Excel sheet. Either way, being able to import product images to accompany the descriptions is a huge relief.
Automap excel cells while import & avoid repetition
You can automap the fields of excel to product fields to avoid repetition while import. Prerequisite for this is excel column lables to follow WordPress & WooCommerce naming Convention. You may also find example excel file.
Extra Feature
Now here is another cool feature from WooCommerce Product Excel Importer Exporter PRO. When you select any given subcategory, you instantly select parent categories for the specific product by default. This helps you out stay on track with your e-shop inventory, for sure!
Product Import Image Gallery
Do you want to create an image gallery for each product? Now you can do that! You can upload unlimited product images and identify each URL, copy and paste it to individual Excel cells for your convenience. Alternatively, multiple URLs may be separated using a comma.
Downloadable Product Feature
Last but definitely not least, this feature allows you to identify each product as downloadable or not. You may also identify its name and file URL, download limitations and even expiration dates.
Get it Now
Product Excel Importer Exporter Documentation
Handle Images
- A) Upload Images Via URL along with Product creationInsert in a column the image URL address eg. example.com/image.png
B) Upload multiple images manually to your Media Library independently from product creation
- Include the Name of an existing image in an Excel Column
- Map the column of the data to Image Field and image will be attached to product.
The 2nd approach is useful if you have the images stored locally in a folder and you have the list of image names along with product names.
Simple VS Variable Products
- Importing Products means 3 options:
1) Simple Products with NO Atrributes - 1 product (defined by unique title) per Excel row. Only one needed in the excel file.
2) Simple Products with Atrributes (eg color) NO Variations - 1 Row per product Attribute (title of product is the same) for Each Attribute. You need to click the checkbox "Create only attributes" while data mapping.
3) Variable Products with Atrributes (eg color) - 1 Row per product variation (title of product is the same) for Each Variation. You dont't click the checkbox "Create only attributes" while data mapping.
4)Variable Products with Attributes (eg color,size) comma separated from Only 1 excel row. This means the variations share the same meta data such as prices, sku, stock, dimensions, images etc .Click the checkbox "Add Variable product from 1 row with attrributes comma separated" while data mapping.
Simple Products with Attributes
- Now, you can import Simple Products with multiple attributes, comma separated. This mean you need only one row for each product, one cell for each attribute, with the values comma separated. Prerequisite for this is to tick the box Create Attributes (if Any) ONLY, Not Variations
This saves time and import products much faster.
Attribute Selection for Variation in Variable Products
- 1. Upload your Excel
2. the mapping screen will appear. If your Excel file contains columnn you will map and refers to attribute Values, a checkbox will appear for each attribute.
3. If checkbox for the specific attribute is checked, this attribute will be used in Product Variation. Add Variable Products with One Excel Row
- This may apply to cases where your variations share same data for prices, stock , image , etc and you just need to add more attribute variation combination and make procerss faster.Instead of using one row per variation in Excel, you will
1) insert Only one row , a
2) add the attribute values comma separated
3) Select the checkbox "Add Variable product from 1 row with attrributes comma separated" Installation
- 1. Upload the plugin files to the `/wp-content/plugins` directory and unzip, or install the plugin through the WordPress plugins screen directly.
2. Activate the plugin through the ‘Plugins’ screen in WordPress
3. Use the Woocommerce Importer Menu Link or Settings link on plugins page to use the plugin.
4. Insert the lisence number for the first time you use the plugin.
5. Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your products.
Version 5.2 - 28/11-2020
- bug fix on manual edit of variable products inserted with plugin for stock status - was wrongly as outofstock even if variations were in stock. fixed
Version 5.1 - 23/11-2020
- bug fix on import variable products - sku and stock was added by last variation - ommited
Version 5.0- 22/11-2020
- add alternative export method (cases with issues and memory limits) - chosen in plugin settings
Version 4.9- 22/10-2020
- bug fix on image & product gallery import
Version 4.8- 17/10-2020
- WPML post type translations support reworked
- WPML -- translation - identify initial post ID or TITLE
Version 4.7 - 09/10-2020
- WPML product translations support
Version 4.5 (7.1+ PHP VERSION) - 11-09-2020
- ADDED function to Import Variable Products from One Row (that share same data)
- ADDED shipping class,tax status,tax rate,stock status fields for import
- ADDED Checkbox to Choose which attributes will be used in Variations for Variable products
- BUG Fix import for Variable product with 1 attribute
- ADDED Checkbox to assign attribute to product even if excel cell empty but attribute label exists - this applies for not duplicate attribute values entries in variable products
- BUG Fix on Export for Variation Description
- ADDED on Export tax Class, Tax Status
Version 4.4 - 27-08-2020
- rework import process for product variations
- add menu_order for import and export
Version 4.3 - 13-08-2020
- Fix compatibility with wp 5.5 javascript for import
Version 4.2 - 30-07-2020
- Fixed bug on Update via SKU or ID
Version 4.1 - 20-07-2020
- Update by SKU,ID or TITLE
Version 4.0 - 20-07-2020
- Fields automapping feature added
Version 3.8 - 15-04-2020
- added tax class to import capability
- added option to import parent product categories / tags or not
Version 3.7 - 09-03-2020
- added functionality to import simple products with attributes comma separated - 1 row needed for each product
- fixed wpml import bug
- fixed special characters for attributes import bug
Version 3.5 - 16/09/19
Version 3.4 - 02/08/19
- changed export functionality - export directly to .xlsx
- added chechbox on export 'check all'
Version 3.3 - 30/07/19
- fix export in chrome
- check wooCommerce compatibility
Version 3.2 - 04/05/19
- Added feature to insert always new products to import functionality - even if product title is the same
- change in import UI
Version 3.1 - 02/05/19
- Bux fixes on export functionality
- php warnings eliminated when taxonomies not assigned to products
Version 3 - 13/04/19
- Bux fixes on import functionality
Version 2 - 10/02/19
- Import Product Gallery Images comma separated urls
- Import Upsell Ids, Crosell ids, purchase note, sold individually
Version 1.5 - 17/12/18
- Bux Fixes
- Change layout on settings page
Version 1.4 - 17/11/18
- WP 5.0 Compatibility check
Version 1.3 - 17/04/17
- Bux Fixes
- Change layout on settings page
Version 1.3 - 17/04/17
- Bux Fixes
- Change layout on settings page
Version 1.2 - 17/01/17
- Bux Fixes
- Export functionality added
Version 1.0 - 25/05/16
- Version 1.0 release
- Import / Update simple variable products
- Problem on Import? showing nothing
Different servers have different configurations - make sure PHP Zip Archive Library is enabled
- Problem on Export? showing nothing
Make sure to increase PHP Memory Limit or / and go to plugins settings page and choose Alternative Export Method
- How can I insert new products when I have products with the same title?
Check "Always add new Products even if title is the same / will not work for variable products" checkbox.
Bare in mind that having products with same title means that if you will need later to update the products, this will need to be done based on product ID
- How to import Simple Products with Attributes
Now, you can import Simple Products with multiple attributes, comma separated. This mean you need only one row for each product, one cell for each attribute, with the values comma separated. Prerequisite for this is to tick the box Create Attributes (if Any) ONLY, Not Variations
This saves time and import products much faster.
- How to automap excel columns with product fields?
Excel first row labels should match the product fields naming convention provided by WordPress & WooCommerce. You may find sample of excel file in plugin settings page. Then you can just click automapping checkbox in the mapping screen.
- I automapped but I prefer to do manually. How to?
You can always uncheck the automapping checkbox if you previously checked it - by default it is disabled
- Automapping maps excel columns that I do not want to map
Correct, it works this way checking on the Label Name in your excel file. You can either remove columns you do not want to map or rename those unsuded columns to naming different than WordPress - WooCommerce naming convention.
Warren –
Very nice tool helped me a lot importing the products with images!
Chris Johnson –
Very Helpful Plugin! Save me a lot of time
Thalia –
It help me a lot! and very good support. I would definitely recommend