Deliveo knowledge base

The [Import] menu allows you to import up to thousands of files at a time (CSV / XLS / XLSX / ODS)

The function consists of four short steps:

Click on the "Upload File" icon in the taskbar. Click on the "Upload file" button.
Select the transport option from the drop-down list (you can only import with one transport option at a time within an import).
Import the file. The table will display the shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.s you want to send. This is only a temporary table, the shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.s are not yet dispatched.
Once you have checked the list in the temporary table, click on the "Send shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.s" button.

If there is an error in the list, the temporary table can be cleared. Imported shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.s will appear in the dispatched shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.s in the same way as manually dispatched shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.s.

The header is mandatory, so the order of the fields can be reversed. The number of columns in the header and in the data must be equal. Content without a header will be ignored.

Multiple packages in one shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.

Consecutive rows with the same Sender name + postcode + address AND Recipient name + postcode + address AND Tracking Code are merged into one shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.. (Insert the package into the previous shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units..) In the case of a row merge, the data of the last row of the merged rows of the common data (cod, reference_id, optional_parameter_1, optional_parameter_2, optional_parameter_3, pic_up_point, comment, etc.) of a single shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units. will be used.

If the system finds addressesAddresses The geographical addresses where the Courier will pick up or deliver the parcel. An Address can be both a shipping address and a receiving address, the system does not distinguish between the two. in the imported file that do not yet exist, it will save the address (if the sender and recipient are not specified using sender_id/consignee_id).

Field separator: ; (semicolon). Required fields are in bold. A period (.) is used as a decimal separator.

Two-character ISO codes: iban.com/country-codes

#	Field (header) name	Recordable value	Explanation
1.	sender_id	Max. 10 characters number	External identifier of the sender (Master Data → AddressesAddresses The geographical addressesAddresses The geographical addresses where the Courier will pick up or deliver the parcel. An Address can be both a shipping address and a receiving address, the system does not distinguish between the two. where the Courier will pick up or deliver the parcel. An Address can be both a shipping address and a receiving address, the system does not distinguish between the two. → External identifier) If there is a value here, fields 2,3,4,5,6,8 are optional (the column cannot be missing but can be empty).
2.	sender	Max. Max. 30 characters letter and number	Sender name
3.	sender_country_code	Two-digit ISO country code. 2 characters.	iban.com/country-codes
4.	sender_zip	Max. 10 characters letter and number	Sender's postal code
5.	sender_city	Max. 25 characters letter and number	Name of sender municipality
6.	sender_address	Max. 40 characters letter and number	Name of the sending public area, house number
7.	sender_apartment	Max. 15 characters letter and number	Sender building, staircase, floor, door
8.	sender_phone	Min. 10, max. 15 digits, start with + sign	Telephone number with international dialling code (e.g. +36205555555)
9.	sender_email	Max. Max. 50 characters of letters and numbers.	Sender's email address
10.	consignee_id	Max. Max. 10 characters.	Recipient's external identifier (Master Data → AddressesAddresses The geographical addressesAddresses The geographical addresses where the Courier will pick up or deliver the parcel. An Address can be both a shipping address and a receiving address, the system does not distinguish between the two. where the Courier will pick up or deliver the parcel. An Address can be both a shipping address and a receiving address, the system does not distinguish between the two. → External identifier) If there is a value here, fields 11,12,13,14,15,17 are optional (the column cannot be missing but can be empty).
11.	consignee	Max. Max. 30 characters for letters and numbers.	Name of addressee
12.	consignee_country_code	Two-digit ISO country code. 2 characters.	iban.com/country-codes
13.	consignee_zip	Max. Max. 10 characters letter and number	Postal code of the addressee
14.	consignee_city	Max. 25 characters letter and number.	Addressed municipality name
15.	consignee_address	Max. 40 characters letter and number	Addressed public area name, house number
16.	consignee_apartment	Max. 15 characters letter and number	Addressed building, staircase, floor, door
17.	consignee_phone	Min. 10, max. 15 numbers, start with + sign	Telephone number with international dialling code (e.g. +36205555555)
18.	consignee_email	Max. Max. 50 characters letters and numbers.	Recipient's email address
19.	comment	Max 255 characters letter and number	Comment to the shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units.
20.	pick_up_point	Max. 30 characters letter and number	Receiving location identifier (not the name!) for delivery to a parcel point (e.g. 62211557)
21.	optional_parameter_1	1 or 0	Optional parameter 1
22.	optional_parameter_2	Max. 8 digits + 2 decimal places	Optional parameter 2
23.	optional_parameter_3	1 or 0	Optional parameter 3
24.	referenceid	Max. 15 characters letters and numbers.	Reference number (e.g. for document retransmission). In case of delegation to a partner, activate the document retransmission service (if the partner has such a service).
25.	cod	Max. 8 numbers + 2 decimal places	Amount of post-entry. If the field is included in the uploaded file, it must be a number.
26.	tracking	Max. 15 characters	Optional data that can be recorded to track the package (e.g. order number, account number, etc.)
27.	packaging_unit	Max. 3 characters positive integer, > 0	(Min. 1, max. number of packages in the shipmentSend to An identifier that groups together packages sent from a Sender to a Recipient by a Customer at the same time. In practice, this is understood to mean the entire shipment, even if it consists of several Packing Units..)
28.	x	Max. 7 digits + 2 decimal places	Package width.
29.	y	Max. 7 digits + 2 decimal places	Package height.
30.	z	Max. 7 digits + 2 decimal places	Package depth.
31.	weight	Max. 5 characters, number up to 1 decimal	Weight of the package.
32.	item_no	Max. 30 characters letter and number.	Article number assigned to package ID. May vary from package to package. If there is an article number, the system will check it in the Article Master and if there is a match, it will automatically fill in cells 28,29,30,31 with the data associated with the article number (any value previously entered in it will be overwritten).
33.	customcode	Max. 30 characters for letters and numbers.	Unique identifier assigned to package ID. May vary from package to package, preferably the package factory number (if any).
33.	multiplier	Max. 3 characters positive integer, > 0	Multiplier. The line where a positive integer is entered here is multiplied by this number during import. This allows to import hundreds of items in a row under the same DeliveoIDUnique primary identifier for shipments in the Deliveo system..