Skip to main content

Content Settings - CSV

Nadezhda
Updated

GoMage.com DOES NOT provide any CSV or XML templates! 

Content Settings

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

Content_Settings_for_CSV.png

 

Delimiter

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 ( ; )
     

Enclosure

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. 

 

Show Header

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 at 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”.

 

Fields Mapping

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 the “Add New Row” button.

Screenshot: Fields Mapping

Fields_Mapping.png

 

When the row is added, click “Edit” to configure the parameters of the field.

Screenshot: New Row

New_Row.png

The configuration panel with all parameters of the field will be displayed.

Screenshot: Field Config 1

Field_Config_1.png

 

Field Name

The name of each field (column) in your feed based on the template or requirements of the corresponding shopping system.

 

Type

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.
     

Value

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

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. 
For example:
50.0000 USD → integer → 50
BUT
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.
For example:
50.0000 → float → 50.00  
BUT
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 → &amp. 
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: &amp; → 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.

For example:
This is
a sample -- > This is a sample text.
text

 

Symbols Limit

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

Field_config_2.png

 

Prefix

This function allows you to control where data starts in each cell or add the desired information at 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 a 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.

 

Suffix

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 a static value.

For example: the suffix is “suf” and the attribute is “name”. The product names will be output as “name1suf”, “name2suf” etc.

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk