Aurelia · jewelry catalog

What it is

An importer that maps the images embedded in supplier spreadsheets to their rows, then loads the catalog into Odoo 19 over batched XML-RPC. Names and descriptions for 7,387 products were generated with the Claude batch API from each product's photo and inventory data, with strict JSON output and quality flags. A local model was benchmarked first and rejected.

Highlights

• 7,451 products imported, 7,000 published; 55 duplicate-SKU groups resolved
• Hardened after an attempted intrusion on day 3: contained in eight minutes, no data lost, firewall rules and secret rotation the same day