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.
Creating new export formats
Detailed description of all options
Pane A: General information
Name: Internal name for the export format.
Language: Here you specify the language for which the export is to be carried out. This setting is only relevant if you export language-related data, such as the item name or description.
Currency: Specify the currency in which prices are to be indicated in the export file.
Campaign: Assign export to a campaign.
Customer group: Here you define for which customer group the prices and items are to be exported. This setting is only relevant if you differentiate between customer groups in your JTL-Shop.
Character encoding: Here you set the character encoding for the file.
Use cache: Here you specify whether cached data, if any, should be written to the export file or whether it should be reloaded in each case.
Export of child items: Here you determine whether only parent items, only child items or both are to be exported for parent-child relationship.
Size per file (MB): Here you define the maximum size of the export file.
File name: Here you specify the name of the export file.
Pane B: Format definition
Header: Here you define which columns the export file should have. Separate the individual column terms with a vertical line (|).
Export template: Here you define which fields are to be exported from the JTL-Shop database. The content is parsed by Smarty, which means that you can query variables via Smarty syntax.
Variable name
Type
Description
Item
Object
This object represents an item.
Artikel->kArtikel
Key
Internal ID of item
Artikel->fLagerbestand
Number
Stock of the item
Artikel->fMindestbestellmenge
Number
Minimum order quantity of the item
Artikel->fGewicht
Number
Shipping weight of the item
Artikel->fArtikelgewicht
Number
Item weight
Artikel->fUVP
Number
Recommended retail price of the item
Artikel->fAbnahmeintervall
Number
Permissible order quantity of the item
Artikel->fPackeinheit
Number
Packing unit
Artikel->cName
String
Name of the item in the current language:
Artikel->cBeschreibung
String
Description in the current language in plain text (cleansed of HTML)
Artikel->cBeschreibungHTML
String
Description in the current language in HTML format
Artikel->cAnmerkung
String
Item comment
Artikel->cArtNr
String
SKU of the item
Artikel->cNeu
Bool
New in product range (Y/N)
Artikel->cSerie
String
Additional ID used for a more identification options
Artikel->cISBN
String
ISBN
Artikel->cHAN
String
MPN
Artikel->cASIN
String
ASIN
Artikel->cUPC
String
UPC
Artikel->cGefahrnr
String
Hazard number
Artikel->cUNNummer
String
UN number
Artikel->cEinheit
String
Measurement unit of the item
Artikel->cBarcode
String
EAN/Bar code of the item
Artikel->cKurzBeschreibung
String
Brief description in the current language in plain text (cleansed of HTML)
Artikel->cKurzBeschreibungHTML
String
Brief description in the current language in HTML format
Artikel->cHersteller
String
Manufacturer in the current language
Artikel->cHerstellerHomepage
String
URL to the manufacturer’s homepage
Artikel->cMwstVersandText
String
String “incl. / excl. X% VAT, + shipping costs”
Artikel->cMwstText
String
String “incl. / excl. X% VAT”
Artikel->cLieferstatus
String
Delivery status in the current language
Artikel->cTopArtikel
Bool
Top item (Y/N)
Artikel->cVorschaubild
Path
Path to the preview image of the item
Artikel->Bilder
Object array
Images for this item
Artikel->Bilder[i]->nNr
Number
Image number
Artikel->Bilder[i]->cPfadKlein
Path
Path to the preview image
Artikel->Bilder[i]->cPfadNormal
Path
Path to the normal image
Artikel->Bilder[i]->cPfadGross
Path
Path to the large image
Artikel->FunktionsAttribute
Associative array
Function attributes; see http://docs.jtl-shop.de/de/latest/shop_templates/tipps_tricks.html#funktionsattribute (German only)
Important: Function attribute names must be written in lowercase only even if the name in JTL-Wawi contains upper case letters.
Example: The function attribute “meinFunktionsAttribut” is set in JTL-Wawi.
{if $Artikel->FunktionsAttribute.meinfunktionsattribut}Funktionsattribut "meinfunktionsattribut" ist gesetzt{/if}Artikel->Attribute
Array
Item attributes; see code example: http://docs.jtl-shop.de/de/latest/shop_templates/tipps_tricks.html#artikelattribute-abfragen (German only)
Settings in JTL-Wawi {$Artikel->AttributeAssoc.meinAttrName}
Artikel->cMerkmalAssoc_arr
Array
{if $Artikel->cMerkmalAssoc_arr.Merkmalname}Wert vom Merkmal "Merkmalname": {$Artikel->cMerkmalAssoc_arr.Merkmalname}{/if}For umlauts the “assign” is important
{assign var="Merkmalname" value="GrößeTower"}{$Artikel->cMerkmalAssoc_arr.$Merkmalname}Important: Spaces, brackets and certain special characters such as “/” or “\” will be removed from the characteristic name in the array!
Example: A characteristic saved in JTL-Wawi as Material/Surface can be output in the export format as follows
{assign var=”MaterialSurface" value="GrößeTower"}{$Artikel->cMerkmalAssoc_arr.$Merkmalname}Artikel->Variationen[i]->kEigenschaft
Key
Internal ID of the variation
Artikel->Variationen[i]->cName
String
Name of the variation
Artikel->Variationen[i]->cTyp
String
Selection type for variation (SELECTBOX, RADIO, FREETEXT)
Artikel->Variationen[i]->nSort
Number
Sort number
Artikel->Variationen[i]->Werte
ObjectArray
Variation values of the item
Artikel->Variationen[i]->Werte[o]->kEigenschaftWert
Key
Internal ID of the variation value
Artikel->Variationen[i]->Werte[o]->cName
String
Name of variation value
Artikel->Variationen[i]->Werte[o]->fAufpreisNetto
Number
Net surcharge/discount of this variation value
Artikel->Variationen[i]->Werte[o]->fGewichtDiff
Number
Weight difference compared to the item of this variation value
Artikel->Variationen[i]->Werte[o]->cArtNr
String
SKU of the variation value
Artikel->Variationen[i]->Werte[o]->nSort
Number
Sort number
Artikel->Variationen[i]->Werte[o]->fLagerbestand
Number
Stock level of the variation value
Artikel->Variationen[i]->Werte[o]->fPackeinheit
Number
Packing unit
Artikel->Variationen[i]->Werte[o]->cAufpreisLocalized
PriceArray
Net surcharge/discount [1] / Gross [0] with currency indication
Artikel->Variationen[i]->Werte[o]->cPreisInklAufpreis
PriceArray
Item price incl. surcharge/discount Net [1] / Gross [0] with currency indication
Artikel->Preise
Object
Prices for the item
Artikel->Preise->cVKLocalized
PriceArray
IndivSP Net[1] / Gross [0] with currency indication
Artikel->Preise->fVK
PriceArray
IndivSP Net[1] / Gross [0] without currency indication
Artikel->Preise->nAnzahl1
Number
Quantity for scale 1
Artikel->Preise->nAnzahl2
Number
Quantity for scale 2
Artikel->Preise->nAnzahl3
Number
Quantity for scale 3
Artikel->Preise->nAnzahl4
Number
Quantity for scale 4
Artikel->Preise->nAnzahl5
Number
Quantity for scale 5
Artikel->Preise->cPreis1Localized
PriceArray
SP Net[1] / Gross [0] with currency indication for scale 1
Artikel->Preise->cPreis2Localized
PriceArray
SP Net[1] / Gross [0] with currency indication for scale 2
Artikel->Preise->cPreis3Localized
PriceArray
SP Net[1] / Gross [0] with currency indication for scale 3
Artikel->Preise->cPreis4Localized
PriceArray
SP Net[1] / Gross [0] with currency indication for scale 4
Artikel->Preise->cPreis5Localized
PriceArray
SP Net[1] / Gross [0] with currency indication for scale 5
Artikel->fMwSt
Number
Value-added tax
Artikel->cSuchbegriffe
String
Terms that should also be considered by the search function
Artikel->dErscheinungsdatum_de
Date
Release date
Artikel->dErstellt_de
Date
Creation date
Artikel->Kategoriepfad
String
Hierarchical category path (e.g. Computers & Accessories > CPUs > Intel)
Artikel->Versandkosten
Number
Shipping costs of the item to the destination country indicated in the price format
Artikel->cDeeplink
String
URL directly to the item in the shop
Artikel->Artikelbild
String
URL directly to the item image
Artikel->Lieferbar
Bool
Whether item is available (Y/N)
Artikel->Lieferbar_01
Bool
Whether item is available (0/1)
Artikel->Verfuegbarkeit_kelkoo
Key
Special number for availability for Kelkoo
Artikel->Kategorie
Object
Category in which the item is located
Artikel->Kategorie->cName
String
Category name
Artikel->Kategorie->cSeo
String
SEO name of the category
Artikel->Kategorie->cBeschreibung
String
Category description
Artikel->Kategorie->cURL
String
URL Suffix for category. Use {$URL_SHOP}/{$Artikel->Kategorie->cURL} to generate a direct link to the category in the shop
Waehrung
Object
Represents the currency selected in the export format
Waehrung->cISO
String
ISO code of currency
Waehrung->cName
String
Name of the currency
Waehrung->cNameHTML
String
Representative of the currency in HTML
Waehrung->fFaktor
Number
Multiplier for standard currency
Waehrung->cStandard
Bool
Indicates whether this currency is the default currency in the shop (Y/N)
Waehrung->cVorBetrag
Bool
Indicates whether the currency sign is to be displayed before or after the amount
Waehrung->cTrennzeichenCent
String
Decimal separator
Waehrung->cTrennzeichenTausend
String
Thousands separator
Artikel->cLocalizedVPE[0]
Base price
Artikel->cEstimatedDelivery
String
estimated delivery time of the item, e.g. “1-3 work days”
Footer: Here you define what is to be written in the last line of the export file.
Pane C: Settings
Only items with stock over 0: Here you specify whether only items that are in stock are to be exported.
Only items with price over 0: Here you specify whether only items that are not free are to be exported.
Only items with description: Here you specify whether only items that have a description are exported.
Shipping costs for destination country (ISO code): Here you specify the country for which the shipping costs to be exported are to be calculated. Use the ISO code, for example DE for Germany or PL for Poland.
Escaping of “: Here you define whether the character ” is to be converted into another character during export. Use the drop-down menu to select which character should be used instead.
Escaping of ‘: Here you define whether the character ‘ is to be converted into another character during export. Use the drop-down menu to select which character should be used instead.
Escaping of ;: Here you define whether the character ; is to be converted into another character during export. Use the drop-down menu to select which character should be used instead.