Importing orders from BigCommerce

Note: view our Zapier webhooks and import integrations for more ways to connect to your BigCommerce store.

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

Configuring BigCommerce exports:

Before exporting, you'll need to create a copy of the default BigCommerce order export template, and modify the following setting for maximum compatibility when exporting orders containing more than one product type:

  • Template Details tab > Advanced CSV Export Settings section > Sub Items setting: set to Create one row per sub item.

Save this updated template copy with a familiar name for quick access further along in the export workflow. Full details on editing templates for data export can be found in this BigCommerce support article.

Exporting from BigCommerce:

  1. From your BigCommerce dashboard, navigate to the Orders page from the sidebar menu:

BigCommerce dashboard with an arrow pointing at Orders in the sidebar menu, and the View orders page open

  1. Using the checkboxes, select the orders you'd like to export. Alternatively, use the order status navigation tabs at the top of the page to filter which orders are displayed:

    BigCommerce View orders page with the order status tabs (All orders, Awaiting Fulfillment and others) outlined, and two orders ticked with their checkboxes outlined

  2. From the Choose an action dropdown menu, select Export selected, then click the Confirm button beside it:

    BigCommerce orders list with Export selected chosen in the action drop-down and the Confirm button beside it, both outlined

  3. On the following page, select the template copy edited above, select Export as csv, and click the Continue button:

    BigCommerce Template and file format options with an arrow pointing at the Default Edited Copy template, and Export as csv and the Continue button outlined

  4. Follow the prompts to download your BigCommerce export.


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 BigCommerce (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
Company Shipping Company
Address Shipping Street 1
Apartment, suite, etc. Shipping Street 2
City Shipping Suburb
Province/state/territory Shipping State
Postal code/ZIP code Shipping Zip
Country/region Shipping Country
Email Shipping Email
Phone Shipping Phone
Note Customer Message
Order name Order ID
Item quantity Product Qty
Item name Product Name
Item weight Product Weight
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.