In Client section there is an option to upload a CSV file containing packet data.
NOTE: CSV file is not suitable to import packets with mandatory customs declarations. In that case the better option is the XML import (otherwise customs declarations have to be filled in manually afterwards).
The file needs to conform to the following rules:
First two rows of the file are header rows and:
version 5at first position (first cell). The rest is ignored.
,. Comma must be within quotes
,is already used as CSV separator.
NOTE: To use double quote as a part of the value, i.e. name is
Jeff "the Dude" Lebowski, you need to escape the quote by doubling it. The name from previous example should then look like this:
Jeff ""the Dude"" Lebowski.
iso-8859-2. The encoding is recognized automatically.
You can download example CSV file here.
|1||Reserved||The first column is reserved and needs to be empty.|
|2||Order number||1-24 characters||Yes||Order number (from your eshop). If the value is shorter than 4 charactes, it will be padded by
|3||Name||1-32 characters||Yes||Recipient's name.|
|4||Surname||1-32 characters||Yes||Recipient's surname.|
|5||Company||1-32 characters||No||Recipient's company.|
|6||valid email||If no phone||Recipient's e-mail.|
|7||Phone||valid phone number||If no email||Recipient's phone number. The phone number is validated and needs to be in the valid destination country's format.|
|8||COD||decimal, non-negative||No||For CZK only whole values are allowed, for EUR max 2 decimal places are allowed, for HUF only multiples of 5 are allowed.|
|9||Currency||ISO 4217 code||No||If left blank, currency of the destination country is used. The currency applies to
|10||Value||decimal > 0||Yes||Same rules apply as with the field
|11||Weight||decimal > 0||No||The weight of the packet in kilograms (
|12||Pickup point or carrier||integer||Yes||Unique ID of the pickup point or an address delivery service.|
|13||Sender label||1-64 characters||If you have more senders||A label of your sender (e-shop). In case you are sending packets as more than one sender, this field is required. The latest active record is taken.|
|14||Adult content||0-1||No||Indicates whether the packet is to be delivered only to a person older than 18 years of age. Identification will be required on pickup.|
|15||Delayed delivery||date d.m.Y||No||Delays the delivery so that the packet isn't delivered before this date. Accepted dates are from today to 14 days from today.|
|16||Street||1-32 characters||On address delivery|
|17||House number||1-16 characters||On address delivery|
|18||City||1-32 characters||On address delivery|
|19||ZIP||valid ZIP||On address delivery||Valid destination country's ZIP code.|
|20||Carrier pickup point||String||If carrier requires it||Unique ID of the carrier pickup point|
|21||Size - width||String||If carrier requires it||Packet width in mm|
|22||Size - height||String||If carrier requires it||Packet height in mm|
|23||Size - depth||String||If carrier requires it||Packet depth in mm|