Flow Selfservice

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. 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	Description	Max length	Type	Example
ORDER_ID	External order ID Typically identifies each customer for this distribution.	12	String	A345
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	35	String	Storgaten 11A H0202
CONSIGNEE_ZIP	Also known as postal code.	9	String	0155
CONSIGNEE_CITY	Also known as postal name.	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
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_ZIP	Also known as postal code.
CONSIGNOR_CITY	Also known as postal name.
CONSIGNOR_PHONE	This can be used for automated SMS notification.
CONSIGNOR_EMAIL	This can be used for automated email notification.
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 piece of generic information that will be stored with the orders.		Text

Template-file and examples

flow_selfservice_example.csv