Last Updated on May 21, 2019

To edit a template simply click “Edit” button towards the right of that template’s name. Next screen has the following tabs:

> Template Settings, these are the general settings required by the channel.

> Template fields, are the fields that you want to amend before sending the feed.

Template settings

> Name, description and output file name of this template.

> XML Feed type requires the following fields to achieve proper formatting:

> XML envelope is the larger container that all products are stored in, it is similar to the name of the file or the header of the file.

> XML item envelope is the smaller container for each product which has the fields are contained in.

> Flat Feed type requires the following parameters to achieve successful formatting:

            – Field delimiter is the character to separate fields from each other within an enclosure

            – Field enclosure is the character to separate different product enclosures from each other

            – Fixed headers and footers are information to identify different feeds from each other

> Excel feed type follows MS Excel formatting guidelines, and do not require any formatting parameters.

> Mime type. Encoding, New Line, Decimal, Date, Time format are part of the general data transmission protocol format requirements. If you were working in a predefined channel template these values are already set. If you were working in a generic template these require assigning values.

Template fields

Channel required data field contents can be formatted or changed from the tab “Template fields”. This process will not impose any change to the data in the inventory database. Simply, click on the “Add field” button to provide the field to be amended.

> If you were working in a predefined channel template (e.g. Amazon Template), the system will provide a long list of predefined “Target fields” that can be amended for that particular channel. Browse and select the field or use the search function to find it. Selecting the target field will bring the “Field Properties” dialog box for further defining the data feed template.

> If you were working in a generic template when you click on “Add Field” button the system will bring the “Field Properties “dialog box immediately, where you can manually enter the “Target Field” value. 

Field Properties Dialog Box

In this dialog box you have the following tabs to help to change or format your data:

> General, this is the main target and source field selector, this is the tab for reformatting

> Attributes are only for XML tag attributes

> Replacements are for finding and replacing clauses in fields

> URL Params are for formatting product-specific URL links

> Advanced, are for advanced formatting options

General Tab

This is the tab to set the target to its source.

> If you were working in a predefined channel template (e.g. Amazon Template), you have already chosen the “Target field” that you want to override in the previous screen, and now you need to specify your “Source Field” that needs to be a field from your inventory database.  

> Autofill function:

        – Autofill is a useful feature to automatically fill in the fields listed in your inventory database,

        – Just below the Source field, the button with “M” denotes that the Autofill mode is active,

        – The button with “A” denotes Manual fill mode is active,

        – And you can toggle between these two modes by clicking on this button.

        – Click on “Source 0” textbox to use Autofill feature and the system will provide a long list of predefined fields in your database that can be matched with the selected Target field, and conversely, in the manual fill mode, you need to fill out the field name.

        – Manual fill function: type in dynamic field name without any suggestions, make sure to include a hashtag before writing text. StoreAutomator supports some internal coding which can be written during manual fill; coding allows extra functions, calculations, and conditional formatting of the output data for that field, please refer to Template Functions for detailed information.

        – Sometimes the feed needs to combine a couple or more fields into one; to do that click on “Add New” button and a new source is added. You can add as many fields as you need.

        – Added sources of data can be combined into one field in the “Format” Text box using the appropriate syntax. Any text written in the textbox will be included in the new field, and sources can be added as the source number put in curly brackets; e.g. {0} or {1}.

        – If you are using multiple sources make sure to select “Use all sources” under source usage.

        – If you are using 2 or more complementary sources you can select “Use First Valid Source” the system will use the field with a value and omit all will null da.

        – Check “Required” checkbox to denote if this Field is required by the channel. This is a useful feature to exclude a product or listing from the feed if this listing doesn’t have the required field or the date in the field is invalid.

        – Formatting of the data in “Format” textbox uses .NET framework formatting, here are some highlights:

                    –  {0}, {1}, {2}, 0, 1, 2 are source numbers

                    – {0:C2}, is currency formatting with 2 decimal points

                    – {0:d}, is date formatting

                    – {0:t}, is time formatting

                    – {0,12} reserves a 12 decimal long string and align text to the right

                    – {0,-12} reserves a 12 decimal long string and align text to left

                    – {0,8:yyyy} reserves an 8 decimal long field with 4 character year

                    – {0:#.0000} number with 4 decimal places

                    – {0:0,000.00} number with 2 decimal places and thousands separator

                    – {0:N0} general number formatting with 0 decimal places

                    – {0,P1} percentage formatting with 1 decimal place

                   – https://docs.microsoft.com/en-us/dotnet/api/system.string.format?view=netframework-4.7.2

Click OK to save your work or proceed to the replacements tab to further enter your feed requirements.

Attributes

Attributes for a field can be entered only if the feed template is XML type. In XML, attributes are the container specific parameters that stay within tags (< >) with the name of the container.

E.g.: <p style=”color:red”>text here…</p>

Here (style=”color: red”) is an attribute for “p” element and is setting the text color as red. Sometimes channels allow for such formatting, to emphasize product details. While working in this tab, enter the attribute to “Attribute” textbox and link the source to it as described in Autofill function above in “General” tab.  Hit add new to add as many attributes as you like.

Replacements tab

Once you add a field, you can replace words or clauses in that field with something else; with help of this tab. Find the specific text with “Find” textbox and replace with the text in “Replace” textbox. You can simply type in while in manual mode and utilize autofill function to find a predefined field as described in Autofill function above in “General” Tab. If you are replacing with text make sure to add “#” before the text.

You can add as many replacements as you wish.

URL Params

Once you add a field, you can add more URL parameters to the end of this field by simply filling in the information in this tab. You can add as many parameters as you like. In the output file, URL parameters will be added after “?” switch and “&” will be placed between parameters, as depicted in the syntax below:

?<Parameter_1>=<Source_1>&<Parameter_2>=<Source_2>&<Parameter_3>=<Source_3>

You can write the parameter’s name to “Parameter” text box and link it with “Source” textbox as described in Autofill function above in “General” Tab.

Advanced Tab

These are the settings for individual fields.

> Boolean true False format and Join separator works the same as explained under “Template Settings” except, these setting are at field level and applies to the field only.

> Skip empty (appears only with XML Feed types) skips empty containers as Object and as CDATA and don’t include them in the feed at all.

> Repeat (appears only with XML Feed types): Sometimes a field may have multiple data nodes as arrays; for e.g. an image field might have multiple URL links. When creating a feed, the system’s default behavior for this condition is to include each field respectively and separate them with the “Join separator”. If “Repeat” is checked, the system keeps each data in their separate XML Nodes.

> Prefix and suffix are used to add any text to the beginning and the end of the field container. This is same as the “Format” text box in “General” tab, except this one cannot be formatted.

> Limit, sets the feed file size limiter, as required by some channels.

Click OK to save your work.

>> Assigning Templates to Channels