Turned hours of daily SKU hunting into instant matches for K&L Wines

E-commerce & Retail
Machine Learning
LLM
Consulting
Mid-market

A wine retailer losing hours every day to manual product lookups

Family-owned since 1976, K&L Wines sells wine and spirits from a catalog of hundreds of thousands of records. Every day, its team matched messy wine names to the right SKU by hand, and the work grew with every new bottle. With no machine learning engineers in-house, K&L brought in NineTwoThree.

$273K+ annual savings
99% accuracy rate
60x speed increase
2 FTE equivalent capacity

What we delivered

Custom ML Model

Narrows the full wine catalog to about 50 likely matches.

LLM Precision Layer

Reads vintages, shorthand, and misspellings to pick the best.

Simple Search

Type any version of a wine name, get ranked matches back.

Human-in-the-Loop

Staff confirm the right SKU from 2 to 5 options.

challenges

K&L Wines faced three main challenges

The data was all there. Finding the right record in it was the problem, and the tools K&L had couldn't solve it.

Wine names too messy for search

The same wine could appear as "Château Petit 1989," "Chateau 89," or with "Chateau" misspelled. Ctrl+F and database filters couldn't keep up with that many variations across the full catalog.

A bottle of Chateau Margaux 2012 wine with different text variations of the label name around it including 'Chateau Margaux '12', 'Margaux, Château 2012', 'Chât. Margaux 2012', 'Château Margaux 2012', 'Ch. Margaux 2012', and '2012 Ch. Margaux'.

Off-the-shelf AI couldn't handle the scale

ChatGPT or Claude can read a messy wine name well, so an LLM became part of the answer. But no LLM can hold hundreds of thousands of records at once, and forcing it to try makes results slow, costly, and unreliable.

Diagram showing challenges of a large-scale catalog with central oval labeled 'Large-scale catalog' connected to two dark red ovals labeled 'Off-shelf AI' on the left and 'Traditional scripts' on the right, surrounded by white ovals listing issues: on the left - 'Failed in production,' 'Hallucinations,' 'Context limits,' 'High cost'; on the right - 'Manual upkeep,' 'Rigid rules,' 'Messy data,' 'Low precision.'

No time to spare, no room for error

With seven people losing a few hours a day each to lookups, K&L couldn't spare the time to second-guess results. A near-miss means the wrong wine, record, or price, so every match had to be right, with a person still confirming it.

Graphic showing factors contributing to a daily loss of $1,050 including 7 employees, 2 hours a day each, more naming variations, and manual SKU lookups on a light background.
How we solved it

NineTwoThree built a hybrid intelligence architecture combining ML and LLMs

The team combined traditional ML and modern LLMs in a way neither could work alone, splitting the problem into two stages.

ML does the heavy lifting

Custom ML models process all 500,000 records using vector embeddings, Levenshtein and Jaro-Winkler matching algorithms, and pattern recognition to narrow the field to the most likely matches.

User interface showing a custom machine learning matching system filtering from 500,000 to 12 items using methods like vector embeddings, Levenshtein, Jaro-Winkler, and pattern recognition, with search results for Château Margaux wine bottles ranked by match percentage

LLM adds precision

With only 50 records within context limits, an LLM applies human-like reasoning. It understands that "Ch." means "Château," "89" means 1989, and recognizes common misspellings.

Search box showing 'Ch. margeaux 89' and corrections for each part: 'Ch.' to 'Château', 'Margeaux' to 'Margaux', and '89' to '1989', next to a bottle of Château Margaux 1989 wine.

Simple for users, powerful underneath

Instead of handing over a repository, we built an interface where staff type a wine name and get results. They pick the correct SKU from ranked, ML-powered options. No training was needed, and the team started using it on day one.

1 sec
to match 10 wines
Laptop screen showing an online wine store search results for Château Margaux

What K&L Wines gained from partnering with us

$100k+ in annual savings

14 hours saved daily at $75/hour across 260 working days eliminated the equivalent cost of two full-time employees, totaling over $273,000 in annual savings.

99% accuracy rate

The hybrid ML and LLM approach delivered 99% accuracy validated in production, eliminating the manual errors that came with human matching across half a million records.

60x speed increase

Matching 10 wines went from 1 hour to 1 minute. Staff type a name, get 2 to 5 accurate matches, and select the correct SKU with human verification on ML-powered options.

Week 1 ROI

The solution paid for itself in the first month. The simple interface meant immediate adoption with zero change management, and the system scales automatically as inventory grows.

“Thanks to 923, we've dramatically increased throughput and reduced manual errors.”

NineTwoThree AI Studio’s work led to increased throughput and fewer manual errors in critical workflows. The team managed the project with regular meetings, responded well to needs, and quickly understood business goals.

Chris Hawley

Chris Hawley

Head of Engineering at K&L Wines

case studies

Similar case studies

New revenue stream with a supporting AI app for a note taker

Arrow Right
Contact us

Ready to become an AI-first company? Let’s connect.

Build a new platform, or add AI capabilities to existing software, we deliver solutions that work in real operational environments.

  • Meet with founders Andrew Amann & Pavel Kirillov

    founders
  • Custom AI implementation roadmap

  • No sales pressure

This site is protected by reCAPTCHA