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.
- 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
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
PRO VERSION DEMO user:demo — pass:demo
Screenshots
Installation
- Upload the plugin files to the
/wp-content/plugins
directory and unzip, or install the plugin through the WordPress plugins screen directly. - Activate the plugin through the ‘Plugins’ screen in WordPress
- 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.
- Upload your excel file (there is a link for a sample excel file) and proceed to data mapping and creating your products.
- 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
Contributors & Developers
“Product Excel Import Export & Bulk Edit for WooCommerce” is open source software. The following people have contributed to this plugin.
ContributorsTranslate “Product Excel Import Export & Bulk Edit for WooCommerce” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
4.7
phpspreadsheet 3.4.0 latest version update, php 8.1 required
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