You can import your product catalog using a CSV file, by reusing an existing file—whether it's in a Google Shopping format or another format you already use.

If you need to create a new CSV file specifically for the catalog, the data flow description below outlines the essential information to include.

The product catalog provides your Copilot with the necessary data to assist customers in their search and answer questions related to product features.
An optimized structure for this CSV file is therefore crucial to ensure smooth and effective performance.

1. Data flow description

1.1. File format

The CSV file must include a header row that indicates the content of each column, followed by one row per product. The columns should list product attributes such as Title, Description, Price, etc.

A sample CSV file is available via this link. Make sure to use the CSV format with UTF-8 encoding to avoid any errors during import.

1.2. Required fields

To import your product catalog, the CSV file must include the following columns:

Unique product ID
Title
Description
Product page URL
Price

It is also strongly recommended to add:

Product availability
Main product image URL

These details are essential to provide an optimal experience for your visitors. If they are not properly filled in for most products, the catalog cannot be activated or used by your Copilot.

The CSV file may contain additional columns to enrich the Copilot. In this case, make sure the column names are explicit, for example: "Lead time" or "Power supply"

Once your product catalog is ready, use the Knowledge Explorer to check that all the provided information has been correctly integrated into the knowledge base.

1.3. Data updates

You can import a CSV file either by selecting it from your computer or by providing the URL of a file hosted on your website. Using a URL has the advantage of enabling automatic daily synchronization of your data.

To ensure the Copilot always provides up-to-date information to your customers, it's essential to regularly update your CSV file, adding new products and adjusting existing information.

2. Help with creating the product catalog using a CSV file

Use a URL to import your CSV file and benefit from automatic daily synchronization. If authentication is required, include the necessary credentials in the headers.

If your file does not use the standard CSV format (comma, semicolon, tab, etc.), adjust the field separator to ensure proper parsing.

When your file columns follow standard labels, they are automatically recognized and mapped to the corresponding fields. Additional columns not configured via mapping will be added as supplementary information, provided their names are clear enough to be correctly interpreted.

Finally, make sure to regularly update your CSV file to ensure the Copilot always has the latest product information.

3. Error handling

In case of an error, an explanatory message will indicate the cause of the issue.

The most common errors include:

Incorrect separator: The specified separator does not match the file format.
Invalid CSV format: Some rows do not contain the same number of columns. Each row must have a fixed number of columns, even if some are empty.
Incorrect encoding: The file is not encoded in UTF-8.
Invalid field format: One or more fields do not follow the expected specifications (see the product catalog field requirements).

These error messages help you quickly identify the issue and make the necessary corrections.