The Flow Selfservice solution is intended to provide an easy way to see with which transport-products a batch of deliveries can be sent with. The steps are as follows:
- Upload a file in the format explained below
- Click on "process file"
- 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.
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 | 12 | String | A345 | |
CONSIGNEE_NAME | Yes | Name of customer | 105 | String | Ola Nordmann |
CONSIGNEE_COUNTRYCODE | Yes | Country code, according to ISO 3166-1. | 3 | String | NO |
CONSIGNEE_ADDRESS | Combined address information with the following format:
| 105 | String | Storgaten 11A H0202 | |
CONSIGNEE_CO | "Care Of"-address. Adding "c/o" (or similar) is not necessary. | ||||
CONSIGNEE_ZIPCODE | Yes | Also known as postal code. | 9 | String | 0155 |
CONSIGNEE_POSTAL_NAME | Yes | 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 | |
CONSIGNOR_NAME | Yes | Name of customer | |||
CONSIGNOR_COUNTRYCODE | Yes | Country code, according to ISO 3166-1. | |||
CONSIGNOR_ADDRESS | Combined address information with the following format:
| ||||
CONSIGNOR_CO | "Care Of"-address. Adding "c/o" (or similar) is not necessary. | ||||
CONSIGNOR_ZIPCODE | Yes | Also known as postal code. | |||
CONSIGNOR_POSTAL_NAME | Yes | 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. | ||||
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 |