v1.6.0

FICOFI - LCFA Wine AI Assistant

Le Club FICOFI Advisor - Personalized Wine Selection Tool

About This Tool

Welcome to the FICOFI - LCFA Wine AI Assistant! This intelligent recommendation system helps you create personalized wine selections for Le Club FICOFI members. The AI analyzes member preferences, purchase history, cellar inventory, and current promotions to suggest the perfect wines across four categories.

Quick Operating Procedure

Wine catalog auto-loads - Stock database (no upload needed)
Enter member name - Purchase history and cellar inventory auto-load from database
Select wine categories - Choose from 4 categories (at least one required)
Adjust recommendation weights - Fine-tune the AI algorithm (must total 100%)
Generate recommendations - AI creates personalized selections
Export to Excel - Download results in CSV format for further use

Database: Loading... wines in stock • 118,273 purchases (681 members) • 130,499 cellar items (363 members)

Step 1: Upload Data Files

Wine Catalog AUTO-LOADED

Stock database loaded automatically - No manual upload needed!

📅 Last updated: Dec 17, 2024

Loading wine catalog...

Member Preferences (Optional)

Past Purchases AUTO-LOADED

✨ Purchases automatically loaded from database when you enter member name

📅 Database: 118,273 purchases (681 members) • Last updated: Nov 19, 2024

Enter member name above to auto-load purchases

Cellar Inventory (Optional) AUTO-LOADED

✨ Cellar inventory automatically loaded from database when you enter member name

📅 Database: 130,499 cellar items (363 members) • Last updated: Nov 19, 2024

Enter member name above to auto-load cellar inventory

Step 2: Select Member & Categories

Member Name

Select Categories (Choose 1-4)

Category 1: Champagne & White Burgundy Category 2: Red Burgundy Category 3: Red Bordeaux Category 4: Others

Step 3: Adjust Criteria Weights

Quick Presets (click to apply)

Member Preferences

Match stated likes/dislikes

Wine Vertical Focus

Fill gaps in verticals

Past Purchases

Based on buying history

Cellar Inventory

Complement cellar holdings

Random Discovery

Surprise recommendations

Exclude from Cellar

Filter out owned wines

Total Weight:

100%

Step 4: Select AI Mode

Classic

Original algorithm with weighted scoring based on preferences, purchases, and cellar data.

Fast • Free

Hybrid Recommended

Algorithm pre-selects top 25 candidates, then GPT-4o makes final intelligent selection with personalized rationales.

Smart • ~$0.02/request

Full AI GPT-4o

GPT-4o sommelier analyzes all wines and member profile to select the perfect wines with expert explanations.

Most Intelligent • ~$0.05/request

Classic: Fast, rule-based scoring | Hybrid: Best balance of speed and intelligence | Full AI: Maximum personalization, GPT-4o analyzes everything