Importing orders from WooCommerce

Note: view our Zapier webhooks and import integrations for more ways to connect to your WooCommerce account, including our WooCommerce Zap import template with many common variables pre-filled for quick integration setup.

Planning optimized delivery routes using WooCommerce orders? Follow the steps below to export your orders from WordPress/WooCommerce, and import them into EasyRoutes for delivery route planning.

Note: The following steps were performed from a site powered by WordPress version 6.6.1, with the WooCommerce plugin version 9.1.4, and the Order Export & Order Import for WooCommerce plugin by WebToffee version 2.5.5. Workflow specifics may vary if using older or newer versions of any of the above.

Exporting from WooCommerce:

  1. From your WordPress dashboard, click the WebToffee Import Export (Basic) tab from the sidebar navigation menu, and access the Export page shown below.
  2. Select the Order item before clicking the button to proceed to Step 2:

WebToffee Import Export (Basic) Export page in WordPress, with an arrow at Export in the sidebar and Order and the Step 2: Select an export method button outlined

  1. Select Quick export from the export method selection screen, before clicking the button to advance to Step 3:

Export Order: Select an export method screen with Quick export selected and the Step 3: Advanced options/Batch export button outlined

  1. From the Advanced options screen, modify the Export line items setting to Separate rows (all other settings can be left in their default state as shown below) before clicking the Export button:

Export Order: Advanced options/Batch export screen with Export line items in set to Separate rows and the Export button outlined

  1. You'll be prompted to download the file, which will generate a CSV export and save it to your device's default download location.

Importing to EasyRoutes:

  1. Login to your EasyRoutes for Web account. Access the Orders page from the EasyRoutes sidebar navigation menu.
  2. Click the Import new CSV button found to the right of the map, below your active Route Options:

Orders page with an arrow pointing at the Import new CSV button, among the small buttons to the right of the map below the route options

  1. Click the Add file(s) button and select the CSV file exported from WooCommerce (or drag and drop the CSV file directly onto the button):

Import stops page, Step 1, with a CSV drop zone and the Add file(s) button highlighted in its centre

  1. Review the import preview (shown below) to ensure all imported variables are mapped to the proper column:
    1. If everything looks correct, click the Save button, and skip to Step #8 below.
    2. If something's not right, click the Edit stops button:

Import stops preview table listing three stops with their name, company and address columns, and the Edit stops, Cancel and Save buttons below

  1. After clicking the Edit stops button, you'll be able to configure which CSV column is mapped to which EasyRoutes variable. Ensure that variables are mapped as follows:

Column Title

Dropdown Selection
First name shipping_first_name
Last name shipping_last_name
Address shipping_address_1
Apartment, suite, etc. shipping_address_2
City shipping_city
Province/state/territory shipping_state
Postal code/ZIP code shipping_postcode
Country/region shipping_country
Email customer_email
Phone shipping_phone
Note customer_note
Order name order_id
Item quantity item_quantity
Item name item_name
Note: Additional order information that doesn't fit any of the mappings above can be mapped to the Tags field, and then used to filter orders by tags.  Order tags need to be comma-separated in the CSV file to import more than one per stop.
  1. Once all columns have been mapped, click the Next button in the upper right-hand corner of the page:

Import stops - 1 file page header, at Step 2: Select an import method and select the columns to import, with the Next button outlined

  1. Imported orders will be shown as pins on the map, with order details in the table below. Review the listed orders before clicking the Import and add orders button above the map:

Import stops Step 3 review page with three numbered pins on the map, the stops' details in a table below, and the Import and add orders button highlighted in the top-right corner

  1. Your imported orders will now be available as pins on the map, ready to route. Configure any desired Route Options using the controls to the right of the map. Click the Create route button above the map to generate an optimized delivery route containing your imported orders:

Orders page with two imported orders as pins on the map, the Route start, Route end and Routes to create options outlined, and an arrow pointing at the Create route button

Additional Resources:

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.