The system is able to scan imported CSV files and send the packages to Deliveo (CSV files can be exported by many software, but can also be generated from Excel using the "Save as" option.)
The function consists of five short steps:
- Select the Customer whose 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 scan.
- Select the recipient you want to select and select the recipient to whom you want to send the mail.
- Select the shipping option from the drop-down list (you can only import with one shipping option at a time within an import).
- Read 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 have not yet been sent.
- Once you have checked the list in the temporary table, click on the "Send dispatches" button.
If there is an error in the list, you can use the "Delete" button in the bottom bar to delete the temporary container, or click on the small red delete icon at the beginning of the rows to remove the unwanted rows one by one. Parcels posted in this way will appear as unallocated parcels in the same way as their manually posted counterparts. (If there is some sort of automation set up to assign parcels to couriers, this will process imported parcels in the same way.)
The header is mandatory, so the order of the fields can be reversed. The number of columns in the header and data must be equal. Content without a header will be ignored.
Consecutive rows with the same Sender name + postcode + address AND Recipient name + postcode + address AND Tracking code will be 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..
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 already exist (for that Customer), it will (if the sender and recipient are not designated using sender_id/consignee_id) save the address as the address of the designated Customer (even if the same address already exists as the address of another Customer.)
Field separator: ; (semicolon). Fields required are in bold. The 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. | |
| 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 numbers, 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. | |
| 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 mailing |
| 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.. |