Column Names and Descriptions

id

The id is a unique identifier representing a single product.

Once an id is assigned to a product and imported, the id may not be used for a different product, nor can the id be used for a particular product change.

If you have item_group_id also populated, populate id with the child ID/SKU.

Character requirements: ASCII characters, and must not contain quotation marks.

Limit: 240

Type: String

Sample value: abc123-black-7.5

mandatory

title

The title is the product’s name, typically as it is displayed on the product’s detail page.

This will be used as the main text descriptor in the banners for a given product.

Character requirements: Must start with a letter or number.

Limit: 150

Type: String

Sample value: Working Boots – Size 7.5

mandatory

link

The link is the dedicated detail page for the product and is usually unique to a given product.

The product information on this URL should match the corresponding information provided in your catalog.

Character Requirements: The link must start with the protocol (http:// or https://) followed by the full URL of the product detail page.

All symbols must be encoded. For example, “$” must be replaced with “%24”.

Limit: 1024
Type: String

Sample value: http://www.example.com/product/working-boots

mandatory

image_link

The image_link is a URL that specifies a file path to a given product’s image. The image_link will be used to display the product’s image in the banners. Ideally, images should be at least 800×800 pixels and under 16MB. The image must have a Content-Type header specified, either image/png, image/gif or image/jpeg. If you restrict your images from being accessible via cURL, please whitelist our user-agent so we may display your images in the Criteo banners: curl/7.15+ (x64-criteo) libcurl/7.15+ OpenSSL zlib libidn.

Character Requirements: The image_link must start with http:// or https:// followed by the full URL of the product’s image. All symbols must be encoded. E.g. $ must be replaced with %24.

Limit: 2000

Type: String

Sample value: http://www.example.com/product/image/working-boots.png

mandatory

additional_image_link

The additional_image_link is a URL that specifies a file path to a given product’s image. The additional_image_link will be used to display the product’s image in the banners. Ideally, images should be at least 800×800 pixels and under 16MB. The image must have a Content-Type header specified, either image/png, image/gif or image/jpeg. If you restrict your images from being accessible via cURL, please whitelist our user-agent so we may display your images in the Criteo banners: curl/7.15+ (x64-criteo) libcurl/7.15+ OpenSSL zlib libidn.

Character Requirements: This must start with http:// or https:// followed by the full URL of the product’s image. All symbols must be encoded. E.g. $ must be replaced with %24.

Limit: 2000

Type: String

Sample value: http://www.example.com/product/image/working-boots2.png

price

The “price” is the price at which the product is available for purchase on the site. If a given product is “on sale”, the price would be populated with the lower price. The price should be in the same currency as the site.

Character Requirements: The decimal separator must be a period (.) with no thousands separator.

Limit: 14

Type: String

Sample value: 1199.99

mandatory

sale_price

The sale_price is the price the manufacturer recommends the product be sold for. If a given product is “on sale”, the price field would be populated with the higher price. The price should be in the same currency as the site.

Character Requirements: The decimal separator must be a period (.) with no thousands separator.

Type: String

Limit: 50

Sample value: 99.99

optional

availability

The availability indicates if the product may be purchased on the site. You may populate availability with three possible values: preorder (item is not currently shipping, but still may be purchased), out of stock (item is not shipping and you are not accepting orders for this item), and in stock (item is shipping and orders may be placed for this item). Items marked as out of stock will be excluded from being shown in the banners.

Character Requirements: The availability must be populated with one of the following three values: preorder, out of stock, or in stock.

Limit: 25

Type: String

Sample value: out of stock

optional

categoryid1

The categoryid1 is the first-level category to which the product belongs (you may provide up to 3 category levels in your catalog but only one can be used for CPC-optimization).

Character Requirements: N/S

Limit: N/S

Type: String

Sample value: Computing

mandatory

description

The description is a short piece of text that gives more information about a product in addition to its name.

Because of the design of the banners, shorter descriptions (under 50 characters) are more likely to fit in Criteo’s formats and layouts, however, not all formats and layouts will have a description.

Character Requirements: The description must start with a letter or number. Remove all HTML tags from this field, including style, embed, object, and anchor tags.

Limit: 5000

Type: String

optional – mandatory to run Facebook ads

google_product_category

Category level attributes indicate the category of the product being submitted, according to the Google product taxonomy. If your product can be linked to multiple categories, we only want the one that is the most relevant.

Character Requirements: We accept both IDs and full category path.

Type: String

Sample value: 2271 or Apparel & Accessories > Clothing > Dresses

optional

brand

The brand indicates the product brand’s name. Some products don’t have a clear brand associated and in this case, the brand doesn’t need to be provided.

Character Requirements: The name must start with either a letter or number, and can only contain ASCII characters. Remove all HTML tags from this field, including style tags.

Limit: 70

Type: String

Sample value: Feed Donkey

mandatory

categoryid2

The categoryid2 is the second-level category to which the product belongs.

Character Requirements: N/S

Limit: N/S

Type: String

Sample value: Keyboards and Mice

optional

categoryid3

The categoryid3 is the second-level category to which the product belongs.

Character Requirements: N/S

Limit: N/S

Type: String

Sample value: Wireless Mice

optional

star

The star is the item’s rating (with a decimal point as separator).

Character Requirements: number from 1 to 5 in increments of 0.5

Limit: N/S

Type: Number

Sample value: 4.7

optional

item_group_id

The item_group_id is a unique parent-level product identifier. It can contain alphanumeric characters that represent one product that can be expressed as a collection of child products. Once an item_group_id is assigned to a product and imported, the item_group_id may not be used for a different product, nor can the item_group_id for a particular product change.

Because item_group_id can represent a collection of products, several products may have the same value for item_group_id

Characters Requirements: The item_group_id can only contain ASCII characters, and must not contain quotation marks.

Limit: 240

Type: String

Sample value: abc123

mandatory for variant products

adult

The adult attribute indicates if the product is safe to be shown for all users and all audiences. Adult products can’t be shown in Criteo banners and might lead to your campaign being blocked by publisher networks. You can also use this field with the value “yes” if you want this product to be non-recommendable and not displayed in the banners.

Character Requirements: The value must be yes or no.

Type: Boolean

Sample value: no

Criteo Help Documentation

Product catalog specification