Import Shipments via Excel File

How to import shipments via Excel file

This procedure allows to import your shipments on Qapla’ via Excel file.

1. Create an Excel file

Download the example file.

Fill it out with the needed data (in the example file the mandatory fields are highlighted in red)
Click on this link to have a look to the Courier Codes list

2. Upload the shipments on Qapla’

Copy all Excel cells WITHOUT the row of columns name.
Select the channel where the shipments have to be imported and paste the cells in the appropriate space, that is in the white box on Qapla’ going to the tracking home and clicking on the gear icon: Import > Import from Excel file.

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
  • 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
  • tiktokshop
  • tradeinn
  • truffaut
  • twil
  • ubaldi
  • urbanoutfitters
  • venca
  • venteunique
  • vivino
  • watchfinder
  • winesitting
  • wook
  • worten
  • yoox

 

Need help?
If you need assistance, contact Qapla’s Customer Care at support@qapla.it