WordPress Product Import Export with Excel for WooCommerce

On Sale!

Product Import WooCommerce – Import Simple & Variable WooCommerce Products with Excel Easily! No more hassle with Csv’s!

  • Bulk Product Upload / Update /Export / Delete with Excel for Simple, Variable & Subscription Products
  • Product Import – Update with Image & Product Gallery
  • Import/export affiliate/external products
  • ACFACF PRO , Custom & YOAST SEO Meta Fields Import
  • Products Update by SKU, ID or TITLE
  • Easy to Use with Drag & Drop feature!
  • 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
  • Schedule Product Export with CRON Job
  • Control User access to plugin
  • free version of product import with excel in WordPress.org
Clear
License Renewals: 40% off
License

, ,

Support

6 months (48 hours SLA)

Updates

6 months

Minimum PHP Version

7.1

Latest Version

11.3

WordPress Tested

6.4

Max PHP Version

8.2

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 Excel for WooCommerce lets you manage your Eshop Easily – no more CSV problems!


This Ajax driven plugin is very easy to use. All your product data to import along with Images will be implemented on the spot, without any delay or inaccuracy. Import, update, export and delete anything right away. And WooCommerce Product Excel Importer Exporter PRO is not only valid for titles, prices and descriptions, but also images and the rest product data to use along with your e-shop products.

...What Our Customers Say...

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

  • WordPress Product Import Export with Excel for WooCommerce WordPress Product Import Export with Excel for WooCommerce
    5 out of 5
    This software helps me maintain my catalogue and frequently update. Very good support when you need it also!

  • WordPress Product Import Export with Excel for WooCommerce WordPress Product Import Export with Excel for WooCommerce
    5 out of 5
    We make frequent changes to our product prices and stock and this plugin helped us easily do that!

  • WordPress Product Import Export with Excel for WooCommerce WordPress Product Import Export with Excel for WooCommerce
    5 out of 5
    It help me a lot! and very good support. I would definitely recommend

KEY BENEFITS

 

Import/Update Product Import for Simple, Variable, External & Subscription 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 and Subscription 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.

 

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 update products using an Excel file in a publicly accessible URL , or even using Google Sheets output as xlsx! Do the job in the background and get notified once import is done.

 

Schedule Product Export with CRON Job

You can schedule the Product Export , using CRON Job . You can now export products in the background and do other tasks – once export is ready you are notified in WordPress backend and via Email !

 

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. Lately supporting WooCommerce Subscription Products all relevant subscription fields are available.

Product Import Export with Excel for WooCommerce with Excel will save your time!

Get it here

EXTEND YOUR PRODUCT IMPORTS!

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

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

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

Import/Update Subscription Products

If you are offering subscription products or services based on the popular WooCommerce Subscription plugin, you can now easily do this with Product Import Export with Excel . We will also provide sample excel files for both Simple and Variable Subscriptions
import export woocommerce subscription products with exel

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
Import WooCommerce Variable Product with 1 excel row

Choose Product attributes to use in 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
choose product attribute in woocommerce variations with excel

Update WooCommerce Products 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
update WooCommerce Products by SKU WITH EXCEL

Import Affiliate / External WooCommerce Products

You can now import and export Affiliate / External products – this means you also import _product_url and _button_text field for the product ( and export ) and product is assigned as external/affiliate
Import Affiliate / External Products

Import Downloadable WooCommerce Product

This feature allows you to identify each Simple or Variable product as downloadable or not. You may add downloadable file in simple or product variation, identify its name and file URL, download limitations and even expiration dates.
import downloadable simple variable woocommerce products excel

Product Import with Images in Excel

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.
import woocommerce products with images and gallery with excel

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.
import product image gallery woocommerce excel

Import WooCommerce Product Categories / Assign to Products

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.
 Product Import WooCommerce 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

Auto Assign Parent Category Terms to Product

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!
taxonomy-structure-hierarchical-woocommerce-products-excel

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.
automap-excel-columns-woocommerce-product-fields

Delete WooCommerce Products with Excel

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?
delete-woocommerce-products-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

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

How to import Product Gallery images in WooCommerce products with excel

How to import ACF custom field with multiple values comma separated , using excel

Automate your WooCommerce Product Exports in excel | Schedule using Cron

How to Schedule Excel WooCommerce product import via Cron job

How to import WooCommerce products in bulk with Comma in Attribute term Value

Taxonomy Structure: How to import WooCommerce Products and caterogory terms with Excel

How to Bulk Import / Export Products YOAST SEO META with Excel

How to Import Simple Products with Attributes in WooCommerce with Product Import Plugin Faster!

How to select attributes for Variations in Variable Product Import?

How to Import Variable Product in WooCommerce with 1 Excel Row?

How to Import Variable Product with attributes when not all attribute values change data

How to Import WooCommerce Products with Custom fields like ACF with Excel

How to Bulk Import WooCommerce Product Translations with Excel for WPML

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 11.3 14-02-2024

  • added setting to define separator for multiple value . This is done in plugin settings page. If not set , comma(,) will be used
  • defined separator will be also applied during export on a field with multiple values

Version 11.2 06-02-2024

  • fix on import custom fields with dot in text but not delimiter

Version 11.1 06-02-2024

  • fix custom field import of url

Version 11.0 12-01-2024

  • fix js issues

Version 10.9 11-01-2024

  • added functionality to import comma separated ACF values

Version 10.8 31-01-2023

  • added export scheduling via cron

Version 10.7 26-01-2023

  • hpos and woo 8.4 compatibility

Version 10.6 18-12-2023

  • added 10 and 15 minutes schedule import intervals
  • 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…