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:
- a “minimum” file with only 3 mandatory fields (Courier Code, tracking Number and Shipment Date):
- 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:
- Name and Surname
- Reference
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):
- Courier Code* (courier code list)
- 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 agent1
- Amount2
- POD3
- Custom 14
- Custom 24
- Custom 34
- Notes5
- Delivery Date (YYYY-MM-DD)6
- Tag7
- Origin8
- Packages
- 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
- incomedia
- maxpho
- newcart
- ahlens
- aliexpress
- allegro
- alltricks
- amazon
- animalis
- anthropologie
- asos
- atlasformen
- auchan
- bandq
- beerwulf
- bestsecret
- bhv
- bild
- blackredwhite
- blokker
- boots
- brandalley
- bricobravo
- bricodepot
- bricomarche
- bricoprive
- bulevip
- but
- carrefour
- casadellibro
- castorama
- cdiscount
- conforama
- creavea
- cultura
- darty
- debenhams
- decathlon
- douglas
- ebay
- elcorteingles
- elkjop
- ellos
- empik
- eprice
- etsy
- fanatics
- feelunique
- fnac
- fonq
- freepeople
- fressnapf
- gifi
- greenweez
- groupon
- handm
- home24
- ibs
- lafayette
- laredoute
- leroyMerlin
- maisonDuMonde
- manomano
- matalan
- mathon
- maty
- maykers
- mediaMarkt
- miravia
- modivo
- mountainwh
- natureetdeco
- nocibe
- obelink
- pandacola
- pccomponentes
- perfumesclub
- phonehouse
- pixmania
- placedestend
- planetahuerto
- pourdebon
- printemps
- privalia
- privsportshop
- public
- quirumed
- redcarepharmacy
- rueducommerce
- sarenza
- shopapotheke
- showroomprive
- slood
- spartoo
- sprinter
- stadium
- superdrug
- tiendanimal
- tradeinn
- truffaut
- twil
- ubaldi
- urbanoutfitters
- venca
- venteunique
- vivino
- watchfinder
- winesitting
- wook
- worten
- yoox
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.