How to export WooCommerce shipping addresses

Before you start

• Administrator access to WP admin
• The Customer / Order / Coupon Export extension active on the store
• A decision on which order statuses count as your shipping queue

Steps

1. Narrow the order list to the queue

   In WP admin, go to WooCommerce > Orders and filter to the statuses you ship.

   You should see processing and on-hold orders, and none of the completed ones.

2. Open the export settings

   In WP admin, go to WooCommerce > Export and select the Manual Export tab.

   You should see the Output type, Export type, Format, Filename and Mark as exported settings.

3. Set the output to an orders CSV

   On the Manual Export tab, set Output type to CSV and Export type to orders.

   You should see the options below changing to the ones that apply to orders.

4. Choose a format that carries the shipping fields

   In Format, pick a predefined format, or a custom format built to hold the shipping name, address lines, city, state, postal code, country and phone. The extension lets you create your own formats to determine which fields are included and where they are positioned.

   You should see a format selected by name rather than a default you have not read.

5. Limit the export to those orders

   In the Export Options section, target the orders you filtered rather than the whole store.

   You should see an export scoped to the queue, not to the year.

6. Run it and collect the file

   Select Export, then take the file from the dialog or from WooCommerce > Export > Export List.

   You should see a CSV whose row count matches the orders in your queue.

7. Check two addresses by hand

   In the file, compare the first and last rows against the same orders in WP admin.

   You should see the same recipient, street and postal code in both places.

If it goes wrong

Some rows carry the billing address

WooCommerce does not always hold a separate shipping address, and where one is absent the billing address is what you are looking at. That is fine for most orders and wrong for gifts and company purchases. Our guide on the WooCommerce shipping address versus the billing address covers where the fallback applies.

The format dropped a field you needed

A predefined format is a fixed field list, so a missing phone number or second address line is a format problem rather than an order problem. Build a custom format once and name it for the job, then the next export is a repeat rather than an investigation.

Orders vanished from the next export

Exported orders are marked as exported, which excludes them from future automated exports. If your address file is part of a nightly routine, check the Exported filter on the order list before assuming the queue was empty.

The state arrived as a code

WooCommerce stores states and countries as codes, so a label importer expecting names needs a mapping step. Check one row before you map 200, and keep the country column even for a domestic only store.

What happens next

An address file needs remaking every time the queue moves, which in a busy store is several times a day. A REST connection reads the same fields continuously instead, on a 10 to 15 minute poll with a 10 minute freshness floor per store, so the queue in front of you is minutes old rather than however old your last export is.