Woocommerce Export Products to XLS (item ID: 9307040) is an item from codecanyon.net in category wordpress. Plugin to export products to XLS spreadsheet This is a premium item and their price is $19 with regular license. According to some statistics, the author nitroweb sold about 1010 items from the release date 2014-10-28. Woocommerce Export Products to XLS enjoys sound reputation, so 15 user(s) rated it with 4.33 stars. Now, you can free download Woocommerce Export Products to XLS in CPUMe. Remember this item is for testing & studying purposes only and is not supported for commercial use.
Woocommerce Export Products to XLS
A WordPress plugin that will export your Woocommerce products data to XLS
by: Nitroweb
IMPORTANT! If you have a lot of products (thousands of products), it is recommended that you can set php memory limit to 256MB or higher.
Please read the plugin description. If you are unsure about anything (setup, compatibility etc), feel free to ask before purchasing.
Features
- Can export thousands of products and variations by using AJAX technology
- Will export all products, published or not
- Will export Variations and Group Products
- Filter exported products by categories
- 53 fields supported by default
- ACF (Advanced custom fields) support
- Will export predefined and custom attributes
- Extensible / developer friendly. You can add your custom fields via WordPress filter
- Easy administration with drag n drop sorting
- Caches the .xls files for future download
- XLS output, not CSV
- Compatible with MS Excel 2003, 2007, 2010, 2013
- Supports WPML. You can export the language of the products.
- Supports WordPress SEO by Yoast plugin. You can export the Yoast SEO plugin data of the products.
- Supports WC Vendors plugin. You can export commision, vendor id and vendor nicename.
- Supports WC Vendors plugin. You can export commision, vendor id and vendor nicename.
- Supports WooCommerce Brands by proword plugin. You can export Brand ID and Brand name.
Usage
In order to use the Woocommerce export to XLS, please navigate from your WordPress administration panel to “Woocommerce > Products to XLS“
Below are the fields that are available by default
- Version: Recommended is XLSX. Although XLS is compatible with older versions of Excel, it produces bigger files and can only hold 65535 records/rows.
- Caching Method: Recommended is sqlite3. Please read for more information
- Products per batch: Recommended is 100. If you get products skipped or the produced files have issues please lower the number or ask your web hosting to increase the resources or change web hosting service. If you think that your web hosting can do it, you may increase the number.
- Join character(s) for the categories path: Character to join categories names for the categories path.
You will have to add a rule to the ACF group that you want to be available for export like it is demonstrated on the documentation. Only then the fields will be on the export list so you can select them.
Developer Friendly
You can add new custom fields that are already on your products data to be exported via a filter, eg.
add_filter( 'wooxls_exportfields_filter', 'my_woocommerce_product_meta'); function my_woocommerce_product_meta($wooxls_exportfields) { $wooxls_exportfields['_deprecated'] = __('Deprecated status', 'wooxls'); return ($wooxls_exportfields); } Requirements
- WordPress 4.0+
- Woocommerce 4.0 or later
- PHP 7.x & PHP 8.x
- PHP extension php_zip enabled
- PHP extension php_xml enabled
- PHP extension php_gd2 enabled (if not compiled in)
Frequently Asked Questions
Please use open, select the file you have downloaded, from the open button on the bottom-right click the arrow down and select “open and repair”. If a question pop up please select “No”.
Please check the section For Developers.
No, this plugin will only Export the Woocommerce products data to XLS. On the other hand WP All Import plugin may be able to do this by adding with the addon: https://wordpress.org/plugins/woocommerce-xml-csv-product-import/
No, this plugin will only export the images ids and/or urls of your Woocommerce products in a separate column.
Please read the Microsoft guide here: http://support2.microsoft.com/kb/924074.
Installation
This wordpress plugin can be installed as any other wordpress plugin. Installation is simple.
Changelog
0.6.4 22 Jan 2023- Feature: Added the option to save and load multiple settings as templates
- Fix: “Save changes” URL set to the default plugin page after export
- Feature: Added support for exporting ACF repeater field (first level)
- Feature: Added custom product meta support
- Fix: Added PHP 8 compatibility
- Feature: Added option to export product by categories
- Feature: Added generic support for all product taxonomies
- Feature: Added filter on DB query
- Feature: Added support for WooCommerce Prices By User Role plugin by Festi-Team
- Fix: Removed some deprecated Woocommerce function notices
- Fix: Removed string to array convertion fatal error
- Fix: In some cases not published products were exported
- Feature: Added the option to strip any HTML from the excerpt
- Feature: Added the option to set a custom filename
- Feature: Added price fields with or without tax
- Feature: Added export to CSV support
- Feature: Moved files in the uploads directory
- Feature: Added ACF (Advanced custom fields) support
- Update the PHPExcel class
- Added PHP 7 compatibility
- Only published products will be exported
- Set default cell type to string
- Added WooCommerce Brands by proword support
- Added one more filter on the xls export
- Added some filters on the output of the cell
- Added product URL/link field
- Added Yoast Twitter and Google+ fields support
- Added option to exclude simple and/or variable products
- Added WC Vendors plugin support
- Added categories titles path column
- Added WordPress SEO by Yoast support
- Added caching option
- Added version option
- Added products per batch option
- Fixed jQuery bug that prevented plugin to continue when skipping products
- Changed the way XLS is produced by using AJAX.
- Many UI/UX enhancements.
- Added WPML support. Now you can export the language of the product.
- Minor bug fix
- Added product tags
- Added option to export the full featured image url
- Added option to export all images urls of the product gallery
- Initial release
Sources and Credits
This plugin uses the following libraries
- PHPExcel
| # | Server | Resource Title | Uploaded at | Download |
|---|---|---|---|---|
| 1 | C | Woocommerce Export Products to XLS v0.6.0 | 29 August 2017 | Download |
