Below you can find information about common cases and issues, as well as how to better utilize the WooCommerce Customer/Order/Coupon CSV Export plugin.
Select a question to see its answer
Yes! This plugin is compatible with refunds while using one of the predefined formats or custom formats if the following fields are added:
refunded_total: The amount refunded in the orderItem_refunded: The total refunded for a particular item in the orderUsers must place at least one order before they will be considered “customers” and included in this export.
No, we automatically remove all duplicate sources because columns are used as keys for the column headers.
Sure thing! You can hide this column (and many others!) by going to the Screen Options pages at the top of these screens.
By default, Excel hides leading zeros. This is most common with ZIP codes like “02111” – Excel will automatically hide the first zero and display “2111”. However, the zero is included in the export – you can force Excel to show this by formatting the column as “Text”.
We’ll need to force Excel to use UTF-8 encoding to render these characters properly by adding this snippet to your site – please be sure you know how to safely add custom code to your site before adding this snippet:
add_filter( 'wc_customer_order_csv_export_enable_bom', '__return_true' );
Note: Excel for Mac doesn’t support UTF-8 characters, so your exports may not display accented or special characters properly. We recommend using a different application, such as:
It sounds like your computer is setup to use a different delimiter than the standard comma. In most cases, the alternative delimiter is a semicolon. You can change delimiters in your export format.
Unfortunately, the way that Product Add-Ons are stored on orders makes it nearly impossible to accurately get all add-ons for an order, so we do not support this for XML exports. However, we do have a code snippet available that should work for most stores, but please be sure you know how to safely add custom code to your site and test this thoroughly!
Absolutely! The defaults should work for most sites, but if you need to filter the character encoding, standalone definition, XML version, or other format definitions, you can do so using the wc_customer_order_export_suite_format_definition filter. Here’s a sample snippet to get you started – please be sure you know how to safely add custom code to your site before installing this snippet!
Article ID: 1532
Created On: Mon, May 10, 2021 at 3:10 PM
Last Updated On: Mon, May 10, 2021 at 3:10 PM
Online URL: https://www.heartinternet.uk/support/article/common-questions-about-the-woocommerce-customer-order-coupon-csv-export-plugin.html