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 container units via data exchange
Your task/initial situation
You send items to your fulfilment service provider in container units. You would like to import data about the container units collectively as a CSV import into the JTL-Fulfillment Network.
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 item attributes
Name in FFN
Description
Mandatory field
sku
SKU of the item in the container unit
Yes
name
Name
Yes
quantity
How often the item is included in the container unit
Yes
ean
GTIN of the container unit
No
upc
UPC of the container unit
No
Doing an import
- Create an export of your container units 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 container units in the item data here: My operations > Items.
Related topics