Product Excel Import & Bulk Edit for WooCommerce

Description

Import with Excel Products in WooCommerce & Bulk Edit easily from one screen!

Advanced Search of your Products by keyword, taxonomy term, regular price, sale price, sku.

Select what fields you want to see in the list and Update.

Inline Editing for the Products from one screen.

Select what Fields to show in the Editor.

Import / Create Simple products from Excel File!

Update Simple products from Excel File!

Click here if you need Excel Importer Only

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
  • NEW! virtual
  • NEW! author id
  • NEW! 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
  • New! Author ID
  • New! Url – Slug
  • New! Virtual

Video Instructions

PRO VERSION

Get it Here

Bulk Editor

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

Excel Importer

  • Import/update Variable Products with Excel
  • Set Default Attribute Combination for Variable Products
  • 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
  • Add Multiple Attributes and autogenerate Variations
  • 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 Custom Taxonomies
  • Export Produts in Excel in the right format for Editing and re-importing
  • Delete products with Excel File
  • Import Category Terms and Subterms with Excel File
  • Delete Category Terms with Excel File

Get it Here

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

Reviews

February 20, 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 1 review

Contributors & Developers

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

Contributors

Changelog

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