CSV / TSV

To create a comprehensive CSV product feed sample incorporating all the parameters discussed in Feed parameters, we structure the CSV to include the headers with corresponding example values for each parameter.

This sample illustrates how to structure your data for upload to Criteo.

Here's an example of what the CSV might look like:

id,title,description,link,image_link,additional_image_link,sale_price,price,gtin,mpn,product_type,product_type_key,brand,item_group_id,google_product_category,availability,filters,seller_id,seller_name,regiondata,product_rating,number_of_reviews
12345,"Red Men's T-Shirt Size L","A classic red T-shirt perfect for casual wear.","http://www.example.com/products/red-mens-t-shirt-size-l","http://www.example.com/images/red-t-shirt.jpg","http://www.example.com/images/red-t-shirt-back.jpg","29.99","25.99","012345678905","RT12345","Men>Clothing>T-Shirts","1>3>25","Adidas","12340","Apparel & Accessories > Clothing > Shirts & Tops","In Stock","Color=Red|Blue,Size=S|M|L|XL","123seller","Top Fashion","{'4126':{'Price':25.99,'Quantity':6},'4127':{'Price':25.99,'Quantity':0}",,"4.5","10"
23456,"Blue Women's Jeans","Comfortable blue jeans with a modern fit.","https://www.example.com/products/blue-womens-jeans","https://www.example.com/images/blue-jeans.jpg","https://www.example.com/images/blue-jeans-side.jpg","49.99","45.99","987654321098","BW23456","Women>Clothing>Jeans","4>10>22","Levi's","23450","Apparel & Accessories > Clothing > Pants","Out of Stock","Color=Blue|Black,Size=4|6|8|10|12","456seller","Jeans Boutique","'789':{}, '1011':{}","3.8","25"
34567,"Green Women's Scarf","Soft and stylish green scarf.","http://www.example.com/products/green-womens-scarf","http://www.example.com/images/green-scarf.jpg","","19.99","17.99","234567890123","GS34567","Women>Accessories>Scarves","5>11>23","Gucci","","Apparel & Accessories > Clothing Accessories > Scarves & Shawls","In Stock","","","","","4.7","40"
45678,"Black Men's Wallet","Elegant black leather wallet.","https://www.example.com/products/black-mens-wallet","https://www.example.com/images/black-wallet.jpg","","59.99","54.99","345678901234","BM45678","Men>Accessories>Wallets","6>12>24","Prada","","Apparel & Accessories > Clothing Accessories > Wallets & Money Clips","In Stock","","","","","4.9","15"

CSV breakdown

id: Unique identifier for each product variant.
title: The product's name as displayed on the website.
description: A brief description of the product.
link: URL to the product's detail page.
image_link: Main image URL of the product.
additional_image_link: URL for additional product images.
sale_price: Recommended retail price or the higher price if on sale.
price: Actual selling price, which might be lower than sale_price during promotions.
gtin: Global Trade Item Number, a unique identifier for products within the global marketplace.
mpn: Manufacturer Part Number.
product_type: Category breadcrumb in a hierarchical format.
product_type_key: Corresponding category IDs matching the product_type.
brand: Manufacturer or brand name.
item_group_id: Identifier for related product variants (e.g., different sizes or colors of the same product).
google_product_category: Google's taxonomy classification for the product.
availability: Current stock status of the product.
filters: Custom filter values for the product.
seller_id: Identifier for the seller on a marketplace.
seller_name: Name of the seller on a marketplace.
regiondata: Store-specific availability, optionally with pricing.
product_rating: The average customer rating for the product, scaled typically from 1 to 5.
number_of_reviews: The total number of customer reviews for the product.

Notes

Column order: The order of columns in the CSV does not affect the processing. You can arrange the columns in any order that suits your workflow or system requirements.
Field formatting: Use double quotes for fields that contain commas, special characters, or embedded double quotes. For fields containing embedded double quotes, ensure each double quote is represented by two double quotes (e.g., "Example ""quoted"" text").
Protocols: Always include the protocol (http:// or https://) in URLs to ensure they are correctly processed.
Commas in fields: Do not use commas within fields. If you need to separate elements within a field, use alternative separators like vertical bars | or semicolons ;.
Image links: Ensure that image URLs are accessible and conform to specified criteria such as resolution and file size. The image_link must specify a valid image content type (e.g., image/png, image/gif, image/jpeg).
Character encoding: The CSV file should be encoded in UTF-8 to support international characters and special symbols correctly.

This sample CSV is designed to be illustrative and may need to be adjusted based on the specific requirements and systems used by Criteo and your eCommerce platform.

XML

Here's how the XML version of the feed above might look. We'll add custom_label tags which are commonly used to group products in custom ways that aren't covered by standard product attributes.

<?xml version="1.0" encoding="UTF-8"?>
<feed>
    <product>
        <id>12345</id>
        <title>Red Men's T-Shirt Size L</title>
        <description>A classic red T-shirt perfect for casual wear.</description>
        <link>http://www.example.com/products/red-mens-t-shirt-size-l</link>
        <image_link>http://www.example.com/images/red-t-shirt.jpg</image_link>
        <additional_image_link>http://www.example.com/images/red-t-shirt-back.jpg</additional_image_link>
        <sale_price>29.99</sale_price>
        <price>25.99</price>
        <gtin>012345678905</gtin>
        <mpn>RT12345</mpn>
        <product_type>Men&gt;Clothing&gt;T-Shirts</product_type>
        <product_type_key>1&gt;3&gt;25</product_type_key>
        <brand>Adidas</brand>
        <item_group_id>12340</item_group_id>
        <google_product_category>Apparel & Accessories &gt; Clothing &gt; Shirts & Tops</google_product_category>
        <availability>In Stock</availability>
        <filters>Color=Red|Blue,Size=S|M|L|XL</filters>
        <seller_id>123seller</seller_id>
        <seller_name>Top Fashion</seller_name>
        <regiondata>'123':{'Price':'23.99'}, '456':{'Price':'27.99'}</regiondata>
        <product_rating>4.5</product_rating>
        <number_of_reviews>10</number_of_reviews>
        <custom_label_0>Spring</custom_label_0>
        <custom_label_1>Clearance</custom_label_1>
        <custom_label_2>Men</custom_label_2>
    </product>
    <product>
        <id>23456</id>
        <title>Blue Women's Jeans</title>
        <description>Comfortable blue jeans with a modern fit.</description>
        <link>https://www.example.com/products/blue-womens-jeans</link>
        <image_link>https://www.example.com/images/blue-jeans.jpg</image_link>
        <additional_image_link>https://www.example.com/images/blue-jeans-side.jpg</additional_image_link>
        <sale_price>49.99</sale_price>
        <price>45.99</price>
        <gtin>987654321098</gtin>
        <mpn>BW23456</mpn>
        <product_type>Women&gt;Clothing&gt;Jeans</product_type>
        <product_type_key>4&gt;10&gt;22</product_type_key>
        <brand>Levi's</brand>
        <item_group_id>23450</item_group_id>
        <google_product_category>Apparel & Accessories &gt; Clothing &gt; Pants</google_product_category>
        <availability>Out of Stock</availability>
        <filters>Color=Blue|Black,Size=4|6|8|10|12</filters>
        <seller_id>456seller</seller_id>
        <seller_name>Jeans Boutique</seller_name>
        <regiondata>'789':{}, '1011':{}</regiondata>
        <product_rating>3.8</product_rating>
        <number_of_reviews>25</number_of_reviews>
        <custom_label_0>Fall</custom_label_0>
        <custom_label_1>New Arrival</custom_label_1>
        <custom_label_2>Women</custom_label_2>
    </product>
    <product>
        <id>34567</id>
        <title>Green Women's Scarf</title>
        <description>Soft and stylish green scarf.</description>
        <link>http://www.example.com/products/green-womens-scarf</link>
        <image_link>http://www.example.com/images/green-scarf.jpg</image_link>
        <sale_price>19.99</sale_price>
        <price>17.99</price>
        <gtin>234567890123</gtin>
        <mpn>GS34567</mpn>
        <product_type>Women&gt;Accessories&gt;Scarves</product_type>
        <product_type_key>5&gt;11&gt;23</product_type_key>
        <brand>Gucci</brand>
        <google_product_category>Apparel & Accessories &gt; Clothing Accessories &gt; Scarves & Shawls</google_product_category>
        <availability>In Stock</availability>
        <seller_id></seller_id>
        <seller_name></seller_name>
        <product_rating>4.7</product_rating>
        <number_of_reviews>40</number_of_reviews>
        <custom_label_0>Winter</custom_label_0>
        <custom_label_1>Luxury</custom_label_1>
        <custom_label_2>Women</custom_label_2>
    </product>
    <product>
        <id>45678</id>
        <title>Black Men's Wallet</title>
        <description>Elegant black leather wallet.</description>
        <link>https://www.example.com/products/black-mens-wallet</link>
        <image_link>https://www.example.com/images/black-wallet.jpg</image_link>
        <sale_price>59.99</sale_price>
        <price>54.99</price>
        <gtin>345678901234</gtin>
        <mpn>BM45678</mpn>
        <product_type>Men&gt;Accessories&gt;Wallets</product_type>
        <product_type_key>6&gt;12&gt;24</product_type_key>
        <brand>Prada</brand>
        <google_product_category>Apparel & Accessories &gt; Clothing Accessories &gt; Wallets & Money Clips</google_product_category>
        <availability>In Stock</availability>
        <seller_id></seller_id>
        <seller_name></seller_name>
        <product_rating>4.9</product_rating>
        <number_of_reviews>15</number_of_reviews>
        <custom_label_0>Year-Round</custom_label_0>
        <custom_label_1>Premium</custom_label_1>
        <custom_label_2>Men</custom_label_2>
    </product>
</feed>

Notes

In this XML feed example, the category levels are separated by > instead of > as it is more compliant with XML best practices. However, Criteo supports both options.

About `custom_label`

custom_label tags are used to provide additional non-standard information that can be useful for sorting, filtering, or categorizing products within the feed. In the example above:

custom_label_0: Identifies which season the product is best suited for (e.g., Spring, Fall).
custom_label_1: Indicates if the product is part of any special promotional category like Clearance or New Arrival.
custom_label_2: Helps in targeting specific demographic groups, such as Men or Women.

Custom labels are particularly useful in marketing and promotional campaigns where products need to be dynamically grouped or highlighted based on specific themes or sales strategies.

They allow for greater flexibility in how products are presented and promoted on platforms that use this feed.

Product Importer API example

Please refer to this page for more information about how to use the Product Importer API, and to this one for more Product Importer examples.

{
    "entries": [{
            "batchId": 0,
            "merchantId": "123",
            "method": "insert",
            "product": {
                "id": "12345",
                "title": "Red Men's T-Shirt Size L",
                "description": "A classic red T-shirt perfect for casual wear.",
                "link": "http://www.example.com/products/red-mens-t-shirt-size-l",
                "imageLink": "http://www.example.com/images/red-t-shirt.jpg",
                "additionalImageLinks": "http://www.example.com/images/red-t-shirt-back.jpg",
                "salePrice": "29.99",
                "price": "25.99",
                "gtin": "012345678905",
                "mpn": "RT12345",
                "productTypes": "Men&gt;Clothing&gt;T-Shirts",
                "productTypeKeys": 1 & gt;
                3 & gt;
                25,
                "brand": "Adidas",
                "itemGroupId": 12340
                "googleProductCategory": "Apparel & Accessories &gt; Clothing &gt; Shirts & Tops",
                "availability": "In Stock",
                "filters": "Color=Red|Blue,Size=S|M|L|XL",
                "sellerId": "123seller"
                "sellerName": "Top Fashion",
                "productRating": "4.5",
                "numberOfReviews": "10",
                "CustomAttribute": {
                    "regiondata": "'123':{'Price':'23.99'}, '456':{'Price':'27.99'}",
                    "custom_label_0": "Spring",
                    "custom_label_1": "Clearance",
                    "custom_label_2": "Men"
                }
            },
            "feedId": "string"
        }
    ]
}

CSV / TSV

CSV breakdown

Notes

XML

Notes

About custom_label

Product Importer API example

About `custom_label`