Marketplace reviews

Marketplace reviews let you show buyer reviews written for your store on Trendyol, Hepsiburada, Amazon, N11 or Çiçeksepeti on your product pages. Every review is published with its source named and a link to the review at the source. The screen is the Marketplace reviews tab of the Integration menu; users with the “Can manage settings” permission see the tab and the connections.

Sayproof does not collect reviews from marketplaces on its own. Reviews are taken only from a file you download from the marketplace and upload, or from a web address the marketplace allows.

What is taken and what is not

Rule	Explanation
Buyer reviews only	Reviews the marketplace marks as “bought” are taken. A row without the mark is skipped.
Your own store only	The seller number on the row must equal the seller number you entered on the connection. Reviews from people who bought from other stores are not taken.
Every rating	There is no rating filter; every rating from 1 to 5 is taken. Nothing is dropped for the length of the text either; a row with only a rating is taken.
Matching by barcode	A review is taken when its barcode matches the gtin of a product in your product list exactly. Spaces, hyphens and leading zeros do not matter. A barcode that matches nothing, or more than one product, is not taken and shows in the report.
Author name	Only the first letter of each word and *** are stored and shown (for example Z*** K***). The full name is never stored anywhere.
Photos	Up to six photos are taken. Photos are downloaded when the review is first taken; they pass the virus scan, re-encoding and location and metadata removal. A photo that cannot be fetched does not stop the review and is counted in the report.
Review date	The date of the review at the source is shown as the review’s date on the page.

Setting up

The Add a marketplace button opens a wizard with two steps.

1. Marketplace and store: choose the marketplace, the channel the reviews are published in and your store’s seller number. Reviews are published in that channel’s market. The seller number cannot be changed afterwards; if it is wrong, set up a new connection.
2. How reviews arrive: File upload or Web address. For a web address you enter the https address and, if it needs one, an access password; the password is stored sealed and is never shown anywhere.

Setting up, changing and removing a connection is written to the Activity history with who did it. You can Pause and Resume a connection. A paused connection reads no new reviews; reviews already published stay on the page. A connection cannot be removed while it has imported reviews that have not been removed (including those waiting for approval) or while it holds the record of a review removed by a personal data request; that record keeps the removed review from being imported again.

File upload

The file can be CSV, Excel (.xlsx) or JSON. Every upload must hold all of your store’s reviews: a review missing from the file counts as removed at the source. The file can be up to 20 MB and 100,000 rows. The first row is the header; headers are read without regard to case or the difference between a space and a hyphen.

Column	Required	Meaning
review_id	Yes	The review number on the marketplace. The same number is not taken twice. Other name: id.
barcode	Yes	The product’s barcode. Other names: gtin, ean.
rating	Yes	A whole number from 1 to 5. Other names: stars, star.
buyer	Yes	The marketplace’s buyer mark: true, 1, yes or evet means a buyer. Other names: verified_buyer, purchased.
seller_id	Yes	The seller number of the store the review was written for. Other name: seller.
title	No	The review title (at most 200 characters).
comment	No	The review text (at most 5,000 characters). Other names: body, text.
author	No	The author’s name; it is shortened as soon as it is read. Other names: author_name, name.
created_at	No	The review date: 2026-03-04, 04.03.2026, ISO 8601 or a timestamp in seconds or milliseconds. A future date is ignored. Other name: date.
photos	No	Photo addresses separated by |, a comma, a semicolon or a space (a list also works in JSON). Only https addresses are taken. Other names: images, photo_urls.
url	No	The address of the review at the source. The link on the review goes here; it becomes a link only if the address is on the marketplace’s own domain (subdomains included, e.g. trendyol.com, hepsiburada.com, amazon.com.tr, n11.com, ciceksepeti.com); an address on any other domain is not linked and the label stays plain text. Other name: review_url.

A JSON file can be a list or a list under the reviews, items or data key:

{
  "reviews": [
    {
      "review_id": "88120001",
      "barcode": "8690000000011",
      "rating": 4,
      "comment": "Fits well, quick delivery.",
      "author": "Zeynep Kaya",
      "created_at": "2026-03-04",
      "buyer": true,
      "seller_id": "55",
      "photos": ["https://cdn.example.com/p/1.jpg"],
      "url": "https://marketplace.example.com/review/88120001"
    }
  ]
}

The Try first button reads the file but saves nothing; it shows how many reviews would be taken, how many would change or be removed and which barcodes do not match. Upload and import takes the reviews in the background.

Web address

For a connection that works by web address, the address must be https and return a CSV or JSON with the columns above (or the same JSON keys). The address cannot reach private network addresses and redirects are not followed. New reviews are read once an hour; once a day a full comparison with the source is made as well. Read now starts a full read at once.

Matching report

The report of every read shows on the source’s card: how many reviews were read (rows not marked as a buyer or belonging to another store are not in this number and show among the skipped ones), how many reviews were taken new, changed and removed, which barcodes did not match (and why), how many rows were skipped and why (not marked as a buyer, another store, removed by a deletion request, unreadable row, repeated number). When you fix an unmatched barcode in your product list, those reviews are taken on the next read.

How it looks on the page

• Every review carries a source label: Bought on Trendyol · Imported automatically from Trendyol. The label links to the review at the source (it is plain text if there is no address or the address is not on the marketplace’s own domain).
• An imported review has no Verified buyer badge; the site where the purchase was verified is written in the label. The Verified buyers filter does not cover these reviews.
• Imported reviews count in the average, the rating breakdown and the number of reviews. A line in the summary area such as 3 of 4 reviews imported from Trendyol says so.
• Imported reviews are left out of the page’s structured data (Review, AggregateRating) and of the Google product reviews file; the structured data is calculated from your own reviews only.
• One sentence is added to the method statement for every active marketplace; if you host the statement on your own page you have to confirm it again.

Approval and checks

An imported review goes through the same checks as the others: the personal data, insult and health claim checks run and a flagged review waits for approval. A review is held back only for a legal reason; its rating or being negative is not one. Whether a review goes live on its own is decided by the channel’s approval mode: in manual mode every imported review waits in the approval queue. The repeated text check is not applied to imported reviews; the same short sentence written many times is normal on marketplaces.

No notice goes to the customer about an imported review that is not published, because the customer’s email address is not known; the reason is recorded in the review’s detail.

In the panel, the marketplace an imported review came from is shown everywhere: in the Awaiting approval and All reviews lists the marketplace’s name appears as a badge next to the review text (for example Trendyol), and the badge next to the rating in the review details and the Source row carry the same name. To see only imported reviews, choose Imported from a marketplace in the Came from filter on the All reviews screen.

Changes and deletions at the source

• A changed review: A review whose rating or text changed at the source is updated and written to the Activity history. A live review is checked again; if the check finds something, the review is hidden with the reason Under review and waits for your decision. Photos are downloaded only when a review is first taken; a photo added or changed later is not taken.
• A removed review: In a full comparison, a review that is no longer at the source is removed with the reason Removed at the source. A review that comes back at the source is taken again.
• Safeguard: If the source fails, nothing is removed. If more than half of a product’s imported reviews (at least 10), or more than half of the connection’s reviews (at least 10), vanish in one read, or no review comes at all, or all of them vanish, the removal is held back; the read stays in the Removals held back state and new reviews are still taken. If you are sure the file or the address is right, tick the box and upload the file again for a file connection, or press Confirm removals and read for a web address.
• A review you rejected or removed by hand does not come back even if it stays at the source.

Personal data requests

Because imported marketplace reviews carry no email address, they cannot be looked up under a person. On the Personal data requests screen the Remove a marketplace review button lets you search reviews by their text, author name or marketplace review number and remove the ones you pick. The picked review leaves the page, its photos are deleted, the personal details in its text are replaced with marks and the same review is not imported again. The record goes to the request list and the erasure log like other deletion requests. For details: Personal data requests.

Warnings

• On the Overview screen: when removals are held back for a connection, or a connection could not be read several times in a row, the Needs your attention card shows a line that opens the Integration › Marketplace reviews tab. The line for held removals gives the number of reviews that were not removed; the line for failed reads gives the number of connections. A held removal stays on the line and on the connection’s card until a full comparison succeeds, even if the hourly reads after it succeed. Failed reads clear as soon as one read succeeds. The number of failed reads that raises the line is the one in Settings › Warning limits (3 if it is set to 0). Paused connections and connections on a closed channel are not counted.
• By email: brand administrators receive one email the first time removals are held back for a connection, and one when reads fail as many times in a row as the number in Settings › Warning limits (3 by default). A second email is not sent for the same connection unless the situation is resolved and then comes back; a value of 0 in that setting turns both emails off. The email names the marketplace and the channel, says what to do and is in the language of the channel.

Related pages

• Management API: the connection, read and removal endpoints
• DOM attributes: the label and the summary line