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.
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|brand
Content 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.