Thank you for using the English version of the JTL-Guide!
We are currently still building up the English documentation; not all sections have been translated yet. Please note that there may still be German screenshots or links to German pages even on pages that have already been translated. This guide mostly addresses English speaking users in Germany.
We are currently still building up the English documentation; not all sections have been translated yet. Please note that there may still be German screenshots or links to German pages even on pages that have already been translated. This guide mostly addresses English speaking users in Germany.
Importing bill of materials components via data exchange
Your task/initial situation
You 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.
Structure of the CSV file
Data that you export from third-party systems must be in CSV format. The CSV file can contain the following columns:
Columns for BOM components
Name in FFN
Description
Mandatory field
sku
SKU of the BOM
Yes
component_sku
SKU of the BOM component
Yes
component_quantity
How often the component is included in the BOM
Yes
Doing an import
- Create an export of your BOMs in CSV format.
- Create an import template for the CSV import based on the table shown above. Please read Creating import templates in the portal 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.
- In the FFN Portal (Go to JTL-Fulfillment Network), go to Data exchange > Import.
- Click on the Direct import button. The dialogue Direct import opens.
- Under Import template, select the template you created for this import.
- Under Select import file, click Browse and select your CSV file.
- Select Start import. The import is now carried out. You will then find your bills of materials here: My operations > Items.
Related topics