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.
Exporting item data from JTL-Shop
Your task/initial situation
You want to export the item data from JTL-Shop for another website such as a price search engine. You may want to create a new export format beforehand or use one of the export formats supplied with JTL-Shop.
Exports with existing export formats
Automation: With the JTL-Shop task scheduler, you can also automate manual exports: Setting up the task scheduler for exports.
Step 1: Adapting an export format
- In the back end of JTL-Shop, open the Export formats page via Administration > Export > Other formats. Here you will find a list of all export formats that are supplied by JTL-Shop and those you have created yourself.
- Click on the edit icon behind the format that you want to export. The Editing export formats page opens for the export format you selected.
- Specify here which items you want to export. If you do not make any changes here, all items will be exported.
- Click Save edited export format.
Step 2: Performing the export
- Click on one of the plus symbols behind the format for which you want to create the export file. You can choose between Create export file and Create export file asynchronously.
- Then click on the Download file icon.
Creating a new export format
If none of the supplied export formats is suitable for you, you can also create a new export format.
- Click the Create new export format button below the list of export formats. The page Creating a new export format opens. Go to dialogue description.
- Give the template a name and use the options on the page to define exactly which items are to be exported.
- Define your export template. Under Header, enter the names of the individual columns in the exported file. Separate each column with separators (e.g. “Name|ItemNO|Description”). Under Export template you can use different variables to access the data of each item to be exported. Separate this data with the same separator you used in the header.
The content is parsed by Smarty, which means that you can query variables via Smarty syntax.
- Click Save new export format. You can now carry out the export as described in step 2.