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:
- From your BigCommerce dashboard, navigate to the Orders page from the sidebar menu:
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:
From the Choose an action dropdown menu, select Export selected, then click the Confirm button beside it:
On the following page, select the template copy edited above, select Export as csv, and click the Continue button:
Follow the prompts to download your BigCommerce export.
Importing to EasyRoutes:
- Login to your EasyRoutes for Web account. From the Dashboard, click the Import new CSV button and select the CSV file exported from BigCommerce (or drag and drop the CSV file directly onto the button):
- Select Provide the address using multiple fields from the address import method section:
- Use the dropdown menus below to map the CSV's fields as follows - note that columns will only need to be mapped once when initially importing a CSV file; mappings will be saved to streamline importing of any future CSV files containing the same data format:
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 |
| Shipping Email | |
| Phone | Shipping Phone |
| Note | Customer Message |
| Order name | Order ID |
| Item quantity | Product Qty |
| Item name | Product Name |
| Item weight | Product Weight |
- Once all columns have been mapped, click the Next button in the upper right-hand corner of the page:
- 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:
- Configure any desired Route Options using the controls below the map. Click the Create route button above the map to generate an optimized delivery route containing your imported orders:
Additional Resources:
- Full details on CSV import workflows: How do I import orders from a spreadsheet (.CSV)?
- Review and re-use any imported orders with the Address Book feature.
- View our Zapier webhooks and import integrations for more ways to connect to your BigCommerce store.
- You can also write custom integrations using our EasyRoutes API.