GoMage.com DOES NOT provide any CSV or XML templates!
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 or XML format.
Screenshot: Content Settings for CSV
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.
Set this option to "Yes" if you need a header in the feed file. Set it to “No” if you don’t.
Use Addition Header
This option is used for Amazon feeds to add specific text in the beginning of the feed file. The field for the text input is displayed if the option is set to "Yes". By default, the option is set to “No”.
The online marketplaces such as Google Shopping, Amazon, eBay and others require specific information about the products to be present in the feed files. The list of mandatory fields varies for each shopping system. But the basic information is always required: the name of the product, its SKU, brand (manufacturer), category to which the product belongs, color, size, stock availability. In order to include all necessary information in the feed, the required fields must be created and mapped to the corresponding Magento® attributes.
To create a new field, click “Add New Row” button.
Screenshot: Fields Mapping
When the row is added, click “Edit” to configure the parameters of the field.
Screenshot: New Row
The configuration panel with all parameters of the field will be displayed.
Screenshot: Field Config 1
The name of each field (column) in your feed based on the template or requirements of the corresponding shopping system.
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.
- Parent Dynamic Attribute: this type is used to include the Dynamic Attribute values of parent products for simple products 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.
Output Type is a filter that you can apply to the data in each column. The following filter types are supported:
None: 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).
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).
Strip Tags: this function removes html tags from the text.
For example: <b>example</b> → striptags → example.
Encode special chars: this function converts all applicable characters to HTML entities.
For example: & → encode special chars → &.
See more info on HTML entities here.
Encode HTML special: this function converts certain special characters to HTML entities.
See more info on HTML specialchars here.
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.
Remove line break symbols: this option removes line break symbols \r and \n from the feed file.
a sample -- > This is a sample text.
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.
Screenshot: Field config 2
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.
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.