A shop receives hundreds of reviews and returns every month, but they are scattered: the WooCommerce reviews module, the Google Business Profile, ratings on the Amazon and eBay marketplaces, Facebook and Instagram comments, and the return reason that a cashier types as free text into the SAP Business One return document. A manager looks at the few worst ratings on Amazon because they affect the sales ranking, while systemic problems, for example a specific model that everyone returns because it runs small, are noticed only after the season, when the stock has already been bought again.
We bring review sources and return reasons into one flow: WooCommerce reviews through the API, the Google profile, Amazon and eBay ratings through the seller portal export, Facebook comments, and SAP Business One return documents through a periodic export. Claude or ChatGPT via API assigns every record to a topic (size, quality, delivery, mismatch with the description, service, price), determines the sentiment and links it to a specific product by the SAP Business One item code or the WooCommerce order. The results are written to a data table, from which a Power BI report shows the topic distribution, the products with the most recurring problems and the change from week to week. Every Monday managers receive a short summary with concrete examples and links to the original entries. Decisions about the range, descriptions or the supplier are made by people, and the system only shows where to look. The model runs on the Anthropic API, Amazon Bedrock in an EU region or the OpenAI platform without training on your data, and customer names are removed before analysis.