=== Product Excel Import & Export for WooCommerce ===
Contributors: wpcodefactory, anbinder, karzin, omardabbas
Tags:  product import, excel import, product export, import products, bulk import
Requires at least: 3.0.1
Tested up to: 6.9
Requires PHP: 8.1
Stable tag: 7.0.4
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

WordPress Plugin to Import Products and Export Products for Woocommerce in Bulk with Excel.

== Description ==

With this WordPress plugin you can do Product Import & Export for Woocommerce in Bulk with Excel instantly.
Unlimited import/updates of Simple products along with their images is possible as the process works in batched to avoid PHP memory limits.
Export your WooCommerce products in excel file to later do Inventory Stock Updates or change your Prices in bulk.

== MAIN FEATURES ==

* **Product Import Simple** Products  with Excel
* **Product Update Simple** Products  with Excel easily , stock inventory and prices updates.
* **Product Export for Woocommerce of your Simple Products** in Excel - by the hit of a button!
* **Filter Product Exports** by keyword
* **Import Product Categories tree** with excel - Independently from products to create your product categories hierarchy for your eShop.
* **Data mapping** - Drag and drop Excel Columns to Product Fields easily. No More Hassle with CSV's!
* **Automatch feature** - The plugin can automatically map excel columns to the relevant product fields based on label names.

== OTHER FEATURES ==
* define user role to use the plugin apart from admin

== You need to Import / Export Variable Products? ==

The [PRO Version](https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/ "Woo Product Importer Exporter Premium") of this wp plugin allows you to do Product Import Export for WooCommerce, **Simple or Variable with Multiple Attributes**,  **import Images & Galleries for custom fields - [ACF pro](https://www.advancedcustomfields.com/pro/ "ACF pro")**, **update products by ID, SKU** or TITLE. Moreover, **WPML compatibility** and multilingual support for product import , **Import [WooCommerce Subscription Products](https://woocommerce.com/products/woocommerce-subscriptions/ "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!

= How to =
1. Create an excel or use the sample from plugin setting's page with your data - 1st row  is the heading e.g., TITLE, 2nd row will have the product title. Use 1 row for each product. Each Column represents a field to import along with your product.
2. Upload the excel file on Product Excel Import & Export for WooCommerce settings page.
3. Once you upload, you will see a screen where you can map the data from the excel to the product fields of WooCommerce.
4. Click Upload and wait. Product Import in Bulk will function with no hassle!

Lastly, added "wpeieWoo" user capability for admin, you are free to set this capability either programmatically or with a plugin like 'User Role Editor'.

= Video Instructions =
[youtube https://www.youtube.com/watch?v=Cgf2QoyhwLs&rel=0]

**PRO VERSION**

* PRODUCT IMPORT - SIMPLE & VARIABLE - You can upload simple products with attributes or variables, along with their attributes and their images!
* Import [WooCommerce Subscription Products](https://woocommerce.com/products/woocommerce-subscriptions/ "WooCommerce Subscription Products")
* Support for WPML WooCommerce Product Translations Import with Excel
* Import / Export Affiliate/External products
* Import Product Featured image
* Import Product Image Gallery
* Schedule Product Import / Update with CRON JOB
* Save Template for Product Import to save time
* UPDATE SIMPLE & VARIABLE PRODUCTS - Through WooCommerce Product Excel Importer Premium, users are free to update those products with simple attributes and variables.
* Define which attributes will be used for your Variable Products during Import
* Update by Product ID, SKU or Title. You can easily export get the necessary fields and update back.
* PRODUCT IMPORT - SIMPLE PRODUCTS WITH ATTRIBUTES: add multiple attributes,comma separated, this means you need only one Excel row for each product!
* Update Feature Supports Update by PRODUCT ID - given in the Export Feature! This was you can easily update simple products or variable, along with product variations on the fly!
* FIELDS SUPPORTED: User preConfigured Attributes, User preConfigured Custom Taxonomies, length, width, height, downloadable, download url, download expiry, download limit, virtual, purchase note, cross-sell ids, upsell ids, purchase note, backorders, sold individually, featured, tax class, tax status, stock status, shipping class
* CUSTOM FIELDS SUPPORT: ACF / ACF PRO and other plugin's post meta fields  - YOU CAN ALSO manually set the name of custom field you need to be available for import & export
* Import / Export YOAST SEO Meta Product fields,  like META TITLE, META DESCRIPTION
* Compatible with [YITH WooCommerce Color and Label Variations](https://yithemes.com/themes/plugins/yith-woocommerce-color-and-label-variations/ "YITH WooCommerce Color and Label Variations")
* Compatible with [Additional Variation Images Gallery for WooCommerce](https://wordpress.org/plugins/woo-variation-gallery/ "Additional Variation Images Gallery for WooCommerce")
* Compatible with [Perfect Brands for WooCommerce](https://wordpress.org/plugins/perfect-woocommerce-brands/ "Perfect Brands for WooCommerce")
* Compatible with [Variation Swatches for WooCommerce](https://wordpress.org/plugins/woo-variation-swatches/ "Variation Swatches for WooCommerce")
* IMPORTS CUSTOM TAXONOMIES - along with product creation you can import terms for any custom taxonomy which is pre assigned to post type product.
* EXPORT SIMPLE & VARIABLE PRODUCTS. The excel is providing the product or Variation ID, you can choose what products to show based on criteria and also choose which columns - product fields to export
* DELETE PRODUCTS WITH EXCEL - Just like you can import multiple products, you can delete them as well. Deleting is based on ID or product Title.
* 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.
* DELETE CATEGORY TERMS THROUGH EXCEL FILE
* HTML SUPPORT for PRODUCT DESCRIPTION - directly from an excel column you can right html to import as content for your product description. As simple as that!
* HTML SUPPORT for PRODUCT EXCERPT - directly from an excel column you can right html to import as content for your product excerpt. As simple as that!
* Set Default Attribute Combination for Variable Products
* Define custom separator for when importing / exporting multiple values of a field. This avoids conflicts with comma separated values , mixed with values with comma as delimiter

-- Last but not least, define which WordPress role will access the plugin apart from Admin straight in settings page

[youtube https://www.youtube.com/watch?v=wCloPECyTPo&rel=0]

[PRO VERSION DEMO](https://demo.extend-wp.com/enter "Woo Product Importer Exporter PRO") user:demo - pass:demo
[Get it Here](https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/ "Woo Product Importer Exporter PRO")

[youtube https://www.youtube.com/watch?v=w8YkbMrUuMY&rel=0]

== Check our other Plugins ==
[Orders Import - Orders Export, Coupons Import Export, Reviews & Products Import/Export Bundle](https://wordpress.org/plugins/store-migration-products-orders-import-export-with-excel/")
[Bulk Edit + Excel Importer](https://extend-wp.com/product/woocommerce-product-excel-importer-bulk-editing-pro/ "WebD WooCommerce Product Excel Importer & Bulk Edit")
[Excel Importer for Any Content Type](https://extend-wp.com/product/content-importer-wordpress-woocommerce-excel/ "WordPress
CONTENT EXCEL IMPORTER")
[Users & Customers Import Export with Excel](https://wordpress.org/plugins/users-import-export-with-excel-for-wp/ "Users & Customers Import Export with Excel")
[Stock Manager with Excel & Auto Updates](https://wordpress.org/plugins/products-stock-manager-with-excel/")

== 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 "WPFactory > Product Import Export" menu link, 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.

== Frequently Asked Questions ==

= How to do product import in excel for WooCommerce? =
Add one row for each product and each column will refer to a product field, such as title, description, prices, etc. Example excel provided to download through plugin's configuration scren.

= Can I update the existing products  for WooCommerce? =
Yes, update is also supported and will be mentioned while uploading. Update is based on Title. If a title entered in an excel column exists as product in your website, this product's fields will be updated.

= Can I add categories with Excel for WooCommerce Products? =
Yes, when you add a category terms 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 WooCommerce 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.

= How can I add custom taxonomies along with the product? =
This feature is available in the [PRO Version](https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/ "Woo Product Importer Premium").

= Can I add WooCommerce Product Gallery Images and Featured Image? =
This feature is available in the [PRO Version](https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/ "Woo Product Importer Premium").

= Can I import Orders, Coupons or Reviews with this plugin?
This feature is available in [Products Reviews Orders Customers Coupons WooCommerce Migration Pro](https://extend-wp.com/product/products-reviews-orders-customers-woocommerce-migration-excel/")

= Can I update by SKU? =
This feature is available in the [PRO Version](https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/ "Woo Product Importer Premium").

= Can I import / update Product ACF fields or other Custom Fields? =
This feature is available in the [PRO Version](https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/ "Woo Product Importer Premium").
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 or export WordPress Users with this plugin? =
For such a feature you can use [Users Import Export with Excel](https://wordpress.org/plugins/users-import-export-with-excel-for-wp/ "Users Import Export with Excel for WordPress").

= Can I update just Stock and Prices automatically with Cron? =
For such a feature you can use [Product Stock Manager PRO](https://wordpress.org/plugins/products-stock-manager-with-excel/ "Product Stock Manager PRO").

= Can I import Coupons and Products Reviews with this plugin? =
For such a feature you can use [Orders, WooCommerce Subscriptions, Coupons, Reviews & Products shop Migration](https://extend-wp.com/product/products-reviews-orders-customers-woocommerce-migration-excel/ "Orders, WooCommerce Subscriptions, Coupons, Reviews & Products shop" )

= Is plugin compatible with WPML? =
WPML compatibility and multilingual support product import is available in the [PRO Version](https://extend-wp.com/product/wordpress-product-import-export-excel-woocommerce/ "Woo Product Importer Premium").

= Can Other user apart from admin access the plugin? =
Yes, we added "wpeieWoo" user capability for admin, you are free to set this capability either programmatically or with a plugin like 'User Role Editor'

= Can I import / export WooCommerce Orders and Subscriptions with this plugin?  =
This feature is available in the [PRO Version of Orders Import Export for WooCommerce with Excel](https://extend-wp.com/product/orders-import-export-for-woocommerce-with-excel/ "Orders Import Export for WooCommerce with Excel")

== Screenshots ==

1. WordPress Product Excel Import & Export configuration screen
2. WordPress Product Excel Import & Export data mapping
3. WordPress Product Excel Import & Export mapped data
4. WordPress Product Excel Import & Export Functionality

== Changelog ==

= 7.0.4 - 21/01/2026 =
* Fix - Fixed wrong totals on products import.
* WC tested up to: 10.4.
* Tested up to: 6.9.

= 7.0.3 - 13/10/2025 =
* WPFactory Admin Menu - Library updated (to v1.0.8).
* WPFactory Recommendations - Library updated (to v1.0.6).
* WC tested up to: 10.2.

= 7.0.2 - 10/06/2025 =
* Fix - Fix plugin icon.

= 7.0.1 - 06/06/2025 =
* Dev - Updated plugin icon and banner.

= 7.0.0 - 22/05/2025 =
* Fix - Translation loading fixed.
* Dev - Plugin settings moved to the "WPFactory" menu.
* Dev - "Recommendations" added.
* Dev - Code refactoring and cleanup.
* WC tested up to: 9.8.
* Tested up to: 6.8.

= 6.0 =
* PhpSpreadsheet updated to 3.4 version.

= 5.9 =
* Check woo compatibility.

= 5.8 =
* Rewrite import code to insert products in chunks and avoid any php memory limit.
* Compatibility woocommerce 8.7.

= 5.7 =
* Run js due to popup.

= 5.6 =
* Fix signup repeatedly showing.
* Check compatibility.

= 5.5 =
* Show signup only on plugin page.

= 5.4 =
* Fix dismiss note.
* Add product gallery  import and export functionality.

= 5.3 =
* Fix export issues.

= 5.2 =
* Add product Image import and export functionality.
* Fix export issues.

= 5.1 =
* Check wp compatibility.

= 5.0 =
* Check PHP 8.2 compatibility.

= 4.9 =
* Localization fix.

= 4.8 =
* Fix PHP 8.06 compatibility.

= 4.7 =
* Added feature to import product categories tree with excel.

= 4.6 =
* Extra check for wc_product return.

= 4.5 =
* Fixed set_sale price.

= 4.4 =
* Fix product import index based on meta - SKU on backend - update WooCommerce table wc_product_meta_lookup.

= 4.3 =
* 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.

= 4.2 =
* Compatibility checks, change descriptions.

= 4.1 =
* 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 ).

= 4.0 =
* Replace PHPExcel Library with PHPSpreadsheet.

= 3.9 =
* Fixed export duplicates.

= 3.8 =
* Added capability for user other than admin to access - check compatibility.

= 3.7 =
* Add post status to import.

= 3.6 =
* Fixed compatibility with wp 5.5.

= 3.5 =
* Added option to import also parent product categories.

= 3.3 =
* Fixed php error on calculation/functions.php.
* Checked wooCommerce 3.7 compatibility.

= 3.2 =
* Changed export functionality - export directly to .xlsx.

= 3.1 =
* Export fix in chrome.
* Check WooCommerce compatibility 3.6.5.

= 3.0 =
* Export Simple Products to Excel for WooCommerce added.
* Bug fixes on import functionality.
* Wordpress 5.1 compatibility.

= 2.0 =
* Check Wordpress 5.0 compatibility.
* Check latest WooCommerce version compatibility.
* Added Features: Import Author id, import URL Slug, Virtual Product.

= 1.7 =
* Bug fix for decimal values on weight, prices etc.

= 1.6 =
* Short Description field - Excerpt support for import.

= 1.5 =
* Drag n Drop for Excel Files.

= 1.4 =
* If description column not selected, during update previous content will be preserved

= 1.3 =
* Properly refresh the view for price changes for products - delete product_transients.

= 1.2 =
* Functionality to add multiple categories or tags from one cell comma separated.
* Fix UI.
* Avoid css conflicts.

= 1.1 =
* Fix bug with empty excel columns.

= 1.0 =
* Initial release.

== Upgrade Notice ==

= 6.0 =
PHPSpreadsheet updated to 3.4 version.
