River
Y CombinatorBacked by Y Combinator
FREE TEMPLATE

Ecommerce Negative Review Response Template

Three documents and three sheets that match every review to the order it describes before any response gets drafted.

Free download  ·  No account needed

Review Register

[Company] — [n] negative reviews, matched [date]

A review names a claim an order record can check: which variant, roughly which ship date. Matching first is what makes the response specific instead of generic.

Review IDPlatformThemeOrder MatchStatus

Three match outcomes, one rule for each

ConfirmedOrder number given, or name, date and product all agree
LikelyName and product agree, no order number to confirm it
Not foundAsk for the order number before drafting a response

A theme with three or more confirmed matches moves to the Product Issue Register instead of getting a fourth identical reply.

Guides on responding to negative reviews teach tone. Acknowledge the complaint, apologize, offer to help, in roughly that order. None of them touch the actual claim, which is a specific, checkable fact once the order behind it gets pulled. A review saying a lid will not seal names a variant and roughly a ship date, both already sitting in a system the merchant owns. Matching the review to that order before drafting anything is the difference between a generic apology and an answer that tells a future buyer exactly what happened.

Thistlewood Kitchen Co, an invented cookware brand, has fifty-eight reviews this quarter across Amazon, Shopify and Etsy, seventeen of them negative. Seven cite chipped enamel on the 9-inch skillet. Matching them to their orders shows six shipped inside a nineteen-day window in May, all from one receiving lot. That is a 7.14 percent complaint rate against the lot's 84 orders, nine times the product line's usual 0.79 percent. The seventh shipped in March, and its own text mentions a drop, a cause the batch conversation should not absorb.

The Review Register holds every negative review with its order match, and Theme Frequency groups them by complaint rather than platform. Product Issue Register is where three or more matched reviews on the same cause become a supplier or process decision instead of three separate replies. A lot defect worth escalating here is also the shape of claim a return pattern flags before it becomes a chargeback. A wrong-item theme traced to two similar SKUs is the same confusion a consistent SKU catalogue exists to prevent.

Seventeen negative reviews, matched to their orders and grouped by cause

The Review Register, Theme Frequency, and Product Issue Register sheets from the pack.

Review Register

Thistlewood Kitchen Co, an invented cookware brand. Fifty-eight reviews this quarter across Amazon, Shopify and Etsy, seventeen negative, computed as of September 8.

IDPlatformRatingThemeOrder MatchStatus
R-001Amazon2 starEnamel chipped on arrivalConfirmed - Lot TK-0417Drafted
R-002Amazon1 starEnamel chipped on arrivalConfirmed - Lot TK-0417Drafted
R-003Shopify2 starEnamel chipped on arrivalConfirmed - Lot TK-0417Drafted
R-004Etsy1 starEnamel chipped on arrivalConfirmed - Lot TK-0417Drafted
R-005Amazon2 starEnamel chipped on arrivalConfirmed - Lot TK-0417Drafted
R-006Shopify1 starEnamel chipped on arrivalConfirmed - Lot TK-0417Drafted
R-007Amazon2 starEnamel chipped on arrivalConfirmed - outside the lot windowDrafted
R-008Amazon3 starLid does not seat flushConfirmedDrafted
R-009Etsy2 starLid does not seat flushConfirmedDrafted
R-010Shopify3 starLid does not seat flushConfirmedDrafted
R-011Amazon2 starLid does not seat flushConfirmedNeeds response
R-012Amazon2 starArrived after the promised windowConfirmedDrafted
R-013Shopify3 starArrived after the promised windowConfirmedDrafted
R-014Amazon2 starArrived after the promised windowConfirmedNeeds response
R-015Etsy2 starWrong item or variant receivedConfirmedDrafted
R-016Amazon1 starWrong item or variant receivedConfirmedNeeds response
R-017Amazon1 starNo specifics, no order matchNot foundNeeds response

Six of the seven chipped-enamel rows share a nineteen-day ship window. The seventh, R-007, shipped in March and the reviewer’s own text mentions dropping the pan, which is why it stays out of the batch conversation.

Theme Frequency

The same seventeen rows, grouped by complaint instead of by platform.

ThemeCountSharePlatformsSignal
Enamel chipped on arrival741.2%Amazon, Shopify, Etsy6 of 7 trace to a single 19-day receiving window, Lot TK-0417
Lid does not seat flush423.5%Amazon, Shopify, EtsyAll 4 on the 9-inch skillet, none on the 11-inch
Arrived after the promised window317.6%Amazon, ShopifyAll 3 show the delay starting after the parcel left the warehouse
Wrong item or variant received211.8%Etsy, AmazonTwo different SKU pairs, no shared cause yet
No specifics, no order match15.9%AmazonToo small a sample to look for a pattern
Total17100.0%All negative reviews this quarter

Chipped enamel and the lid seal issue are 64.7 percent of every negative review between them, and both are variant-specific rather than store-wide.

Product Issue Register

Where a theme becomes a decision, with the rate it is actually running at.

IssueBaseComplaintsRateBaselineStatus
Chipped enamel on Lot TK-041784 orders shipped from the lot67.14%0.79% (product line, trailing four quarters)Open - supplier notified
Lid seal on the 9-in skillet261 orders this quarter41.53%Not yet baselined - tooling changed this quarterOpen - checking tooling tolerance
Carrier transit delay at the regional hub3 affected orders3Not applicableNot applicableOpen - flagged to carrier account rep
Packing mix-up on visually similar items2 affected orders2Not applicableNot applicableWatching - below the action threshold

The lot rate is 7.14 percent against a 0.79 percent baseline for the product line, nine times the usual rate, which is what turns six reviews into a supplier conversation instead of six separate replies.

What's in the pack

01

Response Guidance

States the FTC boundary plainly: contact and resolve is fine, pressure to remove a review is not.

02

Templates by Complaint Type

Five drafts, one per theme this pack tracks, with brackets for the order detail and the fix already offered.

03

Escalation Note

Names the three signals that move a review past a single reply, and the one line escalation may never cross.

04

Review Register sheet

One row per negative review with its order match confirmed, likely, or not found, before any response gets drafted.

05

Theme Frequency sheet

Every review's theme counted across platforms, so a chip on Etsy and a chip on Amazon count as one pattern.

06

Product Issue Register sheet

Turns three matched reviews into a rate against its base, the number a reorder decision needs before restocking.

07

Two logging prompts

Matches a new review to its order first, then drafts a response only once the match and theme are set.

How it works

  1. 1

    Open it or download it

    Open the pack in River with the agent ready to match reviews to orders, or take the blank documents and sheets away for free with no account.

  2. 2

    Send reviews and orders

    Send the reviews as they come in, across whichever platforms you sell on, plus enough order history from the same period to match them against.

  3. 3

    Read the match and the theme

    Get each review checked against its order, grouped with any other review naming the same cause, and a rate once three or more line up.

  4. 4

    Respond or escalate, logged

    Send the response that matches what actually happened, or raise a confirmed pattern to the Product Issue Register before it becomes five more of the same complaint.

Frequently asked questions

Is this template free?

Yes. Three documents, three sheets and two logging prompts with no signup and no card, and they are the same files the agent works in. Editing with AI is the optional path, where your own reviews and order history become the register.

What format are the downloaded files?

CSV for the Review Register, Theme Frequency and Product Issue Register sheets, and Word for Response Guidance, Templates by Complaint Type and the Escalation Note, zipped together. Excel, Numbers, Sheets, Word, Pages and Google Docs all open them directly.

Can I actually get a review taken down?

Only if it violates the platform's own policy, and that is a platform decision, not this pack's. What the FTC's review rule does allow is responding publicly and contacting the reviewer to fix the problem, which is what every drafted response here does instead.

What if a review gives no order number?

It gets logged as an unmatched row rather than guessed at, and Response Guidance says to ask rather than assume. The reply requests the order number or the email used at checkout, so the next response can be specific once that comes back.

Should every negative review get its own unique response?

No, and it should not. A first complaint about a defect gets a plain apology and a fix. The sixth one citing the same cause needs something else: a mention that the cause is already being addressed, which is what Theme Frequency and Product Issue Register are for.

What does Edit with AI actually do?

It installs the pack as a private Space and asks for your reviews and enough order history to match them. From those it builds the register, groups the themes, and drafts each response inside the FTC boundary on what a business can and cannot say.

Match your next batch of reviews to the orders behind them

Download the blank pack as Word and CSV files, or open it in River, send your reviews and order history, and get the register built with each theme's rate computed.

Edit with AI