O-Trace AI

Inspiration

Arca Continental sales reps spend a significant part of their day manually copying purchase orders from Walmart, Soriana, and Sam's Club into the internal system, field by field. It's repetitive, error-prone, and takes time away from what actually matters: selling. We lived that problem firsthand and decided to fix it.

What it does

O-Trace AI is a Chrome extension that automates the entire order capture process. It has two modes: Analysis mode reads the retail portal, identifies products and quantities, and matches them against Arca Continental's internal catalog in seconds. Auto mode goes further — one click handles everything from reading the portal to filling the destination system, with zero human intervention.

How we built it

O-Trace is a three-layer solution. A Chrome Extension (Manifest V3) captures page content and sends it to the backend. A Flask backend uses Anthropic's claude-opus-4-5 to semantically extract products, then performs a fuzzy search on MongoDB Atlas to retrieve the correct SKU and business unit. Playwright then fills the destination system automatically with the mapped data.

Challenges we ran into

Making AI extraction reliable across different portal layouts without hardcoding rules was hard. We needed careful prompt engineering to get Claude to return consistent, parseable JSON from messy real-world pages. Matching product names like "Refresco Coca Cola 1.25 l" against catalog entries like "Coca - Cola" also required building a custom fuzzy matching system with stop word filtering.

Accomplishments that we're proud of

A fully working end-to-end pipeline — from a retail portal page to a filled internal form — triggered by a single click. We're also proud of the extension's UX: visually polished, intuitive, and ready for real day-to-day use from the first interaction.

What we learned

How to connect a browser extension, a language model, a database, and a UI automation layer into one seamless agent.
How to engineer prompts for structured output extraction from unstructured web content.
That user experience is just as important as functionality — a powerful tool that's hard to use won't get used.

What's next for O-Trace AI

Expanding support to more retail portals, adding a dashboard for order history and analytics, and integrating directly with Arca Continental's ERP system to eliminate the destination form entirely.