Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Ingrid Oliversen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Content

Table of Contents

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 Selfservice system 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

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

(tick)

(tick)

Name of customer

105

String

Ola Nordmann

CONSIGNEE_COUNTRYCODE

(tick)

(tick)

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

35

105

String

Storgaten 11A H0202

CONSIGNEE_CO

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

CONSIGNEE_

ZIP

ZIPCODE

(tick)

(tick)

Also known as postal code.

9

String

0155

CONSIGNEE_POSTAL_

CITY

NAME

(tick)

(tick)

Also known as

postal name

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

(tick)

(tick)

Name of customer

CONSIGNOR_COUNTRYCODE

(tick)

(tick)

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_

ZIP

ZIPCODE

(tick)

(tick)

Also known as postal code.

CONSIGNOR_

CITY

POSTAL_NAME

(tick)

(tick)

Also known as

postal name

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

COMING SOON A

_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

stored with the orders

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.

(warning) 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

...

View file
nameFilimport_ex.xlsx