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.
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.
Export formats of JTL-Shop
Your task/initial situation
You want to export data from JTL-Shop, for example, to be able to use it for Google Shopping.
Pre-built export formats allow you to easily export data with just a few clicks. These can be found for JTL-Shop 5 in the JTL-Extension Store.
However, you can also create custom export formats. In the example, you can see how you can create such an export format.
Example of an export format
Header:
deep_link|art_name|long_description|price|currency|image_url|category|art_number|ean|delivery_costs|brandContent template:
{strip}
{assign var="d" value="|"}
{$Artikel->cDeeplink}{$d}
"{if $Artikel->cLocalizedVPE}{* Attach base price to item *}
{$Artikel->cName|truncate:60} ({$Artikel->cLocalizedVPE[0]})
{else}
{$Artikel->cName|truncate:70}
{/if}"{$d}
{$Artikel->cBeschreibung}{$d}
{$Artikel->Preise->fVKBrutto}{$d} {$Waehrung->cISO}{$d}
{$Artikel->Artikelbild}{$d}
{$Artikel->Kategoriepfad}{$d}
{$googlekat}{$d}
{$Artikel->cArtNr}{$d}
{$Artikel->cBarcode}{$d}
{$Artikel->Versandkosten}{$d}
{$Artikel->cHersteller}
{/strip} Attention: For security reasons, it is no longer permitted to execute PHP code in export templates as of JTL-Shop 5.
If you want to use customised export templates from JTL-Shop 4, please make sure to remove the executable code from these templates to avoid errors.