Product Excel Import Export & Bulk Edit for WooCommerce

Description

Import WooCommerce Products with Excel & Bulk Edit easily from one screen! You can Import new Products in Bulk with Excel, Update Products in Bulk from one screen and save time.

Why Use WooCommerce Products with Excel & Bulk Edit

  • Advanced Products Search by keyword, taxonomy term, regular price, sale price, sku.
  • Select what fields you want to see in the list and Update.
  • WooCommerce Products Bulk Inline Editing from one screen.
  • Select what Fields to show in the Editor.
  • Simple WooCommerce Products Import with Excel
  • Excel Simple Data mapping – Drag and drop Excel Columns to Product Fields or Automatch based on Excel Labels & save time.
  • Bulk Update Simple WooCommerce Products from Excel File!

The PRO Version of this wp plugin allows you to do Product Import Export for WooCommerce, for External, Simple, Variable with Multiple Attributes, Product Image & Product Gallery images as well, update products by ID, SKU or TITLE. Moreover, WPML compatibility and multilingual support for product import , Import WooCommerce Subscription Products , Schedule Product Import with CRON Job and create Import Template to Save Time, import Product Categories with their Images, all using Excel! Last but not least, Bulk Edit from One screen Simple & Variable Products.

Bulk Edit Supports

  • Change Regular Price at Once! In bulk for exact given amount, added or divided, percentage added or divided to the existing price.
  • Change Sale Price at Once! In bulk for exact given amount, added or divided, percentage added or divided to the existing price.

Inline Edit Supports

  • title
  • description
  • Short Description – Excerpt -NEW
  • product category – add/edit adding multiple comma separated. If not exist new terms will be added.
  • product tags – add/edit adding multiple comma separated. If not exist new terms will be added.
  • weight
  • sku
  • stock
  • stock status
  • width
  • length
  • height
  • virtual
  • author id
  • url / slug

Excel Import/Update

  • Title
  • Description
  • Short Description – Excerpt -NEW
  • Product Category (multiple comma separated)
  • Product Tags (multiple comma separated)
  • Weight
  • SKU
  • Regular Price
  • Sale Price
  • Stock
  • Author ID
  • Url – Slug
  • Virtual

Video Instructions

PRO VERSION

Get it Here

Product Bulk Editing from a Screen

  • Bulk Edit Variable Products and Product Variations
  • List will include Custom Taxonomies
  • List will include Product Attibutes
  • Bulk Edit support for Any Custom Taxonomies
  • Bulk Edit support for Any Product Attibutes defined
  • Bulk Edit support for Stock
  • Bulk Delete / Inline Delete Products
  • Bulk Create Product Categories (independently from product creation/edit)
  • Bulk Delete / Inline Delete Product Categories (independently from product creation/edit)

Product Import with Excel

  • Import/update Variable Products with Excel
  • Set Default Attribute Combination for Variable Products
  • support for WPML WooCommerce Product Translations Import with Excel
  • Import / Export Affiliate/External products
  • PRODUCT IMPORT – SIMPLE PRODUCTS WITH ATTRIBUTES: add multiple attributes,comma separated, this means you need only one Excel row for each product!
  • Schedule Product Import / Update with CRON JOB
  • Save Template for Product Import to save time
  • Update by Product ID, SKU or Title. You can easily export get the necessary fields and update back.
  • FIELDS SUPPORTED: User preConfigured Attributes, User preConfigured Custom Taxonomies, length, width, height, downloadable, download url, download expiry, download limit, virtual, purchase note, crossell ids, upsell ids, purchase note, backorders, sold individually, featured
  • CUSTOM FIELDS SUPPORT: ACF and other plugin’s post meta fields
  • Import / Export YOAST SEO Meta Product fields, like META TITLE, META DESCRIPTION
  • IMPORTS PRODUCT IMAGES FROM URL – 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 if image exists in Media. Dropbox public folder also suppported to get the image from.
  • IMPORT IMAGES IN PRODUCT GALLERY – Do you want to create an image gallery for each product? Now you can do that! You can upload unlimited product images easily by inserting multiple URLs separated using a comma in an excel column.
  • IMPORT PRODUCT CATEGORIES with Images: you are able to import multiple product categories individually from product creation along with uploading Product Category Image. This allows you to complete your work a lot quicker, without missing out on important stuff such as e-shop categories.
  • Import Custom Taxonomies
  • Export Produts in Excel in the right format for Editing and re-importing
  • Delete products with Excel File
  • Delete Category Terms with Excel File
  • Compatible with YITH WooCommerce Color and Label Variations
  • Compatible with Additional Variation Images Gallery for WooCommerce
  • Compatible with Perfect Brands for WooCommerce
  • Compatible with Variation Swatches for WooCommerce

— Last but not least, define which WordPress role will accss the plugin apart from Admin

Get it Here

PRO VERSION DEMO user:demo – pass:demo

Screenshots

  • Product Excel Importer configuration screen – Drag and Drop
  • Product Excel Importer configuration screen – Data Mapping
  • Bulk Edit Features – Advanced Search – Hide/show Columns
  • Bulk Edit – Update massively regular and sale price
  • Inline Edit per Product / For categories and tags add multiple 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 Product Excel Importer Bulk Editing Link(found on main menu, and submenu of Woocommerce and Products) or Settings link on plugins page to use the plugin.
  4. Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your products.
  5. Go to Search/Bulk edit administration screen and manage your products.

FAQ

Can I update massively many products?

Yes, update massive features is available for regular and sale price, plus more in the Pro version.

Can I update the existing products?

Yes, update is also supported and will be mentioned while uploading.

Can I add product categories?

Yes, when you add a category term in excel, this will be created along with the product.
You can add them comma separated in an excel column.

How do i define if a product is in stock?

By default, leaving stock column blank will create products that are ‘in stock’.
If you need the to be as ‘out of stock’, simple add ‘0’ to stock column and map it through the import process.

Can I add product images / custom taxonomies along with the product?

This feature is available in the PRO Version

Can I update by SKU with Excel?

This feature is available in the PRO Version.

Can I Export Products?

This feature is available in the PRO Version

Can I import / update Product ACF fields or other Custom Fields?

This feature is available in the PRO Version.
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.

Can I import / update YOAST SEO Meta Fields like Title and description?

This feature is available in the PRO Version.

Can I import / export WooCommerce Orders?

This feature is available in the PRO Version of Orders Import Export for WooCommerce with Excel

Reviews

9 October 2022 1 reply
I try to import xls woocommerce product and dont work. It is fake.
16 June 2021 1 reply
Where is the benefit of an automatic importer which can only import 50 Products? I tested this plugin with a couple of products. There was 2 or 3 Lines in the excelsheet so i thought this will work fine. I bought the pro version and wanted just to update products without any other information. Just two colums of ID and the PRODUCTPRICE but with 16.000 lines. After the counter hits 50 succesfull updated products, the importer is getting slower with each imported product. After comunicating with the support and doing all their suggested solutions it still doesnt work. so i asked for a refund. infacht it was over their service time of 14 days for a refund but still the importer doesnt work and they refuse to refund my money. Very sad and bad service
7 May 2021 1 reply
Hi, I have a pro version of this plugin when I trying to update bulk update its not working this only showing loading… I have 8000 products.
20 March 2021
file size and product quantity is low
20 February 2018
Nice tool and excel import works great. Update multiple products at the same time also helps a lot and it saved me time!
Read all 5 reviews

Contributors and Developers

“Product Excel Import Export & Bulk Edit for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Change Log

4.6

show signup only on plugin page

4.5

fix hpos compatibility and fix notice

4.4

fix PHP 8.2 compatibility

4.3

fix PHP 8.06 compatibility

4.2

extra check for wc_product return

4.1

fixed set_sale price

4.0

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

3.9

Added feature for Automatching Excel Columns to Product Fields if Excel Label the same with product field
Fixed bug when importing Excel with empty Column

3.8

compatibility checks, change descriptions

3.7

Remove Sale price by adding 0 to excel cell
Fix Setting stock to zero by adding 0 to excel cell
Fix updating prices and stock number with values less than zero ( 0 )

3.6

Replace PHPExcel Library with PHPSpreadsheet

3.5

fixed javascript compatibility for products bulk edit

3.4

fixed compatibility with wp 5.5

3.2

fixed bug on update when content and excerpt empty

3.1

fixed bug on update when content and excerpt empty

3.0

added option to import also paretn product categories

2.0

Check WordPress 5.0 compatibility.
Check latest woocommerce version compatibility.
Added Features: Import Author id, import URL Slug, Virtual Product

1.2

Bug fix for decimal values on weight, prices etc.

1.1

Short Description field – Excerpt support for import

1.0