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:
- a complete file with 3 compulsory fields and more information
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
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
- Representative1
- Amount2
- POD3
- Custom 14
- Custom 24
- Custom 34
- Notes5
- Delivery Date (YYYY-MM-DD)6
- Tag7
- Origin
- Parcels
- Weight
1Email address of the client’s commercial contact
2Possible amount of the shipment (to communicate to the client. For example Payment on Delivery)
3To specify if the shipment is Pay On Delivery (value 1)
4“Custom” field can be used as desired (max 255 char)
5Notes related to a shipment (max 255 char)
6Delivery date required
7A “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