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.. (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 case of a row merge, the data of the last row of the merged rows of the common data (cod, reference_id, saturday, pic_up_point, comment, etc.) of a 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 the given Customer), it will (if the sender and consignee 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: https: //www.iban.com/country-codes
| # | Field (header) name | Recordable value | Explanation |
|---|---|---|---|
| 1. | sender_id | Max. 10 characters number | Sender 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 2,3,4,5,6 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. |
Help: https:// www.iban.com/country-codes |
| 4. | sender_zip | Max. 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 ID (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 ID) If there is a value here, fields 11,12,13,14,15 are optional (the column cannot be missing but can be empty). |
| 11. | consignee | Max. Max. 30 characters for letters and numbers. | Recipient name |
| 12. | consignee_country_code | Two-digit ISO country code. 2 characters. |
Help: https:// www.iban.com/country-codes |
| 13. | consignee_zip | Max. Max. 10 characters letters and numbers | Recipient postal code |
| 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 retrieval). In case of delegation to a partner, activate the document retrieval 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 contain a number. |
| 26. | tracking | Max. 15 characters | Optional data that can be recorded to track the parcel (e.g. order number, account number, etc.) |
| 27. | packaging_unit | Max. 3 characters positive integer, > 0 | ColliPackaging unit. Shows how many pieces are included in a given shipment. (package unit). (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 | The weight of the package in the unit of measurement that is set (decimals separated by a dot). |
| 32. | item_no | Max. Max. 30 characters letter and number. | Article number assigned to the 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.. |