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:

  1. a minimum file with 3 compulsory fields:
  2. 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:

  1. Name and Surname
  2. Reference
  3. Email

File

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

  1. Courier Code*
  2. Tracking Number*
  3. Shipping Date (YYYY-MM-DD)*
  4. Reference°
  5. Order Date (YYYY-MM-DD)
  6. Name and Surname°
  7. Address
  8. City
  9. Zip Code
  10. Province
  11. Country
  12. Email°
  13. Telephone Number
  14. Representative1
  15. Amount2
  16. POD3
  17. Custom 14
  18. Custom 24
  19. Custom 34
  20. Notes5
  21. Delivery Date (YYYY-MM-DD)6
  22. Tag7
  23. Origin
  24. Parcels
  25. 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