Your product reviews already tell you what to fix. The problem is that nobody has time to read hundreds of them. Here's a simple way to turn reviews into a to-do list.
Get them in one place
Start by exporting your reviews from your review app into one spreadsheet. Include the product, the star rating, the date, and the full review text.
- Export: From your review app
- Columns: Product, rating, date, review text
- Scope: Start with the last 90 days
Tag each review with a theme
Next, tag each review with a theme. Most stores only need a handful: sizing and fit, quality, shipping, packaging, and whether the product matched its description.
- Fit: Sizing runs small or large
- Quality: Materials, durability, defects
- Shipping: Late, damaged, wrong item
- Description: Not what the page promised
Count, then rank
Now count. Rank the themes by how often they come up in your low-star reviews. A complaint that appears in twenty reviews matters more than a loud one that appears once.
- Count: Mentions of each theme
- Focus: 1 to 3 star reviews first
- Rank: Most frequent problem at the top
Keep the evidence
Keep two or three real quotes for each problem, and note which products it comes from. Quotes are what convince a supplier, or your team, that the fix is worth making.
| Weak | Strong |
|---|---|
| Customers seem unhappy with sizing | “Runs a full size small”: 14 reviews, mostly on the Linen Crew Tee |
Doing this at scale
ReviewLens does this for you. It reads the product reviews already in your store, groups them into themes, scores the sentiment for each one, and builds a ranked Fix This Week list, with customer quotes behind every issue. See ReviewLens.