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

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

The product catalog provides the Assistant with the necessary data to assist customers in their search and answer questions regarding product characteristics. Therefore, an optimal structure of this CSV file is crucial to ensure effective functionality.

1. Data feed description

1.1. File format

The CSV file must include a header row indicating the content of each column, followed by a row for each product. The columns should list the product characteristics such as Title, Description, Price, etc.

An example of the CSV file is available via this link. Ensure to use the CSV format with UTF-8 encoding to avoid any errors during import.

1.2. Expected data

Required fields : 

• id : Unique Product ID
• title: Product Title
• description: Product Description
• link: Product Page URL of your brand's website

Other available and strongly recommended fields :

• item_group_id: Group ID (used to group variants of the same product: sizes, colors, materials, conditions)

• availability : Availability

  Supported values: in_stock, out_of_stock, preorder, backorder

• availability_date : Availability Date

• price: Price

• sale_price : Sale Price

• product_types : Product Category 

  Example value: Home > Men > Clothing > Shirts

• gender : Gender 

  Supported values: male, female, unisex

• brand: Brand

• color: Color

  The primary color must be listed first

• size: Size

• material: Material

  Can include a primary material followed by secondary ones separated by a comma, slash, etc.

• condition: Condition

  Supported values: new, refurbished, used

• crosssellproducts : cross selling (learn more)
• compatiblewith : compatibility (learn more)

These pieces of information are essential to provide an optimal experience for your visitors. If they are not correctly provided for the majority of products, the catalog cannot be activated or used by your Assistant.

The CSV file may contain additional columns to enrich the Assistant. You have two options:

• Use the mapping feature to define the content of additional columns, such as color or size.
• Let our system store these details as complementary data. In this case, ensure the column names are explicit, such as “Manufacturing Lead Time” or “Power Supply”.

Once your product catalog is created, use the knowledge explorer to ensure all the provided information is correctly integrated into the knowledge base.

1.3. Data update

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

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

2. Assistance in creating the product catalog through CSV file

Use a URL to import your CSV file and benefit from automatic daily synchronization.

If authentication is required, include the necessary information in the headers. If your file does not use the standard CSV format (comma, semicolon, tab, etc.), adjust the field separator to ensure correct reading.

When the columns in your file follow standard labels, they are automatically recognized and mapped to the corresponding fields. Additional columns that are not configured in the mapping will be added as complementary information, as long as their name is clear enough to be interpreted correctly.

Finally, be sure to regularly update your CSV file to ensure the Assistant always has the most up-to-date information about your products.

3. Error management