Woocommerce Export Products to XLS


Woocommerce Export Merchandise to XLS

A WordPress plugin that may export your Woocommerce merchandise information to XLS


IMPORTANT! If in case you have loads of merchandise (1000’s of merchandise), it is strongly recommended you can set php reminiscence restrict to 256MB or increased.

Please learn the plugin description. In case you are not sure about something (setup, compatibility and so on), be happy to ask earlier than buying.


  • Can export 1000’s of merchandise and variations by utilizing AJAX expertise
  • Will export all merchandise, revealed or not
  • Will export Variations and Group Merchandise
  • Filter exported merchandise by classes
  • 53 fields supported by default
  • ACF (Advanced custom fields) help
  • Will export predefined and customized attributes
  • Extensible / developer pleasant. You’ll be able to add your customized fields through WordPress filter
  • Straightforward administration with drag n drop sorting
  • Caches the .xls recordsdata for future obtain
  • XLS output, not CSV
  • Suitable with MS Excel 2003, 2007, 2010, 2013
  • Helps WPML. You’ll be able to export the language of the merchandise.
  • Helps WordPress search engine optimization by Yoast plugin. You’ll be able to export the Yoast search engine optimization plugin information of the merchandise.
  • Helps WC Vendors plugin. You’ll be able to export commision, vendor id and vendor nicename.
  • Helps WC Vendors plugin. You’ll be able to export commision, vendor id and vendor nicename.
  • Helps WooCommerce Brands by proword plugin. You’ll be able to export Model ID and Model title.


With a view to use the Woocommerce export to XLS, please navigate out of your WordPress administration panel to “Woocommerce > Merchandise to XLS

  1. Please verify the info you wish to export and drag the rows to order the columns of the exported XLS and click on “Save Adjustments”.
  2. Then you might export the chosen information to XLS by clicking the “Export to XLS” button.
  3. A message will likely be displayed with the actions taken and on the underside of the message there will likely be a hyperlink to the file that has been simply created. Click on on the hyperlink “Obtain Excel File” to obtain the XLS file.

    export xls output

Beneath are the fields which are accessible by default

  1. Product ID
  2. Product writer ID
  3. Product publish date
  4. Product description – content material
  5. Product Title
  6. Excerpt
  7. Standing
  8. Slug
  9. Modified date
  10. Dad or mum product ID
  11. guid
  12. Class IDs
  13. Classes title
  14. Classes titles path
  15. Inventory (amount)
  16. Offered individually
  17. Value
  18. Gross sales value date to
  19. Gross sales value date from
  20. Tax class
  21. Buy notice
  22. Featured
  23. Weight
  24. Size
  25. Width
  26. Peak
  27. SKU
  28. Merchandise attributes
  29. Backorders standing
  30. Handle inventory standing
  31. Tax standing
  32. Gross sales value
  33. Common value
  34. Digital standing
  35. Downloadable standing
  36. Complete gross sales
  37. Visibility
  38. Inventory standing
  39. Thumb ID
  40. Full Picture URL
  41. Gallery pictures IDs
  42. Gallery pictures URLs
  43. Tags
  44. Customized attributes
  45. All attributes which have been added through the Woocommerce attribute supervisor
  46. WPML language show title
  47. Yoast search engine optimization Title
  48. Yoast search engine optimization Meta Description
  49. Yoast search engine optimization Fb Title
  50. Yoast search engine optimization Fb Description
  51. Yoast search engine optimization Fb Picture
  52. Yoast search engine optimization Twitter Title
  53. Yoast search engine optimization Twitter Description
  54. Yoast search engine optimization Twitter Picture
  55. Yoast search engine optimization Google+ Title
  56. Yoast search engine optimization Google+ Description
  57. Yoast search engine optimization Google+ Picture
  58. Yoast search engine optimization Customized Index Standing
  59. Yoast search engine optimization Focus KW
  60. WC Distributors plugin vendor commision
  61. WC Distributors plugin vendor id
  62. WC Distributors plugin vendor nicename
  63. WooCommerce Manufacturers plugin model ID
  64. WooCommerce Manufacturers plugin model title
  65. ACF (Superior customized fields)
Different choices
  • Model: Advisable is XLSX. Though XLS is suitable with older variations of Excel, it produces larger recordsdata and may solely maintain 65535 information/rows.
  • Caching Methodology: Advisable is sqlite3. Please read for more information
  • Merchandise per batch: Advisable is 100. When you get merchandise skipped or the produced recordsdata have points please decrease the quantity or ask your hosting to extend the sources or change hosting service. When you suppose that your hosting can do it, you might improve the quantity.
  • Be a part of character(s) for the classes path: Character to hitch classes names for the classes path.
ACF (Superior customized fields) help

You’ll have to add a rule to the ACF group that you just wish to be accessible for export like it’s demonstrated on the documentation. Solely then the fields will likely be on the export listing so you possibly can choose them.

Developer Pleasant

You’ll be able to add new customized fields which are already in your merchandise information to be exported through a filter, eg.

add_filter( 'wooxls_exportfields_filter', 'my_woocommerce_product_meta');
perform my_woocommerce_product_meta($wooxls_exportfields) {
  $wooxls_exportfields['_deprecated'] = __('Deprecated standing', 'wooxls');
  return ($wooxls_exportfields);


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

Continuously Requested Questions

  1. The information on my XLS is unusual on my Excel 2003

    Please use open, choose the file you’ve gotten downloaded, from the open button on the bottom-right click on the arrow down and choose “open and restore”. If a query pop up please choose “No”.

  2. Can I add my customized meta information discipline to export?

    Please verify the part For Builders.

  3. Will I have the ability to import the info of an XLS with this plugin?

    No, this plugin will solely Export the Woocommerce merchandise information to XLS.
    However WP All Import plugin might be able to do that by including with the addon: https://wordpress.org/plugins/woocommerce-xml-csv-product-import/

  4. Will this plugin export the photographs of my Woocommerce merchandise?

    No, this plugin will solely export the photographs ids and/or urls of your Woocommerce merchandise in a separate column.

  5. How can I open an XLSX file on my Workplace 2003?

    Please learn the Microsoft information right here: http://support2.microsoft.com/kb/924074.

Set up

This wordpress plugin will be put in as every other wordpress plugin. Set up is straightforward.

  1. Extract the zip file you’ve gotten downloaded.
  2. Login to your administration panel (ex. http://www.yourdomain.com/wp-admin).
  3. Go to Plugins -> Add New.
  4. On the prime of the web page click on the “Add Plugin” hyperlink
  5. Click on select file (or what your browser makes use of to navigate to your recordsdata)
  6. From the extracted recordsdata of the first step (1) navigate to and choose woo-products-xls.zip and click on “Set up Now
  7. It’s possible you’ll be requested to verify your want to set up the Plugin.
  8. If that is the primary time you’ve put in a WordPress Plugin, you might must enter the FTP login credential info. When you’ve put in a Plugin earlier than, it’ll nonetheless have the login info. This info is accessible via your internet server host.
  9. Click on Proceed to proceed with the set up. The ensuing set up display screen will listing the set up as profitable or notice any issues throughout the set up.
  10. If profitable, please click on Activate Plugin to activate it.


0.6.3 25 Apr 2022
  • Characteristic: Added help for exporting ACF repeater discipline (first stage)
0.6.2 14 Mar 2022
  • Characteristic: Added customized product meta help
0.6.1 06 Mar 2022
  • Repair: Added PHP 8 compatibility
  • Characteristic: Added choice to export product by classes
0.6.0 08/18/2017
  • Characteristic: Added generic help for all product taxonomies
  • Characteristic: Added filter on DB question
  • Characteristic: Added help for WooCommerce Prices By User Role plugin by Festi-Team
  • Repair: Eliminated some deprecated Woocommerce perform notices
  • Repair: Eliminated string to array convertion deadly error
  • Repair: In some instances not revealed merchandise have been exported
0.5.9 01/17/2017
  • Characteristic: Added the choice to strip any HTML from the excerpt
  • Characteristic: Added the choice to set a customized filename
  • Characteristic: Added value fields with or with out tax
  • Characteristic: Added export to CSV help
  • Characteristic: Moved recordsdata within the uploads listing
  • Characteristic: Added ACF (Advanced custom fields) help
0.5.8 05/24/2016
  • Replace the PHPExcel class
  • Added PHP 7 compatibility
  • Solely revealed merchandise will likely be exported
0.5.7 10/22/2015
  • Set default cell kind to string
0.5.6 10/01/2015
  • Added WooCommerce Manufacturers by proword help
  • Added yet one more filter on the xls export
0.5.5 04/21/2015
  • Added some filters on the output of the cell
0.5.4 04/17/2015
  • Added product URL/hyperlink discipline
  • Added Yoast Twitter and Google+ fields help
0.5.3 04/15/2015
  • Added choice to exclude easy and/or variable merchandise
0.5.2 04/14/2015
  • Added WC Vendors plugin help
  • Added classes titles path column
0.5.1 03/22/2015
0.5.0 03/18/2015
  • Added caching possibility
  • Added model possibility
  • Added merchandise per batch possibility
  • Fastened jQuery bug that prevented plugin to proceed when skipping merchandise
0.4.0 03/02/2015
  • Modified the best way XLS is produced by utilizing AJAX.
  • Many UI/UX enhancements.
0.3.2 02/11/2015
  • Added WPML help. Now you possibly can export the language of the product.
0.3.1 11/08/2014
  • Minor bug repair
0.3 11/06/2014
  • Added product tags
  • Added choice to export the total featured picture url
  • Added choice to export all pictures urls of the product gallery
  • Preliminary launch

Sources and Credit

This plugin makes use of the next libraries


Related Posts