Quick search:eBay DataTransfer JTL-Worker PayPal

JTL-Links

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.

Note: On 1 September 2024, JTL introduced new editions that bundle most of the previous individual services into different packages. In order for you to continue working as smoothly as possible, existing customers were automatically switched to the package configuration that best matched their existing contract. The individual packages differ in terms of limitations and/or range of functions. Therefore, some of the features described in the JTL-Guide may not be available to you as part of your booked JTL edition. You can change your package configuration in your JTL customer account. Find out more about the new editions and packages here. Check our FAQ for frequently asked questions about the product editions.

Contents

Importing item data via data exchange

Your task/initial situation

You have exported item data from a third-party system and would now like to import it into the JTL-Fulfillment Network so that you can then transfer it to your fulfilment service provider or create sales orders for these 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:

Item columns

Name in FFN

Description

Mandatory field

sku

SKU of the item

Yes

name

Item name

Yes

price_net

Net price of the item

Yes

price_currency

Currency of the net price of the item

Yes

product_group

Product group

origin_country

Country of origin (ISO-3166-1 ALPHA-2)

manufacturer

Manufacturer of the item

weight

Weight

net_weight

Item weight

height

Height

length

Length

width

Width

note

Comment about the item

ean

GTIN (formerly EAN) of the item

isbn

ISBN

upc

UPC

asin

ASIN

mpn_manufacturer

Manufacturer of the item

mpn_part_number

MPN

un_number

UN number

hazard_identifier

Hazard identification number

taric

TARIC code

fnsku

Amazon FNSKU

is_batch

Is batch item, permissible values are true (if it is a batch item) and false (if it is not a batch item)

is_divisible

Split quantity, permissible values are true (if splittable) and false (if not splittable)

is_best_before

Is an item with a shelf life expiration date (SLED); permissible values are true (if there is a SLED) and false (if there is no SLED)

is_serial_number

Is an item with a serial number; permissible values are true (if there is a serial number) and false (if there is no serial number)

is_bill_of_materials

Item is a bill of materials (BOM); permissible values are true (if it is a BOM) and false (if it is not a BOM)

Doing an import

Create an export of your item data 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 for item data. 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.

Direct import into the JTL-Fulfillment Network Portal

Under Import template, select the template you created for this item 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 items here: My operations > Items.