{"id":185488,"date":"2022-02-09T08:29:55","date_gmt":"2022-02-09T07:29:55","guid":{"rendered":"https:\/\/guide.jtl-software.com\/importing-sales-order-data-via-data-exchange\/"},"modified":"2023-08-08T14:55:00","modified_gmt":"2023-08-08T12:55:00","slug":"importing-sales-order-data-via-data-exchange","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/","title":{"rendered":"Importing sales order data via data exchange"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2,h3\" data-toc class=\"list-fulfillment\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center hl-fulfillment\" id=\"importing-sales-order-data-via-data-exchange\">Importing sales order data via data exchange <span id='anchor-importing-sales-order-data-via-data-exchange' data-href='#importing-sales-order-data-via-data-exchange' class='far fa-link' data-anchor><\/span><\/h1><div class=\"custom-box\">\n\t<div class=\"d-flex align-items-center mb-4\">\n\t\t\t\t\t\t\t<span class=\"mr-3 fa-stack flex-shrink-0 fa-1x\">\n\t\t\t<span class=\"fas fa-circle fa-stack-2x text-shaftblue\"><\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 fas fa-clipboard-list text-white fa-stack-1x\"><\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\n\t\t<h3 class=\"mb-0 \" id=\"your-task-initial-situation\">Your task\/initial situation <span id='anchor-your-task-initial-situation' data-href='#your-task-initial-situation' class='far fa-link' data-anchor><\/span><\/h3>\t<\/div>\n\t<div class=\"box-content\">\n\t\tYou have exported data about sales orders from a third-party system and would now like to import it into the JTL-Fulfilment\u00a0Network so that you can then assign them to your fulfilment service provider.\t<\/div>\n<\/div>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"structure-of-the-csv-file\">Structure of the CSV file <span id='anchor-structure-of-the-csv-file' data-href='#structure-of-the-csv-file' class='far fa-link' data-anchor><\/span><\/h2><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-fulfillment\"><\/span>\n\t\t\t<span class=\"media-content border-fulfillment\">\n\t\n\t\t\t<span style=\"color: #009688;\"><strong>Please note:<\/strong><\/span> If you want to import Amazon Prime sales orders, you must maintain 3 additional data fields during import and enter your Amazon access data in the portal. It can be found under <span class=\"highlight\">Settings &gt; Seller Fulfilled Prime &gt; New access data<\/span>. There you specify your Amazon MWS auth. token and your seller ID for the respective platform (example: Amazon COM (US)).\r\n\r\nSee also <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/setting-up-amazon-seller-fulfilled-prime\/#amazon-prime-durch-verkaeufer-einrichten\">Setting up Amazon Seller Fulfilled Prime<\/a>.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>Data that you export from third-party systems must be in CSV format. The CSV file can contain the following columns:<\/p>\n<div id=\"parent_69e1960355945\" role=\"tablist\" aria-multiselectable=\"true\" class=\"accordion mb-5 parent_69e1960355945\">\n\t<div class=\"accordion-group\">\n\t<div class=\"accordion-header no-gradient collapsed\" role=\"tab\" id=\"group_69e1960355bf0\" data-toggle=\"collapse\" data-target=\"#group_69e1960355bf0_collapse\" aria-expanded=\"true\" aria-controls=\"group_69e1960355bf0_collapse\">\n\t\t<div class=\"accordion-title\">\n\t\t\tColumns for sales orders\t\t\t<span class=\"fas fa-caret-up indicator\"><\/span>\n\t\t<\/div>\n\t<\/div>\n\t<div id=\"group_69e1960355bf0_collapse\" class=\"accordion-collapse collapse \" role=\"tabpanel\" aria-labelledby=\"group_69e1960355bf0\" data-parent=\".parent_69e1960355945\">\n\t\t<div class=\"accordion-body clearfix\">\n\t\t\t\n<div class=\"row\">\n\t\t<p><strong>Name in FFN<\/strong><\/p>\n\t<p><strong>Description<\/strong><\/p>\n\t<p><strong>Mandatory field<\/strong><\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>warehouse_id<\/p>\n\t<p>Identification number of the warehouse of your fulfilment service provider. Your service provider will give you this ID. You can also find the warehouse ID from which the sales order is to be sent in the table\u00a0<a class=\"external-link\" title=\"\" href=\"https:\/\/fulfillment.jtl-software.com\/merchant\/warehouses\" rel=\"nofollow\">https:\/\/fulfillment.jtl-software.com\/merchant\/warehouses<\/a>. You can also store the warehouse ID as a default value if you want to create a template for a specific warehouse.<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>merchant_outbound_number<\/p>\n\t<p>A sales order ID that can be freely assigned as necessary. For each sales order in your system, there is a unique number. If coming from external systems, this might for example be a sales order ID, a delivery ID, etc.<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>currency<\/p>\n\t<p>Currency of the sales order<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_quantity<\/p>\n\t<p>The quantity of the items in the sales order.<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_merchant_sku<\/p>\n\t<p>Merchant SKU of the item (For correct allocation, the SKU must exist in JTL-FFN. For this, the items must have been created beforehand in JTL-FFN.)<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_jfsku<\/p>\n\t<p>The JFSKU is an SKU that is automatically generated by JTL-FFN for each item of a merchant that is sent to the network. After creating the items in the JTL-Fulfillment\u00a0Network, you will find this number in the item overview and detailed view. The JFSKU can be used as a unique identifier and as an alternative to the normal SKU, but is not mandatory.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_item_type<\/p>\n\t<p>Type of the shipping line item. We distinguish between \u201cProduct\u201d = the product, \u201cShipping = shipping line item, \u201cBillOfMaterials\u201d = bill of materials and \u201cOther\u201d.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_outbound_item_id<\/p>\n\t\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_bill_of_materials_id<\/p>\n\t<p>Die SKU of the bill of materials. Becomes a mandatory field when a line item is of the \u201cBillOfMaterials\u201d type.<\/p>\n\t<p>No (see description)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_external_number<\/p>\n\t<p>An external SKU, e.g. the supplier SKU<\/p>\n<p>For Amazon Prime, the Order item ID of the Amazon order must be specified.<\/p>\n\t<p>No<\/p>\n<p><span class=\"highlight\">For Amazon Prime Yes.<\/span><\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>amazon_seller_id<\/p>\n\t<p>The seller\/merchant ID of the Amazon seller\/merchant.<\/p>\n\t<p>No<\/p>\n<p><span class=\"highlight\">For Amazon Prime Yes.<\/span><\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_name<\/p>\n\t<p>Sales order line item name<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_note<\/p>\n\t<p>Comment on the item, e.g. \u201cThis item contains hazardous substances.\u201d<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_price<\/p>\n\t<p>Net price of the sales order line item in the currency defined under \u201ccurrency\u201d<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>item_vat<\/p>\n\t<p>VAT rate of the sales order line item in the currency defined under \u201ccurrency\u201d<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>status<\/p>\n\t<p>Status with which the sales order is to be imported into the JTL-Fulfillment Network. You can assign a fixed default value to the status in the import template.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>external_number<\/p>\n\t<p>An external order ID, e.g. the order ID from Amazon<\/p>\n\t<p>No<\/p>\n<p><span class=\"highlight\">For Amazon Prime Yes.<\/span><\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>internal_note<\/p>\n\t<p>Note to the Fulfiller that is not passed on to the end customer.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>external_note<\/p>\n\t<p>Note to the end customer that the fulfilment service provider can print on documents.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>priority<\/p>\n\t<p>Priority of the sales order. The higher the number, the higher the sales order priority is.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>premium_type<\/p>\n\t<p>Marketplace programme through which the sales order was generated. We currently distinguish between two premium types and thus possible values. One of them is \u201cEbayPlus\u201d, the other \u201cAmazonSellerFulfilledPrime\u201d. If the sales order is an Amazon Seller Fulfilled Prime order, the fulfilment service provider can request an Amazon label in the name of the merchant. Also read <span style=\"color: #009688;\"><a class=\"external-link\" style=\"color: #009688;\" title=\"\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/merchant-with-jtl-wawi\/7-setting-up-amazon-seller-fulfilled-prime\/\" rel=\"nofollow\">Setting up Amazon Seller Fulfilled Prime<\/a><\/span>.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sales_channel<\/p>\n\t<p>Sales channel from which the sales order originates, e.g. Amazon, eBay, online shop, etc.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>desired_delivery_date<\/p>\n\t<p>Desired delivery date for the sales order<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_method_id<\/p>\n\t<p>Shipping information for the sales order<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_type<\/p>\n\t\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_last_name<\/p>\n\t<p>Last name of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_first_name<\/p>\n\t<p>First name of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_company<\/p>\n\t<p>Company of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_email<\/p>\n\t<p>E-mail address for shipping address; is useful if the fulfilment service provider or shipping service provider is to inform the customer about the shipment.<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_city<\/p>\n\t<p>City of the shipping address<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_country<\/p>\n\t<p>Country of the shipping address<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_extra_\u2009address_line<\/p>\n\t<p>Address 2 of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_extra_line<\/p>\n\t<p>Additional row of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_fax<\/p>\n\t<p>Fax number of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_mobile<\/p>\n\t<p>Mobile phone number of the shipping address, e.g. for delivery notifications via text message<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_phone<\/p>\n\t<p>Phone number of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_salutation<\/p>\n\t<p>Form of address of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_state<\/p>\n\t<p>Federal state, canton, etc. of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_street<\/p>\n\t<p>Street name of the shipping address<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>shipping_address_zip<\/p>\n\t<p>Postal code of the shipping address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_last_name<\/p>\n\t<p>Last name of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_first_name<\/p>\n\t<p>First name of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_company<\/p>\n\t<p>Company of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_email<\/p>\n\t<p>Email address of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_city<\/p>\n\t<p>City of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_country<\/p>\n\t<p>Country of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_extra_\u2009address_line<\/p>\n\t<p>Address 2 of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_extra_line<\/p>\n\t<p>Additional row of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_fax<\/p>\n\t<p>Fax number of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_mobile<\/p>\n\t<p>Mobile phone number of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_phone<\/p>\n\t<p>Phone number of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_salutation<\/p>\n\t<p>Form of address of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_state<\/p>\n\t<p>Federal state, canton, etc. of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_street<\/p>\n\t<p>Street name of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>sender_address_zip<\/p>\n\t<p>Postal code of the sender address<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>invoice_document<\/p>\n\t<p>Path of the invoice document. There are two possible types of path specifications:<\/p>\n<p>The document is in the same folder as the CSV file. In this case, the relative path to the document must be entered (e. g. invoice123.pdf).<\/p>\n<p>The document is stored on a different system. The absolute path including the protocol must be specified (e.g.\u00a0ftps:\/\/user:password@my-server.tld\/invoices\/invoice123.pdf).<\/p>\n<p><strong>Please note:<\/strong> You can also import ZIP files via the direct import. The CSV files must be located in the root directory of the ZIP file. The invoice documents you want to import can be located anywhere within the ZIP file. In this case, you must also specify a relative path to the invoice document (e.g. invoices\/invoice123.pdf).<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>delivery_note_document<\/p>\n\t<p>Path to the delivery note. The linking works in the same way as for invoice documents (see above).<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>attribute_key<\/p>\n\t<p>Name of the attribute<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>attribute_value<\/p>\n\t<p>Value of the attribute<\/p>\n\t<p>No<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>attribute_type<\/p>\n\t<p>Type of the attribute. This already gets defined as the default value in the sales order template. Possible types are \u201cString\u201d, \u201cDate\u201d, \u201cDecimal\u201d, \u201cBoolean\u201d and \u201cInteger\u201d. A value is not required in this column. Use the attributes to pass extended information.<\/p>\n\t<p>No<\/p>\n<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"doing-an-import\">Doing an import <span id='anchor-doing-an-import' data-href='#doing-an-import' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"list-reset step mb-5 list-fulfillment normal-step\">\n\t<li class=\"media-single-line\">\n\tCreate an export of your sales order data in CSV format.<\/li><li >\n\tCreate an import template for the CSV import based on the table shown above. Please read <span style=\"color: #009688;\"><a style=\"color: #009688;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/creating-import-and-export-templates-in-jtl-ffn\/\">Creating import templates in the portal<\/a><\/span> to learn how to create an import template for sales order data. Above all, make sure that all mandatory fields are linked to a column in your CSV file or have a default value.<\/li><li >\n\tIn the FFN Portal <a href=\"https:\/\/fulfillment.jtl-software.com\/\">(Go to JTL-Fulfillment\u00a0Network<\/a>), go to <span class=\"highlight\">Data exchange &gt; Import<\/span>.<\/li><li class=\"media-single-line\">\n\tClick <span class=\"highlight\">Direct import<\/span>. The <span class=\"highlight\">Direct import<\/span> dialogue box opens.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Direct-import-Portal-Jtl-Ffn-1.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Direct-import-Portal-Jtl-Ffn-1-1024x425.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Direct-import-Portal-Jtl-Ffn-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Direct-import-Portal-Jtl-Ffn-1-1024x425.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Direct-import-Portal-Jtl-Ffn-1-768x319.png 640w\" width=\"1024\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"425\" alt=\"Direct import into the JTL-Fulfillment\u00a0Network Portal\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Direct-import-Portal-Jtl-Ffn-1.png&quot;,&quot;w&quot;:1483,&quot;h&quot;:616}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"5\" class=\"list-reset step mb-5 list-fulfillment normal-step\">\n\t<li class=\"media-single-line\">\n\tUnder <span class=\"highlight\">Import template<\/span>, select the template you created for this sales order import.<\/li><li >\n\tUnder <span class=\"highlight\">Select import file<\/span>, click <span class=\"highlight\">Browse<\/span> and select your CSV file.<\/li><li >\n\tSelect <span class=\"highlight\">Start import<\/span>. The import is now carried out. You will then find your sales orders here: <span class=\"highlight\">My operations &gt; Sales orders<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Direct-link-Configuration-Jtl-Ffn-1.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Direct-link-Configuration-Jtl-Ffn-1.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Direct-link-Configuration-Jtl-Ffn-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Direct-link-Configuration-Jtl-Ffn-1.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Direct-link-Configuration-Jtl-Ffn-1-768x293.png 640w\" width=\"812\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"310\" alt=\"Direct import of sales orders\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Direct-link-Configuration-Jtl-Ffn-1.png&quot;,&quot;w&quot;:812,&quot;h&quot;:310}\" class=\"img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<h2 class=\"d-flex align-items-center hl-wawi\" id=\"carrying-out-order-imports-with-documents-and-a-zip-archive\">Carrying out order imports with documents and a zip archive <span id='anchor-carrying-out-order-imports-with-documents-and-a-zip-archive' data-href='#carrying-out-order-imports-with-documents-and-a-zip-archive' class='far fa-link' data-anchor><\/span><\/h2>\t<p>You are a portal merchant and would like to import a sales order as a direct import with documents in a zip archive.<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-fulfillment normal-step\">\n\t<li >\n\tIn the FFN Portal (<a href=\"https:\/\/fulfillment.jtl-software.com\/\">Go to JTL-Fulfillment Network<\/a>), go to\u00a0<span class=\"highlight\">Data exchange<\/span> &gt; <span class=\"highlight\">Import<\/span>.<\/li><li class=\"media-single-line\">\n\tSelect <span class=\"highlight\">Import<\/span> &gt; <span class=\"highlight\">Direct import<\/span>.<\/li><li >\n\tOpen the CSV file and enter the names of the respective PDF files with the suffix\u00a0<span class=\"highlight\">.pdf<\/span>\u00a0in the\u00a0<span class=\"highlight\">invoice_document<\/span>\u00a0and\u00a0<span class=\"highlight\">delivery_note_document<\/span> columns.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Rechnung-Lieferschein-in-CSV-jtl-ffn.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Rechnung-Lieferschein-in-CSV-jtl-ffn.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Rechnung-Lieferschein-in-CSV-jtl-ffn.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Rechnung-Lieferschein-in-CSV-jtl-ffn.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Rechnung-Lieferschein-in-CSV-jtl-ffn.png 640w\" width=\"516\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"160\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Rechnung-Lieferschein-in-CSV-jtl-ffn.png&quot;,&quot;w&quot;:516,&quot;h&quot;:160}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"4\" class=\"list-reset step mb-5 list-fulfillment normal-step\">\n\t<li class=\"media-single-line\">\n\tCreate a zip archive from the CSV file and the PDF documents.<\/li><li class=\"media-single-line\">\n\tThen upload the zip archive via direct import.<\/li><\/ol>\t<p>The fulfilment service provider can now print the PDF files delivery note and invoice during the shipping process and enclose them with the goods that are being shipped.<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-fulfillment\"><\/span>\n\t\t\t<span class=\"media-content border-fulfillment\">\n\t\n\t\t\t<span style=\"color: #009688;\"><strong>Please note:<\/strong><\/span> You cannot upload zip archives via an FTP server. Zip archives can only be uploaded via manual direct import.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<div class=\"mt-5 card\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-fulfillment\">\n\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t<span data-fa-transform=\"shrink-8\" class=\"fas fa-link fa-inverse\"><\/span>\n\t\t<\/span>\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"d-flex align-items-center hl-wawi h4\">Related topics<\/p>\n<ul class=\"list-reset list-icons list-custom-square list-fulfillment\">\n\t\t<\/ul>\t<\/div>\n<\/div>[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"Contents Contents Importing sales order data via data exchange Your task\/initial situation You have exported data about sales orders from <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/\">[...]<\/a>","protected":false},"author":2,"featured_media":0,"parent":189952,"menu_order":186,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-185488","page","type-page","status-publish","hentry","pages_category-jtl-ffn-haendler-ohne-wawi-import-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Importing sales order data via data exchange &#8211; JTL-Guide<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing sales order data via data exchange &#8211; JTL-Guide\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-08T12:55:00+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"41 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/\",\"name\":\"Importing sales order data via data exchange &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2022-02-09T07:29:55+00:00\",\"dateModified\":\"2023-08-08T12:55:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Fulfillment Network\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Online merchants without JTL-Wawi\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfillment-network\/onlinehaendler-ohne-jtl-wawi\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Importing sales order data via data exchange\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing sales order data via data exchange &#8211; JTL-Guide","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/","og_locale":"en_US","og_type":"article","og_title":"Importing sales order data via data exchange &#8211; JTL-Guide","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/","og_site_name":"JTL-Guide","article_modified_time":"2023-08-08T12:55:00+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"41 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/","name":"Importing sales order data via data exchange &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2022-02-09T07:29:55+00:00","dateModified":"2023-08-08T12:55:00+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-sales-order-data-via-data-exchange\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Fulfillment Network","item":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/"},{"@type":"ListItem","position":2,"name":"Online merchants without JTL-Wawi","item":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfillment-network\/onlinehaendler-ohne-jtl-wawi\/"},{"@type":"ListItem","position":3,"name":"Importing sales order data via data exchange"}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/185488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=185488"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/185488\/revisions"}],"predecessor-version":[{"id":227626,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/185488\/revisions\/227626"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/189952"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=185488"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=185488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}