Versions Compared

Old Version 18

changes.mady.by.user Mathias Grønnern

Saved on

compared with

New Version 19

changes.mady.by.user Ingrid Oliversen

Saved on

Key

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

The Flow Selfservice 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
  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 finalisedfinalized, 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 ("").
  • 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. 

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

CONSIGNEE_REFERENCE
This can be an orderId or some other reference. Consignee reference can be placed on some shipping labels.35String012345
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.




CONSIGNOR_REFERENCE
This can be an orderId or some other reference. Consignor reference can be placed on some shipping labels.35String012345
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
SHIPMENT_IDNo

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.

35String(401)70712190172720651
TRACKING_REFERENCENo

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.

(warning) For return solutions this field should never be set by the callee. Tracking refernce for return packages is generated by DI and returned in the response.

35String(00)370724760010119754

Template-file and examples

flow_selfservice_example.csv

...