Structure of the CSV file for shipping service providers

With the help of CSV files DHL, GLS and DPD are connected.

Separator

The entries are separated with a |.

header data

The header line consists of:

Shipment Ref-No. sender Ref. no. sender remark Mand. Ref. no. proceedings participation cost center product service list NN Currency TV currency Rec. Ref. no. Rec. Name1 Rec. Name2 Rec. Name3 Rec. Postcode Rec. location Rec. district Rec. Street Rec. Hausnr. Rec. Tel Rec. fax POOL_REC_EMAIL POOL_REC_DATEOFBIRTH POOL_REC_CARD_NO POOL_REC_TYPE_OF_CARD POOL_REC_ID POOL_REC_MINIMUM_AGE POOL_REC_MA_LOCATION POOL_REC_MA_DISTRICT POOL_REC_MA_STREET POOL_REC_SURNAME POOL_REC_FIRST_NAME POOL_REC_CONTRACT_ID POOL_REC_CITICENSHIP POOL_REC_ADDITIONAL_QUERY POOL_REC_ANSWER POOL_REC_IDP_CONF Rec. Add.-Partner Rec. remark UST-IdNr. Rec. country POOL_REC_DISTRICT_OF_CUSTOMS weight number of shipments customs type POOL_WORKSTATION POOL_ZOLL_MRNNUMBER Advance Nat. POOL_V_PREVIEW_NAT_TERM undeliverability notice POOL_AVISE POOL_V_PREVIEW_INT POOL_V_PREVIOUS_INT_TERM POOL_V_PREVIOUS_INT_TRANSP POOL_EPACK_AHEAD POOL_IDENTEXPRESS POOL_EXCHANGE_DIFFERENDERETADDR POOL_EXCHANGE_EXCHANGE_TYPE POOL_EXCHANGE_TEST_TYPE POOL_EXCHANGE_PERFORMANCE_ATTR POOL_SHIPMENT_ID POOL_EXWORKS POOL_CONTENTS POOL_USAGE_PURPOSE POOL_PREDATE POOL_SHIPPMENTCONTENTDHL POOL_INVOICETYPEDHL POOL_INVOICENUMBERDHL POOL_INVOICEDATEDHL POOL_SIGNATORYDHL POOL_CUSTOMSTARIFFDHL POOL_INVOICEDHL POOL_EXPORTTYPEDHL POOL_EXPORTREASONDHL POOL_INVOICEITEMSDHL POOL_EXTRADATA POOL_ADDITIONAL_1 POOL_ADDITIONAL_2 POOL_ADDITIONAL_3 customs declaration

The header data is not output in the standard configuration.

Content

The content can look like this:

121212 asas 1 101 EUR EUR 1KuAbw8 Johannes Neumann 21465 Reinbek Borsigstrasse 24 0 Johannes Neumann DE 2.5 1 0 1 Test product|1124.0Test product|1124.0

Note the last column here: this can also contain the | character as a separator symbol for the customs declaration.

Application

The CSV files are available for DHL Easylog, DPD Delisprint and GLS Gepard. An XML file is generated for the connection to UPS Worldship. DPD, DHLand Internetmarke are also directly connected via the respective web service. In addition, Wemalo provides a connection to Shipcloud, in which all common shipping service providers are contained in one interface.

Example

Sendungs Ref-Nr.|Abs. Ref-Nr.|Abs. Bemerkung|Mand. Ref-Nr.|Verfahren|Teilnahme|Kostenstelle|Produkt|Serviceliste|NN Währung|TVWährung|Empf. Ref-Nr.|Empf. Name1|Empf. Name2|Empf. Name3|Empf. PLZ|Empf. Ort|Empf. Ortsteil|Empf. Strasse|Empf. Hausnr.|Empf. Tel|Empf. Fax|POOL_EMPF_EMAIL|POOL_EMPF_GEBDATUM|POOL_EMPF_AUSWEISNR|POOL_EMPF_AUSWEISART|POOL_EMPF_AUSWEISBEH|POOL_EMPF_MINDESTALTER|POOL_EMPF_MA_ORT|POOL_EMPF_MA_STADTTEIL|POOL_EMPF_MA_STRASSE|POOL_EMPF_NACHNAME|POOL_EMPF_VORNAME|POOL_EMPF_VERTRAG_ID|POOL_EMPF_STAATSANGEHOERIGKEIT|POOL_EMPF_ZUSAETZLICHEABFRAGE|POOL_EMPF_ANTWORT|POOL_EMPF_IDP_CONF|Empf. An.-Partner|Empf. Bemerkung|UST-IdNr.|Empf. Land|POOL_EMPF_ZOLLBEZIRK|Gewicht|Sendungsanzahl|Zoll-Warenart|POOL_WORKSTATION|POOL_ZOLL_MRNNUMBER|Vorausverf. Nat.|POOL_V_VORAUSVERF_NAT_TERMIN|Unzustellbarkeitsanzeige|POOL_AVISE|POOL_V_VORAUSVERF_INT|POOL_V_VORAUSVERF_INT_TERMIN|POOL_V_VORAUSVERF_INT_TRANSP|POOL_EPACK_VORAUS|POOL_IDENTEXPRESS|POOL_TAUSCH_ABWEICHENDERETADDR|POOL_TAUSCH_TAUSCHTYP|POOL_TAUSCH_PRUEFUNGTYP|POOL_TAUSCH_LEISTUNGATTR|POOL_SHIPMENT_ID|POOL_EXWORKS|POOL_CONTENTS|POOL_VERWENDUNGSZWECK|POOL_VORDATE|POOL_SENDUNGSINHALTDHL|POOL_RECHNUNGSARTDHL|POOL_RECHNUNGSNUMMERDHL|POOL_RECHNUNGSDATUMDHL|POOL_UNTERZEICHNERDHL|POOL_ZOLLTARIFDHL|POOL_RECHNUNGSBEMDHL|POOL_EXPORTARTDHL|POOL_EXPORTGRUNDDHL|POOL_RECHNUNGSPOSITIONENDHL|POOL_EXTRADATA|POOL_ADDITIONAL_1|POOL_ADDITIONAL_2|POOL_ADDITIONAL_3|Zollinhaltserklärung
121212|||asas|1|||101||EUR|EUR|1KuAbw8||Johannes Neumann||21465|Reinbek||Borsigstrasse|24||||||00||||||Johannes Neumann||||||||||DE||2.5|1||0||||||||||||1||||||||||||||||||||||”Testproduct|1124.0Testproduct|1124.0″

Example 2

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
Shipment Ref-No. sender Ref. no. sender remark Mand. Ref. no. proceedings participation cost center product service list NN Currency TV currency Rec. Ref. no. Rec. Name1 Rec. Name2 Rec. Name3 Rec. PLZ Rec. location Rec. district Rec. Street Rec. Hausnr. Rec. Tel Rec. fax POOL_REC_EMAIL POOL_REC_DATEOFBIRTH POOL_REC_CARD_NO POOL_REC_TYPE_OF_CARD POOL_REC_ID POOL_REC_MINIMUM_AGE POOL_REC_MA_LOCATION POOL_REC_MA_DISTRICT POOL_REC_MA_STREET POOL_REC_SURNAME POOL_REC_FIRST_NAME POOL_REC_CONTRACT_ID POOL_REC_CITICENSHIP POOL_REC_ADDITIONAL_QUERY POOL_REC_ANSWER POOL_REC_IDP_CONF Rec. Add.-Partner Rec. remark UST-IdNr. Rec. country POOL_REC_DISTRICT_OF_CUSTOMS weight number of shipments customs type POOL_WORKSTATION POOL_CUSTOMS_MRNNUMBER Advance Nat. POOL_V_PREVIEW_NAT_TERM undeliverability notice POOL_AVISE POOL_V_PREVIEW_INT POOL_V_PREVIOUS_INT_TERM POOL_V_PREVIOUS_INT_TRANSP POOL_EPACK_AHEAD POOL_IDENTEXPRESS POOL_EXCHANGE_DIFFERENDERETADDR POOL_EXCHANGE_EXCHANGE_TYPE POOL_EXCHANGE_TEST_TYPE POOL_EXCHANGE_PERFORMANCE_ATTR POOL_SHIPMENT_ID POOL_EXWORKS POOL_CONTENTS POOL_USAGE_PURPOSE POOL_PREDATE POOL_SHIPPMENTCONTENTDHL POOL_INVOICETYPEDHL POOL_INVOICENUMBERDHL POOL_INVOICEDATEDHL POOL_SIGNATORYDHL POOL_CUSTOMSTARIFFDHL POOL_INVOICEDHL POOL_EXPORTTYPEDHL POOL_EXPORTREASONDHL POOL_INVOICEITEMSDHL POOL_EXTRADATA POOL_ADDITIONAL_1 POOL_ADDITIONAL_2 POOL_ADDITIONAL_3 customs declaration
121212 asas 1 101 EUR EUR 1KuAbw8 Johannes Neumann 21465 Reinbek Borsigstrasse 24 0 Johannes Neumann DE 2.5 1 0 1 Test product|1124.0Test product|1124.0



DHL customs declaration

A customs declaration can also be generated via DHL’s web service.

The following data is used in the product master:

  • Country of origin (ISO code (ISO-2- Alpha))
  • customs tariff number
  • weight
  • SKU
  • name

The following data from the order items:

  • Price per item
  • Packed quantity



Shipping profile COD DPD/DHL Webservice

Shipping profile last name for DHL and DPD

After creating a shipping account, the shipping profile can be created. The product, the label size and optionally the surname intended use must be specified.

The following placeholderscan be defined for the intended purpose:

  • {PROFILE_NAME} = >Shipping profile name
  • {ORDER_NR} = >Client order number
  • {ORDER_ID} = >internal order ID
  • {COUNTRY_CODE} = > Country indicator, e.g. DE for Germany
  • {NAME_1} =>Name 1
  • {NAME_2} => Name 2
  • {NAME_3} => Name 3

For purpose, you can use for example: {ORDER_NR}, {COUNTRY_CODE} {NAME_1}

The specification would then be for example 4455664, DE Max Mustermann

Note on DPD

Please note that the intended purpose may only be 14 characters long! In the above example, it would therefore be reduced to 4455664, DE Ma.

Note about DHL

For the intended use, intended use 1 and 2 are filled. Both fields can be used for max. 35 characters long. If the intended use is longer than 35 characters, it will be divided by wemalo into both fields.




UPS WorldShip Setup

Wemalo supports the export of shipping data for UPS Worldship as an XML file. The following data is required for this:

  • UPS Client Number
  • product (in WorldShip BillingOption, e.g. PP)
  • Method (in Worldship ServiceType, for example, ST)
  • Duties and taxes to be borne by
  • Transport at the expense of

Sample export of an XML file:

<?xml version="1.0" encoding="UTF-8"?>
<OpenShipments xmlns="x-schema:OpenShipments.xdr">
 <OpenShipment ProcessStatus="" ShipmentOption="">
 <ShipTo>
 <CompanyOrName>Test-Spediteur</CompanyOrName>
 <Attention>Test Z.2</Attention>
 <Address1>TestStr. 10-13</Address1>
 <Address2>1st floor right</Address2>
 <CountryTerritory>DE</CountryTerritory>
 <CityOrTown>Wiesbaden</CityOrTown>
 <Telephone>0049-123456789</Telephone>
 <StateProvinceCounty/>
 <PostalCode>11111</PostalCode>
 </ShipTo>
 <ShipFrom>
 <CompanyOrName>Johannes Neumann</CompanyOrName>
 <Attention>-</Attention>
 <Address1>Dr.-Raber-Str. 4</Address1>
 <CountryTerritory>DE</CountryTerritory>
 <CityOrTown>Hagenow</CityOrTown>
 <Telephone>0</Telephone>
 <PostalCode>19230</PostalCode>
 </ShipFrom>
 <ShipmentInformation>
 <ShipperNumber>test1234</ShipperNumber>
 <ServiceType>ST</ServiceType>
 <BillingOption>PP</BillingOption>
 <NumberOfPackages>1</NumberOfPackages>
 <DescriptionOfGoods>textiles</DescriptionOfGoods>
 </ShipmentInformation>
 <Package>
 <Weight>1</Weight>
 <PackageType/>
 <Reference1>12121</Reference1>
 <Reference2>sasasa</Reference2>
 </Package>
 </OpenShipment>
</OpenShipments>



DPD Connection Guide

The following data is required to connect Weamlo to the DPD cloud service:

  • UserCredentials CloudUserID
  • UserCredentials Token
  • if not yet available, please contact ci@dpd.de – lasts approx. 1 day

In Wemalo, shipping profiles are created under Configuration- >Shipping profiles. A shipping account should also be set up for DPD to store the above information. Subsequently, shipping profiles can be stored referencing the account, e.g. for the different shipping products of the provider.




DHL Connection Guide

The following information is required to use the DHL Mailing Web Service:
  • Your EKP number
  • Login and password for the DHL business customer portal. Please create a new user for us.
  • The product “Send” must already be activated for you. If you have any questions, please contact your DHL contact directly.

In Wemalo, shipping profiles are created under Configuration- >Shipping profiles. A shipping account should also be set up for DHL to store the above information. Subsequently, shipping profiles can be stored referencing the account, e.g. for the different shipping products of the provider.




Create shipping profiles

New shipping profiles can be created via “Configuration- > Shipping profiles- > New shipping profile”.

Tab_Configuration_Dispatch_Profiles

Create_shipping_profile

All fields are optional, so you can also create an empty shipping profile.

Create_shipping_profile2

Finally, click “Save” to save your new record.

Save2