Skip to main content
Keep Your Business Open During COVID-19Learn More
Call us
Phone numbers and hours
Help Center

Explore our online help resources

Help

Managed WordPress Ecommerce Help

Common questions about the WooCommerce Customer/Order/Coupon CSV Export plugin

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.

Required: WooCommerce Customer/Order/Coupon CSV Export is a premium WooCommerce extension included with WordPress Ecommerce Hosting or as a standalone purchase.

Select a question to see its answer

Can I export refunds?

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 order
  • Item_refunded: The total refunded for a particular item in the order

(Back to top.)

There are users missing from my customer export. Where are they?

Users must place at least one order before they will be considered “customers” and included in this export.

(Back to top.)

Can I duplicate columns in my custom export format?

No, we automatically remove all duplicate sources because columns are used as keys for the column headers.

(Back to top.)

Can I remove the Export Status column from the Orders or Users pages?

Sure thing! You can hide this column (and many others!) by going to the Screen Options pages at the top of these screens.
how to deactive the customer/order/coupons export status from the WooCommerce orders and/or users page

(Back to top.)

Why are leading zeros (e.g. in a ZIP code) missing from my Excel export?

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

(Back to top.)

Why are the foreign / special characters not displaying correctly in Excel?

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:

(Back to top.)

How can I ensure that Excel won’t show all my data in one column?

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.

(Back to top.)

Can I separate Product Add-Ons in the XML file so they’re easier to find?

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!

(Back to top.)

Can I change the character encoding or XML version? My site uses special characters.

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!

(Back to top.)

More info