The “Export templates” page allows you to create and manage your export templates with filtered product costs used for manual or automatic export.
To open the “Export templates” page go to Business Analytics navigation bar > Import / Export > Export templates.
Manage your export templates
The "Export templates" page displays a list of all export templates created by the users under your account, visualized as cards. Each card contains the following information and buttons:
1. Export template name: It serves as an identifier to easily recognize and refer to the template.
2. Format: It specifies the file format for the exported data – TXT or CSV.
3. Creation and update dates: They indicate the date and time when the export template was initially created and the most recent date and time when any changes or updates were made to the export template.
4. Export: It allows launching the manual export operation directly from this page. Its results can be viewed and downloaded on the “Export product settings” page. For more information, see Business Analytics | Export product settings.
5. Update: It allows editing settings of the export template.
6. Delete: It allows deleting the export template from the system.
Note: Deleting a template that is used by one or more auto exports is not possible. The template needs to be unlinked from all the auto exports before deleting.
Page header
The “Export templates” page header offers two types of filters for the page content – “Template name” and “Format”.
To filter the export templates, enter the name of the template (or a part of the name) in the “Template name” input field. Alternatively, you can filter the templates by file format (TXT or CSV) selected from the “Format” dropdown menu or use both parameters for the targeted filtering. The page will update, displaying only the filtered export templates. If needed, refine your search by modifying or adding additional keywords to narrow down the results.
Clear the fields to revert to the default view displaying all export templates.
Create a new export template
To create a new export template, follow these steps:
Step 1: Click on the "Create” button with the plus icon at the top right to open the “Create template” page and fill out the following fields:
- "Template name": enter a descriptive name for your export template. Note: This field is mandatory.
- "Format": select the desired file format for the exported data from the dropdown menu: TXT or CSV. Note: This field is mandatory.
Step 2: Select the product settings filter within the “Select filter” section to determine the products and product settings to be included in the export.
Below is the list of all filters available on this page, along with their respective description:
| All | This option selects all products for the chosen parameter. |
|---|---|
| Text |
With this option, you can select products based on a specific parameter by defining the required text. You can enter the text either in full or partially within the “Enter text” field. For example, if you enter ‘comp' as the text for the "Product title" filter, all products with ‘comp’ anywhere in their title, such as ‘compact' and 'computer’, will be included in the export. |
| Select items | By choosing this option, a list of additional filters will be provided, allowing you to narrow the list of product settings to be exported. |
| <>= | Selecting this option allows you to specify value limits for the parameter to filter the data for export. Choose a comparison operator >=, >, =, <, <= and enter the corresponding value in the additional field. |
| Range | With this option, you can select product data with values within a specified range. Enter the lower and upper bounds of the range in the "From" and "To" fields. |
| With | Selecting this option includes products that have this particular parameter assigned to them. |
| Without | Selecting this option includes products that have this particular parameter empty or not assigned. |
Step 3. Having selected the needed filters for the chosen parameters, click on the "Submit" button to create the export template or "Cancel" to return to the “Export templates” page.