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.
Screenshot: Content settings for CSV/TXT
Set this option to "Yes" if you need a header in the feed file. Set it to “No” if you don’t.
A delimiter should be selected in order to split the text into columns in the 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 allows you to remove line break symbols from the feed file.
You can use this option for shopzilla.com if your uploaded feed file doesn't 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 cursor after the text and press “Enter” once.
If you want to add different names into separate columns you need to use delimiters and enclosures.
For example: "First Column","","Third Column" (then – “Enter”).
Screenshot: Amazon Header
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 that is always required include: 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 attributes of Magento®.
To create a new field, click “Add New Row” button.
Screenshot: Fields Mapping
When the row is added, click “Edit” in order 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
Set the order of this attribute column in the feed table. For example, “1” column goes first, “2” – goes second, etc.
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 attribute of Magento® for each product.
Parent Attribute – the field presents the value of the corresponding attribute of Magento® 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 attribute of Magento® 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).
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).
Strip Tags: 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.
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.
Remember to press the “Save” button as soon as all settings have been configured for each field in the feed file.
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 you create 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.