{"id":186526,"date":"2021-04-12T15:15:39","date_gmt":"2021-04-12T13:15:39","guid":{"rendered":"https:\/\/guide.jtl-software.com\/creating-new-export-formats\/"},"modified":"2023-08-14T15:20:22","modified_gmt":"2023-08-14T13:20:22","slug":"creating-new-export-formats","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/","title":{"rendered":"Creating new export formats"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2, h3, h5\" data-toc class=\"list-shop\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center hl-shop\" id=\"creating-new-export-formats\">Creating new export formats <span id='anchor-creating-new-export-formats' data-href='#creating-new-export-formats' class='far fa-link' data-anchor><\/span><\/h1><h2 class=\"d-flex align-items-center\" id=\"detailed-description-of-all-options\">Detailed description of all options <span id='anchor-detailed-description-of-all-options' data-href='#detailed-description-of-all-options' class='far fa-link' data-anchor><\/span><\/h2>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/new-export-format-jtl-shop-5-1.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/new-export-format-jtl-shop-5-1-694x1024.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/new-export-format-jtl-shop-5-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/new-export-format-jtl-shop-5-1-694x1024.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/new-export-format-jtl-shop-5-1-521x768.png 640w\" width=\"694\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"1024\" alt=\"Creating new export formats in JTL-Shop\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/new-export-format-jtl-shop-5-1.png&quot;,&quot;w&quot;:1395,&quot;h&quot;:2057}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<h5 class=\"d-flex align-items-center h3\" id=\"pane-a-general-information\">Pane A: General information <span id='anchor-pane-a-general-information' data-href='#pane-a-general-information' class='far fa-link' data-anchor><\/span><\/h5>\t<p><b>Name:<\/b> Internal name for the export format.<\/p>\n<hr  \/>\n\t<p><b>Language:<\/b> 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.<\/p>\n<hr  \/>\n\t<p><b>Currency:<\/b> Specify the currency in which prices are to be indicated in the export file.<\/p>\n<hr  \/>\n\t<p><b>Campaign:<\/b> Assign export to a campaign.<\/p>\n<hr  \/>\n\t<p><b>Customer group:<\/b> 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.<\/p>\n<hr  \/>\n\t<p><b>Character encoding:<\/b> Here you set the character encoding for the file.<\/p>\n<hr  \/>\n\t<p><b>Use cache:<\/b> Here you specify whether cached data, if any, should be written to the export file or whether it should be reloaded in each case.<\/p>\n<hr  \/>\n\t<p><b>Export of child items:<\/b> Here you determine whether only parent items, only child items or both are to be exported for parent-child relationship.<\/p>\n<hr  \/>\n\t<p><b>Size per file (MB):<\/b> Here you define the maximum size of the export file.<\/p>\n<hr  \/>\n\t<p><b>File name:<\/b> Here you specify the name of the export file.<\/p>\n<h5 class=\"d-flex align-items-center h3\" id=\"pane-b-format-definition\">Pane B: Format definition <span id='anchor-pane-b-format-definition' data-href='#pane-b-format-definition' class='far fa-link' data-anchor><\/span><\/h5>\t<p><b>Header:<\/b> Here you define which columns the export file should have. Separate the individual column terms with a vertical line (|).<\/p>\n<hr  \/>\n\t<p><b>Export template:<\/b> 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 <a class=\"external text\" href=\"http:\/\/www.smarty.net\/docsv2\/de\/language.variables.tpl\"  target='_blank' rel='noopener noreferrer' rel=\"nofollow noopener noreferrer\">query variables via Smarty syntax<\/a>.<\/p>\n<div id=\"parent_69e1b182d80f6\" role=\"tablist\" aria-multiselectable=\"true\" class=\"accordion mb-5 parent_69e1b182d80f6\">\n\t<div class=\"accordion-group\">\n\t<div class=\"accordion-header no-gradient collapsed\" role=\"tab\" id=\"group_69e1b182d8763\" data-toggle=\"collapse\" data-target=\"#group_69e1b182d8763_collapse\" aria-expanded=\"true\" aria-controls=\"group_69e1b182d8763_collapse\">\n\t\t<div class=\"accordion-title\">\n\t\t\tThe following variables are available in the export format:\t\t\t<span class=\"fas fa-caret-up indicator\"><\/span>\n\t\t<\/div>\n\t<\/div>\n\t<div id=\"group_69e1b182d8763_collapse\" class=\"accordion-collapse collapse \" role=\"tabpanel\" aria-labelledby=\"group_69e1b182d8763\" data-parent=\".parent_69e1b182d80f6\">\n\t\t<div class=\"accordion-body clearfix\">\n\t\t\t\n<div class=\"row\">\n\t\t<p><strong>Variable name<\/strong><\/p>\n\t<p><strong>Type<\/strong><\/p>\n\t<p><strong>Description<\/strong><\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Item<\/p>\n\t<p>Object<\/p>\n\t<p>This object represents an item.<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;kArtikel<\/p>\n\t<p>Key<\/p>\n\t<p>Internal ID of item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fLagerbestand<\/p>\n\t<p>Number<\/p>\n\t<p>Stock of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fMindestbestellmenge<\/p>\n\t<p>Number<\/p>\n\t<p>Minimum order quantity of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fGewicht<\/p>\n\t<p>Number<\/p>\n\t<p>Shipping weight of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fArtikelgewicht<\/p>\n\t<p>Number<\/p>\n\t<p>Item weight<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fUVP<\/p>\n\t<p>Number<\/p>\n\t<p>Recommended retail price of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fAbnahmeintervall<\/p>\n\t<p>Number<\/p>\n\t<p>Permissible order quantity of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fPackeinheit<\/p>\n\t<p>Number<\/p>\n\t<p>Packing unit<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cName<\/p>\n\t<p>String<\/p>\n\t<p>Name of the item in the current language:<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cBeschreibung<\/p>\n\t<p>String<\/p>\n\t<p>Description in the current language in plain text (cleansed of HTML)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cBeschreibungHTML<\/p>\n\t<p>String<\/p>\n\t<p>Description in the current language in HTML format<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cAnmerkung<\/p>\n\t<p>String<\/p>\n\t<p>Item comment<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cArtNr<\/p>\n\t<p>String<\/p>\n\t<p>SKU of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cNeu<\/p>\n\t<p>Bool<\/p>\n\t<p>New in product range (Y\/N)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cSerie<\/p>\n\t<p>String<\/p>\n\t<p>Additional ID used for a more identification options<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cISBN<\/p>\n\t<p>String<\/p>\n\t<p>ISBN<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cHAN<\/p>\n\t<p>String<\/p>\n\t<p>MPN<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cASIN<\/p>\n\t<p>String<\/p>\n\t<p>ASIN<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cUPC<\/p>\n\t<p>String<\/p>\n\t<p>UPC<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cGefahrnr<\/p>\n\t<p>String<\/p>\n\t<p>Hazard number<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cUNNummer<\/p>\n\t<p>String<\/p>\n\t<p>UN number<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cEinheit<\/p>\n\t<p>String<\/p>\n\t<p>Measurement unit of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cBarcode<\/p>\n\t<p>String<\/p>\n\t<p>EAN\/Bar code of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cKurzBeschreibung<\/p>\n\t<p>String<\/p>\n\t<p>Brief description in the current language in plain text (cleansed of HTML)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cKurzBeschreibungHTML<\/p>\n\t<p>String<\/p>\n\t<p>Brief description in the current language in HTML format<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cHersteller<\/p>\n\t<p>String<\/p>\n\t<p>Manufacturer in the current language<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cHerstellerHomepage<\/p>\n\t<p>String<\/p>\n\t<p>URL to the manufacturer&#8217;s homepage<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cMwstVersandText<\/p>\n\t<p>String<\/p>\n\t<p>String \u201cincl. \/ excl. X% VAT, + shipping costs\u201d<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cMwstText<\/p>\n\t<p>String<\/p>\n\t<p>String \u201cincl. \/ excl. X% VAT\u201d<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cLieferstatus<\/p>\n\t<p>String<\/p>\n\t<p>Delivery status in the current language<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cTopArtikel<\/p>\n\t<p>Bool<\/p>\n\t<p>Top item (Y\/N)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cVorschaubild<\/p>\n\t<p>Path<\/p>\n\t<p>Path to the preview image of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Bilder<\/p>\n\t<p>Object array<\/p>\n\t<p>Images for this item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Bilder[i]-&gt;nNr<\/p>\n\t<p>Number<\/p>\n\t<p>Image number<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Bilder[i]-&gt;cPfadKlein<\/p>\n\t<p>Path<\/p>\n\t<p>Path to the preview image<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Bilder[i]-&gt;cPfadNormal<\/p>\n\t<p>Path<\/p>\n\t<p>Path to the normal image<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Bilder[i]-&gt;cPfadGross<\/p>\n\t<p>Path<\/p>\n\t<p>Path to the large image<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;FunktionsAttribute<\/p>\n\t<p>Associative array<\/p>\n\t<p>Function attributes; see <span style=\"color: #3b3b3b;\"><a style=\"color: #3b3b3b;\" href=\"http:\/\/docs.jtl-shop.de\/de\/latest\/shop_templates\/tipps_tricks.html#funktionsattribute\"  target='_blank' rel='noopener noreferrer' rel=\"noopener noreferrer\">http:\/\/docs.jtl-shop.de\/de\/latest\/shop_templates\/tipps_tricks.html#funktionsattribute<\/a><\/span> (German only)<br \/>\nImportant: Function attribute names must be written in lowercase only even if the name in JTL-Wawi contains upper case letters.<br \/>\nExample: The function attribute \u201cmeinFunktionsAttribut\u201d is set in JTL-Wawi.<\/p>\n\t<pre>{if $Artikel-&gt;FunktionsAttribute.meinfunktionsattribut}Funktionsattribut \"meinfunktionsattribut\" ist gesetzt{\/if}<\/pre>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Attribute<\/p>\n\t<p>Array<\/p>\n\t<p>Item attributes; see code example: <span style=\"color: #3b3b3b;\"><a class=\"external free\" style=\"color: #3b3b3b;\" href=\"http:\/\/docs.jtl-shop.de\/de\/latest\/shop_templates\/tipps_tricks.html#artikelattribute-abfragen\"  target='_blank' rel='noopener noreferrer' rel=\"nofollow noopener noreferrer\">http:\/\/docs.jtl-shop.de\/de\/latest\/shop_templates\/tipps_tricks.html#artikelattribute-abfragen<\/a><\/span> (German only)<br \/>\nSettings in JTL-Wawi {$Artikel-&gt;AttributeAssoc.meinAttrName}<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cMerkmalAssoc_arr<\/p>\n\t<p>Array<\/p>\n\t<pre>{if $Artikel-&gt;cMerkmalAssoc_arr.Merkmalname}Wert vom Merkmal \"Merkmalname\": {$Artikel-&gt;cMerkmalAssoc_arr.Merkmalname}{\/if}<\/pre>\n\t<p>For umlauts the \u201cassign\u201d is important<\/p>\n\t<pre>{assign var=\"Merkmalname\" value=\"Gr\u00f6\u00dfeTower\"}{$Artikel-&gt;cMerkmalAssoc_arr.$Merkmalname}<\/pre>\n\t<p>Important: Spaces, brackets and certain special characters such as  \u201c\/\u201d or \u201c\\\u201d will be removed from the characteristic name in the array!<\/p>\n<p>Example: A characteristic saved in JTL-Wawi as <b>Material\/Surface<\/b> can be output in the export format as follows<\/p>\n\t<pre>{assign var=\u201dMaterialSurface\" value=\"Gr\u00f6\u00dfeTower\"}{$Artikel-&gt;cMerkmalAssoc_arr.$Merkmalname}<\/pre>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen<\/p>\n\t<p>ObjectArray<\/p>\n\t<p>Please read: <span style=\"color: #f68b25;\"> <a class=\"JTL-Wawi-color\" style=\"color: #f68b25;\" title=\"Creating variation items in JTL-Wawi\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/items\/creating-variation-items\/\">Variations in JTL-Wawi<\/a><\/span><\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;kEigenschaft<\/p>\n\t<p>Key<\/p>\n\t<p>Internal ID of the variation<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;cName<\/p>\n\t<p>String<\/p>\n\t<p>Name of the variation<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;cTyp<\/p>\n\t<p>String<\/p>\n\t<p>Selection type for variation (SELECTBOX, RADIO, FREETEXT)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;nSort<\/p>\n\t<p>Number<\/p>\n\t<p>Sort number<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte<\/p>\n\t<p>ObjectArray<\/p>\n\t<p>Variation values of the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;kEigenschaftWert<\/p>\n\t<p>Key<\/p>\n\t<p>Internal ID of the variation value<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;cName<\/p>\n\t<p>String<\/p>\n\t<p>Name of variation value<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;fAufpreisNetto<\/p>\n\t<p>Number<\/p>\n\t<p>Net surcharge\/discount of this variation value<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;fGewichtDiff<\/p>\n\t<p>Number<\/p>\n\t<p>Weight difference compared to the item of this variation value<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;cArtNr<\/p>\n\t<p>String<\/p>\n\t<p>SKU of the variation value<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;nSort<\/p>\n\t<p>Number<\/p>\n\t<p>Sort number<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;fLagerbestand<\/p>\n\t<p>Number<\/p>\n\t<p>Stock level of the variation value<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;fPackeinheit<\/p>\n\t<p>Number<\/p>\n\t<p>Packing unit<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;cAufpreisLocalized<\/p>\n\t<p>PriceArray<\/p>\n\t<p>Net surcharge\/discount [1] \/ Gross [0] with currency indication<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Variationen[i]-&gt;Werte[o]-&gt;cPreisInklAufpreis<\/p>\n\t<p>PriceArray<\/p>\n\t<p>Item price incl. surcharge\/discount Net [1] \/ Gross [0] with currency indication<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise<\/p>\n\t<p>Object<\/p>\n\t<p>Prices for the item<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;cVKLocalized<\/p>\n\t<p>PriceArray<\/p>\n\t<p>IndivSP Net[1] \/ Gross [0] with currency indication<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;fVK<\/p>\n\t<p>PriceArray<\/p>\n\t<p>IndivSP Net[1] \/ Gross [0] without currency indication<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;nAnzahl1<\/p>\n\t<p>Number<\/p>\n\t<p>Quantity for scale 1<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;nAnzahl2<\/p>\n\t<p>Number<\/p>\n\t<p>Quantity for scale 2<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;nAnzahl3<\/p>\n\t<p>Number<\/p>\n\t<p>Quantity for scale 3<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;nAnzahl4<\/p>\n\t<p>Number<\/p>\n\t<p>Quantity for scale 4<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;nAnzahl5<\/p>\n\t<p>Number<\/p>\n\t<p>Quantity for scale 5<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;cPreis1Localized<\/p>\n\t<p>PriceArray<\/p>\n\t<p>SP Net[1] \/ Gross [0] with currency indication for scale 1<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;cPreis2Localized<\/p>\n\t<p>PriceArray<\/p>\n\t<p>SP Net[1] \/ Gross [0] with currency indication for scale 2<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;cPreis3Localized<\/p>\n\t<p>PriceArray<\/p>\n\t<p>SP Net[1] \/ Gross [0] with currency indication for scale 3<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;cPreis4Localized<\/p>\n\t<p>PriceArray<\/p>\n\t<p>SP Net[1] \/ Gross [0] with currency indication for scale 4<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Preise-&gt;cPreis5Localized<\/p>\n\t<p>PriceArray<\/p>\n\t<p>SP Net[1] \/ Gross [0] with currency indication for scale 5<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;fMwSt<\/p>\n\t<p>Number<\/p>\n\t<p>Value-added tax<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cSuchbegriffe<\/p>\n\t<p>String<\/p>\n\t<p>Terms that should also be considered by the search function<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;dErscheinungsdatum_de<\/p>\n\t<p>Date<\/p>\n\t<p>Release date<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;dErstellt_de<\/p>\n\t<p>Date<\/p>\n\t<p>Creation date<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Kategoriepfad<\/p>\n\t<p>String<\/p>\n\t<p>Hierarchical category path (e.g. Computers &amp; Accessories &gt; CPUs &gt; Intel)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Versandkosten<\/p>\n\t<p>Number<\/p>\n\t<p>Shipping costs of the item to the destination country indicated in the price format<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cDeeplink<\/p>\n\t<p>String<\/p>\n\t<p>URL directly to the item in the shop<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Artikelbild<\/p>\n\t<p>String<\/p>\n\t<p>URL directly to the item image<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Lieferbar<\/p>\n\t<p>Bool<\/p>\n\t<p>Whether item is available (Y\/N)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Lieferbar_01<\/p>\n\t<p>Bool<\/p>\n\t<p>Whether item is available (0\/1)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Verfuegbarkeit_kelkoo<\/p>\n\t<p>Key<\/p>\n\t<p>Special number for availability for Kelkoo<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Kategorie<\/p>\n\t<p>Object<\/p>\n\t<p>Category in which the item is located<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Kategorie-&gt;cName<\/p>\n\t<p>String<\/p>\n\t<p>Category name<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Kategorie-&gt;cSeo<\/p>\n\t<p>String<\/p>\n\t<p>SEO name of the category<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Kategorie-&gt;cBeschreibung<\/p>\n\t<p>String<\/p>\n\t<p>Category description<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;Kategorie-&gt;cURL<\/p>\n\t<p>String<\/p>\n\t<p>URL Suffix for category. Use {$URL_SHOP}\/{$Artikel-&gt;Kategorie-&gt;cURL} to generate a direct link to the category in the shop<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>URL_SHOP<\/p>\n\t<p>String<\/p>\n\t<p>URL to the shop. E.g. <a class=\"external free\" href=\"http:\/\/www.meinshop.de\"  target='_blank' rel='noopener noreferrer' rel=\"nofollow noopener noreferrer\">http:\/\/www.myshop.com<\/a><\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung<\/p>\n\t<p>Object<\/p>\n\t<p>Represents the currency selected in the export format<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;cISO<\/p>\n\t<p>String<\/p>\n\t<p>ISO code of currency<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;cName<\/p>\n\t<p>String<\/p>\n\t<p>Name of the currency<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;cNameHTML<\/p>\n\t<p>String<\/p>\n\t<p>Representative of the currency in HTML<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;fFaktor<\/p>\n\t<p>Number<\/p>\n\t<p>Multiplier for standard currency<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;cStandard<\/p>\n\t<p>Bool<\/p>\n\t<p>Indicates whether this currency is the default currency in the shop (Y\/N)<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;cVorBetrag<\/p>\n\t<p>Bool<\/p>\n\t<p>Indicates whether the currency sign is to be displayed before or after the amount<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;cTrennzeichenCent<\/p>\n\t<p>String<\/p>\n\t<p>Decimal separator<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Waehrung-&gt;cTrennzeichenTausend<\/p>\n\t<p>String<\/p>\n\t<p>Thousands separator<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cLocalizedVPE[0]<\/p>\n\t<p>Base price<\/p>\n<\/div>\n\n<div class=\"row\">\n\t\t<p>Artikel-&gt;cEstimatedDelivery<\/p>\n\t<p>String<\/p>\n\t<p>estimated delivery time of the item, e.g. \u201c1-3 work days\u201d<\/p>\n<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div>\n<hr  \/>\n\t<p><b>Footer:<\/b> Here you define what is to be written in the last line of the export file.<\/p>\n<h5 class=\"d-flex align-items-center h3\" id=\"pane-c-settings\">Pane C: Settings <span id='anchor-pane-c-settings' data-href='#pane-c-settings' class='far fa-link' data-anchor><\/span><\/h5>\t<p><b>Only items with stock over 0:<\/b> Here you specify whether only items that are in stock are to be exported.<\/p>\n<hr  \/>\n\t<p><b>Only items with price over 0:<\/b> Here you specify whether only items that are not free are to be exported.<\/p>\n<hr  \/>\n\t<p><b>Only items with description:<\/b> Here you specify whether only items that have a description are exported.<\/p>\n<hr  \/>\n\t<p><b>Shipping costs for destination country (ISO code):<\/b> 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.<\/p>\n<hr  \/>\n\t<p><b>Escaping of &#8220;:<\/b> Here you define whether the character &#8221; is to be converted into another character during export. Use the drop-down menu to select which character should be used instead.<\/p>\n<hr  \/>\n\t<p><b>Escaping of &#8216;:<\/b> Here you define whether the character &#8216; is to be converted into another character during export. Use the drop-down menu to select which character should be used instead.<\/p>\n<hr  \/>\n\t<p><b>Escaping of&nbsp;;:<\/b> Here you define whether the character&nbsp;; is to be converted into another character during export. Use the drop-down menu to select which character should be used instead.<\/p>\n[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"Contents Contents Creating new export formats Detailed description of all options Pane A: General information Name: Internal name for the <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/\">[...]<\/a>","protected":false},"author":2,"featured_media":0,"parent":187885,"menu_order":777,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-186526","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating new export formats &#8211; JTL-Guide<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating new export formats &#8211; JTL-Guide\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-14T13:20:22+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"79 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/\",\"name\":\"Creating new export formats &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2021-04-12T13:15:39+00:00\",\"dateModified\":\"2023-08-14T13:20:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Shop\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"System administration\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Creating new export formats\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating new export formats &#8211; JTL-Guide","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/","og_locale":"en_US","og_type":"article","og_title":"Creating new export formats &#8211; JTL-Guide","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/","og_site_name":"JTL-Guide","article_modified_time":"2023-08-14T13:20:22+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"79 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/","name":"Creating new export formats &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2021-04-12T13:15:39+00:00","dateModified":"2023-08-14T13:20:22+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/creating-new-export-formats\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Shop","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/"},{"@type":"ListItem","position":2,"name":"System administration","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/system-administration\/"},{"@type":"ListItem","position":3,"name":"Creating new export formats"}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=186526"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186526\/revisions"}],"predecessor-version":[{"id":229318,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186526\/revisions\/229318"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/187885"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=186526"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=186526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}