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