WooCommerce Customer / Order CSV Export

Overview ↑ Back to top

The WooCommerce Customer / Order CSV Export extension exports your site’s customers and orders into a CSV file. Export individual orders, multiple orders with a bulk action, or even all orders with the bulk export tool. Customers can be exported via the manual export tool as well.

Orders and customers can be automatically exported to CSV and uploaded to a remote server via FTP, HTTP POST, or sent via email, which is helpful for fulfillment systems that require automated uploads. Export processes take place asynchronously on your site, meaning you can export thousands of records at once, and you can continue with site management while your export happens in the background.

This plugin requires WordPress 4.4 or newer to export data from WooCommerce.
Working on customizations? Developers, you can find developer documentation here.

Sample CSV Files ↑ Back to top

You can use a built-in export format for your order or customer records, or you can create a custom format for your CSV file by selecting which information should be included.

Below are some sample CSV files generated by the extension so you can see the built-in export formats available and compare formats. You can download a sample file from Google Sheets by clicking “File > Download as > CSV”, or copy these to your own Google Sheet to modify.

Legacy Formats represent formatting for all versions prior to 3.0. Legacy order format samples are not included here, as we recommend using a newer format since these will be removed from the plugin in the future.

Installation ↑ Back to top

  1. Download the extension from your WooCommerce dashboard
  2. Ensure your store uses WordPress 4.4 or newer.
  3. Go to Plugins > Add New > Upload and select the ZIP file you just downloaded
  4. Click Install Now, and then Activate
  5. Click the Configure link, or go to WooCommerce > CSV Export, and read the next section to learn how to setup and configure the plugin.

Export Processing ↑ Back to top

Both order and customer CSV exports are processed asynchronously in the background on your site. This means that you can begin an export, and it will process as you continue to work on other things. These exports are batch-processed to prevent timeouts, letting an export churn through thousands of records while you continue working on your site. You can even leave your site completely and exports will continue to process, waiting for you to return to download them.

If you start a manual export, you’ll be notified of it beginning, and can wait for the process to complete if desired. Typically for exports of a couple hundred rows or less, this process will occur quickly (less than 10 seconds).

WooCommerce Customer / Order CSV Export process started

If you wait for the export process to complete, your file download will begin automatically, and you’ll see a notification that the process has completed.

WooCommerce Customer / Order CSV Export - export process completed

If you don’t want to wait for the export, that’s okay too! You can leave the page to continue working, or leave the site completely. As soon as the export has completed, you’ll receive a notification that your file is ready, and can be downloaded from the “Exports List”. If you’ve left the site, this will be shown to you upon your return.

WooCommerce Customer / order CSV Export job completed notice
Export completed notice

You can then access any manually or automatically-generated file export from the “Exports List” to download or transfer it. You’ll also see jobs in progress or queued if they’re ready to begin, and see the transfer status of automatic exports.

WooCommerce Customer / Order CSV Export Export List
Export list

This list will keep export records for 14 days, after which they’ll automatically be removed.

If your site is not capable of processing exports in the background, this is due to your hosting configuration, and you’ll need to reach out to your hosting provider to resolve this. You’ll see a notice on the plugin settings to inform you of this.

WooCommerce Customer / Order CSV Export: batch processing required notice

You will not be able to process automated exports if your host does not support background processing. In the meantime, you can enable the “Batch Processing” setting. This will require you to stay on the page for manual exports, but will provide an alternate way of exporting orders and customers until your host resolves background processing on the site.

Custom Export Formats ↑ Back to top

Both customer and order CSV exports can allow you to set a custom export format, or use a built-in format instead. Custom formats are useful if you need to re-order columns, remove columns, or add columns for order or user meta. You can then use this format for your manual and automatic exports.

To use a custom format, be sure this format is selected under the “Export Format” settings for orders or customers.

WooCommerce Customer / Order CSV Export: select custom export format

You can view your custom formats settings from WooCommerce > CSV Export > Columns, and switch between the “Orders” and “Customers” section to customize your format.

WooCommerce Customer / Order CSV Export build custom format
Build Custom Format

You can build this format manually, or you can click Load Column Mapping in the bottom-right corner. This will let you load one of the pre-built order or customer formats as a starting point, which you can then modify.

WooCommerce Customer / Order CSV Export load column mapping
Load built-in column layout

Custom Meta Keys

You can add columns for meta to both custom order and customer formats (advanced usage). This can let you add dedicated columns for order meta, or for user meta in customer exports.

You must know the correct meta key for the data and use it when adding a column for meta.

If you’re not sure, running an export with “add all meta” enabled will add columns for each meta key, which should help you determine the meta key for the data you want (it will be the column name).

WooCommerce Customer / Order CSV export: add custom meta columns
Add Custom Meta columns

Static Values

You can also add columns for static information to custom order and customer formats, which will allow you to add blank columns, or columns with a set value for all rows, such as store name.

To add a static value, select “Static value” for the data source, then enter the information that should appear in each row of the export.

WooCommerce Customer / Order CSV Export: Static value
Add static values

Custom Export Format Settings ↑ Back to top

The custom export formats do have some settings you can configure as well.

Setting Export Type Description
A row represents Orders Choose whether a row in the CSV file should represent an order, or a single item purchased (will use multiple rows for an order if it contains multiple items).
Items columns should use* Orders Choose whether cells for items (line items, shipping items, fee items, etc) should use a pipe-delimited format, or a JSON format.*
CSV delimiter Orders + Customers Select the delimiter the CSV file should use. If you’re not sure, choose “comma”.
Include all meta Orders + Customers Enable this to add all order or user meta to the export, one column per meta key (this will include hidden meta)

*The cell will use your selected format for all items.
JSON Example (typically used in the built-in Order CSV Import format)

[{"product_id":99,"product_name":"Woo Album","quantity":1,"total":19.99}]

Pipe-delimited (typically used in the built-in Order CSV default formats)

product_id:99|sku:woo-album|name:Woo Album|quantity:1|total:19.99

Order Export Settings ↑ Back to top

Go to WooCommerce > CSV Export > Settings > Orders to configure order export settings and optionally setup your FTP, HTTP POST, or email export information for automated exports.

WooCommerce Customer / Order Export order settings

Export Format Settings (Orders) ↑ Back to top

  • Export Format – Change the format for your order exports. The export formats are:
    • Default – This format uses one order per row with pipe-delimited item cells. This is compatible with many other plugins automatically.
    • Default: One Row Per Item – This format uses one row per item (multiple rows per order) with pipe-delimited item cells. This is compatible with many other plugins automatically. Please note this can also be considered as one row per line item. The number of rows is not affected by the quantity of items in an order.
    • CSV Import – This format matches the CSV Customer / Order / Coupon Import Suite format
    • Custom – This format will use the columns you’ve created under the “Custom” tab for the order export.
    • Legacy CSV Import – This format matches the CSV Import format prior to CSV Import v3.0.
    • Legacy – One Row per item – This format was used in the plugin prior to CSV Export version 3.0. We do not recommend using this format for new installations.
    • Legacy – Single Column for items – This format was used in this plugin prior to CSV Export version 3.0. We do not recommend using this format for new installations.

    You can view sample export files for formatting to choose the best export format for your needs.

  • Order Export Filename – Change the name of the filename that is exported. You can use %%timestamp%% to represent the date / time (in YYYY_MM_DD_H_S format), and %%order_ids%% to include a dash-separated list of the order IDs exported in the file.
  • Add Order Notes – Enable this to add a note to orders when they’re exported. This note will only be added the first time an order is exported, and is not added for subsequent exports.
  • Batch Processing – Uses batch processing for manual order exports instead of processing these asynchronously. Can be used when background processing is not supported, but requires you to keep the page open while running an export.

You can also determine if you’d like to set up automated order exports from this settings.

Automated Export Settings (Orders) ↑ Back to top

WooCommerce Customer / Order CSV Export Email Settings

  • Automatically Export Orders – Select an auto-export method to automatically export un-exported orders on the recurring interval set. Auto exports only include “new” (non-exported) orders with each run.
  • Trigger Automatic Export – Determine whether auto-exports should happen for each order after it’s marked “paid”, or if exports should happen on a defined schedule.
  • Export Start Time – (If exports are scheduled) Choose the start time for automatic order exports. The next export will run at the chosen time and continue on the recurring interval set.
  • Export Interval – (If exports are scheduled) Choose the interval for automatic order exports. The default is 30 minutes.
  • Order Statuses – Select the order statuses that should be automatically exported. For example, if you only want processing and completed orders to be exported, use the multi-select box and click on “Processing” and “Completed”. Leave this blank to export new orders with any status.
  • Product Categories – Select product categories for automated exports. This will only include orders that contain products from the selected categories. Leave this blank to export new orders with any product category.
  • Products – Select products for automated exports. This will only include orders that contain the selected products. Leave this blank to export new orders with any product.

Email Settings (Orders)

  • Recipient(s) – Enter recipient email address(es) to receive the CSV export. Separate multiple addresses with commas. Defaults to site admin email.
  • Email Subject – Enter the subject of the Export email. Defaults to [Store Name] Order CSV Export.
  • Test – Once you save your email settings, you can send a test email with a dummy CSV file to check your settings.

Local Exports (Orders)

Local auto-exports have no specific settings; these files are generated and simply saved for 14 days in your “Export List” without being transferred.

WooCommerce Customer / Order CSV Export; local auto-export

FTP Settings (Orders)

WooCommerce Customer / Order CSV Export FTP Settings

  • Server Address – Enter either an IP address or hostname for the FTP server
  • Username – Enter the username for the FTP server
  • Password – Enter the password for the FTP server
  • Port – Enter the port to connect to for FTP. This should be port 21 for regular FTP, 22 for SFTP, and 990 for FTP with Implicit SSL
  • Initial Path – Enter the initial path to change to before uploading the export file. The initial path already includes a leading slash so do not include one. It does require trailing slash. For example, to upload to a “test” folder, you would enter test/. If you are connecting via SFTP, the initial path needs to be a full path to the folder if the username you are connecting with does not default to the HOME directory
  • Security – Choose the type of security for the FTP server. Ask your FTP provider if you’re unsure what to select.
  • Passive Mode – Enable this to turn on passive mode for FTP connections. This should be unchecked unless you are having issues connecting, especially if you are seeing the “PORT command successful” message followed by a timeout in the error log

HTTP POST Settings (Orders)

  • HTTP POST URL – Enter the URL to which you want to POST the exported CSV.

WooCommerce Customer / Order CSV Export HTTP POST settings

Customer Export Settings ↑ Back to top

Go to WooCommerce > CSV Export > Settings > Customers to configure customer export settings and optionally setup your FTP, HTTP POST, or email export information for automated exports.

WooCommerce Customer / Order Export customer settings
Customer export settings

Export Format Settings (Customers) ↑ Back to top

  • Customer Export Format – Select the format for your customer exports. The export formats are:
    • Default – This format includes basic customer information, such as ID, billing information, and shipping information.
    • CSV Import – This format matches the Customer / Coupon / Order CSV Import plugin’s customer import format.
    • Custom – This format will use the columns you’ve created under the “Custom” tab for the customer export.
    • Legacy – This format was used in the plugin prior to CSV Export version 3.0. We do not recommend using this format for new installations.
  • Customer Export Filename – Change the name of the filename that is exported. You can use %%timestamp%% to represent the date / time (in YYYY_MM_DD_H_S format).
  • Batch Processing – Uses batch processing for manual order exports instead of processing these asynchronously. Can be used when background processing is not supported, but requires you to keep the page open while running an export.

Automated Export Settings (Customers) ↑ Back to top

WooCommerce Customer / Order CSV Export: customer auto email export

  • Automatically Export Customers – Select an auto-export method to automatically export un-exported customers on the recurring interval set. Auto exports only include “new” (non-exported) customers with each run.
  • Export Start Time – (If exports are scheduled) Choose the start time for automatic customer exports. The next export will run at the chosen time and continue on the recurring interval set.
  • Export Interval – (If exports are scheduled) Choose the interval for automatic customer exports. The default is 30 minutes.

Email Settings (Customers)

  • Recipient(s) – Enter recipient email address(es) to receive the CSV export. Separate multiple addresses with commas. Defaults to site admin email.
  • Email Subject – Enter the subject of the Export email. Defaults to [Store Name] Order CSV Export.

Local Exports (Customers)

Local auto-exports have no specific settings; these files are generated and simply saved for 14 days in your “Export List” without being transferred.

WooCommerce Customer / Order CSV export local auto export - customers

FTP Settings (Customers)

WooCommerce Customer / Order CSV Export customer FTP Export settings

  • Server Address – Enter either an IP address or hostname for the FTP server
  • Username – Enter the username for the FTP server
  • Password – Enter the password for the FTP server
  • Port – Enter the port to connect to for FTP. This should be port 21 for regular FTP, 22 for SFTP, and 990 for FTP with Implicit SSL
  • Initial Path – Enter the initial path to change to before uploading the export file. The initial path already includes a leading slash so do not include one. It does require trailing slash. For example, to upload to a “test” folder, you would enter test/. If you are connecting via SFTP, the initial path needs to be a full path to the folder if the username you are connecting with does not default to the HOME directory
  • Security – Choose the type of security for the FTP server. Ask your FTP provider if you’re unsure what to select.
  • Passive Mode – Enable this to turn on passive mode for FTP connections. This should be unchecked unless you are having issues connecting, especially if you are seeing the “PORT command successful” message followed by a timeout in the error log

HTTP POST Settings (Orders)

  • HTTP POST URL – Enter the URL to which you want to POST the exported CSV.

Manual Exports ↑ Back to top

Both orders and customers can be exported manually at any time. Any manually-triggered export will still be processed asynchronously unless you’ve enabled Batch Processing in the settings. Manual exports will be available in the export list when the export has been processed. If the export happens asynchronously, you can wait for the file to download, or continue working until you get a “job completed” notice.

The bulk export tool lets you export several orders or customers at once. You can access the bulk export tool via WooCommerce > CSV Export > Export and selecting “Orders” or “Customers” for your export type.

When exporting customers, you can export all customers, or select a start and end date range to get customers whose registration / first purchase was in the given date range.

WooCommerce Customer / Order CSV Export: customer bulk export
Export Tool: Customers

When exporting orders, you have more options to configure to get the order list you need.

WooCommerce Customer / Order CSV Export: orders export tool
Export Tool: Orders
  • Order Statuses – Select the order statuses that should be exported. For example, if you only want processing and completed orders to be exported, use the multi-select box and click on “Processing” and “Completed”. Leave this blank to export orders with any status.
  • Product Categories – Select product categories for the export. This will only include orders that contain products from the selected categories. Leave this blank to export orders with any product category.
  • Products – Select products for the export. This will only include orders that contain the selected product(s). Leave this blank to export orders with any product.
  • Start Date – Enter a start date for the export. This will only include orders placed after the start date. Leave blank to include all orders.
  • End Date – Enter an end date for the export. This will only include orders placed before the ned date. Leave blank to include all orders.

Finally, if WooCommerce Subscriptions is enabled, you’ll see a Subscriptions Options section added. This will allow you to export subscription orders, renewal orders, or both without any “regular” orders included. This does not export subscription records from the “Subscriptions” list; this is more like an “order filter” for subscription purchases instead.

WooCommerce Customer / Order CSV Export Subscriptions export options

Order Export Actions ↑ Back to top

You can also trigger order exports from your Orders list. The “export” action will let you quickly export an un-exported order, while the “bulk export” action for orders will export all selected orders.


WooCommerce Customer / order CSV Export download action
Single Order Export action


WooCommerce Customer / Order CSV Export: order bulk actions
Order bulk actions

While viewing a single order, you’ll also have a “download CSV” action for the order.

WooCommerce Customer / Order CSV Export order single actions

Customer Export Actions ↑ Back to top

Customer exports can be triggered from the WordPress “Users” list, letting you export a list of customers via bulk action (helpful if you want to export for a certain user role).

WooCommerce Customer / Order CSV Export customer bulk export

Manual Transfers ↑ Back to top

Order and customer bulk actions, along with order single actions, will allow you to select an “Export to CSV via {method}” action if you have auto-exports configured. This can let you manually trigger an FTP, Email, or HTTP POST transfer for the selected order(s).

Transfers can also be initiated from the “Export List” for a previous export.

Automatic Exports ↑ Back to top

If background processing is not available on your site, note that you’ll see an error message, and that automated exports will not process.

Both orders and customers can be exported via Email, FTP, or HTTP POST on a schedule. To configure your automatic export settings, please see our notes on order auto-export settings or customer auto-export settings.

Here are some important notes about automated exports, which address common questions:

  • Orders that were placed before the plugin was installed & activated will not be automatically exported. They can be marked as “exported” using the bulk action.
  • For automated exports, only “new” records will be exported. For orders, this means any order that does not have the “Export Status” as “exported”.
    WooCommerce Customer / Order CSV Export Status
    Export Status

    For customers, this means only new purchasers or newly registered users are included in automated exports (customer export status is hidden).
  • Timezones: Please note that the exports happen in the same timezone as you’ve set for the WordPress site. If the site timezone is set to New York (EST) and the export time is set to 9:30am, the exports happen in the same timezone as the site.
  • Auto-exports should always be tested once configured to confirm dummy files reach their destination successfully using the “Test” actions.

Export Schedules ↑ Back to top

The plugin relies on WP-Cron to help it schedule the automated export jobs. This is the established way of performing recurring tasks with WordPress. Unfortunately, the WP-Cron system is not always 100% accurate – it requires constant traffic to your site in order to trigger events at the proper times.

There are two suitable workarounds for the accuracy issue:

  1. Setup a real system cron on your server that ensures WP-Cron is triggered every minute – this article explains how to do this.
  2. Use a service like Pingdom, UptimeRobot, etc to ping your site every few minutes – this FAQ section details how to do this.

Your hosting provider should be able to help you with workaround #1, which would be the ideal if your hosting allows it. This is guaranteed to solve the issue with random times.

Transfer Monitoring ↑ Back to top

When automated exports are configured, the plugin will track the transfer status of each automated export under the Export List. If transfers fail, any site user who can manage WooCommerce (typically admins and shop managers) will be notified of transfer failures so they can be retried from this list.

WooCommerce Customer / Order CSV Export transfer warnings

If several failures occurs consecutively, you’ll be notified so that logs and settings can be checked to ensure the automated export set up is correct.

Testing Auto-Exports ↑ Back to top

If you’re looking to test automatic exports or debug them, we recommend using a service like RequestBin, which will allow you to test the HTTP POST option. You can create a new bin and use the plugin’s “Test” option to send data for debugging.

You can also test the export scheduling using the WP Crontrol plugin. This lets you view all cron events along with their arguments, recurrence, and when they are next due.

Compatible Plugins ↑ Back to top

This list is not exhaustive, but here are some of the plugins that are known to be compatible with the WooCommerce Order / Customer CSV Exporter. Just because a plugin may be missing from this list does not mean that it won’t be incompatible with the CSV Exporter. You can also read up on customizing your CSV output for compatibility with other extensions.

Columns are automatically added for plugins in this list; they are compatible out-of-the-box.

Extension Columns Added Notes
Admin Custom Order Fields admin_custom_order_field*
* column name appends name/id of each field
value/option for custom field
AvaTax vat_id
tax_exemption*
*customer exports only
customer VAT ID and tax exemption status code
Checkout Add-ons checkout_add_on*
checkout_add_on_total*
* column name appends name/id of each add-on
value/option for add-on field
associated cost for option(s) selected
Checkout Field Editor field_name*
* column name is generated from the field name
value for custom field
Cost of Goods order_cost_total
total_cost
item_cost
the total cost for the order
the total cost for the line item
the individual cost for the item
Customer / Order / Coupon CSV Import Suite N/A Must use CSV Import-compatible format in Exporter settings
Sequential Order Numbers Pro order_number
order_number_formatted
uses SONP order number
Shipment Tracking tracking_provider
custom_tracking_provider
tracking_number
custom_tracking_link
date_shipped
Automatically adds support for these fields in exports when both plugins are activated and in use.
WooCommerce Subscriptions* N/A Can export subscription or renewal orders only

Refunds

This plugin is also compatible with refunds while using one of the default export formats (or if manually included in a custom format). Each order will display a refunded_total column, which will display the total amount refunded in the order, as well as an item_refunded column, which will display the total refunded for a particular item in the order.

* Subscriptions

Note that this plugin is compatible with Subscriptions, but is not a subscriptions exporter. When Subscriptions is active, you can choose to export subscription or renewal orders only as a sort of filter on which orders to export. This does not export subscription data for you to then import your subscriptions into a new site.

Incompatible Plugins ↑ Back to top

There are very few plugins that are fully incompatible with the order exporter, but here are some known issues with other plugins.

  • Product Add-ons is not fully compatible with this export plugin. While add-on data will be displayed in line item meta when exported, dedicated compatibility to show add-ons separately for each line item will not be included.
  • WooCommerce Bookings version 1.10.0 and newer changes the way booking data is related to an order. Because the booking data is no longer part of the order or order item data, bookings will not be exported automatically.

Troubleshooting ↑ Back to top

Having trouble? Please ensure your site uses WordPress 4.4 or newer, then check out these sections or the FAQ below.

Exports Remaining Queued ↑ Back to top

Using WordPress.com? Please review this troubleshooting step.

Exports are done as a background, asynchronous process, that requires your site to make requests to itself for information. As such, your site cannot block HTTP requests or exports will not begin to process. If your exports freeze without completing, your site may be blocking HTTP requests in some way.

Please check the following common causes of blocked requests:

  • If your site is hosted with WordPress.com, please ask them to check the length of the options table in your database. When setting up WooCommerce on WordPress.com, they must change your site’s database; sometimes this limit is outdated at 64 characters, when it should be 255 characters (as of WordPress 4.4). They may need to fix this limit so that export jobs save properly. If WordPress.com confirms that the limit is 255 characters, please get in touch with our help desk.
  • Are you using a maintenance mode or blocking plugin? For example, the “Airplane Mode” plugin for developers will block HTTP requests. Please disable the maintenance mode plugin to process exports.
  • Similarly, if your site is behind BasicAuth, background requests will fail to complete. For example, WP Engine staging sites often use basic authentication to block site access (you see a popup for credentials when you try to access the site):
    Basic Authentication
    Please see the notes here to correct this issue, or disable basic authentication while testing exports.
  • Finally, some hosts will block the requests from servers to themselves. You can test this by going to WooCommerce > Status > Tools. The plugin will add a tool called “Background processing test”, which will simulate the export process:
    WooCommerce Background Processing Test Tool

If this tool returns an error, this means that your host won’t allow requests from your site’s server (the plugin) to itself to start processing a file (sometimes called a “loopback connection”). Your host must enable this for exports to work.

While some hosts may note that this is a security issue, there is no security threat to using a loopback connection; if done incorrectly, it could increase server usage, but quality hosts will combat this for you with intelligent rate limiting.

More importantly, many features in WooCommerce or upcoming features need loopback connections to function: for example, the database updater (already in use) and future plans for backgrounded email sending; both of which uses the same type of background processing (and requires loopback connections). It’s essential that a host for an eCommerce site support this.

Slow exports or out-of-memory errors ↑ Back to top

If you’re running into slow exports or out-of-memory errors, please contact your hosting provider to double-check that the the MySQLi extension is installed on your server and that WordPress is using it. In rare cases, the extension is already installed but is not being used by WordPress, but this can be easily remedied by adding define( 'WP_USE_EXT_MYSQL', false ); to your wp-config.php file.

With the introduction of the database data store in v4.5.0, the plugin now defaults to streaming exports to their destination whenever possible, rather than sending an entire file at once. This increases server efficiency and reduces the likelihood of out-of-memory errors, especially when downloading very large exports. This new feature requires the MySQLi extension to be enabled and be used by WordPress.

Other Issues ↑ Back to top

Seeing other issues? Please follow these steps to make sure everything is setup correctly before posting a support request:

  1. Having trouble adding custom meta columns? Please ensure your meta keys are correct.
  2. Custom format not working? Please ensure that “custom” is selected for the desired export to put your custom column mapping in action.
  3. If this is a different issue with automatic exports, please:
    • Check that your FTP, HTTP POST, or email information is correct
    • Double-check that your Export settings are correct 😉 — especially port settings for FTP
    • Review our Export Schedules section, which explains the most common scheduling issues, along with our information on testing procedures.
  4. If this is an issue with non-English or non-standard characters, please see our UTF-8 FAQ below.
  5. If you’re seeing one column when exporting to Excel, please view this FAQ.
  6. Review the plugin log under WooCommerce > System Status > Logs. If this doesn’t help you resolve the issue, submit a support ticket, with the log as an attachment.

Frequently Asked Questions ↑ Back to top

Q: Why aren’t all of my customers exported?
A: Customers must have at least one order before they will be considered an export-able “customer.” Please note that if you use WordPress 4.4 or newer, your employees (administrators and shop managers) are excluded from customer exports as well, so if you purchased a test order, you may not see yourself in the export file.


Q: What happens to the leading zeroes in my exports when opened in Excel? For example, zip codes with leading zeroes are shortened.
A: Excel hides leading zeroes by default. This is most common with ZIP codes like 02111 – Excel will display 2111 and hide the first zero. However, the export does include the full ZIP and all leading zeroes. In order to force Excel to show this, you must format the column as “text”.


Q: Why do all of my foreign or special characters get messed up when I view this document in Excel?
A: We need to force Excel to use UTF-8 encoding to render these properly. Add this code snippet to your site to do so:

add_filter( 'wc_customer_order_csv_export_enable_bom', '__return_true' );

Please note that Excel for Mac does not support UTF-8 characters, so your CSV Exports may garble any special or accented characters in your order or customer data.

Unfortunately, the best option here would be to use an alternate application to view the CSV exports. Some alternatives include:


Q: Will exported orders also show refunded totals?
A: They can, but only if you’re using one of the default format (or a custom format that includes refunds). See our info on refunds for more information.


Q: Can I rely on the column ordering for my exported CSVs to always be the same?
A: Unfortunately no — We strongly recommend not relying on the column ordering for the generated CSV. While we do our best to not change column ordering, sometimes we must do so and this will break any integrations that rely on a specific order. Instead, use the column names / ids, which are guaranteed to never change.


Q: I can’t seem to duplicate a column. Is this possible?
A: No, you cannot currently duplicate a source column, as we remove all duplicate sources. This is because the columns are used as keys for the column header. As such, this isn’t currently a possiblity, unfortunately.


Q: Excel shows all of my data in one column. How do I separate the columns?
A: It is likely that your computer is configured to use a different CSV delimiter than the standard comma (,). In most cases the alternative delimiter is a semicolon (;).

You can change the delimiter used by the Customer/Order CSV Export extension by adding this code snippet:

function sv_customer_order_csv_export_delimiter( $delimiter ) {
    return ';';
}
add_filter(  'wc_customer_order_csv_export_delimiter',  'sv_customer_order_csv_export_delimiter' );

Alternatively, you can configure your OS installation to use a comma as the default delimiter:

For Windows Users:

To change the default separator in your Windows installation:

  1. Click the Windows Start menu.
  2. Click Control Panel.
  3. Open the Regional and Language Options dialog box.
  4. Click the Regional Options Tab.
  5. Click Customize.
  6. Type a new separator in the List separator box.
  7. Click OK twice.

For Mac Users:

The default CSV delimiter in Mac is dependent on your number separator settings. By default, the Mac is setup to use a period as the decimal separator which also sets the CSV delimiter to a comma. However, if you use the comma as a decimal separator, then Mac OS will default to using the semicolon (;) for the CSV delimiter.

To change the CSV delimiter to a comma:

  1. Open System Preferences
  2. Click Language & Region
  3. Click Advanced …
  4. Change the Number Separators by setting the Grouping to a comma (,) and the Decimal to a period (.)

Q: How do I remove the Export Status column on the orders page?
A: You can easily hide this column (and any columns on your Orders / Products pages!) by going to “Screen Options” at the top right of your page and disabling the “Export Status” column.

WooCommerce Order / Customer CSV Export Status Disable

Questions & Support ↑ Back to top

Have a question before you buy? Please fill out this pre-sales form.

Looking for developer documentation? You can view it here.

Already purchased and need some assistance? Please check out our troubleshooting tips for common issues, or get in touch with support via the help desk if you require further assistance.

WooCommerce - the most customizable eCommerce platform for building your online business.

Back to the top