Description
We need a Python developer to automate the creation of a data dictionary for our WooCommerce catalog (~2,000 mobility/accessibility products, ~86 categories). The system must: (1) group raw attribute names into synonym clusters using a text-similarity method of your choice, including a verification step to confirm groupings are correct before finalizing; (2) generate standardized definitions for each non-synonym attribute using a prompt we provide, integrated with Gemini or Claude API (we provide API access, you choose the best model for quality/cost); (3) output a structured Excel file with 4 tabs (definitions, mapping rules, synonyms, unresolved candidates). We have existing methodology, a working prompt, and a manual pilot example to use as a quality reference. Budget-conscious project — we want to start with a small paid trial on a single product category before committing to the full catalog.