> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lemrock.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Product feed and category file

> The two files Lemrock needs to build ads that send shoppers to your product and category pages.

Lemrock ads send shoppers to two kinds of pages on your site: product pages and category pages. To build those ads, Lemrock needs two files from you:

* **A product feed**: a file listing your products, published at a feed URL that Lemrock downloads.
* **A category file**: a file listing the category pages you want to promote.

Lemrock writes the ad text and takes the images from these files. You don't need to create any ad content.

## File format

Both files use the same format:

* **CSV**, comma-separated, with one header row followed by one row per product or page.
* **UTF-8** encoding, so accents display correctly.
* **Quotes** around any value that contains a comma, a quote or a line break, with quotes inside a value doubled: `"Canapé ""Oslo"", gris"`. Feed tools and spreadsheet exports do this automatically.
* **Field names** in lowercase, exactly as written below. Column order doesn't matter. Columns not listed below are ignored.

Tab-separated files (`.tsv` or `.txt`) are also accepted.

## Tracking parameters

Tell your Lemrock contact which tracking parameters you want on your URLs, such as `utm_source=lemrock`. Lemrock adds them to every product and category URL it sends shoppers to, so you don't need to change your files.

Tracking parameters already in your URLs are kept. If one has the same name as a parameter Lemrock adds, Lemrock's value replaces it.

## Product feed

### What to send

If your catalog is in Lengow or Channable, follow the [Lengow](/en/catalog/lengow) or [Channable](/en/catalog/channable) guide.

Send us **one feed URL**: a web address where your product file can be downloaded. Lemrock downloads it regularly, so you don't need to send updates.

* **Keep the feed URL the same over time**, and keep the file behind it up to date with your catalog. Feed management tools provide a URL like this.
* **The feed URL must use HTTPS.** If it is protected, use a secret token in the URL or HTTP basic authentication, and send us the credentials.
* **Include the products you want to promote.** You can send your whole online catalog or a selection. Lemrock chooses among them which products to show in each conversation.

### Fields

The product feed follows the [Google Merchant Center product data specification](https://support.google.com/merchants/answer/7052112).

Template: [product-feed-template.csv](https://drive.google.com/uc?export=download\&id=1qlIXiSx5OrHtPFdGDilBIO0ZBhiNoOBB).

**Required.** Every row must have a value in each of these fields.

| Field | What to send | Example |
| - | - | - |
| `id` | your product ID, unique and permanent. | `100234` |
| `title` | the product name, including colour or size. 150 characters max, key words first | `Canapé d'angle convertible 4 places gris` |
| `description` | the product description, as plain text without HTML | `Canapé d'angle réversible, couchage 140 x 190 cm...` |
| `link` | the product page URL, over HTTPS | `https://www.example.fr/canape-angle-gris-100234.html` |
| `image_link` | a direct HTTPS link to the main product image, in JPEG or PNG | `https://media.example.fr/100234.jpg` |
| `price` | the regular price in euros, with a dot for decimals, followed by `EUR` | `799.00 EUR` |
| `availability` | one of `in_stock`, `out_of_stock`, `preorder`, `backorder` | `in_stock` |
| `brand` | the product brand | `Example Home` |

**Recommended.** These improve the ads and the reporting.

| Field | What to send | Example |
| - | - | - |
| `product_type` | the product's category on your site, from broadest to most precise, separated by `>` | `Canapé, fauteuil > Canapé d'angle > Canapé d'angle convertible` |
| `sale_price` | the discounted price, if there is one. Lower than `price` | `649.00 EUR` |
| `gtin` | the barcode (EAN), 8 to 14 digits without spaces | `3700000000013` |
| `mpn` | the manufacturer reference, if there is no barcode | `CNP-ANG-4P-GR` |
| `item_group_id` | **required if the product has variants**: the same ID on every variant row of one product | `CNP-ANG-4P` |
| `additional_image_link` | other product images, separated by commas in a single quoted value | `"https://media.example.fr/100234-2.jpg,https://media.example.fr/100234-3.jpg"` |
| `color` | the colour | `Gris` |
| `material` | the main material | `Tissu` |
| `size` | the size, if the product has one | `4 places` |
| `product_length`, `product_width`, `product_height` | the dimensions, with the unit | `250 cm` |
| `product_weight` | the weight, with the unit | `65 kg` |

### Rules

* **One row per variant.** Each variant a shopper can buy separately, such as a colour or a size, gets its own row with its own `id`, `price`, `availability`, `image_link` and `link`. Rows of the same product share one `item_group_id`.
* **Use the same `id` as your conversion tracking.** The product IDs your [pixel](/en/conversion-tracking/overview) sends must match the `id` in the feed, so sales can be linked to products.
* **Leave unknown values empty.** Don't write placeholder text such as `N/A`, `null` or `unknown`.

## Category file

### What to send

Send us **one category file** listing the category pages to promote. Include any page that lists products: a main category, a sub-category or a filtered view (for example, sofas filtered by colour).

When you add, rename or remove categories on your site, send an updated file.

Template: [category-urls-template.csv](https://drive.google.com/uc?export=download\&id=1u-nET-SDhFZGe9hwN694_CDo_kzAYwaF). An Excel file with the same columns is also accepted.

### Fields

**Required.** Every row must have a value in each of these fields.

| Field | What to send | Example |
| - | - | - |
| `id` | your page ID, unique and permanent. | `c1234` |
| `url` | the category page URL, over HTTPS | `https://www.example.fr/canape-fauteuil/canape-angle/index-c1234.html` |
| `title` | the page name as shoppers see it, usually the page heading | `Canapé d'angle` |
| `category` | where the page sits on your site, from broadest to most precise, separated by `>` | `Canapé, fauteuil > Canapé d'angle` |

**Optional.**

| Field | What to send | Example |
| - | - | - |
| `image_link` | a direct HTTPS link to an image representing the page, in JPEG or PNG. Without it, the page is promoted in text-only ad formats | `https://media.example.fr/c1234.jpg` |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.