Courier Options Dialog - DPD Ship@Ease
The courier integration for DPD Ship@Ease is available as a CourierNeo (ie setup in [ System Data | Courier / Shipping | Couriers ]). In addition, following the changes required by DPD with regard to Brexit, the export file from Khaos Control will include the required individual product information. These changes are based upon the DPD document DPDgroup_File_Import_Spec_Brexit_FINAL.pdf.
For more information on the setup see 018498: MyDPD File Import Specification.
| Option Name | Usage | Example Value |
|---|---|---|
| Service Code | DPD Service to use for this shipment.[1] | 10, 32 |
| Output Folder | Folder to output generated file to. | C:\keystoneSoftware\Courier\ShipatEase\Output |
| Output Filename | Filename suffix | DPDShipAtEase |
| Import Folder | Folder to import DPD shipment from. | C:\keystoneSoftware\Courier\ShipatEase\Import |
| Account Number | DPD account number | |
| EORI Number | EORI (Tax) Number. | If unsure leave blank. |
| Raw Dump | Enable raw dump of requests. | ? |
| Raw Dump Folder | Folder to dump requests to. | |
| Fabric content | Fabric content of the shipped orders, if unsure leave blank. | |
| Weight Scale | The weight of the shipment(s) will be multiplied by this scaling factor before sending to the courier. [2] | 0.001 |
| Nominal weight | If the shipment has no weight, then this value will be used instead. | |
| Dimension Scale | The dimensions of the shipment(s) will be multiplied by this scaling factor before sending to the courier. | |
| Requires Consignment Ref | When ticked, the invoice cannot be moved past the Shipping Stage in the Sales Invoice Manager. | ? |
| Raw Dump to Table | Ticked, request data will be logged to a database table for review by the support team. | |
| Note Choice | Choose which note type to feed through to the courier. The options are as follows:
|
Notes
- ? Available service codes can be checked from the Click & Drop website, by clicking Settings in the top right, then clicking on the Shipping Services area.
- ? The correct value for the weight scale will depend on what unit of measurement weights are entered into Khaos Control in and what unit is used by the courier.
- Grams in Khaos Control to kilograms in the courier software would be a weight scale of '0.001'
- Kilograms in Khaos Control to kilograms in the courier software would be a weight scale of '1'.
- Kilograms in Khaos Control to grams in the courier software would be a weight scale of '1000'.
- Pounds in Khaos Control to kilograms in the courier software would be a weight scale of '0.45359'.
File export format
The suggested mappings listed here are just a rough guide intended as a starting point, and users should ensure that they are using correct and up-to-date mappings as advised by DPD support.
| Column number | Contents (Exported from Khaos Control) | Field name for suggested mapping in MyDPD |
|---|---|---|
| 1 | Contact Name (and Company Name, if different) | Delivery organisation/name |
| 2 | Address Line 1 (Address1) | Delivery address line 1 (property/street) |
| 3 | Address Line 2 (Address2) | Delivery address line 2 (locality) |
| 4 | Address Line 3 (Locality) | Delivery address line 4 (county/state) |
| 5 | Address Line 4 (Town) | Delivery Address line 3 (city) |
| 6 | Post Code | Delivery post code |
| 7 | ISO 3166-1 two-digit country code for the shipment address. | Delivery country code |
| 8 | Service Code from [ System Data | Courier / Shipping | Couriers ]. | Delivery service code |
| 9 | DPD Account Number, from [ System Data | Courier / Shipping | Couriers ]. | Ignore field |
| 10 | Total Shipment Weight (KG) | Delivery total weight (kg) |
| 11 | KC Sales Invoice Reference | Delivery customer ref. 1 |
| 12 | Delivery Contact Name | Delivery contact name |
| 13 | Delivery Contact Telephone (or Invoice Contact, if it's blank) | Delivery contact telephone number |
| 14 | Text from the SOrder invoice note. | Delivery description |
| 15 | Total order value, excluding VAT and delivery, rounded up to the nearest pound. | Delivery customs value (GBP) |
| 16 | Delivery Contact Email (or Invoice Contact, if it's blank) | Delivery notification email address |
| 17 | Delivery Contact Mobile (or Invoice Contact, if it's blank) | Delivery notification SMS number |
| 18 | Tax Reference | Delivery VAT number |
| 19 | Number of Labels | Delivery number of packages |
| 20 | Additional Info | Delivery additional information |
| 21 | The name of the .out file expected. | Ignore field |
| 22 | Export Data column from [ System Data | Courier / Shipping | Couriers ]. | Ignore field |
| 23 | Ship Date. Only exported if UseShipDate is -1, otherwise this will be blank (which DPD interpret as today's date). | Shipment Date |
| 24 | Blank column. This is for DPD to put the consignment number into. | Ignore field |
25 | Extended Liability (exported as ‘Y’ or ‘N’).
Taken from right click > Configure… options in [ System Data | Courier /
Shipping - Couriers ]. | Extended liability flag (Y/N |
26 | Extended Liability Value. Taken from right click
> Configure… options in [ System Data | Courier / Shipping - Couriers ]. | Extended liability value |
27 | Generate customs data (exported as ‘Y’ or ‘N’). Taken from right click > Configure… options in [ System Data | Courier / Shipping - Couriers ]. | Generate Customs Data (Y/N) |
28 | Invoice Type. Taken from right click > Configure… options in [ System Data | Courier / Shipping - Couriers ]. | Invoice Type |
29 | Reason for export. Taken from right click > Configure… options in [ System Data | Courier / Shipping - Couriers ]. | Reason for Export |
30 | Country of origin. Taken from right click > Configure… options in [ System Data | Courier / Shipping - Couriers ]. | Country of Origin |
31 | Duplicate of column 30, for use as Shipper
Country Code. | Shipper country code |
32 | Receiver contact name (i.e. delivery contact
name from the sales order). | Shipper country code |
33 | Receiver email address (i.e. delivery contact
email from the sales order). | Receiver contact email |
34 | UKIMS Number for courier taken from right click
> Configure… option in [System Data | Courier / Shipping – Couriers ]. | |
35 | EORI Number taken from right click >
Configure… options in [ System Data | Courier / Shipping - Couriers ]. | Exporter EOR number |
36 | If ‘Include IOSS Number’ is ticked in [ System
Data | Courier / Shipping - Couriers ], then this will be the Shipper IOSS number. | Exporter destination tax ID/reg no. |
37 | If ‘Include IOSS Number’ is ticked in [ System Data | Courier / Shipping - Couriers ], then this will be the EU VAT paid. | GST/VAT paid |
38 | Courier Terms of Delivery taken from right click
> Configure… option in [ System Data | Courier / Shipping – Couriers ]. | International Billing Terms |
39 | Gross delivery total. | Ignore field |
40 | UKIMS Number for customer taken from [ Customer
| Detail | Financial ]. | |
41 | EORI Number taken from [ Customer | Detail |
Financial ]. | Importer EORI number |
Note: Users may wish not to map the Address Line 3 (locality) if they feel it would be incorrect to map this to the 'Delivery address line 4 (county/state)' and if this information is not required for delivery.
Product Details
Each Product detail needs to be on a separate line and start with PRD
| Column number | Contents (Exported from Khaos Control) | Field name for suggested mapping in MyDPD |
|---|---|---|
| 1 | Stock Item SKU. | Product Code |
| 2 | Stock item Harmonisation Code. | Harmonised code |
| 3 | Weight for this stock item. | Unit weight (kg) |
| 4 | Product URL | |
| 5 | Box number. | Parcel |
| 6 | Stock Item Description. | Description |
| 7 | Stock item, stock type. | Product type |
| 8 | ISO-2 country code from the stock item. | Item origin |
| 9 | Quantity of this stock item in total or in this box, if boxes are being used. | Quantity |
| 10 | Value of the stock item from the SOrder. | Unit value (GBP) |
| 11 | Description from [ System Data | Courier / Shipping | Couriers ]. | Fabric content |
Notes:
- The actual weight from the Confirm Shipment dialog will override the total Shipment Weight, ONLY when the order is not a commercial invoice (i.e. not going outside the UK)
- For domestic shipments you don't need to provide product data. Please ensure that the Generate Customs Data field is set to 'N'. If it is set to 'Y' MyDPD will check for product data, even though it is not required.
- The maximum allowed adjustment of the actual weight from the [Confirm Shipment] dialog to override the total Shipment Weight is +- 25kg.
e.g.
- If a SOrder is going to require more than one box
- The user knows the total weight of the order but edit the Delivery Total Weight sent from Khaos to DPD, to the weight of the first parcel only.
- The user then prints the label and send it down the conveyor.
- The user does this due to limited space to pack and can't have multiple boxes in the packing areas.
- The user then packs the next box and go onto the DPD app and change the number of labels needed to the correct amount of boxes.
- The user ensures that each box is under 25kg.