Review and returns analysis

Reviews land on the website, Google, Amazon and eBay, while return reasons sit in a free-text field of the SAP Business One return document that nobody reads. AI classifies everything by topic and product, and managers see every week what keeps recurring and decide on the range themselves.

Built for ISO 27001NIS2 DORA

Review and returns analysis
  • Source integrations
  • Classification rules
  • Power BI report

Return reasons are in SAP Business One, reviews on Amazon, but nobody counts them

  • One flow Google, Amazon, eBay, SAP Business One returns
  • By product problems linked to the SAP Business One item code
  • Monday summary for managers with examples
  • Power BI report with topics and trends

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.

How it works

Four steps from input to a record in your system, with human approval wherever there is risk.

Collecting reviews and returns

Every day the flow picks up new reviews from WooCommerce, the Google profile, the Amazon and eBay seller portals and Facebook, and return records with the reason field from the SAP Business One return document export. Customer names and contacts are removed before the text is passed to the model.

What you get

Source integrations
Source integrations

Collecting reviews from WooCommerce, the Google profile, Amazon, eBay and Facebook, and return reasons from the SAP Business One return document export.

Classification rules
Classification rules

A topic list agreed with you and product-linking logic based on SAP Business One item codes, adapted to your categories and return forms.

Power BI report
Power BI report

A report with topics, sentiment, products, sources and the weekly change, available to managers and the merchandising team.

Weekly summary and support
Weekly summary and support

A Monday summary by email or in Teams with examples, and our support when the Amazon or eBay export formats change.

What we build it with

Claude or ChatGPT via API + review collection from WooCommerce, Google, Amazon and eBay, return reasons from a SAP Business One export, Power BI report. We connect through an API, a file export or an email flow, depending on your version. Read more about this service and its limits on the service page.

Frequently asked questions

Will the system reply to Amazon or Google reviews by itself?

This solution is for analysis, not for replies. If you want, we can add draft replies to Google and marketplace reviews as a separate stage, but a person always publishes publicly.

Does it work with Amazon, eBay and SAP Business One?

We take Amazon and eBay ratings from the seller portal export or through the marketplace interface if your account has one, and SAP Business One return documents through a periodic export or the API, depending on the version. We choose the integration method after a check, and we do not claim an official partnership with these platforms.

How many reviews are needed for the analysis to be meaningful?

In our experience it becomes meaningful from a few dozen records per week, because recurring problems show up quickly. For smaller volumes we suggest a monthly summary instead of a weekly one.

Related services

Staff assistant for checkout and service

A new cashier at the Lightspeed till does not know whether a return without a receipt is allowed, what promotion runs today or what to do with a…

More
Supplier invoices and goods receipt

A supplier invoice, a delivery note, the SAP Business One order and the warehouse receipt rarely match, and the differences surface only after…

More
Customer assistant with live stock levels

Customers ask whether an item is in the store, when an order will arrive and how to return it, while the support team checks the same things in…

More
Product descriptions from supplier data

A new supplier sends a thousand products with a code, a price and a few photos, and someone has to write the descriptions, categories and…

More

Expertise confirmed by certifications

This service is delivered by specialists with valid international certifications. Their expertise is confirmed by independent organisations, not by us.

All certifications
  • AISP badge
    AISP PECB

    Artificial Intelligence Security Professional

    AI systems are deployed with protection against data leakage and model abuse.

  • AAISM badge
    AAISM ISACA

    ISACA Advanced in AI Security Management

    The AI security programme and its controls are managed following the ISACA methodology.

  • AAIR badge
    AAIR ISACA

    ISACA Advanced in AI Risk

    AI risks are identified and managed like any other IT risk.

Let's discuss: review and returns analysis

Tell us how this process works for you today and which systems you use. Within 1 business day we will tell you how long an implementation for retail would take.

We reply within 1 business day

Contact us 24/7
+370 630 94 909

Fill out the form, and we will contact you within 1 business day.