Woocommerce Export Products to XLS
A WordPress plugin that will export your Woocommerce products data to XLS
Features
- Will export all products, published or not
- Will export Variations and Group Products
- 40 fields supported by default
- 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
Usage
In order to use the Woocommerce export to XLS, please navigate from your WordPress administration panel to “Woocommerce > Products to XLS“
- Please check the data you want to export and drag the rows to order the columns of the exported XLS and click “Save Changes”.
- Then you may export the selected data to XLS by clicking the “Export to XLS” button.
- A message will be displayed with the actions taken and on the bottom of the message there will be a link to the file that has been just created. Click on the link “Download Excel File” to download the XLS file.
Below are the fields that are available by default
- Product ID
- Product author ID
- Product publish date
- Product description – content
- Product Title
- Excerpt
- Status
- Slug
- Modified date
- Parent product ID
- guid
- Category IDs
- Categories title
- Stock (quantity)
- Sold individually
- Price
- Sales price date to
- Sales price date from
- Tax class
- Purchase note
- Featured
- Weight
- Length
- Width
- Height
- SKU
- Products attributes
- Backorders status
- Manage stock status
- Tax status
- Sales price
- Regular price
- Virtual status
- Downloadable status
- Total sales
- Visibility
- Stock status
- Thumb ID
- Gallery images IDs
- Custom attributes
- All attributes that have been added via the Woocommerce attribute manager or during inserting the product
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 3.8+
- Woocommerce 2.1+
- PHP 5.2
- PHP extension php_zip enabled
- PHP extension php_xml enabled
- PHP extension php_gd2 enabled (if not compiled in)
Frequently Asked Questions
-
The data on my XLS is strange on my Excel 2003
Please use open, select the file you have downloaded, from the open button on the bototm-right click the arrow down and select “open and repair”. If a question pop up please select “No”.
-
Can I add my custom meta data field to export?
Please check the section For Developers.
Installation
This wordpress plugin can be installed as any other wordpress plugin. Installation is simple.
- Extract the zip file you have downloaded.
- Login to your administration panel (ex. http://www.yourdomain.com/wp-admin).
- Go to Plugins -> Add New.
- At the top of the page click the “Upload Plugin” link
- Click choose file (or what your browser uses to navigate to your files)
- From the extracted files of step one (1) navigate to and select woo-products-xls.zip and click “Install Now“
- You may be asked to confirm your wish to install the Plugin.
- If this is the first time you’ve installed a WordPress Plugin, you may need to enter the FTP login credential information. If you’ve installed a Plugin before, it will still have the login information. This information is available through your web server host.
- Click Proceed to continue with the installation. The resulting installation screen will list the installation as successful or note any problems during the install.
- If successful, please click Activate Plugin to activate it.
Sources and Credits
This plugin uses the following libraries