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.

Options

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.

Utilization

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

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”.
Then you might export the chosen information to XLS by clicking the “Export to XLS” button.
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.

Beneath are the fields which are accessible by default

Product ID
Product writer ID
Product publish date
Product description – content material
Product Title
Excerpt
Standing
Slug
Modified date
Dad or mum product ID
guid
Class IDs
Classes title
Classes titles path
Inventory (amount)
Offered individually
Value
Gross sales value date to
Gross sales value date from
Tax class
Buy notice
Featured
Weight
Size
Width
Peak
SKU
Merchandise attributes
Backorders standing
Handle inventory standing
Tax standing
Gross sales value
Common value
Digital standing
Downloadable standing
Complete gross sales
Visibility
Inventory standing
Thumb ID
Full Picture URL
Gallery pictures IDs
Gallery pictures URLs
Tags
Customized attributes
All attributes which have been added through the Woocommerce attribute supervisor
WPML language show title
Yoast search engine optimization Title
Yoast search engine optimization Meta Description
Yoast search engine optimization Fb Title
Yoast search engine optimization Fb Description
Yoast search engine optimization Fb Picture
Yoast search engine optimization Twitter Title
Yoast search engine optimization Twitter Description
Yoast search engine optimization Twitter Picture
Yoast search engine optimization Google+ Title
Yoast search engine optimization Google+ Description
Yoast search engine optimization Google+ Picture
Yoast search engine optimization Customized Index Standing
Yoast search engine optimization Focus KW
WC Distributors plugin vendor commision
WC Distributors plugin vendor id
WC Distributors plugin vendor nicename
WooCommerce Manufacturers plugin model ID
WooCommerce Manufacturers plugin model title
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);
}

Necessities

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

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”.
Can I add my customized meta information discipline to export?

Please verify the part For Builders.
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/
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.
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.

Extract the zip file you’ve gotten downloaded.
Login to your administration panel (ex. http://www.yourdomain.com/wp-admin).
Go to Plugins -> Add New.
On the prime of the web page click on the “Add Plugin” hyperlink
Click on select file (or what your browser makes use of to navigate to your recordsdata)
From the extracted recordsdata of the first step (1) navigate to and choose woo-products-xls.zip and click on “Set up Now“
It’s possible you’ll be requested to verify your want to set up the Plugin.
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.
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.
If profitable, please click on Activate Plugin to activate it.

Changelog

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

Added WordPress SEO by Yoast help

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

0.2

Added choice to export the total featured picture url
Added choice to export all pictures urls of the product gallery

0.1

Preliminary launch

Sources and Credit

This plugin makes use of the next libraries

PHPExcel

DOWNLOAD