Woocommerce Export Products to XLS

[ad_1]

To get this product on 50 % low cost contact me on this link

 

LIVE PREVIEWBUY FOR $19

Woocommerce Export Products to XLS

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

by:
Nitroweb

IMPORTANT! If you’ve gotten a number of merchandise (1000’s of merchandise), it is strongly recommended which you could set php reminiscence restrict to 256MB or larger.

Please learn the plugin description. We will NOT refund your buy, since you thought the plugin will do issues it doesn’t do.

Features

  • Can export 1000’s of merchandise and variations by utilizing AJAX know-how
  • Will export all merchandise, revealed or not
  • Will export Variations and Group Products
  • 53 fields supported by default
  • ACF (Advanced custom fields) assist
  • Will export predefined and customized attributes
  • Extensible / developer pleasant. You can add your customized fields through WordPress filter
  • Easy administration with drag n drop sorting
  • Caches the .xls information for future obtain
  • XLS output, not CSV
  • Compatible with MS Excel 2003, 2007, 2010, 2013
  • Supports WPML. You can export the language of the merchandise.
  • Supports WordPress search engine optimisation by Yoast plugin. You can export the Yoast search engine optimisation plugin information of the merchandise.
  • 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 title.

Usage

In order to use the Woocommerce export to XLS, please navigate out of your WordPress administration panel to “Woocommerce > Products to XLS

  1. Please test the information you need to export and drag the rows to order the columns of the exported XLS and click on “Save Changes”.

    save changes

  2. Then chances are you’ll export the chosen information to XLS by clicking the “Export to XLS” button.

    export xls

  3. A message might be displayed with the actions taken and on the underside of the message there might be a hyperlink to the file that has been simply created. Click on the hyperlink “Download Excel File” to obtain the XLS file.

    export xls output

Below are the fields which are out there by default

  1. Product ID
  2. Product writer ID
  3. Product publish date
  4. Product description – content material
  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 (amount)
  16. Sold individually
  17. Price
  18. Sales value date to
  19. Sales value date from
  20. Tax class
  21. Purchase notice
  22. Featured
  23. Weight
  24. Length
  25. Width
  26. Height
  27. SKU
  28. Products attributes
  29. Backorders standing
  30. Manage inventory standing
  31. Tax standing
  32. Sales value
  33. Regular value
  34. Virtual standing
  35. Downloadable standing
  36. Total gross sales
  37. Visibility
  38. Stock standing
  39. Thumb ID
  40. Full Image URL
  41. Gallery pictures IDs
  42. Gallery pictures URLs
  43. Tags
  44. Custom attributes
  45. All attributes which have been added through the Woocommerce attribute supervisor
  46. WPML language show title
  47. Yoast search engine optimisation Title
  48. Yoast search engine optimisation Meta Description
  49. Yoast search engine optimisation Facebook Title
  50. Yoast search engine optimisation Facebook Description
  51. Yoast search engine optimisation Facebook Image
  52. Yoast search engine optimisation Twitter Title
  53. Yoast search engine optimisation Twitter Description
  54. Yoast search engine optimisation Twitter Image
  55. Yoast search engine optimisation Google+ Title
  56. Yoast search engine optimisation Google+ Description
  57. Yoast search engine optimisation Google+ Image
  58. Yoast search engine optimisation Custom Index Status
  59. Yoast search engine optimisation Focus KW
  60. WC Vendors plugin vendor commision
  61. WC Vendors plugin vendor id
  62. WC Vendors plugin vendor nicename
  63. WooCommerce Brands plugin model ID
  64. WooCommerce Brands plugin model title
  65. ACF (Advanced customized fields)
Other choices
  • Version: Recommended is XLSX. Although XLS is appropriate with older variations of Excel, it produces enormousger information and may solely maintain 65535 information/rows.
  • Caching Method: Recommended is sqlite3. Please read for more information
  • Products per batch: Recommended is 100. If you get merchandise skipped or the produced information have points please decrease the quantity or inquire of your hosting to enhance the sources or change hosting service. If you suppose that your hosting can do it, chances are you’ll enhance the quantity.
  • Join character(s) for the classes path: Character to be part of classes names for the classes path.
ACF (Advanced customized fields) assist

You can have to add a rule to the ACF group that you really want to be out there for export like it’s demonstrated on the documentation. Only then the fields might be on the export listing so you possibly can choose them.

Developer Friendly

You can 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');
operate my_woocommerce_product_meta($wooxls_exportfields) {
  $wooxls_exportfields['_deprecated'] = __('Deprecated standing', 'wooxls');
  return ($wooxls_exportfields);
}

Requirements

  • WordPress 3.8+
  • Woocommerce 2.1 or later
  • 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

  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 repair”. If a query pop up please choose “No”.

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

    Please test the part For Developers.

  3. Will I give you the option to import the information of an XLS with this plugin?

    No, this plugin will solely Export the Woocommerce merchandise information to XLS.
    On the opposite hand WP All Import plugin could give you the option to do that by including 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 solely export the pictures ids and/or urls of your Woocommerce merchandise in a separate column.

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

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

Installation

This wordpress plugin will be put in as every other wordpress plugin. Installation is easy.

  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. At the highest of the web page click on the “Upload Plugin” hyperlink
  5. Click select file (or what your browser makes use of to navigate to your information)
  6. From the extracted information of the 1st step (1) navigate to and choose woo-products-xls.zip and click on “Install Now
  7. You could also be inquire ofed to verify your want to set up the Plugin.
  8. If that is the primary time you’ve put in a WordPress Plugin, chances are you’ll want to enter the FTP login credential info. If you’ve put in a Plugin earlier than, it’s going to nonetheless have the login info. This info is on the market via your net server host.
  9. Click Proceed to proceed with the set up. The ensuing set up display will listing the set up as profitable or notice any issues through the set up.
  10. If profitable, please click on Activate Plugin to activate it.

Changelog

0.6.0 08/18/2017
  • Feature: Added generic assist for all product taxonomies
  • Feature: Added filter on DB question
  • Feature: Added assist for WooCommerce Prices By User Role plugin by Festi-Team
  • Fix: Removed some deprecated Woocommerce operate notices
  • Fix: Removed string to array convertion deadly error
  • Fix: In some instances not revealed merchandise had been exported
0.5.9 01/17/2017
  • Feature: Added the choice to strip any HTML from the excerpt
  • Feature: Added the choice to set a customized filename
  • Feature: Added value fields with or with out tax
  • Feature: Added export to CSV assist
  • Feature: Moved information within the uploads listing
  • Feature: Added ACF (Advanced custom fields) assist
0.5.8 05/24/2016
  • Update the PHPExcel class
  • Added PHP 7 compatibility
  • Only revealed merchandise might be exported
0.5.7 10/22/2015
  • Set default cell sort to string
0.5.6 10/01/2015
  • Added WooCommerce Brands by proword assist
  • Added another 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 area
  • Added Yoast Twitter and Google+ fields assist
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 assist
  • Added classes titles path column
0.5.1 03/22/2015
0.5.0 03/18/2015
  • Added caching choice
  • Added model choice
  • Added merchandise per batch choice
  • Fixed jQuery bug that prevented plugin to proceed when skipping merchandise
0.4.0 03/02/2015
  • Changed the way in which XLS is produced by utilizing AJAX.
  • Many UI/UX enhancements.
0.3.2 02/11/2015
  • Added WPML assist. 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 complete featured picture url
  • Added choice to export all pictures urls of the product gallery
0.1
  • Initial launch

Sources and Credits

This plugin makes use of the next libraries

[ad_2]

To get this product on 50 % low cost contact me on this link

 

Source

Pomento
Logo
Register New Account
Reset Password
Compare items
  • Total (0)
Compare
0
Shopping cart