TurnTo Catalog Feed Format

SKU

Yes

Yes

The unique identifier for the item in your catalog. This should be an identifier for the item on the product page.

When the historical order feed or JavaScript order feed transmits an order for an item, it should use the same SKU as your catalog feed.

Prohibited Characters
Do not include the following characters in your SKU values: / # \ > < & = % ! . +

For more complex use cases, see Use a Variant ID or SKU.

TITLE

Yes

Yes

The name of the product or item.

ITEMURL

Yes

Yes

The URL of the item on your site. We support both relative and absolute link URLs.

IMAGEURL

Yes

No

The URL of the image of your catalog item to display in the widgets and in emails. Although it's not required, we highly recommend that you include it in the feed.

PRICE

Yes

No

Formatted as ####.##. This field is not required, but it is highly recommended because Emplifi Ratings & Reviews selects items for review solicitation emails (RSEs) based on price. For this to work, you must include a price value in your catalog. RSEs prioritize items by price based on the catalog feed, not the order data. If there's no value in the catalog feed, items to be sent in RSEs are picked at random.

CURRENCY

Yes

No

Defaults to USD.

CATEGORY

Yes

No

The name of the category that this item belongs to. An item can only belong to one category. If you will be specifying a category path, include the CATEGORY header (because the header is required) but leave the value blank. Instead, define your categories in the CATEGORYPATHJSON field.

Read more about
Categories in the Catalog Feed.

ACTIVE

No

No

Boolean value (1 or 0, Y or N). Defaults to 1, which means the listing is active. To learn more, see The Active Column.

CATEGORYPATHJSON

No

No

To pass Emplifi Ratings & Reviews a category path for this product, include a JSON array of category objects in the order of most general to most specific.

Required fields for each object in the array:

• id

  IDs must be unique. Do not use name as id.

• name

Optional field for each object in the array:

• url (used in category question emails)
  Read more about
  Categories in the Catalog Feed.

INSTOCK

No

No

Boolean value (1 or 0, Y or N). Defaults to 1, which means the item is in stock.

VIRTUALPARENTCODE

No

No

An arbitrary string used to group products. For example, if your catalog has a row for each color variant of an item, those variants can be grouped in Ratings & Reviews as similar items by setting this column to the same value for all of them. When a question is asked about one variant, it will automatically appear in the Q&A widget on each of the other variant pages as a question about a similar item.
To learn more, see Virtual Parent Code (VPC) and Members.

ISCATEGORY

No

No

Boolean value (1 or 0, Y or N). Defaults to 0, which means the row is not a category. Used to specify whether this row describes a category or an orderable item.

MEMBERS

No

No

If this product is a bundle of other products, specify the SKUs of the members (comma-delimited). To learn more, see Virtual Parent Code (VPC) and Members.

BRAND

No

No

The product's brand name. If used together with MPN, this field uniquely identifies the product.

MPN

No

No

(Manufacturer part number) The string that uniquely identifies the product to its manufacturer. If used together with BRAND, this field uniquely identifies the product across the entire catalog.

You can specify more than one value by comma-separating multiple MPNs. This is useful when your feed contains only parent products but you'd like to pass MPNs for child (variant) products, such as different sizes of a shirt.

UPC

No

No

(Universal Product Code) A unique, 12-digit identifier for commercial products that's usually associated with a barcode printed on retail merchandise. Used mainly in North America.

You can specify more than one value by comma-separating multiple UPCs. This is useful when your feed contains only parent products but you'd like to pass UPCs for child (variant) products, such as different sizes of a shirt.

ISBN

No

No

(International Standard Book Number) A unique numerical identifier for commercial books published since 1970 that can be found on the back of the book along with the barcode.

EAN

No

No

(European Article Number) A unique numerical identifier for commercial products that's usually associated with a barcode printed on retail merchandise. Used mainly outside of North America.

JAN

No

No

(Japanese Article Number) A unique numerical identifier for commercial products that's usually associated with a barcode printed on retail merchandise. Used in Japan.

ASIN

No

No

(Amazon Standard Identification Number) Uniquely identifies each product sold on http://amazon.com.

MOBILEITEMURL

No

No

The URL of the item on your mobile site.

LOCALEDATA

No

No

A JSON field that allows the specification of locale specific product titles and urls. In order to be utilized, the locale must be setup for the site. Valid locales include both the language and country code. For example, "fr_CA" has "fr" for French and "CA" for Canada.

If LOCALEDATA is specified, 'title' and 'itemUrl' are required, but 'mobileItemUrl' is not required. The following JSON example demonstrates the format:

{"fr_CA": {"title": "Bleu Chemise", "itemUrl": "https://domain.com/pathToFrenchProductPage", "mobileItemUrl": "https://domain.com/pathToMobileFrenchProductPage"}}

Example using two locales:

{"fr_CA": {"title": "Bleu Chemise", "itemUrl": "https://domain.com/pathToFrenchProductPage", "mobileItemUrl": "https://domain.com/pathToMobileFrenchProductPage"}, "de_DE": {"title": "Blau Hemd", "itemUrl": "https://domain.com/pathToGermanProductPage", "mobileItemUrl": "https://domain.com/pathToMobileGermanProductPage"}}