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 Copilot 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

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 highly recommended to add:

• Product Availability
• URL of the product’s main image

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 Copilot.

The CSV file may contain additional columns to enrich the Copilot. 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.

Required fields are:

• ID: expected format = id (must match the value returned by the personalized data entered above)

• Title: expected format = title

• Description: expected format = description

• Link: expected format = link (URL of the product page on the brand’s website, must reflect the catalog information; used if no ID is provided)

Other available and strongly recommended fields are:

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

• Availability: expected format = availability

  Supported values: in_stock, out_of_stock, preorder, backorder

• Availability Date: expected format = availability_date

• Price: expected format = price

• Sale Price: expected format = sale_price

• Product Category: expected format = product_types

  Example value: Home > Men > Clothing > Shirts

• Gender: expected format = gender

  Supported values: male, female, unisex

• Brand: expected format = brand

• Color: expected format = color

  The primary color must be listed first

• Size: expected format = size

• Material: expected format = material

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

• Condition: expected format = condition

  Supported values: new, refurbished, used

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 Copilot 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 Copilot always has the most up-to-date information about your products.

3. Error management