A store's overall star rating can look healthy while a handful of products quietly generate most of the complaints. This guide shows how to find those products, tell a real problem from a noisy one, and decide what to do about each.
Do not sort by average rating alone
The lowest average rating is a poor guide on its own. A product with two reviews and one bad one looks worse than a product with two hundred reviews and forty bad ones, but the second is hurting far more customers. Look at rating and volume together.
- Average rating: How unhappy reviewers are
- Review count: How much you can trust the average
- Low-star count: How many customers had a bad experience
- Units sold: How many more customers are exposed to the problem
Build a simple ranking
Export your reviews from your review app into a spreadsheet, with one row per review. Then summarize by product. A count of one-star and two-star reviews per product, alongside the share of all reviews they represent, gives you a workable ranking.
| Column | Why it matters |
|---|---|
| Product or SKU | The unit you will act on |
| Total reviews | Filters out products with too few to judge |
| One-star and two-star reviews | The size of the problem |
| Low-star share | Compares big and small sellers fairly |
| Most recent low-star date | Shows whether the problem is still live |
Read the reviews, not just the stars
A low rating tells you a product has a problem. It does not tell you which one. Read the low-star reviews for each product near the top of your ranking and label each with a cause.
- Product quality: Breaks, wears out, does not work as claimed
- Expectation gap: Size, color or function differs from what the page suggested
- Shipping and packaging: Arrived late or damaged
- Service: Slow or unhelpful response to a problem
- Variant-specific: One size or color attracts most of the complaints
Check the trend
A product that was fine last year and is collecting complaints this quarter needs attention sooner than one with old, resolved issues. Compare recent reviews with older ones. A sudden change often points to a new supplier, a new batch or a change to the page.
- ✅ Compare the last 90 days with the period before
- ✅ Note the date of any supplier, packaging or listing change
- ❌ Treating a three-year-old complaint the same as last week's
Decide what to do
Each cause has a different fix. Match the action to what the reviews say, and start with the products that sell the most.
- Expectation gap: Rewrite the page. See how to analyze product reviews
- Quality: Raise it with your supplier, or pause the product
- Packaging: Change how the item is packed
- Unhappy reviewers: Reply publicly. See how to reply to negative reviews
Doing this at scale
ReviewLens reads the product reviews already in your store, groups them into themes and scores sentiment per theme. It spotlights your top problem SKUs and builds a ranked "Fix This Week" list with verbatim customer quotes, so you do not have to maintain the spreadsheet. See ReviewLens.