Woocommerce Export Products to XLS

Plugin to export products to XLS spreadsheet.

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. We will NOT refund your purchase, because you thought the plugin will do things it does not do.

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

Below are the fields that are available by default

1. Product ID
2. Product author ID
3. Product publish date
4. Product description - content
5. Product Title
6. Excerpt
7. Status
8. Slug
9. Modified date
10. Parent product ID
11. guid
12. Category IDs
13. Categories title
14. Categories titles path
15. Stock (quantity)
16. Sold individually
17. Price
18. Sales price date to
19. Sales price date from
20. Tax class
21. Purchase note
22. Featured
23. Weight
24. Length
25. Width
26. Height
27. SKU
28. Products attributes
29. Backorders status
30. Manage stock status
31. Tax status
32. Sales price
33. Regular price
34. Virtual status
35. Downloadable status
36. Total sales
37. Visibility
38. Stock status
39. Thumb ID
40. Full Image URL
41. Gallery images IDs
42. Gallery images URLs
43. Tags
44. Custom attributes
45. All attributes that have been added via the Woocommerce attribute manager
46. WPML language display name
47. Yoast SEO Title
48. Yoast SEO Meta Description
49. Yoast SEO Facebook Title
50. Yoast SEO Facebook Description
51. Yoast SEO Facebook Image
52. Yoast SEO Twitter Title
53. Yoast SEO Twitter Description
54. Yoast SEO Twitter Image
55. Yoast SEO Google+ Title
56. Yoast SEO Google+ Description
57. Yoast SEO Google+ Image
58. Yoast SEO Custom Index Status
59. Yoast SEO Focus KW
60. WC Vendors plugin vendor commision
61. WC Vendors plugin vendor id
62. WC Vendors plugin vendor nicename
63. WooCommerce Brands plugin brand ID
64. WooCommerce Brands plugin brand name
65. ACF (Advanced custom fields)

Other options

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

ACF (Advanced custom fields) support

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.