Multi-language Catalog Translator
Translates whole catalogs into Portuguese and English and leaves the file ready to load into the ERP, with no manual reformatting.
The problem
International expansion required translating whole catalogs by hand: slow, inconsistent in fashion terminology and without a standard format.
What I did
I built the multi-language version of the agent: a major app rewrite, interactive LLM chat, usage guide and the distinctive feature — LLM semantic column mapping into the corporate ERP's fixed schema.
The outcome
Agent in use on the portal for international-expansion catalogs.
From catalog to ERP
- Catalog in SpanishInput
- Translation to Portuguese and EnglishFull catalogs
- Consistent fashion terminologyThe glossary problem
- LLM chat for adjustmentsCorrection on the fly
- Semantic column mappingTo the ERP's fixed schema
- Template ready to loadOutput
Translating is the easy part. The hard part is getting the result into the ERP without manual reformatting: semantic column mapping solves the step that turned every translation into a hand-keyed load.
Stack
- Python
- Streamlit
- GPT-4o-mini
- pandas
- openpyxl
- Docker
Blue Star Group internal project — the code is not public.
Next project: Visual Product Search →