The AI Import Agent is a time-saving tool within Gelato Connect Procurement (GCP) that helps you bulk import supplier and product information using just one file. Instead of manually creating entries, the system uses AI to read various file formats and update your database automatically. This article walks you through the process and explains how to get the best results from this feature.
How the AI Import Agent Works
The AI Import Agent is designed to simplify supplier and product data entry by removing the need for manual inputs or strict formatting rules. It reads your uploaded files, identifies suppliers and their products, and updates or creates records in GCP accordingly.
What it supports:
Input from commonly used file types: CSV, Excel, PDF, and TXT
Unstructured data like raw supplier price lists or data sheets
Detection of both new and existing suppliers with product-level updates
Step-by-Step Guide to Importing
Upload Your File
Go to the supplier management section in GCP.
Choose the AI Import option.
Upload your data file in any of the supported formats:
.csv.xlsx,.xls.pdf.txt
The tool does not require a specific template, allowing you to use files directly from your suppliers.
Review the Analysis
Once the file is uploaded, the AI Agent analyzes the content and shows a summary:
All identified suppliers in the file
Number of products linked to each supplier
Status of each supplier:
Existing Supplier: Found in your database, will be updated
New Supplier: Will be created as a new entry
Skipped: Missing essential information like a supplier name; will not be imported
Confirm and Import
After verifying the analysis:
Click Import to proceed.
The AI Import Agent will:
Create entries for new suppliers
Update existing supplier records with new products
Build out product lists with information pulled from the file
Verify the Results
When the import finishes, a confirmation will show a summary such as:
"1 supplier updated, 2 products created."
To ensure everything looks right, check your supplier list and confirm that the updates have been successfully applied.
Benefits of Using the AI Import Agent
Time-saving: Import multiple suppliers and products in one go
Flexible: Works with multiple file types and unstructured formats
Accurate: Prevents duplicates and keeps your records clean and up to date
Frequently Asked Questions
Why was a supplier skipped during import?
The AI Agent skips entries that lack key data, such as a supplier name or product list.
What happens if a supplier already exists?
The system checks for existing records and updates them with any new product information instead of creating duplicates.
Can I import multiple suppliers at once?
Yes. The tool is built to handle files containing data for several suppliers and their products in a single import.
📝 Not what you needed?
Help us improve this article, send us an email to [email protected] — please include the article title.