Product Field Data Types

When you create a custom field you must specify the field's data type. The data type cannot be changed once the field is created.

Data Type Description
Date Date and time value that matches the date format specified in the feed configuration. If no time is specified, T00:00:00.000+0000 is appended, which represents midnight (0 hours, 0 minutes, 0 seconds at GMT).

Example: 2015-01-27T13:57:30.829+0000

Currency Currency value, not including the currency type. All products must have the same currency type. The maximum number of decimal places allowed is 4.

Example: 15.99

Text Short text value. The maximum number of characters allowed in a Text field is 500.

Example: Brown

Textarea Long text value. The maximum number of characters allowed in a text area field is 5,000.

Example: This warm hat is made of 100% cotton and comes in various colors.

Long A whole number with no decimal places (an integer).

Example: 25

Double A number with decimal places.

Example: 25.999

Boolean True or false value.

Example: True

Multi A collection of values for a single attribute that are separated by a "multi-field" delimiter. This delimiter must be specified in the feed configuration. The maximum number of characters allowed in a Multi field is 10,000.
Note: The multi-field delimiter must be a different value than the delimiter.

Example: http://www.mysite.com/image1.jpg, http://www.mysite.com/image2.jpg, http://www.mysite.com/image3.jpg

URL A short text value that is specific to a URL address. The URL must start with http:// or https://. The maximum number of characters allowed in a URL field is 2,000.

Example: http://www.mysite.com

ID String used to store unique identifiers, such as Product ID, UPC, and MPN.
Note: Parent Product ID is not stored as an ID because it is not unique. Several different products can have the same Parent ID.

During import, any leading or trailing spaces are removed. When you request Product IDs for messages, you will need to use the trimmed version of the ID.

Example: ShirtsAB123

Product List A comma delimited list of product IDs up to 10,000 characters. This data type should only be used for the Product Whitelist and Product Blacklist product fields.

Example: product1, product2, product3