This section is used to configure the content of the feed file. How many fields the feed file is going to have, what delimiters will be used, whether or not the headers will be included, by which attributes the products will be added to the feed, - all this information is specified under Content Settings. Depending on the feed type being used, the content can be filled for CSV, TXT or XML format.
GoMage.com DOES NOT provide any CSV, TXT or XML templates!
CSV / TXT Content Settings
Screenshot: CSV, TXT Content Settings
Set this option to"Yes" if you need a header in the feed file. Set it to “No” if you don’t.
A delimiter allows you to split text into columns in your feed file. Supported delimiters are:
- Comma ( , )
- Tab ( \t )
- Colon ( : )
- Space ( )
- Vertical pipe ( | )
- Semi-colon ( ; )
This option is used to enclose data in the feed file.
Single quote ‘ – the attribute value will be displayed in quotes;
Double quote “ – the attribute value will be displayed in double quotes;
space - CSV format – this option is recommended for CSV feed type;
space - without double space – the attribute value will be framed with blank spaces in the file.
Here is an example of space - CSV format and space - without double space variants for understanding:
For instance, the attribute values are “aaaa,bbbb” and you choose the enclosure space - CSV format. In this case you will get “aaaa(2 blank spaces),(2 blank spaces)bbbb” value for this attribute in the feed file since the special characters (commas, quotes etc.) are framed with double enclosure.
If you choose the enclosure space - without double space, you will get “aaaa(1 blank space),(1 blank space)bbbb”. Double space will be changed to single space in this case.
Remove line break symbols
This option removes line break symbols \r and \n from the feed file.
a sample -- > This is a sample text.
You can use this option for shopzilla.com if your uploaded feed file does not work correctly.
Use Amazon Header
Set "Yes" to include an Amazon header row in the first line of your feed file. It will always be above the first attributes row or the columns header.
Important! Empty row under the header text is required. Set the cursor after the text and press Enter only once.
If you want to add different names into separate columns you need to use the delimiters and enclosures.
For example: "First Column","","Third Column" (then – “Enter”).
Screenshot: Amazon Header
This option allows you to import Fields Mapping into this feed from the other feeds on your server.
Select a System and a Template and click the "Import" button.
Export Fields to Server
This option allows you to export the existing Fields Mapping to your server. The file with that information will be located in <magento root>/media/productsfeed/examples/ folder. Once it is exported, you will be able to import the same fields mapping into other feeds using “Import Fields Mapping” option.
Import Fields Settings and Export Fields Settings
These options allow you to export Fields Mapping from your current feed, store them as a separate file on your computer and if necessary, import it into other feeds in your Magento. Press “Export Fields Settings”, select the “System” for which this feed can be used (e.g. Google Shopping) and the “Template”, then click the “Export” or “Import” button. The import can also be done from the files previously exported to your server.
Note that these options will not be available until after you have created at least one feed file.
Set the order of this attribute column in the feed table.
For example, “1” column goes first, “2” – it goes second, etc.
The name of each field (column) in your feed based on the template or requirements of the corresponding shopping system.
This function allows you to control where data starts in each cell or add the desired information in the beginning of the attribute line in the feed. Depending on the prefix type and prefix value being used, the information is pulled from Magento® attributes, Dynamic attributes or specified as static value.
For example: the prefix is “abc-“ and the attribute is “name”. The product names will be output as “abc-name1”, “abc-name2” etc.
The type of the field should be selected. The following types are available:
Attribute – the field presents the value of the corresponding Magento® attribute for each product.
Parent Attribute – the field presents the value of the corresponding Magento® attribute of the Parent (Configurable) product. This type is used to export the values of Parent products instead of the values of Child (Simple) products in the feed.
Static Value – this type is used if the field is not mapped to a specific attribute but presents some static data instead.
Dynamic attribute – this type is used to include the values of Dynamic attributes in the feed.
If Parent attr. is empty – this type is used to set the Child product values to be exported in case the Parent product attribute is empty.
If Child attr. is empty – this type is used to export the Parent product values in case the Simple (Child) product attribute is empty.
Select the Magento® attribute from which the value will be exported. Make sure that the attribute values are not empty in the products configuration in Magento®, otherwise the corresponding fields will be blank in the feed.
This function allows you to control where data ends in each cell or add the desired information in the end of the attribute line in the feed. Depending on the suffix type and suffix value being used, the information is pulled from Magento® attributes, Dynamic attributes or specified as static value.
For example: the suffix is “suf” and the attribute is “name”. The product names will be output as “name1suf”, “name2suf” etc.
Output Type is a filter that you can apply to the data in each column.
Screenshot: Output Type
Plus button allows you to expand the list with the filters and apply them to the current attribute.
The following filter types are supported:
Default: the data in this column will be generated as is.
Integer: this function converts numbers into integers.
50.0000 USD → integer → 50
USD 50.0000 → integer → 0 (because the value starts with a letter (USD) and not with a number).
Float: this function standardizes numbers to two decimal places.
50.0000 → float → 50.00
USD 50.0000 → float → 0 (because the value starts with a letter (USD) and not with a number).
Note! We recommend using this filter for prices because most shopping systems require price values with a maximum of two decimal places (for example: 50.00).
Striptags: this function removes html tags from the text.
For example: <b>example</b> → striptags → example
Encode special chars: this function converts special characters to HTML entities.
For example: & → encode special chars → &
Decode special chars: this function converts HTML entities to special characters.
For example: & → decode special chars → &
Delete Space: this function deletes spaces in the attribute values.
For example: s k u name → delete space → skuname
Big to Small: this option converts capital letters in the attribute values into lowercase ones.
This option is used to limit the number of characters in the attribute values of the feed file. The limits are sometimes set by the shopping systems to avoid too long product names, descriptions etc. You may set your own limits in case you have extended product names or descriptions and do not want them to be exported in full length.
You can delete rows using the "Remove" button.
Add New Row
You can add new rows using the "Add New Row" button.
Prefix/Suffix Delimiter Ability
This option allows including an attribute as prefix or suffix to another attribute in the feed. Also, if you need to separate a value from prefix or suffix, you can use the additional field called Prefix Delimiter or Suffix Delimiter.
Screenshot: Prefix/Suffix Delimiter
You can use product attribute and Parent attribute as prefix/suffix.
Prefix Delimiter is a delimiter between the value and the prefix.
Suffix Delimiter is a delimiter between the value and suffix.
Remember to press the “Save” button as soon as all settings have been configured for each field in the feed file.