Woocommerce Product Excel Importer & Bulk Editing PRO

On Sale!

Tired of manually updating products ? No more waiting!

Simplify Product Import Export for WooCommerce plus Bulk Product Editing!
Manage your Wordpress E-shop faster than ever! Import product gallery images !

  • Bulk Product Import / Update /Export / Delete with Excel for Simple , Affiliate(new!)  & Variable Products
  • Bulk Product Edit for Simple, & Variable Products from settings page
  • Support Product Import – Update with Images & Product Gallery
  • ACF , ACF PRO , YOAST SEO, Custom Fields Support
  • Drag and Drop / Automap excel to product fields & avoid repetition!
  • Update by SKU, ID or TITLE
  • Automap excel to product fields & avoid repetition!
  • Save Product Import mapping Configuration as Template to avoid repetition!
  • WPML product translations support
  • Schedule Product Import / Update with CRON Job
  • Control User access to plugin
  • free version of Product Import & Bulk Edit with Excel in wordpress.org
Clear
Limited Offer!
License

, ,

Support

6 months (48 hours SLA)

Updates

6 months

Minimum PHP Version

7.1

Latest Version

9.6

WordPress Tested

6.2

Max PHP Version

8.0.6

Description

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.

Save Mapping Configuration Template

You want to Do your job faster as you always use the same configuration? You now can avoid repetition by creating a Mapping Template. You can either once Manually add the columns based on the excel you built and save the settings , or just to Settings Page and create a mapping configuration for Later Use.

Avoid repetition and be more productive!

 

Schedule Product Import with CRON Job

You can schedule the Product Import as a one time or recurrent schedule , using CRON Job . You can now import or products using an Excel file in a publicly accessible URL , or even using Google Sheets output as xlsx!

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.

...What Our Customers Say...

More than 5000 happy customers trust our solutions & we keep doing our best for their & your satisfaction

  • Woocommerce Product Excel Importer & Bulk Editing PRO Woocommerce Product Excel Importer & Bulk Editing PRO
    5 out of 5
    great plug in helped me a lot and very easy to use. great job. 5 stars for me

  • Woocommerce Product Excel Importer & Bulk Editing PRO Woocommerce Product Excel Importer & Bulk Editing PRO
    5 out of 5
    Nice tool for any woocommerce store! I can now easily manage my product catalogue!

  • Woocommerce Product Excel Importer & Bulk Editing PRO Woocommerce Product Excel Importer & Bulk Editing PRO
    5 out of 5
    Helped me a lot with all my editing!

ACF Custom Fields Supported!

We now provide support for Advanced Custom Fields and other plugin’s post meta fields. AFC PRO: You can even upload images from url for image and gallery fields!
The only prerequisite – you already published a product with fields from ACF or other Similar plugin, so the entry of this field exists in the database.

acf custom fields in product import with excel

Import/Update Yoast SEO Meta Data

If you are using Yoast Seo plugin , you can now easily import/update/export Yoast Seo Title, Yoast Seo Description , Yoast Seo Focus Keyword as long as the plugin is installed & active

yoast seo plugin import title description with excel

WPML MULTILINGUAL support

Is your Eshop Multilingual? 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 wpml translation with woocommerce product excel importer

Woocommerce Product Excel Importer & Bulk Editing will save you Time!

Get it here

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!

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!

Product 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!

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

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

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.

With ease and All in One Form!

Delete Product Categories with Excel

Import WooCommerce Product Categories with Images

You can now import Product Categories along with Images ( import newly image from URL or use existing in Media Gallery ) independently from Products and build your Category tree.
Import WooCommerce Product Categories with Image with Excel


Compatible with Variation Swatches for WooCommerce

Import taxonomy Terms and add Color or Image attached to the Taxonomy term , to later appear in product page
Variation Swatches for WooCommerce

Compatible with Additional Variation Images Gallery for WooCommerce

Import and Export comma separated from url Variation Images to create a gallery for each variation. Our plugin will also upload the images to WordPress from a remote url location
Additional Variation Images Gallery for WooCommerce

Compatible with Variation Images Gallery for WooCommerce

Import and Export comma separated from url Variation Images to create a gallery for each variation. Our plugin will also upload the images to WordPress from a remote url location
Variation Images Gallery for WooCommerce

Compatible with Perfect Brands for WooCommerce

Import / Update Product Brands , logo , banner and link from excel file along with Product Brands
Perfect Brands for WooCommerce import with Excel logo, banner

If you only need the bulk edit feature click here

14-day-money-back-gurantee

100% No-risk Money Back Guarantee!

If the plugin doesn't meet your requirements, you can get a refund within 14 days of purchase.

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.

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.

demo page here

usr: demo - pass: demo

 


Version 9.6 - 13-07-2023

  • buf fix on importing product attributes of greek slung
  • insert option in export to not export product variations

Version 9.5 - 05-07-2023

buf fix on importing webp images

Version 9.4 - 14-06-2023

buf fix on simple product with attributes comma separated from one row

Version 9.3 - 06-06-2023

  • bug fix on setting backorders to change stock status to "onbackorder"

Version 9.2 - 10-02-2023

  • bug fix for product update on replacing taxonomy terms when comma separated

Version 9.1 - 06-02-2023

  • allow html in variation description field

Version 9.0 - 24-01-2023

  • image / gallery images fields support plugins like ACF PRO
  • fix menu order on update - if no menu order defined the update will not turn 0
  • import/update post_date: on bulk import, post_date can be autpomatically the same for products. This is causing issues on pagination links for themes like storefront. Solution is to manually add post_date  / modified_date

Version 8.9 - 21-12-22

  • bug fix on excel update crossell and upsell products

Version 8.8 - 02-09-22

  • fix  downloadable files bug  - check if  column exists

Version 8.7 - 22-08-22

  • fix compatibility with PHP Version 8.0.6

Version 8.6 - 04-05-22

  • bug fix when updating variable products to sale price as 0 so they are not anymore considered as On Sale

Version 8.5 - 31-03-22

  • added feature to import product categories along with category image
  • added compatibility with Perfect Brands for WooCommerce to import Brand Logo, Banner and link

Version 8.4 - 23-03-22

  • fix export for array of ACF fields

Version 8.3 - 18-03-22

  • post status field added as available to get in exports

Version 8.2 - 15-03-22

  • Excel library compatibility  - Check and fix error

Version 8.1 - 10-03-22

  • Excel library compatibility for PHP 8.0.6
  • Check and fix fatal error issue on import products for PHP 8.0.6

Version 8.0 - 04-03-22

  • Fix product & variables import index based on meta - SKU in backend - update WooCommerce table wc_product_meta_lookup
  • added functionality in Settings page to reindex all products if not indexed by SKU in backend

Version 7.9 - 02-03-22

  • Fix product import index based on meta - SKU on backend - update WooCommerce table wc_product_meta_lookup

Version 7-8 - 28-02-22

  • Added Schedule Product Import / Update via CRON Job
  • Added Feature for Saving Template for Product Import - Mapping Configuration
  • Fixed Bug on Import when falsely importing Excel with Empty Columns
  • Built Instructions Section
  • Added extra SKU field - in case of importing Variable Product with variations, but still need an SKU for the Parent Product
  • Added Version Control and Auto Updates from WordPress

Version 7.7 - 18-02-22

  • added compatibility with Variation Images Gallery for WooCommerce - User during import products can import/ upload comma separated variation gallery images from url added in a taxonomy  . Mapping the excel column to WOO VARIATION GALLERY IMAGES custom field. Also export the comma separated variation image URLS exporting the field  

Version 7.6 - 16-02-22

  • added compatibility with variation swatches - User can now import taxonomy terms defining Color hex code for a term , or image ID ( from media gallery ) of a preuploaded image to save in term meta (OR EVEN UPLOAD an image from URL)  - then user can import product with the variation attribute term, swatches will be added automatically
  • added compatibility with Additional Variation Images Gallery for WooCommerce - User during import products can import/ upload comma separated variation gallery images from url added in a taxonomy  . Mapping the excel column to VARIATION GALLERY IMAGES custom field. Also export the comma separated variation image URLS exporting the field rtwpvg_images

Version 7.5 - 11-02-22

  • bug fix for downloadable files download link  - token saved in db

Version 7.4 - 10-02-22

  • added feature export download name, download file for simple mand variable products

Version 7.3 - 09-02-22

  • fix bug on settings default attribute values in variable products

Version 7.2 - 30-01-22

  • added setting for import text log file

Version 7.1 - 27-01-22

  • fixed bugs on export methods - when fitering based on taxonomy, exporting variations

Version 7.0 - 25-01-22

  • fixed bugs on export methods

Version 6.9 - 08-01-22

  • YOAST SEO meta fields import/export support

Version 6.8 - 26-10-2021

  • bug fix on saving custom fields for product variation when importing new product

Version 6.7 - 14-09-2021

  • add extra field input (manual) for import/export in settings page

Version 6.6 - 06-09-2021

  • delete sale price if in excel number 0

Version 6.5 - 06-08-2021

  • add multiple downloadable files per product

Version 6.4 - 22-07-2021

  • fix bug to not delete excerpt when excel column empty
  • add functionality to import multiple download names and files for both simple and variable products

Version 6.3 - 26-05-2021

  • fix export bug on simple products attributes

Version 6.2- 17-03-2021

  • attribute visibility checkbox during import

Version 6.0 - 12-03-2021

  • on product update , append or replace product categories (use a checkbox)

Version 6.0 25-02-2021

  • 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.

You may also like…