Import/Edit/Delete products with Product Excel Importer
Use the power and simplicity of a product excel importer to import and update Simple , Affiliate(new) and variable products, create new attributes and variations, add new taxonomy terms, upload images on the go! . You can also Update existing products by ID, SKU or TITLE.
Woocommerce Product Bulk Editing
Advanced search per one screen by Regular Price, Sale Price, Taxonomy Terms, SKU or any Keyword. Ability to massively Update price, stock or taxonomy terms for multiple products at once! Inline editing for any field at the same screen for any of your Products.
High Speed Funtionality
Ajax Driven
Advanced Filtering
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!
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.
Import Variable Products with Product Excel Importer
Import Unlimited Simple and Variable Products, Update them, Add Images, Import Multiple child – parent Product Categories with this wordpress excel plugin and woocommerce excel import specific. All with a simple Excel file!
NEW – Affiliate/External Products
You can now import/export Affiliate/External Products with and to Excel – this means the _product_url and the _button_text are added and the product will be of Type External!
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
Import Product Images
Import images to attach on your Products.
You can either Import from Locally and refer to the image name in your Excel or
Import images from any URL!
Automap excel cells while import
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.
Woocommerce Export Products
Export Woocommerce Products in the right file format to Excel, edit and update if needed.
Import Product CategOries
Import category terms with excel file, multiple and in a child-parent pattern!
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! Product Image Gallery
Now you can also unlimited images in the Product Gallery, giving the Image URL in an excel cell for each product. You can also import multiple by inserting multiple urls’ comma separated!
NEW! Downloadable Product
Now you can define if product is downloadable, its name, file url, file limit to download and expiry date!
Variable Product Bulk Edit and Variations
Find all product variations, update all relevant fields, such as price, stock , width, lentgh , height.
Show All Custom Taxonomies in the List
You can choose what Products Fields to show after the Search but here All Custom Taxonomies are Added.
Product Bulk Edit Support for Taxonomies, Custom Taxonomies
Any custom taxonomy will be available on the view and you update multiple products simultaneously.
In the Product Inline Editing, similar to Product Categories, you can add multiple taxonomy terms comma separated.
Product Bulk Edit support for Any Attibutes defined
Update product attributes massively.
Product Bulk Edit support for Stock
Change stock value for multiple products with 1 click!
Bulk Delete / Inline Delete Products
Delete Completely Multiple Products at One or One by one, All in One View!
No More sent to trash! Manage your Eshop faster!
Bulk Create Product Categories (independently from product creation/edit)
Add Multiple Product Categories, comma separated along with their description, slug and even Parent Term.
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.
Import Affiliate / External Products
Now, you can import easily import External Products. This is super easy, you can just follow the sample excel file, the only basically thing you need to do is map product_url and button_text excel fields. If the product added has product URL will be auto assigned the type of External.
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 license 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.
bug fix on multiple selection of products for bulk update in bulk edit screen - javascript compatibility
Version 5.9 - 01-02-2021
fix compatibility issue with Polylang during Import
Version 5.8 - 28-01-2021
bug fix on settings page
Version 5.7 - 22-01-2021
select user role to access the plugin in settings page
Version 5.6 - 15-12-2020
bug fix on import attributes
Version 5.5 - 12-12-2020
additional export method added
Version 5.4 - 02-12-2020
IMPORT/EXPORT affiliate/external products added support
Version 5.3 - 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.2 - 23/11-2020
bug fix on import variable products - sku and stock was added by last variation - ommited
Version 5.1 - 22/11-2020
add alternative export method (cases with issues and memory limits) - chosen in plugin settings
Version 5.0 - 10-11-2020
bug fix on export simple products (ID) - number 1 was falsely appended
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.6 - 21/09-2020
EXCEL library updated
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 with excel 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 1.8 - 15-04-2020
added tax class to import capability
added option to import parent product categories / tags or not
Version 1.8 - 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 1.7 - 16/09/19
fixed export by sku bug
Version 1.6 - 02/08/19
changed export functionality - export directly to .xlsx
added chechbox on export 'check all'
Version 1.5 - 30/07/19
fix export in chrome
check wooCommerce compatibility
Version 1.4 - 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 1.3 02/05/19
bug fixes on export
bug fixes on calling custom fields for each product
version 1.2 02/01/19
bug fixes on import
added fields for import
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.