{"id":185308,"date":"2022-02-09T10:48:04","date_gmt":"2022-02-09T09:48:04","guid":{"rendered":"https:\/\/guide.jtl-software.com\/importing-bill-of-materials-components-via-data-exchange\/"},"modified":"2023-08-08T14:32:54","modified_gmt":"2023-08-08T12:32:54","slug":"importing-bill-of-materials-components-via-data-exchange","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-via-data-exchange\/","title":{"rendered":"Importing bill of materials components 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-bill-of-materials-components-via-data-exchange\">Importing bill of materials components via data exchange <span id='anchor-importing-bill-of-materials-components-via-data-exchange' data-href='#importing-bill-of-materials-components-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 transferred item data on bill of materials (BOMs) and bill of material components to your fulfilment service provider. Now you want to link the components to the BOMs. For this, you have created an export from your system that correctly assigns the components to the items.\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>\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_69e1970d1e9b6\" role=\"tablist\" aria-multiselectable=\"true\" class=\"accordion mb-5 parent_69e1970d1e9b6\">\n\t<div class=\"accordion-group\">\n\t<div class=\"accordion-header no-gradient collapsed\" role=\"tab\" id=\"group_69e1970d1eb01\" data-toggle=\"collapse\" data-target=\"#group_69e1970d1eb01_collapse\" aria-expanded=\"true\" aria-controls=\"group_69e1970d1eb01_collapse\">\n\t\t<div class=\"accordion-title\">\n\t\t\tColumns for BOM components\t\t\t<span class=\"fas fa-caret-up indicator\"><\/span>\n\t\t<\/div>\n\t<\/div>\n\t<div id=\"group_69e1970d1eb01_collapse\" class=\"accordion-collapse collapse \" role=\"tabpanel\" aria-labelledby=\"group_69e1970d1eb01\" data-parent=\".parent_69e1970d1e9b6\">\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>sku<\/p>\n\t<p>SKU of the BOM<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>component_sku<\/p>\n\t<p>SKU of the BOM component<\/p>\n\t<p>Yes<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>component_quantity<\/p>\n\t<p>How often the component is included in the BOM<\/p>\n\t<p>Yes<\/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 BOMs 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. 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 on the <span class=\"highlight\">Direct import<\/span> button. The dialogue <span class=\"highlight\">Direct import<\/span> 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 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 bills of materials here: <span class=\"highlight\">My operations &gt; Items<\/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<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 bill of materials components via data exchange Your task\/initial situation You have transferred item data on bill <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-via-data-exchange\/\">[...]<\/a>","protected":false},"author":2,"featured_media":0,"parent":189952,"menu_order":179,"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-185308","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 bill of materials components 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-bill-of-materials-components-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 bill of materials components 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-bill-of-materials-components-via-data-exchange\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-08T12:32:54+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=\"5 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-bill-of-materials-components-via-data-exchange\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-via-data-exchange\/\",\"name\":\"Importing bill of materials components via data exchange &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2022-02-09T09:48:04+00:00\",\"dateModified\":\"2023-08-08T12:32:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-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-bill-of-materials-components-via-data-exchange\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-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 bill of materials components 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 bill of materials components 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-bill-of-materials-components-via-data-exchange\/","og_locale":"en_US","og_type":"article","og_title":"Importing bill of materials components via data exchange &#8211; JTL-Guide","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-via-data-exchange\/","og_site_name":"JTL-Guide","article_modified_time":"2023-08-08T12:32:54+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 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-bill-of-materials-components-via-data-exchange\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-via-data-exchange\/","name":"Importing bill of materials components via data exchange &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2022-02-09T09:48:04+00:00","dateModified":"2023-08-08T12:32:54+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-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-bill-of-materials-components-via-data-exchange\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-fulfilment-network\/online-sellers-without-jtl-wawi\/importing-bill-of-materials-components-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 bill of materials components 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\/185308","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=185308"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/185308\/revisions"}],"predecessor-version":[{"id":227575,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/185308\/revisions\/227575"}],"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=185308"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=185308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}