It is important to create a template based on the format required by the customer. There is a possibility that you might be interacting with a number of applications and each of the applications might have their own custom format. A Custom Export Template is used to export SKU data from the Catalog in a format required by the customer. You need to create an export template by mapping the fields from the file used by the customer to ingest data into their system. Once the template is set, and the SKU attributes are mapped, you can then export the data by selecting the template created.
To create a new template:
Hover over to the upper-left corner on the left navigation band and the following menu is displayed as shown in the following figure.
Click Custom Export Template and then click Add New Export Template.
Enter the Template Name for the template being created.
Click Build Your Own Template and on hovering over i icon, you will be prompted with a message ‘Create a custom export template from scratch’.
Select the File Type which could be either Horizontal Excel or Horizontal Delimited. If you select Horizontal Delimiter, you must enter Field Delimiter and Field Enclosure if any.
On hovering over the ‘i’ icon of File Header, the message prompted is ‘Enter a non-wrapped text that will be added as a header to the export file’. You can enter a header as per your wish. If you want to add multiple Header Lines, click Add Header Line and you can add multiple header lines. If you do not want to add Header Line, keep it blank.
You can enter the number of columns to be skipped from the left. The default will be 0.
Click Next to proceed.
Under Product Data Configuration, you can add the Taxonomy Path Delimiter and Multivalue Delimiter value.
Under Number of DAs to be exported per SKU, if you want to select All the DAs, select All, if you do not want any DAs, then select None. You can specify the number of DAs that can be exported for each SKU by clicking Custom radio button and entering the number of DAs. DA Name, DA Type and DA Public URL are the three DA field sets available. You can drag and change the order. If you want to disable any of the field set, toggle off the respective field. Click Next to move to Field Selection section.
Under the Field Selection section, select the catalog. This will fetch the template fields and display Field Name, Field Type, and Customer Attribute ID.
You can select one or multiple fields and the selected field details can be moved for export to File(s) to be exported section using
. To move the attribute from the File(s) to be exported panel back to Available Field(s), click 
.On the File(s) to be exported panel, Column Position, Field Name, Field Type, Customer Attribute ID are displayed. You can search for specific Field Name and Customer Attribute ID through the search tab available. Column Position are denoted by A(1), B (2) and so on.
There will be an option to Add a Blank Field on the top right which will simply add an empty row in the file. This field will be displayed as <Empty Field>.
Click Next to open the Field Formatting section. The columns available are Column Position, Field Name, Column Header, Change Case of Attribute Value, Prefix with Value, Suffix with Value, and UoM Display Control.
Column Position – Displays the column position like A(1), B (2), and so on.
Field Name – Selected Field Name is displayed.
Column Header - You can enter a different column name for the field chosen by clicking edit which will be displayed as the attribute name in the export. The default value displayed is the original attribute name.
Change Case of Attribute Value - You can apply changes to the attribute value case by selecting an option from the dropdown. The options available are No Change, Upper Case, Lower Case, Title Case. Default will be No Change.
Prefix with Value – The dropdown options available are No Prefix, User Entered Value, UoM Name, UoM Symbol, and Field Name(:). You can enter a text if the selection is User Entered Value, enter a UoM Name or UoM Symbol which will be appended as the prefix to the SKU attribute value. If Field Name(:) is selected, the Field Name followed by value is displayed. For example, if a user enters $, it will be displayed as $ 10 in the export. Prefix is applied to the SKU attribute value in the same column or field. Default selection will be No Prefix.
Suffix with Value - The dropdown options available are No Suffix, User Entered Value, UoM Name, UoM Symbol. You can enter a text if the selection is User Entered value, enter a UoM Name or UoM Symbol which will be outputted as the suffix to the SKU attribute value. For example, if a user enters $, it will be displayed as 10 $ in the export. Suffix is applied to the SKU attribute value in the same column or field. Default selection will be No Suffix.
UoM Display Control – The dropdown options available are No UoM, UoM name in adjacent left column, UoM symbol in adjacent left column, UoM name in adjacent right column, UoM symbol in adjacent right column. By default, No UoM is selected. UoM name in adjacent left column means UoM name will be placed to the left of the attribute in a new column. UoM symbol in adjacent left column means UoM symbol will be placed to the left of the attribute in a new column. UoM name in adjacent right column means UoM name will be placed to the right of the attribute in a new column. UoM symbol in adjacent right column means UoM symbol will be placed to the right of the attribute in a new column.
If you select any option other than the No UoM, the export with UoM controls is displayed.
All UoMs in the attribute (this will export all UoMs for this SKU attribute in the placement specified above)
Include with Specific UoM (List of UoMs entered in a field which includes those UoM (s) for that SKU attribute in the placement specified above). Start typing into the field and select the UoMs you want to include.
Exclude with specific UoM ( List of UoMs entered in the field which will exclude those UoM (s) for that SKU attribute in the placement specified above). Start typing into the field and select the UoMs you want to exclude.
When user selects UoM Name or UoM Symbol in the Prefix with Value or Suffix with Value column, only No UoM will be displayed, other options will be disabled.
You can delete each row; however, if you select multiple rows or files, you cannot delete it. If you want to perform deletion of entities in bulk, you can carry out the operation in Field Selection section (previous section).
If you select multiple fields, and you want to copy a particular value for all the selected fields, click
near to that particular value, and select either Apply To All Field Values or Apply To Selected Field Values.
Once you makes these changes, click Submit to save the template. The saved template is displayed on Export > Custom Export Template. This template can be used to export catalog in the desired template format.
Actions Tab on Custom Export Template
On the Custom Export Template creation page, you can perform four actions on the custom export template. You can update the template, save as the template, delete the template, and export the template.
On clicking 
, you can update the template and follow the steps from 3 to 19.
On clicking 
,you can enter a different name for the new template along with a few other details. Enter the fields such as Template Name, Select Catalog, Select File Type, Field Delimiter, and Field Enclosure. Click Submit to save the template.
You can delete the template by clicking 
. This will ask for a confirmation, click Yes to delete the template.
You can export the template by clicking 
. This will redirect you to Export Data ;screen.
You can also use the customer export template created from Export --> Export Catalog screen.
