Order import .csv specification
Kristoffer avatar
Written by Kristoffer
Updated over a week ago

This article walks you through the fields available for the order import file. It's divided into:

As the headings suggest, Gordon recommends you to include the fields specified in the Recommended section πŸš€

Begin with downloading our Order Import template (we have three different to choose from):
​https://developer.gordondelivery.com/

Required fields

The most basic order file is required to contain the following information.

Required field

Example

Description

external_ref

id1234

Unique order reference number

customer-name

John Doe

Name of the customer

address

Street name 1

Customer address

zip

12345

Zipcode

city

Stockholm

City

deliverydate

2023-04-19

Order delivery date

time-window

11:00-15:00

Time window the customer has requested

deliverygroup

Delivery group name

Name of the Delivery Group in Last Mile the order belongs to

inventory[0].name

Food box

Name of the item (at least one item is required)

inventory[0].quantity

1

Number of items in the order

Other fields

The following fields are available to include in your order import.

Available field

Example

Description

external_id

cc149f07-24d2-4493-9e1f-518630635634

External ID from your internal system

email

john.doe@email.com

Customer email

mobile

+46701234567

Customer phone number

address2

third floor

Second address line

country_code

SE

Country code (ISO)

entrycode

1234

Entry code to the customer's building

latitude

59.479282

Latitude cordinates of the address

longitude

18.315134

Longitude cordinates of the address

description

Flowers of various colors

Description of the order

notes

Knock twice

Notes to the driver

delivery-requirements.delivery-in-person

true

If the order is not allowed to be left outside at the end customer, set this field to true. Driver will be informed that this order has to be delivered in person. If not, set as false or leave blank.

delivery-requirements.id-check

true

If you want the end customer to show their ID upon delivery, set this field to true. If not, set as false or leave blank

baseServiceTime

2

Will add extra service time (minutes) to the order if it requires extra time for the driver.

inventory.[0].weight

5

Weight of the inventory (kilograms)

inventory.[0].width

20

Width of the inventory (cm)

inventory.[0].height

30

Height of the inventory (cm)

inventory.[0].length

40

Length of the inventory (cm)

inventory.[0].type

frozen

Use this field if the order is for frozen goods. If not, leave the field blank.

inventory.[0].serviceType

delivery

Specify if it's a delivery or pickup item. Delivery is default if field is left blank.

inventory.[0].articles.[0].name

Grandma's Chicken Salad

Name of articles tied the item.

inventory.[0].articles.[0].quantity

15

Number of articles with the name tied to the item.

Recommended

We recommend importing the order with the following fields.

Field

Example

Description

external_ref

id1234

Unique order reference number

customer-name

John Doe

Name of the customer

mobile

0701234567

Customer phone number

email

john.doe@email.com

Customer email

address

Street name 1

Customer address

zip

12345

Zipcode

city

Stockholm

City

deliverydate

2023-04-19

Order delivery date

time-window

11:00-15:00

Time window the customer has requested

deliverygroup

Delivery group name

Name of the Delivery Group in Last Mile the order belongs to

inventory.[0].name

Food box

Name of the product

inventory.[0].quantity

1

Number of items in the order

inventory.[0].type

frozen

Use this field if the order is for frozen goods. If not, leave the field blank.

inventory.[0].weight

5

Weight of the inventory (kilograms)

Did this answer your question?