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

Β