How to upload shipments via CSV File

This procedure allows to import your shipments on  Qapla’ via CSV File.

1. Create a CSV file

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

  1. a “minimum” file with only 3 mandatory fields (Courier Code, tracking Number and Shipment Date):
  2. a more complete file with always the first 3 mandatory fields, but containing more information (Name and Surname, Reference, Email):
    download example file

 

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

  • Transactional Emails
  • Ticket

The necessary fields to enable these services are the following ones:

  1. Name and Surname
  2. Reference
  3. Email

 

2. Upload the file on Qapla’

Enter the file on Qapla’ panel, going on the tracking home and clicking on the gear icon: Import >

You will have to select the channel where you want to import the shipments. To proceed please click on “Start import”.

 

List of CSV fields

The file consists of the following fields (fields with “*” are mandatory, whereas those ones indicated with “º” are necessary to activate additional services such as Transactional Emails and Tickets):

  1. Courier Code(courier code list)
  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. Representative agent1
  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. Origin8
  24. Packages
  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 characters)
5A Note related to the shipment (max 255 characters)
6Delivery date required

7 A “tag” to identify shipments belonging to a group.
8Admitted values are below indicated:

  • bigcommerce
  • commercelayer
  • ecwid
  • magento
  • magento2
  • prestashop
  • shopify
  • shopware6
  • storeden
  • vtex
  • woocommerce
  • edock
  • maxpho
  • aliexpress
  • allegro
  • amazon
  • carrefour
  • cdiscount
  • decathlon
  • ebay
  • eprice
  • etsy
  • greenweez
  • groupon
  • ibs
  • leroyMerlin
  • maisonDuMonde
  • manomano
  • mediaMarkt
  • modivo
  • privalia
  • spartoo
  • sprinter
  • vivino
  • worten

 

Automatic import

You can automate the file import using the CSV Connector by setting the address where to find the file and the desired import time.

In the section Channels > [Channel Name] > Configure > Import > Shipments  you can set-up the Connector.