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



packing

Warehouse management – > KO-Box pack – >Scan KO-Box, then scan each product, close package, select packaging material – > Print postage strip, glue on.




Create stock transport orders

Via „Warehouse management – > Stock transfer“ you can create new „Stock transfer orders“.

Stock_rearrangement_Rider

Click the „Display“ icon in the „Actions“ column.

Using the „Filter“ function, you can restrict the displayed entries.

You can use the „Filter“ function to restrict the entries displayed.

Process stock transport orders2

Mit der Funktion „Filter“ können Sie die angezeigten Einträge einschränken. You can also enter the barcode number manually.

Confirm your entry.

Process_stock_transport_orders3_Barcodes

Now the articles deposited to the barcode are indicated to you on the storage space.

In the column „Actions“ enter the quantity of the articles and then click on „Add all“.

Edit stock transport orders4_Select_products

You will now be prompted to specify the new „destination location“ of the item or to scan its barcode.

Then click on „Move“ to save the order.

Process stock transport orders5_Select_storage_location_store

 




Create packaging material

Via „Configuration- >Packaging material- > New packaging material“ you get to a list with all known „packaging materials“.

Tab_Configuration_Packaging material

Packaging_material_new

„Name“ is the only mandatory field, all other fields are optional.

Packaging_material_new_mandatory_fields

Finally, click Save to save the new record.

Save2

 




tie forms to a warehouse

Via „Master data- > Form master data“ you can assign documents, such as barcode forms, to a warehouse.

Tab_Master data_Form master data

To do this, select a warehouse.

Warehouse_Form_Data_Select Warehouse

In the following list, you can store documents for each „template type“ with the „Upload file“ button.

Warehouse_Form_Data_Select_Form

Select the appropriate file from your file system.

The newly uploaded documents are listed in the „Uploaded“ column after the respective template type.

Warehouse_Form_Data_Upload

Please note that uploading a file may take some time. In the lower left corner of the browser window you can see the progress bar during the upload.

loading status




Edit warehouse position

Via Master data- >Warehouse master data, you reach a list with all available warehouses.

Tab_Master data_Warehouse master data

In the „Actions“ column there is a yellow button which you can use to edit the position of the respective warehouse.

Warehouse_Storage_item

Sie werden nun zur „Positionen“-Maske weitergeleitet.You will now be redirected to the „Positions“ screen.

Warehouse_Position

You can use the „Filter“ function at the top left to restrict the „stock items“ displayed.

Tab_Warehouse_Manager_Filter

In the „Action“ column, click the „Edit“ button for a specific „Stock item“ to be able to edit it.

Edit_Ware_Storage_Item

The field „Position name“ must be filled, the remaining fields may remain empty. The „Barcode“ field cannot be overwritten.

Edit_Warehouse_Position_2

After you have modified a record, click „Edit“ to save it.




Create products

Via „Master data- > product master data“ you can access all known products.

Tab_Master data_product master data

Via „Create new product“ you can create products that are not yet listed.

Create_product

First select a „client“.

For each new product a „SKU“ (article number) must be entered, the remaining fields may remain empty.

Create_product2

Scroll all the way down to save the new record.

Save