Import Shipments via CSV File

It is possible to import your shipments via CSV File by creating a text file in the following formats.

CSV File ( a text file separated by ; “semicolon”) can be uploaded in two different file formats:

a minimum file with 3 compulsory fields:
download example csv file
a complete file with 3 compulsory fields and more information
download example excel file

Additional information in the complete file are used for additional services such as:

Transactional Email
Ticket

You need to insert the following fields in order to enable additional services:

Name and Surname
Reference
Email

File

CSV File is composed of the following fields ( all fields marked with an asterisk * are compulsory):

Courier Code^*
Tracking Number^*
Shipping Date (YYYY-MM-DD)^*
Reference^°
Order Date (YYYY-MM-DD)
Name and Surname°
Address
City
Zip Code
Province
Country
Email^°
Telephone Number
Representative¹
Amount²
POD³
Custom 1⁴
Custom 2⁴
Custom 3⁴
Notes⁵
Delivery Date (YYYY-MM-DD)⁶
Tag⁷
Origin
Parcels
Weight

¹Email address of the client’s commercial contact
²Possible amount of the shipment (to communicate to the client. For example Payment on Delivery)
³To specify if the shipment is Pay On Delivery (value 1)
⁴“Custom” field can be used as desired (max 255 char)
⁵Notes related to a shipment (max 255 char)
⁶Delivery date required
⁷A “tag” to identify a group of shipments
^°Necessary fields to enable additional services such as Transactional Email / Ticket

It is possible to automate the import of the CSV File using the CSV Connector and setting the address where Qapla’ finds the CSV File, you can set a schedule of automatic import.

It is possible to set up the CSV Connector by clicking on Settings / [ Channel Name ] / Import

Courier codes list

Click on the following link to see all codes in alphabetical order: Courier Codes