Cobra · Claude → Claude Code pipeline
Automatic Odoo product creation agent
Context
Cobra was manually creating every new Odoo product from catalogs scattered across multiple formats (emails, POS Excel, photos of price tables). The goal: fully automate this workflow for any brand.
What was built
- Multi-source triangulation on the Sony Bravia FY26 catalog: purchase price from POS Excel, cross-referenced with email screenshot (range, size, EAN), VAT-inc retail price from photo
- Drive-ready structured Excel: formatted name, internal reference, EAN, supplier code, net purchase price, VAT-inc retail price — color-coded by range
- Claude Code took over: updating
lst_pricevia XML-RPC
What was hard
- EANs stored as scientific floats in Excel (
4.548736e+12) — mandatoryintcast - Data across 3 formats with no common structure: visual/manual matching — the real bottleneck to solve in the generic version
Stack
Python, pandas, openpyxl, Odoo XML-RPC, Claude Code.
What this illustrates
Multi-source triangulation and the Claude → Claude Code pipeline: Claude structures data from heterogeneous sources, Claude Code handles the Odoo writes. The Sony project is the first pattern for a generic agent covering the entire Cobra catalog.