Importing orders from Squarespace
Note: view our Zapier webhooks and import integrations for more ways to connect to your Squarespace account.
Planning optimized delivery routes using Squarespace orders? Follow the steps below to export your orders from Squarespace, and import them into EasyRoutes for delivery route planning.
Exporting from Squarespace:
- From your Squarespace dashboard, navigate to the Orders page found within the Selling tab of the sidebar menu. Click the Download CSV button found in the upper right-hand corner above your order list:
Ensure that only Pending orders is selected from the Fulfillment section, and click Download to generate a CSV file of your pending Squarespace orders.
Optional: If only certain products are eligible for delivery, select Specific product and use the search bar to select applicable item(s) only for 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 Squarespace (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 Name |
Address | Shipping Address1 |
Apartment, suite, etc. | Shipping Address2 |
City | Shipping City |
Province/state/territory | Shipping Province |
Postal code/ZIP code | Shipping Zip |
Country/region | Shipping Country |
Phone | Shipping Phone |
Item quantity | Lineitem quantity |
Item name | Lineitem name |
- 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.