https://di.no/doc

Parcel Flow Bulk Order File Format

Owned by Former user (Deleted)
Last updated: Apr 22, 2022 by Ingrid Oliversen
4 min read

Content

 

The Flow bulk order solution is intended to provide an easy way to see with which transport-products a batch of deliveries can be sent with and book delivery. The steps are as follows:

  1. Upload a file in the format explained below to flow.di.no

  2. We will email you the file back, with the addition of a new column "RESULT" containing the transport-product, or possibly an error message. Specify the email-address in step 1. At this point the orders are in a "stand-by status".

  3. Based on the results, you now have two options: You can either approve the file, meaning that the orders will be finalized, or you can cancel the file.

  4. If you decide to approve the orders, you will receive an email with labels when the orders are processed.

General notes about the format

  • We support both Excel- and CSV-files.

  • Encoding: The files are assumed to be encoded as ISO-8859-1.

  • Columns

    • The order of the columns is not important.

    • The header-line (with the column names) is essential. Each column MUST have our documented names (i.e. EXTERNAL_ORDER_ID or CONSIGNEE_NAME). 

    • We give an error if there are any unknown column names in the file. The file should therefore not have any other column names than those documented here. 

  • For CSV, the field separator is semi colon (;).

  • The columns can be quoted, if so, use ("").

  • We support files up to 50 000 orders

  • It may take some time for the files to be processed and generate labels. 

  • Contact your carrier provider with questions to the format, errors while uploading or use of different fields. 

  • Filename must be different for each file

Format definition

The Flow application makes use of Parcel Booking API, so please refer to the documentation for more information on possible error-codes.

Name

Mandatory

Description

Max length

Type

Example

Name

Mandatory

Description

Max length

Type

Example

EXTERNAL_ORDER_ID



External order ID
Typically identifies each customer for this distribution.

12

String

A345

CONSIGNEE_EXT_ID

 

Customer ID

n/a

Integer

78899

CONSIGNEE_NAME

Name of customer

105

String

Ola Nordmann

CONSIGNEE_COUNTRYCODE

Country code, according to ISO 3166-1.

3

String

NO

CONSIGNEE_ADDRESS



Combined address information with the following format:

  • Street name

  • Street number (with leading space)

  • Entrance

  • Floor type (only relevant for countryCode=NO)

    • H (main floor)

    • U (basement)

    • L (attic)

    • K (cellar)

  • Floor number

  • Flat numer

105

String

Storgaten 11A H0202

CONSIGNEE_CO

 

"Care Of"-address. Adding "c/o" (or similar) is not necessary.

 

 

 

CONSIGNEE_ZIPCODE

Also known as postal code.

9

String

0155

CONSIGNEE_POSTAL_NAME

Also known as city.

35

String

OSLO

CONSIGNEE_PHONE_1

 

This can be used for automated SMS notification.

100

String

+47 402 10 000

CONSIGNEE_PHONE_2

 

This can be used for automated SMS notification.

100

String

+47 402 20 000

CONSIGNEE_EMAIL

 

This can be used for automated email notification.

100

String

ola@nordmann.no

CONSIGNEE_REFERENCE

 

This can be an orderId or some other reference. Consignee reference can be placed on some shipping labels.

35

String

012345

MESSAGE_TO_CONSIGNEE

 

This information can be placed on some shipping labels in the information field.

350

String

Good morning to you!

CONSIGNOR_NAME

Name of customer

 

 

 

CONSIGNOR_COUNTRYCODE

Country code, according to ISO 3166-1.

 

 

 

CONSIGNOR_ADDRESS



Combined address information with the following format:

  • Street name

  • Street number (with leading space)

  • Entrance

  • Floor type (only relevant for countryCode=NO)

    • H (main floor)

    • U (basement)

    • L (attic)

    • K (cellar)

  • Floor number

  • Flat numer







CONSIGNOR_CO



"Care Of"-address. Adding "c/o" (or similar) is not necessary.







CONSIGNOR_ZIPCODE

Also known as postal code.

 

 

 

CONSIGNOR_POSTAL_NAME

Also known as city.

 

 

 

CONSIGNOR_PHONE_1



This can be used for automated SMS notification.

 

 

 

CONSIGNOR_PHONE_2



This can be used for automated SMS notification.

 

 

 

CONSIGNOR_EMAIL

 

This can be used for automated email notification.

 

 

 

CONSIGNOR_REFERENCE



This can be an orderId or some other reference. Consignor reference can be placed on some shipping labels.

35

String

012345

WEIGHT

 

Measuring unit is gram.

n/a

Whole number

600

VOLUME

 

Measuring unit is cubic decimeter.

n/a

Decimal number

4

LENGTH

 

Measuring unit is centimeter.

n/a

Decimal number

120

HEIGHT

 

Measuring unit is centimeter.

n/a

Decimal number

5

WIDTH

 

Measuring unit is centimeter.

n/a

Decimal number

12

CONTENT



Description of the contents. This can be placed on some shipping labels.

70

String

Brown shirt

CONTENT_VALUE



Currency is according to the location of the shopId.

n/a

Decimal number

580

GENERIC_1



A piece of generic information that will be retained through the process and given back in the resulting file.



Text



GENERIC_2



A piece of generic information that will be retained through the process and given back in the resulting file.



Text



GENERIC_3



A piece of generic information that will be retained through the process and given back in the resulting file.



Text



GENERIC_4



A piece of generic information that will be retained through the process and given back in the resulting file.



Text



GENERIC_5



A piece of generic information that will be retained through the process and given back in the resulting file.



Text



ADDITIONAL_SERVICE_CODE

 

Code of the additional service

3

String

ASB

ADDITIONAL_SERVICE_VALUE

 

Value of the additional service

10

String

HHWMS

ARTICLE_NUMBER

 

Number of the article ( Must be ; separated. See the example )
( Mandatory if additional service is used )

35

String

9055568;9055569;9055570

ARTICLE_NAME

 

Name of the article ( Must be ; separated. See the example )
( Mandatory if additional service is used )

100

String

DataSIM1;DataSIM2;DataSIM3

ARTICLE_QUANTITY

 

Quantity of the article ( Must be ; separated. See the example )
( Mandatory if additional service is used )

3

String

10;25;15

DESIRED_DELIVERY_DATE

 

Date format yyyyMMdd. Optional field for desired delivery date of the shipment.

 If specified for return solutions this day represents the date where the carrier should pickup the package and should be earliest tomorrow. Normally the consignor / sender will be instructed to lay out the package the day before pickup.

8

String

20180804

SHIPMENT_ID

 

If not specified as a part of the request this will be generated and returned in the response. This should be a globally unique identifier.

Typically named MessageNumber, DocumentNumber or ConsignorsReference in EDI.

35

String

(401)70712190172720651

TRACKING_REFERENCE

 

If not specified as a part of the request this will be generated and returned in the response.

This can be a SSCC code according to gs1, or a UPU S10 identifier.

Typically named TransporterInstructionMark in EDI.

For return solutions this field should never be set by the callee. Tracking reference for return packages is generated by DI and returned in the response.

35

String

(00)370724760010119754

EXTERNAL_SUPPLIER_ID

 

ExternalSupplierId is the id of the supplier to the shop. It can be used for access control or filtering.

Must be configured for the shop before use. If service supplier specified in file is not configured (or does not exist) booking will be accepted and only linked to shop

Service supplier is connected to shop, no validation for coverage or other attributes

n/a

String

my_supplier

 

Template-file and examples