Product Excel Import Export & Bulk Edit for WooCommerce Plugin

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.

• Click here if you need Product Import Export only with Excel
• Click here if you need Orders Import – Orders Export, Coupons Import Export, Reviews & Products Import/Export Store Migration Bundle
• Click here if you only need WooCommerce Orders Import with Excel
• Click here if you need Excel Importer for Any Content Type

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

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.

1. 

   Product Excel Importer configuration screen - Drag and Drop

2. 

   Product Excel Importer configuration screen - Data Mapping

3. 

   Bulk Edit Features - Advanced Search - Hide/show Columns

4. 

   Bulk Edit - Update massively regular and sale price

5. 

   Inline Edit per Product / For categories and tags add multiple comma separated

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