The Transfer module is a generic module for the exchange of transaction data. Here, outgoing data is sent from xentral to the target system or made available for retrieval. Incoming data is fetched, read in and processed further.
The direction of this description refers to the perspective of xentral, i.e. the ERP.
Directions:
-
Outgoing: Outgoing data is stored in the FTP directory, for example, to be fetched from there
-
Incoming: Incoming data is copied to the folder from outside and regularly read in by xentral and interpreted or converted to orders, for example
This module is particularly relevant if a system is or will be connected to xentral.
The standard version of the module already offers a variety of options for connecting to shipping or fulfillment service providers, for example. Typically, orders are sent to the fulfiller and shipping information is returned to xentral. However, the system can also be used, for example, to transfer inventory data (stock figures), to transfer items or to provide documents such as orders, delivery bills or invoices as PDFs.
The following technical transfer types (type) are available in the standard:
-
FTP
-
FTPS (username and password, no certificates)
-
SFTP
-
E-mail
-
Local storage on server
-
API
The following transfer formats are available as standard:
-
XML
-
PDF
-
XML with integrated PDF (Base64-encoded)
-
XML and PDF in separate files
-
CSV (Comma Separated Values, simplified Excel format)
-
API
Additional transfer modules can be used to configure further interfaces and transfer formats:
-
AmazonMfn (Amazon MFN - Merchant Fulfillment Network)
-
AmazonVendor (Amazon Vendors)
-
App4Sales (offline order entry for field staff)
-
Brickfox (Portal for connecting multiple services)
-
EDI (Electronic Data Interchange)
-
EDI (Sport 2000)
-
Netstock
-
OpenTrans (XML format)
-
Pixi (Descartes Pixi WMS)
-
Smarty (template generator for any text format)
The tab Monitor lists all successful and faulty transmissions of the module as a filterable and searchable list. The filtering can be differentiated according to errors or message types (e.g. stock, tracking, article, order, purchase order). In addition, the account and thus the remote station can be filtered via the list.
If data is to be processed by configuration in two steps, e.g. because in the introductory phase of an interface this was set to Manual release required, the messages to be transmitted appear in the tab Wait for approval and can be released here.
All created accounts are listed under the tab Accounts.
Based on an API account (see below), any number of accounts can be defined for the transfer with a counterpart. In many cases it can be useful to distribute the transmissions to several accounts, e.g. to be able to test and monitor them better, but also if different intervals are to be used. One account can configure outgoing and incoming messages. In more complex environments it may be useful to split this into two or more accounts.
Before setting up one or more accounts, an API must be created. Although in many cases this does not require a URL or access data for the transfer module, it is necessary in order to define the remote station. It is advisable to create at least one API account per remote station and to use it only once with regard to message type and direction.
The administration of API accounts is not part of the transfer module and can be done at Administration > System > API Account.
To create a new API account click on +New. If you want to edit an existing one click on the pen icon.
The example of the XML account shows that it basically only needs to be created and activated when used for the Transmissions module. Further settings are usually not necessary.
 |
A new transmission can be created using the +New button. The following options are available:
Settings
-
active: Selection when transmission is used. If not selected, it will be deactivated
-
Name: Name of the transmission, which can be freely assigned
Communication
-
API: Selection of an API account**
-
Transmission format: The transmission format designates the format of the file content. In most cases, these are text files that contain structured data (such as CSV or XML) in order to be easily read and interpreted on the other side. In case of doubt and if there is flexibility on the other side, always choose the standard formats in xentral: (XML (xentral standard format), PDF (non-structured data e.g. for backup purposes or for document-based further processing), XML with integrated PDF (Base64-encoded), XML and PDF in separate files, CSV (xentral standard format, Comma Separated Values, simplified Excel-Fomat), API. Additional transfer modules can be used to configure other interfaces and transfer formats: AmazonMfn (Amazon MFN Merchant Fulfillment Network), AmazonVendor (Amazon Vendors), App4Sales (offline order entry for field staff), Brickfox (portal to connect multiple services), DS (DS Logistics), EDI (Electronic Data Interchange), EDI (Sport 2000), Netstock, OpenTrans (XML format), Pixi (Descartes Pixi WMS), Smarty (template generator for any text formats). The description of the formats and further notes can be found in the respective modules. Please change the transmission format of an account first and then go to the help page in the module
-
Type: The following technical transfer types (type) are available in the standard: FTP, FTPS (username and password, no certificates), SFTP, Email, Local storage on server, API
-
Encoding (Send): Selection in which encoding the transmission should be sent (UTF-8, ISO-8859-1, ISO-8859-15, Windows-1252, CP1256)
-
Server: Specify the server where the transmission should go to
-
Port: Port on the recipient server that will be addressed
-
SSL: Specify if the transmission should be encrypted with SSL
-
Username: The user who is logged into xentral, is prefilled by xentral. However, this can be changed manually
-
Password: Password in xentral of the corresponding user
-
OAuth Client ID: Client ID from the service where the API is set up
-
OAuth Client Secret: Client Secret from the service where the API is set up
-
OAuth URL: URL to which the permission to use the data from the service should be sent back to xentral
-
Location (Output): Output of documents from xentral (Optional if xentral is used by fullfilment service providers Output of "Other Actions" warehouse numbers and tracking numbers for slave xentral or ERP from customers)
-
File name prefix: All file names with this prefix will be ignored
-
Response location (input): Input for orders, warehouse, tracking, items etc
-
Response file name prefix: All response file names with this prefix will be ignored.
-
Delete from server after download: These files will be deleted from the server after download.
Send documents
-
Document type: Available documents for transmission are: Order, Invoice, Credit bill, Quotation, Delivery bill, Purchase order, Return, Liability, Goods receipt QA report. Alternatively (e.g. if only the transfer of stock values is desired) "no documents" can be selected
-
Document status: Indication whether the status is created, released, sent or completed
-
Project: Assignment of the transmission to a project
-
Address: Address to which the document is to be sent
-
Group: Indication to which group the address belongs
-
Manual release required: Specification that documents are first released manually
-
Start from ID: Select invoice ID from which the transmission is to start
-
Start from date: Date from which the transmission should start
-
Labels: Select self-defined labels that will be assigned to the transmission. In the overview, it is then possible to filter by these labels, whereby it should be noted that if several labels are assigned, it is also necessary to filter by all of them when filtering, so that this appears in the overview
-
Stationery in XML: Select that the stationery is stored Base64encoded in XML
-
Maximum simultaneous transfers: Number of documents that the process starter transfers at the same time
-
Each document in its own XML: Selection that each document is stored in its own XML
-
XML addition: Specify the XML addition
-
Tracking Mail: Specification that a tracking mail will be sent
-
Invoice Mail: Specify that the invoice email will be sent automatically when the tracking number is reported back by the fulfiller. If there are multiple tracking numbers, the invoice email will only be sent once. The requirements for this are that the check mark in the Transmissions module for "Invoice Mail" is set, the invoice with the customer email addresses and customer names already exists and that the invoice amount is greater than 0
-
Create invoice: Select that if the delivery note or tracking number is reported back and the matching invoice is still missing, an invoice will be created automatically
-
Transfer file as attachment: Select that the file will be transferred as an attachment
-
Transfer attachment as: Select how the attachment should be transferred (as a separate file or Base64 encoded in the document)
Receive documents
-
Receive orders/quotations: Specify that orders or quotations are to be received
-
Transfer customer number from external system: Specify that the customer number is to be transferred from the external system
-
Receive orders: Specify that orders are to be received
-
Create production instead of order: Specify that a production is to be created instead of an order
-
Own address: Selection of own address. This must have been created previously under Master data > Addresses
-
Receive stock figures: Selection that the stock figures are to be received
-
Ignore storage bin in file receipt: Specify that the storage bin in the file receipt is to be ignored.
-
Warehouse: Storage bin for confirmations without storage bin specification
-
Receive tracking: Specify that tracking should be received (Note: Currently, tracking number from xentral to external system can only be played out for the transfer format XML, but not for CSV)
-
Automatic feedback: Independent of delivery bills and tracking numbers, an order will be finalized after X days at the latest and possibly reported back to stores and marketplaces. Only orders that have been sent via transmission module max. 14 days ago will be considered. Automatic feedback can be disabled in the store interfaces
-
Receive articles Not found articles: Indication that if articles are received but these are not found, an error is displayed in the transmission monitor
-
Search supplier number as well: Specify that supplier numbers should be searched as well
-
Always post order to supplier: Specify that an order is always posted to the supplier
Create article
-
Create missing articles: Specification that missing articles from order items should be created automatically
-
Mark missing items as stock items: Specify that missing items should be marked as stock items
Receive articles
-
Receive articles (new articles): Specify that article data should be taken into account when receiving articles
-
Update articles: Indication that in case of deviations of article data to the master data the deviating information should be overwritten
Stock figures
-
Stock figures from xentral to external system: Indication that the stock figures are to be transferred from xentral to the external system
-
Warehouse: Selection of the warehouse
-
Storage location: Selection of the storage location
-
Send "saleable" quantity: specification that the saleable (existing - reserved quantity) quantity is to be sent
-
Transfer at: Specify the time when the transfer should take place
-
Send sales report: Indication that a sales report is to be sent
-
Time range: selection of whether the sales report should be sent daily, weekly, or monthly
Other actions
-
Tracking from xentral to external system: Specify that tracking from xentral to the external system should take place
-
Transfer articles: With this button articles can be transferred to the external system
-
Automatically transfer new articles: Specify that new articles are automatically transferred to the external system
This tab contains a list of all files to be transferred that have to be released manually. This works by selecting the corresponding transfers and then releasing them via the Release button.
In this tab the documents that should be transferred can be selected and then added to the list using the Add order to transfer button. During the next transfer, these documents will be added and move to the Transfer tab. The processing of the documents collected here is done via process starter and is limited to one number per run (limitation in the interface settings). Documents can be removed from the list using the Delete requests button.
This tab contains a list of all documents that have already been transferred. Among other things, the date and time of the transfer can be taken from the list. The files can be deleted on the server. The transfer history is also saved and logged.
The transferred XML files are located in this tab. Even if the files are deleted on the server, the history is displayed here.
If the tracking option was selected under the Details tab, all tracking data will be listed here. This means that all returned tracking numbers are displayed. Transferred documents without tracking numbers can be viewed in the Transferred tab.
If the bearing number option has been selected under the Details tab, all returned bearing numbers will be listed here.
If the Receive items Not found option was selected under the Details tab, all errors will appear listed in the error tab. This therefore corresponds to an error log of all unprocessed data. If a tracking number cannot be assigned to the matching document, an entry is created here in the error log. If there is still no tracking number for a document, you can check the error log to see if there was an incorrect response. If there are no entries, the tracking number was not reported.
Note
If working with CSV-Standard in xentral, multiple orders will be given out in one file. When working with Smarty for customizing, every document will contain only one dispatch note/order.
adresse;artikel;beleg_projekt;art;beleg_status;beleg_datum;beleg_versandart;beleg_belegnr;beleg_kundennummer;beleg_name;beleg_abteilung;beleg_unterabteilung;beleg_adresszusatz;beleg_ansprechpartner;beleg_telefon;beleg_email;beleg_land;beleg_strasse;beleg_plz;beleg_ort;beleg_internebemerkung;beleg_internebezeichnung;beleg_freitext;beleg_lieferbedingung;artikel_nummer;artikel_bezeichnung;artikel_beschreibung;artikel_menge;artikel_lieferdatum;artikel_sort;artikel_einheit;artikel_zolltarifnummer;artikel_herkunftsland;artikel_artikelnummerkunde;artikel_freifeld1;artikel_freifeld2;artikel_freifeld3;artikel_freifeld4;artikel_freifeld5;artikel_freifeld6;artikel_freifeld7;artikel_freifeld8;artikel_freifeld9;artikel_freifeld10;artikel_freifeld11;artikel_freifeld12;artikel_freifeld13;artikel_freifeld14;artikel_freifeld15;artikel_freifeld16;artikel_freifeld17;artikel_freifeld18;artikel_freifeld19;artikel_freifeld20;artikel_freifeld21;artikel_freifeld22;artikel_freifeld23;artikel_freifeld24;artikel_freifeld25;artikel_freifeld26;artikel_freifeld27;artikel_freifeld28;artikel_freifeld29;artikel_freifeld30;artikel_freifeld31;artikel_freifeld32;artikel_freifeld33;artikel_freifeld34;artikel_freifeld35;artikel_freifeld36;artikel_freifeld37;artikel_freifeld38;artikel_freifeld39;artikel_freifeld40;artikel_ean;artikel_preisfuermenge; 2"4";"43";"STANDARD";"lieferschein";"freigegeben";"2021-03-10";"dhlexpress";"300102";"10001";"Eva Müller";"";"";"";"";"089120550";"patrick.ackermann@xentral.com";"DE";"Musterweg 12a";"86150";"Augsburg";"";"";"";"";"1000023";"Exportartikel";"";"1";"0000-00-00";"1";"";"250880";"Deutschland";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"1";
Free fields are only imported into the order if the individual receipts have been approved for the use of free fields under Basic settings > Free fields.
beleg_projekt;art;beleg_status;beleg_datum;beleg_tatsaechlicheslieferdatum;beleg_versandart;beleg_zahlungsweise;beleg_belegnr;beleg_kundennummer;beleg_name;beleg_abteilung;beleg_unterabteilung;beleg_adresszusatz;beleg_ansprechpartner;beleg_telefon;beleg_email;beleg_land;beleg_strasse;beleg_plz;beleg_ort;beleg_aktion;beleg_internebemerkung;beleg_internebezeichnung;beleg_freitext;beleg_ihrebestellnummer;beleg_lieferbedingung;beleg_art;artikel_nummer;artikel_bezeichnung;artikel_beschreibung;artikel_menge;artikel_preis;artikel_rabatt;artikel_waehrung;artikel_lieferdatum;artikel_sort;artikel_umsatzsteuer;artikel_einheit;artikel_zolltarifnummer;artikel_herkunftsland;artikel_artikelnummerkunde;artikel_freifeld1;artikel_freifeld2;artikel_freifeld3;artikel_freifeld4;artikel_freifeld5;artikel_freifeld6;artikel_freifeld7;artikel_freifeld8;artikel_freifeld9;artikel_freifeld10;artikel_freifeld11;artikel_freifeld12;artikel_freifeld13;artikel_freifeld14;artikel_freifeld15;artikel_freifeld16;artikel_freifeld17;artikel_freifeld18;artikel_freifeld19;artikel_freifeld20STANDARD;auftrag;freigegeben;2021-11-25;2021-11-26;DHL;cashinadvance;200219;10018; Max Mustermann;Abteilung;Unterabteilung;Adresszusatz;ASP;123456789;test@mail.com;DE;Fuggerstraße 11;86150;Augsburg;aktion;eigener-shop.de;interneBez;freitext;bestellnummer;lieferbed;standardauftrag;100002;Test Product;Beschreibung;4;251,26;0.00;EUR;2022-05-04;1;normal;oz;250880;BY;Fremdnummer Kunde;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;FreifeldSTANDARD;auftrag;freigegeben;2021-11-25;2021-11-26;DHL;cashinadvance;200219;10018; Max Mustermann;Abteilung;Unterabteilung;Adresszusatz;ASP;123456789;test@mail.com;DE;Fuggerstraße 11;86150;Augsburg;aktion;eigener-shop.de;interneBez;freitext;bestellnummer;lieferbed;standardauftrag;Versand;Versand/shipping;Beschreibung;1;4,15966387;0.00;EUR;2022-05-06;2;normal;stk;2208880;BW;Fremdnummer Kunde;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld;Freifeld
Note
In contrast to XML, no information on BBD/batch/serial number can be processed via tracking feedback via CSV.
belegnr;tracking;tracking_link;versandart 2300111;1234567890;https://example.com/?tracking=1234567890;dhl
In this section you can find sample files for shipping service providers or fulfillment providers. Examples of csv files can be found in our download directory.
Below is the data structure of the delivery note with all necessary fields. The PDF file of the delivery note or other attachments can be found in the pdf base64 encoded field.
<?xmlversion="1.0"encoding="UTF-8"?>
<response>
<xml>
<lieferschein_list>
<lieferschein>
<datum>2016-11-10</datum>
<projekt>1</projekt>
<lieferscheinart />
<belegnr>13256</belegnr>
<bearbeiter>Sachbearbeiter1</bearbeiter>
<auftrag>AH200019</auftrag>
<auftragid>15</auftragid>
<freitext />
<status>versendet</status>
<adresse>26</adresse>
<name>Musterfirma GmbH</name>
<abteilung />
<unterabteilung />
<strasse>Müsterstraße 12</strasse>
<adresszusatz />
<ansprechpartner />
<plz>12345</plz>
<ort>Musterhausen</ort>
<land>DE</land>
<ustid />
<email>musterfirma@waw.de</email>
<telefon />
<telefax />
<betreff />
<kundennummer>12000</kundennummer>
<versandart>DHL</versandart>
<versand />
<firma>1</firma>
<versendet>1</versendet>
<versendet_am>2016-11-10 12:05:35</versendet_am>
<versendet_per>sonstiges</versendet_per>
<versendet_durch>VersandMA1</versendet_durch>
<inbearbeitung_user>0</inbearbeitung_user>
<logdatei>2016-11-10 12:06:59</logdatei>
<vertriebid>0</vertriebid>
<vertrieb>Johannes Schmid</vertrieb>
<ust_befreit>0</ust_befreit>
<ihrebestellnummer />
<anschreiben />
<usereditid>1</usereditid>
<useredittimestamp>2016-11-10 12:06:59</useredittimestamp>
<lieferantenretoure>0</lieferantenretoure>
<lieferantenretoureinfo />
<lieferant>0</lieferant>
<schreibschutz>1</schreibschutz>
<pdfarchiviert>0</pdfarchiviert>
<pdfarchiviertversion>0</pdfarchiviertversion>
<typ>firma</typ>
<internebemerkung />
<ohne_briefpapier>0</ohne_briefpapier>
<lieferid>0</lieferid>
<ansprechpartnerid>0</ansprechpartnerid>
<projektfiliale>0</projektfiliale>
<projektfiliale_eingelagert>0</projektfiliale_eingelagert>
<zuarchivieren>0</zuarchivieren>
<internebezeichnung />
<angelegtam>0000-00-00 00:00:00</angelegtam>
<kommissionierung>0</kommissionierung>
<sprache />
<bodyzusatz />
<id_ext />
<rechnung_name>Musterfirma GmbH</rechnung_name>
<rechnung_anrede />
<rechnung_strasse>Musterstrasse 12</rechnung_strasse>
<rechnung_adresszusatz />
<rechnung_ansprechpartner>Mustermann</rechnung_ansprechpartner>
<rechnung_abteilung />
<rechnung_unterabteilung />
<rechnung_plz>12345</rechnung_plz>
<rechnung_ort>Musterhausen</rechnung_ort>
<rechnung_land>CN</rechnung_land>
<anzahluebertragungen>1</anzahluebertragungen>
<lieferschein_position_list>
<lieferschein_position>
<lieferschein>10</lieferschein>
<projekt>1</projekt>
<bezeichnung>Musterartikel</bezeichnung>
<beschreibung />
<internerkommentar />
<nummer>AI-100-2</nummer>
<seriennummer />
<menge>3</menge>
<lieferdatum>0000-00-00</lieferdatum>
<vpe />
<sort>1</sort>
<status>angelegt</status>
<bemerkung />
<geliefert>0</geliefert>
<abgerechnet>0</abgerechnet>
<logdatei>2016-11-10 11:59:02</logdatei>
<explodiert_parent_artikel>0</explodiert_parent_artikel>
<einheit />
<zolltarifnummer>0</zolltarifnummer>
<herkunftsland>0</herkunftsland>
<artikelnummerkunde />
<freifeld1 />
<freifeld2 />
<freifeld3 />
<freifeld4 />
<freifeld5 />
<freifeld6 />
<freifeld7 />
<freifeld8 />
<freifeld9 />
<freifeld10 />
<lieferdatumkw>0</lieferdatumkw>
<auftrag_position_id>30</auftrag_position_id>
<kostenlos>0</kostenlos>
<lagertext />
<teilprojekt>0</teilprojekt>
<explodiert_parent>0</explodiert_parent>
<id_ext />
<ean />
<gewicht />
<herstellernummer />
<lagerartikel>1</lagerartikel>
</lieferschein_position>
</lieferschein_position_list>
</lieferschein>
</lieferschein_list>
</xml>
</response>
If entries for Auftrag/Lieferschein are created, the return order is connected to those documents. Return reasons won't be added to the general RMA reasons. They are only selected for this specific document. It's not possible to use existing RMA reasons. It is not possible to change the stock value with this return.
The following template can only be used when selecting Smarty as transfer format. This will make the check box Import all documents types in the Receive receipts section available. Select this check box.
<?xml version="1.0" encoding="utf-8" standalone="yes"?> <response> <xml> <retoure_list> <retoure> <datum>06.09.2021</datum> <retoureart/> <belegnr/> <auftrag>200133</auftrag> <lieferschein>300083</lieferschein> <retoure_position_list> <retoure_position> <nummer>100016</nummer> <menge>1.0000</menge> <lieferdatum>25.09.2020</lieferdatum> <beschreibung>Description</beschreibung> <grund>Return Reason</grund> </retoure_position></retoure_position_list> </retoure> </retoure_list> </xml> <status> <action>belege</action> <message>OK</message> <messageCode>1</messageCode> </status> </response>
<?xmlversion="1.0"encoding="UTF-8"?><response><xml><lieferschein_list><lieferschein><id>87</id><datum>2017-11-02</datum><projekt>1</projekt><lieferscheinart /><belegnr>171102-10</belegnr><bearbeiter>Administrator</bearbeiter><auftrag>200091</auftrag><auftragid>122</auftragid><freitext /><status>versendet</status><adresse>2</adresse><name>Beispielkunde</name><abteilung>Wareneingang</abteilung><unterabteilung>Elektronik</unterabteilung><strasse>Rue de bellvue</strasse><adresszusatz /><ansprechpartner>Testkontakt</ansprechpartner><plz>1620</plz><ort>Brüssel</ort><land>BE</land><ustid>4545446656446</ustid><email /><telefon /><telefax /><betreff /><kundennummer>10003</kundennummer><versandart>DPD</versandart><versand>Administrator</versand><firma>1</firma><versendet>1</versendet><versendet_am>0000-00-00 00:00:00</versendet_am><versendet_per /><versendet_durch /><inbearbeitung_user>0</inbearbeitung_user><logdatei>2017-11-02 08:55:17</logdatei><vertriebid>1</vertriebid><vertrieb>Administrator</vertrieb><ust_befreit>3</ust_befreit><ihrebestellnummer /><anschreiben /><usereditid /><useredittimestamp>0000-00-00 00:00:00</useredittimestamp><lieferantenretoure>0</lieferantenretoure><lieferantenretoureinfo /><lieferant>0</lieferant><schreibschutz>1</schreibschutz><pdfarchiviert>0</pdfarchiviert><pdfarchiviertversion>0</pdfarchiviertversion><typ>firma</typ><internebemerkung /><ohne_briefpapier /><lieferid>0</lieferid><ansprechpartnerid>0</ansprechpartnerid><projektfiliale>0</projektfiliale><projektfiliale_eingelagert>0</projektfiliale_eingelagert><zuarchivieren>0</zuarchivieren><internebezeichnung /><angelegtam /><kommissionierung>65</kommissionierung><sprache /><bundesland /><gln /><rechnungid>53</rechnungid><bearbeiterid /><bodyzusatz /><lieferbedingung /><titel /><standardlager>0</standardlager><kommissionskonsignationslager>0</kommissionskonsignationslager><abweichendebezeichnung>0</abweichendebezeichnung><id_ext /><anzahluebertragungen>1</anzahluebertragungen><rechnung_name>Testkunde</rechnung_name><rechnung_anrede /><rechnung_strasse>Musterstrasse 7</rechnung_strasse><rechnung_adresszusatz>Anlieferbereich C</rechnung_adresszusatz><rechnung_ansprechpartner>Testansprechpartner</rechnung_ansprechpartner><rechnung_abteilung>Einkauf</rechnung_abteilung><rechnung_unterabteilung>Technik</rechnung_unterabteilung><rechnung_plz>848415</rechnung_plz><rechnung_ort>Musterhausen</rechnung_ort><rechnung_land>DE</rechnung_land><internet /><shopextid /><lieferschein_position_list><lieferschein_position><id>127</id><lieferschein>87</lieferschein><artikel>1</artikel><projekt>1</projekt><bezeichnung>Muster</bezeichnung><beschreibung /><internerkommentar /><nummer>1000001</nummer><seriennummer /><menge>5.0000</menge><lieferdatum>0000-00-00</lieferdatum><vpe>1</vpe><sort>1</sort><status>angelegt</status><bemerkung /><geliefert>0.0000</geliefert><abgerechnet>0</abgerechnet><logdatei>2017-11-02 08:55:17</logdatei><explodiert_parent_artikel>0</explodiert_parent_artikel><einheit /><zolltarifnummer /><herkunftsland /><artikelnummerkunde /><freifeld1 /><freifeld2 /><freifeld3 /><freifeld4 /><freifeld5 /><freifeld6 /><freifeld7 /><freifeld8 /><freifeld9 /><freifeld10 /><lieferdatumkw>0</lieferdatumkw><auftrag_position_id>226</auftrag_position_id><kostenlos>0</kostenlos><lagertext /><teilprojekt>0</teilprojekt><explodiert_parent>0</explodiert_parent><freifeld11 /><freifeld12 /><freifeld13 /><freifeld14 /><freifeld15 /><freifeld16 /><freifeld17 /><freifeld18 /><freifeld19 /><freifeld20 /><id_ext /><ean>4001222601064</ean><gewicht /><herstellernummer /><altersfreigabe /><lagerartikel>0</lagerartikel></lieferschein_position><lieferschein_position><id>128</id><lieferschein>87</lieferschein><artikel>3</artikel><projekt>1</projekt><bezeichnung>*** Einbauteil A</bezeichnung><beschreibung>Lager: HL001(5)</beschreibung><internerkommentar /><nummer>1000002</nummer><seriennummer /><menge>5.0000</menge><lieferdatum>0000-00-00</lieferdatum><vpe /><sort>2</sort><status>angelegt</status><bemerkung /><geliefert>0.0000</geliefert><abgerechnet>0</abgerechnet><logdatei>2017-11-02 08:55:17</logdatei><explodiert_parent_artikel>1</explodiert_parent_artikel><einheit /><zolltarifnummer>0</zolltarifnummer><herkunftsland>0</herkunftsland><artikelnummerkunde /><freifeld1 /><freifeld2 /><freifeld3 /><freifeld4 /><freifeld5 /><freifeld6 /><freifeld7 /><freifeld8 /><freifeld9 /><freifeld10 /><lieferdatumkw>0</lieferdatumkw><auftrag_position_id>227</auftrag_position_id><kostenlos>0</kostenlos><lagertext>HL001 (5)</lagertext><teilprojekt>0</teilprojekt><explodiert_parent>127</explodiert_parent><freifeld11 /><freifeld12 /><freifeld13 /><freifeld14 /><freifeld15 /><freifeld16 /><freifeld17 /><freifeld18 /><freifeld19 /><freifeld20 /><id_ext /><ean /><gewicht /><herstellernummer /><altersfreigabe /><lagerartikel>1</lagerartikel></lieferschein_position><lieferschein_position><id>129</id><lieferschein>87</lieferschein><artikel>4</artikel><projekt>1</projekt><bezeichnung>*** Einbaukosten/Stk.</bezeichnung><beschreibung /><internerkommentar /><nummer>1000004</nummer><seriennummer /><menge>5.0000</menge><lieferdatum>0000-00-00</lieferdatum><vpe /><sort>3</sort><status>angelegt</status><bemerkung /><geliefert>0.0000</geliefert><abgerechnet>0</abgerechnet><logdatei>2017-11-02 08:55:17</logdatei><explodiert_parent_artikel>1</explodiert_parent_artikel><einheit /><zolltarifnummer>0</zolltarifnummer><herkunftsland>0</herkunftsland><artikelnummerkunde /><freifeld1 /><freifeld2 /><freifeld3 /><freifeld4 /><freifeld5 /><freifeld6 /><freifeld7 /><freifeld8 /><freifeld9 /><freifeld10 /><lieferdatumkw>0</lieferdatumkw><auftrag_position_id>228</auftrag_position_id><kostenlos>0</kostenlos><lagertext /><teilprojekt>0</teilprojekt><explodiert_parent>127</explodiert_parent><freifeld11 /><freifeld12 /><freifeld13 /><freifeld14 /><freifeld15 /><freifeld16 /><freifeld17 /><freifeld18 /><freifeld19 /><freifeld20 /><id_ext /><ean /><gewicht /><herstellernummer /><altersfreigabe /><lagerartikel>0</lagerartikel></lieferschein_position><lieferschein_position><id>130</id><lieferschein>87</lieferschein><artikel>17</artikel><projekt>1</projekt><bezeichnung>*** Einbauteil B</bezeichnung><beschreibung>Lager: HL001(10)</beschreibung><internerkommentar /><nummer>1000008</nummer><seriennummer /><menge>10.0000</menge><lieferdatum>0000-00-00</lieferdatum><vpe /><sort>4</sort><status>angelegt</status><bemerkung /><geliefert>0.0000</geliefert><abgerechnet>0</abgerechnet><logdatei>2017-11-02 08:55:17</logdatei><explodiert_parent_artikel>1</explodiert_parent_artikel><einheit /><zolltarifnummer>0</zolltarifnummer><herkunftsland>0</herkunftsland><artikelnummerkunde /><freifeld1 /><freifeld2 /><freifeld3 /><freifeld4 /><freifeld5 /><freifeld6 /><freifeld7 /><freifeld8 /><freifeld9 /><freifeld10 /><lieferdatumkw>0</lieferdatumkw><auftrag_position_id>229</auftrag_position_id><kostenlos>0</kostenlos><lagertext>HL001 (10)</lagertext><teilprojekt>0</teilprojekt><explodiert_parent>127</explodiert_parent><freifeld11 /><freifeld12 /><freifeld13 /><freifeld14 /><freifeld15 /><freifeld16 /><freifeld17 /><freifeld18 /><freifeld19 /><freifeld20 /><id_ext /><ean /><gewicht /><herstellernummer /><altersfreigabe /><lagerartikel>1</lagerartikel></lieferschein_position></lieferschein_position_list></lieferschein></lieferschein_list></xml><status><action>belege</action><message>OK</message><messageCode>1</messageCode></status></response>
Version 20.2 or higher: Optionally, shipped batches and/or best before dates (BBD) can also be reported per position. An example is found in the following code. Here, BBDs and batches can be combined individually or together in a block. The block can also be integrated several times with the corresponding partial quantities in the case of multiple batch/BBD combinations. The respective quantity must be specified within the block for this purpose. If no quantity is specified in the block and there is only one block, the total quantity is automatically assigned to the position. If there are several blocks without a quantity specification for a position, the specifications are ignored due to the "non-uniqueness".
If you want to see the used/picked BBDs, batches, and serial number information within your pdf document, you have to enable the display of these information in the basic settings (Administration > System > Basic settings > System tab > Receipts section) before creating your documents.
Mandatory information:
-
Tracking
-
Document number of the delivery note
Optional
-
Id of the delivery note
-
Delivery note positions
-
In the delivery_note_items you can use sort as a field instead of id (this will be the position from 1 to x in the delivery bill)
-
Shipping method as a separate tag if you want to specify a different "carrier" (<shipping method>DHL</shipping method>)
<?xmlversion="1.0"encoding="UTF-8"?>
<response>
<xml>
<lieferschein_list>
<lieferschein>
<belegnr>121212</belegnr>
<tracking>1234567890</tracking>
<tracking_link>http://dhl.de/sendungsverfolgung?tracking=123456</tracking_link>
<tracking_sprache>english</tracking_sprache>
<versandart>DPD</versandart>
<lieferschein_position_list>
<lieferschein_position>
<id>105</id>
<geliefert>3</geliefert>
<serial>SN-123456</serial>
<serial>SN-654321</serial>
<serial>SN-456789</serial>
<mhd_charge_block>
<mhd>2020-12-31</mhd>
<charge>ABC123</charge>
<menge>2</menge>
</mhd_charge_block>
<mhd_charge_block>
<mhd>2022-12-31</mhd>
<charge>DEF456</charge>
<menge>1</menge>
</mhd_charge_block>
</lieferschein_position>
</lieferschein_position_list>
</lieferschein>
</lieferschein_list>
</xml>
</response>
or if it is returned based on the order accordingly so:
<?xmlversion="1.0"encoding="UTF-8"?>
<response>
<xml>
<lieferschein_list>
<lieferschein>
<auftragextid>78787878</auftragextid>
<tracking>1234567890</tracking>
<tracking_link>http://dhl.de/sendungsverfolgung?tracking=123456</tracking_link>
<tracking_sprache>english</tracking_sprache>
</lieferschein>
</lieferschein_list>
</xml>
</response>
Note
auftragextid is the document number of the original order. Furthermore, for this type of confirmation, it is not necessary that the document was previously issued via the Transfer module. If the delivery note for the order does not yet exist, then it will be created based on the confirmation.
Several tracking numbers can also be returned on the basis of the order. For this purpose, the delivery note must be called up again, but with its own value in the Tracking field.
<?xml version="1.0" encoding="UTF-8"?> <response> <xml> <lieferschein_list> <lieferschein> <auftragextid>200003</auftragextid> <tracking>00340434653483059685</tracking> </lieferschein> <lieferschein> <auftragextid>200003</auftragextid> <tracking>00340434653483059677</tracking> </lieferschein> </lieferschein_list> </xml> </response>
Confirmation of several tracking numbers in one file
<?xmlversion="1.0"encoding="UTF-8"?>
<response>
<xml>
<lieferschein_list>
<lieferschein>
<belegnr>200001</belegnr>
<tracking>12345678901231</tracking>
<tracking_link>https://nolp.dhl.de/nextt-online-public/de/search?piececode=12345678901231</tracking_link>
<tracking_sprache>german</tracking_sprache>
<lieferschein_position_list>
<lieferschein_position>
<id>1</id>
<geliefert>12</geliefert>
</lieferschein_position>
<lieferschein_position>
<id>2</id>
<geliefert>2</geliefert>
</lieferschein_position>
</lieferschein_position_list>
</lieferschein>
<lieferschein>
<belegnr>200001</belegnr>
<tracking>12345678901232</tracking>
<tracking_link>https://nolp.dhl.de/nextt-online-public/de/search?piececode=12345678901232</tracking_link>
<tracking_sprache>german</tracking_sprache>
<lieferschein_position_list>
<lieferschein_position>
<id>3</id>
<geliefert>4</geliefert>
</lieferschein_position>
</lieferschein_position_list>
</lieferschein>
</lieferschein_list>
</xml>
</response>
The following block is repeated several times here:
<lieferschein>
<belegnr>200001</belegnr>
<tracking>12345678901232</tracking>
<tracking_link>https://nolp.dhl.de/nextt-online-public/de/search?piececode=12345678901232</tracking_link>
<tracking_sprache>german</tracking_sprache>
<lieferschein_position_list>
<lieferschein_position>
<id>3</id>
<geliefert>4</geliefert>
</lieferschein_position>
</lieferschein_position_list>
</lieferschein>
In the following section the required stock file for the feedback of the stock numbers can be found. Optionally one can add the field mhd or Charge charge for articles with minimum durability date. Then the date for the reported quantity and the stock number will be entered in the optionally specified storage binstock_lot.
-
Number: Item number
-
Stock_number: New stock total
-
Stock_lot: Shelf name from xentral e.g. HL001
Besides the number you can also work with the following information if you have entered it in the item:
-
Ean
-
Manufacturer number
Important
Fulfiller inventory feedback must be coordinated to ensure the following process:
-
Xentral transmits orders with stock deduction (fulfillment stock) to the Fulfiller
-
The Fulfiller processes ALL open orders
-
The stock is balanced on both sides (except for stock changes returns, goods receipts)
-
Only now the report of the stock levels of the Fulfiller is sent back to xentral (ideally in the evening or at night, in case of minor stock changes e.g. only once a week, e.g. at the weekend)
<?xmlversion="1.0"encoding="UTF-8"?>
<response>
<xml>
<artikel_list>
<artikel>
<nummer>123456</nummer>
<lagerzahl>7</lagerzahl>
<lager_platz>HL001</lager_platz>
</artikel>
</artikel_list>
</xml>
</response>
With at least 2 MHDs, the structure looks like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><response>
<xml>
<artikel_list>
<artikel>
<nummer>1650007</nummer>
<lagerzahl>3</lagerzahl>
<lager_platz>KR-HR-11</lager_platz>
<mhd>30.10.2018</mhd>
</artikel>
<artikel>
<nummer>1650007</nummer>
<lagerzahl>3</lagerzahl>
<lager_platz>KR-HR-12</lager_platz>
<mhd>15.02.2019</mhd>
</artikel>
</artikel_list>
</xml>
</response>
<?xml version="1.0" encoding="UTF-8"?><response><xml><auftrag_list><auftrag><datum>2021-05-03</datum><art>standardauftrag</art><projekt>1</projekt><internet>OnlineBestellNummer</internet><bearbeiter>Administrator</bearbeiter><freitext>Freitext</freitext><internebemerkung>Interne Bemerkung</internebemerkung><status>freigegeben</status><firma>0</firma><titel>Dr.</titel><name>Eva Müller</name><abteilung>Abteilung</abteilung><unterabteilung>Unterabteilung</unterabteilung><strasse>Musterweg 12a</strasse><adresszusatz>Adresszusatz</adresszusatz><ansprechpartner>ASP</ansprechpartner><plz>12345</plz><ort>Musterdorf</ort><land>DE</land><ustid>DE11125205</ustid><ust_befreit>3</ust_befreit><email>testmail@xentral.com</email><telefon>089123456789</telefon><telefax>089123456790</telefax><kundennummer>10001</kundennummer><versandart>versandunternehmen</versandart><vertrieb>Administrator</vertrieb><zahlungsweise>rechnung</zahlungsweise><zahlungszieltageskonto>11</zahlungszieltageskonto><abweichendelieferadresse>1</abweichendelieferadresse><liefername>Abweichender Name</liefername><lieferabteilung>Abweichende Abteilung</lieferabteilung><lieferunterabteilung>Abweichende Unterabteilung</lieferunterabteilung><lieferland>DE</lieferland><lieferstrasse>Abweichende Straße</lieferstrasse><lieferort>Augsburg</lieferort><lieferplz>86150</lieferplz><lieferadresszusatz>Lieferzusatz</lieferadresszusatz><lieferansprechpartner>Lieferansprechpartner</lieferansprechpartner><transaktionsnummer>TRANSACTION-100</transaktionsnummer><lieferdatum>2022-05-06</lieferdatum><tatsaechlicheslieferdatum>2022-07-05</tatsaechlicheslieferdatum><ihrebestellnummer>23234324</ihrebestellnummer><anschreiben>1</anschreiben><internebezeichnung>11</internebezeichnung><lieferdatumkw>15</lieferdatumkw><bundesland/><gln></gln><liefergln/><lieferemail/><bundesstaat/><lieferbundesstaat/><auftrag_position_list><auftrag_position><bezeichnung>Schraube Deluxe</bezeichnung><beschreibung><ul><li>1 <strong>Fett</strong> geschrieben.</li><li>2</li><li>3</li><li>4</li></ul></beschreibung><internerkommentar/><nummer>700001</nummer><menge>3.0000</menge><preis>0.55328000</preis><lieferdatum>2022-05-05</lieferdatum><freifeld1>Freifeld1</freifeld1><freifeld2>Freifeld2</freifeld2><freifeld3>Freifeld3</freifeld3><freifeld4>Freifeld4</freifeld4><freifeld5>Freifeld5</freifeld5><freifeld6>Freifeld6</freifeld6><freifeld7>Freifeld7</freifeld7><freifeld8>Freifeld8</freifeld8><freifeld9>Freifeld9</freifeld9><freifeld10>Freifeld10</freifeld10><freifeld11>Freifeld11</freifeld11><freifeld12>Freifeld12</freifeld12><freifeld13>Freifeld13</freifeld13><freifeld14>Freifeld14</freifeld14><freifeld15>Freifeld15</freifeld15><freifeld16>Freifeld16</freifeld16><freifeld17>Freifeld17</freifeld17><freifeld18>Freifeld18</freifeld18><freifeld19>Freifeld19</freifeld19><freifeld20>Freifeld20</freifeld20><freifeld21>Freifeld21</freifeld21><freifeld22>Freifeld22</freifeld22><freifeld23>Freifeld23</freifeld23><freifeld24>Freifeld24</freifeld24><freifeld25>Freifeld25</freifeld25><freifeld26>Freifeld26</freifeld26><freifeld27>Freifeld27</freifeld27><freifeld28>Freifeld28</freifeld28><freifeld29>Freifeld29</freifeld29><freifeld30>Freifeld30</freifeld30><freifeld31>Freifeld31</freifeld31><freifeld32>Freifeld32</freifeld32><freifeld33>Freifeld33</freifeld33><freifeld34>Freifeld34</freifeld34><freifeld35>Freifeld35</freifeld35><freifeld36>Freifeld36</freifeld36><freifeld37>Freifeld37</freifeld37><freifeld38>Freifeld38</freifeld38><freifeld39>Freifeld39</freifeld39><freifeld40>Freifeld40</freifeld40><ean/></auftrag_position></auftrag_position_list></auftrag></auftrag_list></xml><status><action>belege</action><message>OK</message><messageCode>1</messageCode></status></response>
Customer selection from xentral master data
When picking up orders via transfers module, matching is done to existing customers as follows (in descending order of priority):
For CSV:
-
Customer number (if the checkbox Transfer customer number from external system is active)
-
GLN
-
ID, if external system also transfers ID (it is checked whether this has already been transferred - is entered in the mapping table when the customer is created)
-
Otherwise, the address is created again
For XML:
-
Customer number (if the hook Transfer customer number from external system is active),
-
GLN
-
Check for an existing address in the project (only if a project is specified in the transfer module), match by postal code, city, street, e-mail)
-
ID, if external system ID is also transferred (it is checked whether this has already been transferred - is entered in the mapping table when the customer is created)
-
Otherwise address is created again
AmazonVendor/EDI (a fixed address must always exist here or the GLN must be defined):
-
Fixed address in transmissions
-
GLN in shipping address or address
<?xmlversion="1.0"encoding="UTF-8"?><response><xml><bestellung_list><bestellung><id>30</id><datum>2017-11-02</datum><projekt>1</projekt><bestellungsart /><belegnr>100023</belegnr><bearbeiter>Administrator</bearbeiter><angebot /><freitext>Bitte aufs Sperrlager einlagern</freitext><internebemerkung /><status>versendet</status><adresse>6</adresse><name>Meine Firma</name><vorname /><abteilung>Entwicklung/Produktion</abteilung><unterabteilung /><strasse>Musterstrasse 6</strasse><adresszusatz>Eingang C</adresszusatz><plz>49646</plz><ort>Musterhausen</ort><land>DE</land><abweichendelieferadresse>1</abweichendelieferadresse><liefername>Testempfänger</liefername><lieferabteilung>Logistik</lieferabteilung><lieferunterabteilung /><lieferland>DE</lieferland><lieferstrasse>Musterstrasse 7</lieferstrasse><lieferort>Musterhausen</lieferort><lieferplz>85344</lieferplz><lieferadresszusatz>Tor 3</lieferadresszusatz><lieferansprechpartner>Ansprechpartner Lieferadresse</lieferansprechpartner><ustid>4648448649848</ustid><ust_befreit>0</ust_befreit><email>testmail@web.de</email><telefon>082126841041</telefon><telefax>081664644565</telefax><betreff /><kundennummer /><lieferantennummer>70004</lieferantennummer><versandart /><lieferdatum>0000-00-00</lieferdatum><einkaeufer /><keineartikelnummern>0</keineartikelnummern><zahlungsweise>rechnung</zahlungsweise><zahlungsstatus /><zahlungszieltage>0</zahlungszieltage><zahlungszieltageskonto>0</zahlungszieltageskonto><zahlungszielskonto>0.00</zahlungszielskonto><gesamtsumme>1.1900</gesamtsumme><bank_inhaber /><bank_institut /><bank_blz>0</bank_blz><bank_konto>0</bank_konto><paypalaccount /><bestellbestaetigung>0</bestellbestaetigung><firma>1</firma><versendet>1</versendet><versendet_am>2017-11-02 07:34:26</versendet_am><versendet_per>sonstiges</versendet_per><versendet_durch>Administrator</versendet_durch><logdatei>2017-11-02 07:35:54</logdatei><artikelnummerninfotext>0</artikelnummerninfotext><ansprechpartner>Testansprechpartner</ansprechpartner><anschreiben /><usereditid>1</usereditid><useredittimestamp>2017-11-02 07:35:54</useredittimestamp><steuersatz_normal>19.00</steuersatz_normal><steuersatz_zwischen>7.00</steuersatz_zwischen><steuersatz_ermaessigt>7.00</steuersatz_ermaessigt><steuersatz_starkermaessigt>7.00</steuersatz_starkermaessigt><steuersatz_dienstleistung>7.00</steuersatz_dienstleistung><waehrung>EUR</waehrung><bestellungohnepreis>0</bestellungohnepreis><schreibschutz>1</schreibschutz><pdfarchiviert>0</pdfarchiviert><pdfarchiviertversion>0</pdfarchiviertversion><typ>firma</typ><verbindlichkeiteninfo /><ohne_briefpapier>0</ohne_briefpapier><projektfiliale>0</projektfiliale><bestellung_bestaetigt>0</bestellung_bestaetigt><bestaetigteslieferdatum>0000-00-00</bestaetigteslieferdatum><bestellungbestaetigtper>internet</bestellungbestaetigtper><bestellungbestaetigtabnummer /><gewuenschteslieferdatum>0000-00-00</gewuenschteslieferdatum><zuarchivieren>0</zuarchivieren><internebezeichnung /><angelegtam>0000-00-00 00:00:00</angelegtam><preisanfrageid>0</preisanfrageid><sprache>deutsch</sprache><kundennummerlieferant /><bodyzusatz /><lieferbedingung /><titel /><liefertitel /><skontobetrag>0.0000</skontobetrag><langeartikelnummern>0</langeartikelnummern><skontoberechnet>0</skontoberechnet><id_ext /><anzahluebertragungen>1</anzahluebertragungen><rabatt>0</rabatt><gebuehr>0</gebuehr><ust>0</ust><bestellung_position_list><bestellung_position><id>31</id><bestellung>30</bestellung><artikel>10</artikel><projekt>1</projekt><bezeichnunglieferant>Steckverbindung c10</bezeichnunglieferant><bestellnummer>Seriennummernartikel XY</bestellnummer><beschreibung /><menge>2.0000</menge><preis>0.50000000</preis><waehrung>EUR</waehrung><lieferdatum>2017-11-30</lieferdatum><vpe>24</vpe><sort>1</sort><status>angelegt</status><umsatzsteuer /><bemerkung /><geliefert>0.0000</geliefert><mengemanuellgeliefertaktiviert>0</mengemanuellgeliefertaktiviert><manuellgeliefertbearbeiter /><abgerechnet>0</abgerechnet><logdatei>2017-11-02 07:29:13</logdatei><abgeschlossen>0</abgeschlossen><einheit /><zolltarifnummer>0</zolltarifnummer><herkunftsland>0</herkunftsland><artikelnummerkunde /><auftrag_position_id>0</auftrag_position_id><preisanfrage_position_id>0</preisanfrage_position_id><freifeld1 /><freifeld2 /><freifeld3 /><freifeld4 /><freifeld5 /><freifeld6 /><freifeld7 /><freifeld8 /><freifeld9 /><freifeld10 /><auswahlmenge>0.0000</auswahlmenge><auswahletiketten>0</auswahletiketten><auswahllagerplatz>0</auswahllagerplatz><teilprojekt>0</teilprojekt><steuersatz>-1.00</steuersatz><steuertext /><erloese /><erloesefestschreiben>0</erloesefestschreiben><freifeld11 /><freifeld12 /><freifeld13 /><freifeld14 /><freifeld15 /><freifeld16 /><freifeld17 /><freifeld18 /><freifeld19 /><freifeld20 /><skontobetrag>0.0000</skontobetrag><id_ext /><ean /><gewicht /><herstellernummer /><altersfreigabe /><lagerartikel>1</lagerartikel></bestellung_position></bestellung_position_list></bestellung></bestellung_list></xml><status><action>belege</action><message>OK</message><messageCode>1</messageCode></status></response>
The connection to a fulfillment service provider enables, among other things, the transfer of XML structures or CSV files to a fulfillment service provider and subsequently the import of the data reported back by the fulfillment service provider, e.g. tracking numbers, stock levels, best-before dates, etc. The interface also enables the import of new customer orders, e.g. from external software/order platforms (e.g. EBISS). The interface also allows the import of new customer orders, e.g. from an external software/order platform (e.g. EBISS). In general, it is possible to store data as a file on a server. This data is then fetched and processed by the Fulfiller. The Fulfiller then reports back to the server e.g. once a day (at night) the tracking numbers, updated stock levels and e.g. also MHDs. This data is read in by xentral via a cronjob and updated in the system. A feedback to stores for stock updates or the tracking number to the store, as a simultaneous trigger for an invoice email, are possible in parallel.
The further processing of the data and the storage of the feedback file for xentral with the necessary fields is usually defined and created by the fulfiller. The following flowchart shows the basic interaction between xentral, an online store/marketplace and a shipping service provider/fulfiller.
 |
The interface also enables the import of new customer orders, e.g. from an external software/order platform (e.g. e.biss or App4Sales). Required master data (articles or customer names) are synchronized in both systems. Order entry can also take place offline, for example.
To set up a netstock connection, a separate transfer module within the Transfer module and an API account are required.
In the next step, the FTP_access data and the input folder for xentral (/from_netstock) must be entered. If necessary, the specification of a prefix for the file name (po_) is required.
 |
Subsequently, further settings for receiving or correct processing have to be made.
 |
Settings of the outgoing XML or CSV data. To enable the transfer of an XML or CSV file from xentral to the outside, the cronjob api_uebertragungen must first be created and activated under Administration > Settings > System > Process starter.
The next step is to create an API_Account. To do this, create a new account under Administration > Settings > System > API Account via +New, which can be filled out as follows (it is important here that the check mark is set at active).
 |
In the next step, a new transmission can be set up in the Appstore under Transmissions (EDI/XML/CSV/PDF). In the following example, an XML transmission for invoices via email is to be created.
 |
 |
Under API the set up account can be deposited. Under XML addition, the outgoing XML file can be extended with customer-specific additional specifications. Under Start from ID, the invoice ID can be selected from which the transfer is to start. In order to test whether the transmission has been set up successfully, the process starter and the transmission can be activated and the last invoice ID and the associated status can be entered and saved. After the set interval has expired, an e-mail with the XML file should be delivered.
An online store is operated that is already connected to xentral. Now the entire shipping process is to be handled by a fulfillment service provider. The service provider receives the delivery bill information from xentral and reports back a tracking number and the stock deduction. To receive this feedback, a transmission must be set up. There are four ways to send the data to the service provider: FTP
-
FTPS (only with username + password, not when using certificates)
-
E-mail
-
Local directory on xentral server
In addition, there are the following transfer formats that can be selected in the Dropdown menu:
 |
The data can also be transferred via the module as a CSV file in addition to an XML file.
Under +New a transfer to the fulfillment service provider can now be created. The type of transfer and the data format can also be defined there.
In the communication area, the FTP account with the incoming and outgoing folders can be stored and a decision can be made as to whether the files (e.g. tracking) stored by the reporting office should be deleted from the server after the download. In the Send receipts section, all settings for outgoing files can be made. In the outbox, the document type, the status and/or a document ID or a date from which the transfer should take place must be specified. In addition, it is possible to specify which email notifications are to be sent to the address.
Note
The item Maximum simultaneous transmissions stands for the number of documents that the process starter transmits simultaneously. The default value entered here is "0". Entered values <1 mean in this case that the described default of 10 is used. Therefore, the entry "0" means that a maximum of 10 documents are transferred per interval of the process starter.
If files are to be transferred to the fulfillment service provider (PDF file from the delivery bill or other attachments), the following option must also be activated: Transfer file attachment (at the bottom of the Send receipts area).
In the Receive documents area, you can define which documents are to be received by the system. In addition, it is also possible in this area to receive warehouse figures from external systems and to map these to a specific warehouse in xentral. In addition, the receiving of tracking messages in response to the transmitted delivery bill and of articles from external systems can be activated here. For this you need to set a checkmark at Tracking received.
In the area Stock numbers the transfer of the stock numbers to an external system can be configured. If no warehouse or shelf has been selected here, the complete stock of the system can be transferred to the external system. If there is an entry for warehouse or storage location, the transfer will be restricted accordingly. In addition, different times can be defined at which the transfer is to take place.
Note
The API account for the API field is created under Administration > Settings > System > API Account.
To retrieve the fulfillment service provider's feedback from the FTP server, a new cronjob must be created via Administration > Settings > System > Process starter. This fetches the returned deliveries at a defined time interval and plays them into xentral. More information on how to set up the cronjob can be found here. If the deliveries are successfully reported back, the list of transfers fills up.