Woocommerce Export Merchandise to XLS

Woocommerce Export Merchandise to XLS

A WordPress plugin for you to export your Woocommerce merchandise data to XLS

by: Hostivate / Nitroweb

NECESSARY! If You have a lot of products (lots of products), it's really helpful that you simply can set php reminiscence prohibit to 256MB or upper.

Options

• Can export thousands of products and diversifications through the use of AJAX technology
• Will export all products, published or no longer
• Will export Diversifications and Group Merchandise
• FIFTY THREE fields supported via default
• Will export predefined and custom attributes
• Extensible / developer pleasant. you'll add your customized fields by means of WordPress filter
• Easy administration with drag n drop sorting
• Caches the .xls recordsdata for long term download
• XLS output, now not CSV
• Appropriate with MS Excel 2003, 2007, 2010, 2013
• Supports WPML. you'll export the language of the products.
• Helps WordPress SEARCH ENGINE OPTIMISATION by way of Yoast plugin. you'll be able to export the Yoast SEARCH ENGINE MARKETING plugin data of the products.
• Supports WC Companies plugin. you'll export commision, vendor identity and seller nicename.
• Helps WC Providers plugin. you'll export commision, seller identity and supplier nicename.
• Helps WooCommerce Brands via proword plugin. you'll export Emblem IDENTITY and Logo name.

Usage

So As to use the Woocommerce export to XLS, please navigate out of your Wordpress management panel to “Woocommerce > Products to XLS“

1. Please take a look at the information you want to export and drag the rows to order the columns of the exported XLS and click “Keep Changes”.

   
   
   
   

2. Then You Definitely might export the selected information to XLS by clicking the “Export to XLS” button.

   
   
   
   

3. A message might be displayed with the movements taken and at the bottom of the message there shall be a link to the document that has been simply created. Click On at the link “Download Excel Report” to obtain the XLS record.

   
   
   
   

Beneath are the fields which can be available through default

1. Product ID
2. Product creator IDENTIFICATION
3. Product publish date
4. Product description – content
5. Product Name
6. Excerpt
7. Standing
8. Slug
9. Modified date
10. Parent product IDENTITY
11. guid
12. Class IDs
13. Classes name
14. Classes titles trail
15. Inventory (amount)
16. Bought in my view
17. Value
18. Gross Sales worth date to
19. Gross Sales value date from
20. Tax magnificence
21. Acquire notice
22. Featured
23. Weight
24. Period
25. Width
26. Height
27. SKU
28. Products attributes
29. Backorders standing
30. Manage stock standing
31. Tax status
32. Sales price
33. Common price
34. Virtual status
35. Downloadable standing
36. Overall sales
37. Visibility
38. Stock standing
39. Thumb ID
40. Complete Image URL
41. Gallery photographs IDs
42. Gallery images URLs
43. Tags
44. Customized attributes
45. All attributes that have been introduced by way of the Woocommerce attribute supervisor
46. WPML language display name
47. Yoast WEB OPTIMIZATION Name
48. Yoast WEB OPTIMIZATION Meta Description
49. Yoast WEBSITE POSITIONING Fb Title
50. Yoast WEB OPTIMIZATION Fb Description
51. Yoast WEB OPTIMIZATION Facebook Image
52. Yoast WEBSITE POSITIONING Twitter Name
53. Yoast SEARCH ENGINE MARKETING Twitter Description
54. Yoast WEB OPTIMIZATION Twitter Symbol
55. Yoast SEARCH ENGINE OPTIMISATION Google+ Identify
56. Yoast WEBSITE POSITIONING Google+ Description
57. Yoast SEARCH ENGINE MARKETING Google+ Symbol
58. Yoast SEO Custom Index Status
59. Yoast WEB OPTIMIZATION Focus KW
60. WC Vendors plugin seller commision
61. WC Providers plugin seller identity
62. WC Companies plugin vendor nicename
63. WooCommerce Manufacturers plugin emblem IDENTIFICATION
64. WooCommerce Brands plugin logo title

Other options

• Version: Really Useful is XLSX. Although XLS is compatible with older variations of Excel, it produces bigger recordsdata and can handiest hold 65535 data/rows.
• Caching Means: Really Useful is sqlite3. Please read for additional info
• Merchandise in line with batch: Recommended is ONE HUNDRED. In The Event You get products skipped or the produced files have issues please lower the quantity or ask your web hosting to increase the resources or change website hosting carrier. In The Event You assume that your hosting can do it, you can also increase the quantity.
• Sign Up For persona(s) for the kinds path: Personality to enroll in categories names for the categories trail.

Developer Pleasant

you'll be able to upload new customized fields which are already for your products data to be exported by means of a filter out, eg.

add_filter( 'wooxls_exportfields_filter', 'my_woocommerce_product_meta'); function my_woocommerce_product_meta($wooxls_exportfields) standing', 'wooxls'); go back ($wooxls_exportfields); }

Requirements

• WordPress 3.8+
• Woocommerce 2.1, Woocommerce 2.2, Woocommerce 2.3, Woocommerce 2.4
• PHP 5.2
• PHP extension php_zip enabled
• PHP extension php_xml enabled
• PHP extension php_gd2 enabled (if no longer compiled in)

Commonly Asked Questions

1. The Information on my XLS is extraordinary on my Excel 2003

   Please use open, make a choice the report you've got downloaded, from the open button at the backside-proper click the arrow down and choose “open and repair”. If an issue pop up please select “No”.
   
   

2. Am I Able To add my custom meta information field to export?

   Please test the segment For Developers.
   
   

3. Will I have the option to import the data of an XLS with this plugin?

   No, this plugin will most effective Export the Woocommerce products knowledge to XLS. on the other hand WP All Import plugin may have the ability to do this via adding with the addon: https://wordpress.org/plugins/woocommerce-xml-csv-product-import/
   
   

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

   No, this plugin will most effective export the pictures ids and/or urls of your Woocommerce products in a separate column.
   
   

5. How can i open an XLSX file on my Place Of Job 2003?

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

Set Up

This wordpress plugin can also be installed as every other wordpress plugin. Set Up is understated.

1. Extract the zip record you will have downloaded.
2. Login on your management panel (ex. http://www.yourdomain.com/wp-admin).
3. Go To Plugins -> Upload New.
4. On The best of the page click the “Upload Plugin” link
5. Click On choose report (or what your browser uses to navigate to your recordsdata)
6. From the extracted files of step one (1) navigate to and choose woo-products-xls.zip and click on “Set Up Now“
7. You could also be asked to make sure your want to set up the Plugin.
8. If this is the first time you’ve put in a WordPress Plugin, you may also need to input the FTP login credential knowledge. Should You’ve installed a Plugin ahead of, it's going to still have the login information. this information is out there via your internet server host.
9. Click On Continue to proceed with the deploy. The resulting deploy reveal will listing the deploy as a success or notice any issues in the course of the set up.
10. If successful, please click on Turn On Plugin to activate it.

Changelog

0.5.8 05/24/2016

• Replace the PHPExcel magnificence
• Introduced PHP 7 compatibility
• Best revealed products will likely be exported

0.5.7 10/22/2015

• Set default cellphone kind to thread

0.5.6 10/01/2015

• Added WooCommerce Manufacturers by proword beef up
• Introduced yet another clear out at the xls export

0.5.5 04/21/2015

• Introduced some filters on the output of the cell

0.5.4 04/17/2015

• Delivered product URL/hyperlink box
• Delivered Yoast Twitter and Google+ fields enhance

0.5.3 04/15/2015

• Delivered approach to exclude simple and/or variable products

0.5.2 04/14/2015

• Delivered WC Vendors plugin strengthen
• Brought categories titles path column

0.5.1 03/22/2015

• Delivered WordPress SEARCH ENGINE OPTIMISATION by means of Yoast enhance

0.5.0 03/18/2015

• Added caching possibility
• Delivered version option
• Brought products in line with batch possibility
• Fastened jQuery trojan horse that prevented plugin to continue whilst skipping merchandise

0.4.0 03/02/2015

• Modified the way XLS is produced through the use of AJAX.
• Many UI/UX improvements.

0.3.2 02/ELEVEN/2015

• Introduced WPML beef up. Now you'll export the language of the product.

0.3.1 ELEVEN/08/2014

• Minor bug repair

0.3 11/06/2014

• Introduced product tags

0.2

• Introduced technique to export the whole featured image url
• Introduced solution to export all photographs urls of the product gallery

0.1

• Preliminary free up

Sources and Credits

This plugin uses the next libraries

• PHPExcel

FULL DOWNLOAD