An explanation on the different value types of fields
When creating new fields in the mapping or in a report, you can select different field types.
- Text (String) - Select this field type for all fields that contain text. All string functions (see mapping functions) can be applied to these fields. Please note that it is not possible to do calculations with fields that have a value type text. Examples: EAN codes, product IDs, SKU numbers, product names, etc.
- Number (Int64) - This field type should be selected for all fields that contain numbers without any decimals. Examples: amount of products in stock, number of products sold, etc.
- Number (Decimal) - This field type is applicable for all fields that contain numbers with decimals. This is the most commonly used Value Type, as it is the right type for all fields containing an indication of monetary value (such as prices, costs, etc). These fields can be used for calculations. Examples: purchase price, shipping costs, etc.
- Boolean - A boolean is a value type that can only have two representations: 1 or 0. This field can be used for indicating a simple Yes or No, True or False. Examples: in stock
Additionally when selecting fields from your feeds in the mapping section, you have to select the field type. Besides the above mentioned field types, there are some other options:
- Price (decimal separator comma/dot) - Select this field type for fields that contain prices including currency symbol. Also choose whether the decimal separator is a comma or a dot.
- Number (decimal separator comma/dot) - Select this field type for fields that contain numbers without currency symbols. Also choose whether the decimal separator is a comma or a dot.