Item master data: Other

    On this page you will find a detailed description of all the options in the Other tab of the item master data. To learn how to create items, please read the relevant scenario.

    In the Other tab, you can assign further specific item properties to your item. The information refers to, among other things, handling your Amazon and eBay listings, exporting shipping data, your purchase and warehouse management as well as the precise setting up of cross-selling in your online shop.

    A: Advanced settings and information

    ISBN: The ISBN (International Standard Book Number) is used to mark books and other independent publications with editorial content.

    UPC: The UPC (Universal Product Code) is a barcode for unambiguous product identification, which is mainly used in the USA and Canada. If the UPC is preceded by a zero, the number chain can be used as a valid 13-digit GTIN.

    UN number: The UN number is a four-digit number that applies to all hazardous materials and dangerous goods. It is assigned by a United Nations (UN) Committee of Experts. It is the lower number on the orange danger panels of dangerous goods transports and describes the composition or type of the transported goods.

    TARIC code: The TARIC code is a 10-digit code that originates from the Integrated Tariff of the European Communities (TARIC) and is required for uniform customs treatment in all Member States when importing into the EU or exporting goods from the EU. TARIC databases can be accessed online.

    My ID: In this field, you can create an individual ID for the item, for example, if you want to ensure a unique assignment within your database when importing item data with JTL-DataTransfer. For more information on importing items with JTL-DataTransfer click here.

    Amazon FNSKU: The Amazon FNSKU (Fulfilment Network Stock Keeping Unit) is a product identifier used by Amazon logistics centres to identify items. The same FNSKU identifier can be assigned to multiple items with tracked stock (SKUs). With this identifier, which is printed on the labels of the item, Amazon can identify any item that is sent to Amazon by the seller.

    Hazard identification number: The hazard identification number is a two- to three-digit number used to identify the hazard that is specified for all hazardous substances. It is the top number on the orange danger panels of dangerous goods transports and describes the hazard that is presented by the transported goods.

    Country of origin: Enter the country of origin of your item in this field if required by customs clearance.

    Item type: In the drop-down menu, select the item type of your item. You can choose from the following: Cardboard, Voucher Digital, Voucher Physical.

    Availability: In the drop-down menu, select when your item is available.

    Check boxes

    Add to price list: If you are working with lists to showcase your product range or with price lists, you can activate this check box and thus ensure that the selected item is included on your product range list or price list. Via the menu Sales > Price list, you can adjust settings regarding your price list in the dialogue box Printing a price list. Read more on the topic here.

    Ignore purchase order proposals: Activate this check box if you do not want the selected item to be considered for the automated purchase order proposals in the purchasing management and to be suggested for purchase orders. Click here for more information on purchase order proposals.

    Ignore discounts: Activate this check box if you want to ignore all discounts for the selected item.

    Text fields

    Comment: In this text field, you can add an additional info text to your item if required.

    Search terms for online shop: If you want your item to be found in the JTL-Shop when a customer searches for terms that are not part of the item name or the item description, you can enter these special search terms in this text field. Specify the terms continuously and only separated by spaces. After successful transfer, your online shop will list the item for the specified search terms.

    B: Cross-selling tab

    Cross-selling allows you to offer your customers additional items, such as matching accessories, in addition to the called-up item. Through a prominent display at suitable points close to the main item or during the purchase process, the sales opportunities of the cross-selling items increase enormously.

    In JTL-Shop, the cross-selling items are displayed in a separate box below the item description on the product detail page.

    With JTL-Wawi, you can create any number of cross-selling links and organise them into clear groups.

    You can open the dialogue box Creating and editing cross-selling groups via the menu Items > Cross-selling groups in JTL-Wawi. Here you can create a group, which you can then assign in the Item master data in the tab Other.

    Adding a cross-selling group

    In the Item master data, you can add the previously created cross-selling group in the tab Other via the Add button.

    In the next step, you assign the items that you want to link to your main item to this cross-selling group.

    Assigning cross-selling items

    In the Groups table, select the group to which you want to assign items. In the adjacent Items in group area, you can open the Searching for items dialogue box via Add and select the desired items by double-clicking.

    Below the panes Groups and Items in group, you can delete your group or item entries using Remove. Please note that if you delete a cross-selling group, all assigned cross-selling items will also be deleted.

    In the item overview, right-click on the item whose cross-selling properties you want to copy. In the context menu, select the option Copy item/master data. Then select another item in the item overview and right-click on it to open the context menu. Now select the option Insert item master data.

    B: Vouchers tab

    If your item is a voucher, you can adjust different settings in the Vouchers tab. To do this, you must first consider the following points:

    • In the item master data, you have to activate Inventory management in the tab General > Warehouse.
    • In the item master data, you have to activate the check box Item with serial number in the tab General > Storage options.
    • In the item master data, in the tab Other in the drop-down menu Item type, you have to select either Voucher Digital or Voucher Physical.

    If the voucher item meets the listed requirements, you can make the following settings in the tab:

    Output method: In this drop-down menu you can decide whether you want to Print, Email or Print and Email the voucher.

    Voucher type: Use this drop-down menu to specify whether it is a Single-purpose voucher or Multi-purpose voucher.

    Template set: In this drop-down menu you determine which template set you want to use. Read more on the topic here.

    Campaign: If you use vouchers as part of a certain campaign, you can enter the name of the campaign in this text field.

    Voucher value: Enter the value of the voucher in this field. If you activate the check box Value from transaction (sales order/invoice correction), the corresponding value for this voucher is automatically applied.

    Currency: In this drop-down menu, select the appropriate currency for the voucher.

    C: Container unit

    Often items are delivered by suppliers and wholesalers in larger container units. In the Container unit area, you can specify a specific container quantity (item quantity in the container) and your own container label, for example a different GTIN. According to the information you entered, the container unit will be posted during goods receipts without PO and added to your stock with the correct item quantity.

    Click Add under the overview table in the pane Container units. A new row is added, the cells of which can be edited by double-clicking them. You can provide the following information:

    GTIN: Enter a possibly different GTIN in this field.

    Quantity: Enter the quantity of items in a container unit in this field.

    Unit: Enter the unit in this field. Go here for more information on how to create units.

    UPC: Enter the container unit’s own UPC, if available, in this field.

    D: Identification numbers

    In the Identification numbers section, you can see the ePID and ASIN tabs.


    ePID stands for eBay Product ID and is used to uniquely identify eBay catalogue items. If you want to assign your own listing to a matching product from the eBay catalogue, enter the ePID number. This allows you to use product details such as standard image, product description and category IDs of the respective item. In addition, if available, item features from the eBay catalogue are automatically added to your listing.


    Die ASIN steht für Amazon Standard Identification Number und ist eine zehnstellige, von Amazon vergebene Produktidentifikationsnummer. Jeder Artikel, der bei Amazon angeboten wird, verfügt über eine eindeutige ASIN. Diese Nummer finden Sie sowohl auf der Produkt-Detailseite bei Amazon als auch in der Web-Adresse des jeweiligen Amazon-Katalogartikels. Nutzen und kopieren Sie diese Nummer, wenn Sie auf ein bestehendes Amazon-Angebot aufschalten möchten.

    For items that you want to list on Amazon for the first time and for which there is no ASIN yet, you will need either the EAN/GTIN, the ISBN or the UPC to clearly identify the item. If an item is listed in the product catalogue on Amazon, an ASIN was also created for it.