Versions Compared

Old Version 15

changes.mady.by.user Ingrid Oliversen

Saved on

compared with

New Version 16

changes.mady.by.user Ingrid Oliversen

Saved on

Key

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

...

  1. Upload a file in the format explained below
  2. Click on "process file"
  3. 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".
  4. Based on the results, you now have two options: You can either approve the file, meaning that the orders will be finalised, or you can cancel the file.
  5. 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 ("").

Format definition

The Flow Selfservice system 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.

12StringA345
CONSIGNEE_EXT_ID
Customer IDn/aInteger78899
CONSIGNEE_NAMEYes

Name of customer

105StringOla Nordmann
CONSIGNEE_COUNTRYCODEYesCountry code, according to ISO 3166-1.3StringNO
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
105StringStorgaten 11A H0202
CONSIGNEE_CO
"Care Of"-address. Adding "c/o" (or similar) is not necessary.


CONSIGNEE_ZIPCODEYesAlso known as postal code.9String0155
CONSIGNEE_POSTAL_NAMEYesAlso known as city.35StringOSLO
CONSIGNEE_PHONE_1
This can be used for automated SMS notification.100String+47 402 10 000
CONSIGNEE_PHONE_2
This can be used for automated SMS notification.100String+47 402 20 000
CONSIGNEE_EMAIL
This can be used for automated email notification.100String

ola@nordmann.no

CONSIGNOR_NAMEYes

Name of customer




CONSIGNOR_COUNTRYCODEYesCountry 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_ZIPCODEYesAlso known as postal code.


CONSIGNOR_POSTAL_NAMEYesAlso 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.




WEIGHT

Measuring unit is gram.

n/aWhole number600
VOLUME

Measuring unit is cubic decimeter.

n/aDecimal number4
LENGTH

Measuring unit is centimeter.

n/aDecimal number120
HEIGHT

Measuring unit is centimeter.

n/aDecimal number5
WIDTH
Measuring unit is centimeter.n/aDecimal number12
CONTENT

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

70StringBrown shirt
CONTENT_VALUE
Currency is according to the location of the shopId.n/aDecimal number580
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_CODENoCode of the additional service3StringASB
ADDITIONAL_SERVICE_VALUENoValue of the additional service10StringHHWMS
ARTICLE_NUMBERYes ( If additional service is used )Number of the article ( Must be ; separated. See the example )35 ( For each article number )String9055568;9055569;9055570
ARTICLE_NAMEYes ( If additional service is used )Name of the article ( Must be ; separated. See the example )100 ( For each article name )StringDataSIM1;DataSIM2;DataSIM3
ARTICLE_QUANTITYYes ( If additional service is used )Quantity of the article ( Must be ; separated. See the example )3 ( For each article quantity )String10;25;15
DESIRED_DELIVERY_DATENo

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

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

8String20180804

Template-file and examples

flow_selfservice_example.csv

...