# Import reviews from another platform

> Bring the reviews you earned on Etsy, Shopify, WooCommerce or anywhere else into Shoprocket from a CSV, Excel, OpenDocument or JSON file, or let the assistant do it. What the file needs, how reviews with no product become shop reviews, what happens to reviews already in your shop, and why imported reviews are labelled.

Help Centre / Marketing - Updated 11 November 2026

When you move to Shoprocket, the reviews your customers left on your old platform can come with you. You import them from a file, and each review is attached to the product it names, matched by product name or SKU. A review that names no product in your shop comes in as a shop review, which is about your shop as a whole, unless you choose a product for it. Imported reviews show in your shop with an **Imported** label, so customers know where they came from.

## Before you begin

- **Add your products first** if your reviews are about products. A review is matched to a product that already exists in your shop. If a review's product cannot be found, it comes in as a shop review, and you can pick a product for it before the import runs.
- **Export your reviews** from your old platform or review app. Most offer a CSV download. Etsy reviews usually come as a JSON file, which works as it is.

## What the file needs

The import takes a CSV, Excel (.xlsx), OpenDocument (.ods) or JSON file of up to 10MB. In a spreadsheet, the first row must be the column headers. A JSON file is a list of reviews, like an Etsy reviews export.

| Column | Required | Notes |
|---|---|---|
| Product name or SKU | No | You choose which one to match in the import settings. Etsy's `listing_title` works as the product name. Without this column, every review comes in as a shop review. |
| Rating (1-5) | Yes | A whole number from 1 to 5. |
| Author name | No | Shown as "Anonymous" when blank. |
| Author email | No | Never shown to customers. Leave it blank if your export has none. |
| Review title | No | |
| Review content | No | |
| Review date | No | For example 2025-06-15, or a Unix timestamp as Etsy writes it. Today's date is used when blank. |

Column names are matched for you where they are recognisable (Rating, Stars, Reviewer name, Body and so on), and you can change any match before importing. To start with the right columns, click **Download CSV template** on the import page.

## Import a file

1. In your dashboard, go to **Reviews** and click **Import**.
2. Choose your file, or paste a link to it under **Or paste a link to a CSV, Excel or JSON file** (the link must open without signing in).
3. On **Map CSV columns**, check that each column goes to the right field, or choose **(Skip this column)**.
4. Under **Import settings**, choose:
   - **Match products by**: **Product name** or **Product SKU**.
   - **Import reviews as**: **Approved (public immediately)**, or **Pending moderation** if you want to look through them first.
   - **Import mode**: **Import all (create + update)**, **Only create new** or **Only update existing**.
   Under the settings, you see how many reviews name a product in your shop, for example "12 of 20 reviews name a product in your shop".
5. If every review names a product, click **Start import**. If not, click **Next: assign reviews**.
6. On **Assign reviews**, you see each review that names no product, with its author, stars, date and the start of its text. Each one is set to **Shop review**. If a review is about one product, open its **Import as** list and pick that product. To give several reviews the same product, tick them and choose the product under **Import the selected as**. Choose **Skip this review** for any review you don't want to import.
7. Click **Start import**. When it finishes you see how many reviews were created, updated and skipped, and the reason for any row that failed.

![The Map CSV columns step of the reviews import, with each column of the file matched to a review field, next to the import settings](https://shoprocket.io/img/help/import-reviews/map-columns.webp)

![The Assign reviews step, listing reviews that name no product, each set to Shop review with a list to pick a product instead](https://shoprocket.io/img/help/import-reviews/assign-reviews.webp)

Each product's star rating updates as its reviews arrive, and so does your shop rating.

## Shop reviews

A shop review is about your shop as a whole rather than one product: "fast shipping, lovely packaging, will order again". In **Reviews**, a shop review shows **Shop** in the product column. The **Reviews of** filter lets you show **Shop and product**, **Shop reviews** or **Product reviews**. The **Shop rating** line above the list is the average of your approved shop reviews.

After an import, you cannot change what a review is about. A shop review cannot be moved onto a product, and a product review cannot be moved to another product or turned into a shop review. So if a review is about one product, pick that product on **Assign reviews**, before the import runs.

### Importing the same file again

A review in the file counts as one already in your shop when it is for the same product (or both are shop reviews) and has the same author email. If there is no email, it must also have the same author name, date and text. So importing the same file twice never doubles your reviews.

When a row matches a review you imported before, **Import all (create + update)** and **Only update existing** update its author name, title and text from the file. Empty cells keep what is there. Two things never change on a re-import:

- **The rating.** Once a review exists, its stars are fixed.
- **A review a customer wrote in Shoprocket.** If the matching review was written by the customer through your shop, the row is reported as an error and the customer's review is left exactly as they wrote it.

**Only create new** skips every row that matches an existing review.

## Etsy reviews

Etsy's reviews file (`reviews.json`) has a reviewer, a date, the stars, the message and the order number for each review. It has no product and no email address, and the import handles both:

- **Your reviews come in as shop reviews.** Because the file names no product, every review goes to **Assign reviews** set to **Shop review**. If a message makes clear which product the review is about, pick that product there. The rest stay shop reviews, which is what most Etsy reviews are ("Love them", "Fast shipping, great item").
- **You can use the file as it is.** Upload the JSON file, or paste the JSON link from a review export tool.
- **A file that does name products works too.** If it names them by `listing_title`, match products by **Product name**, and make sure your product names in Shoprocket match the Etsy listing titles. If it names them only by `listing_id`, map that column to the product and match by **Product SKU**, with each product's SKU set to its Etsy listing ID.
- **Reviewers are not emailed about your replies.** The file has no email addresses, so when you reply to one of these reviews, your reply only shows in the shop.

## Let the assistant import

In the dashboard assistant, attach your file (or paste a link to it) and ask it to import your reviews. It shows a card with how many reviews will be added, how many of them come in as shop reviews, which rows will not and why, and which column goes where. Type IMPORT to confirm.

- The assistant only ever adds new reviews. It never updates ones already in your shop.
- It cannot pick products for reviews that name none: those come in as shop reviews. To pick products, use **Import** on the **Reviews** screen instead.
- Reviews it imports arrive as **Pending**, so you approve them in **Reviews** before they show.
- An assistant import cannot be undone in one step. To remove reviews afterwards, delete them from **Reviews**.

## Why imported reviews are labelled

Imported reviews are never marked **Verified Purchase**, and customers see an **Imported** label on them, in every language your shop sells in.

![An imported review on a product page in the shop, with the Imported label after the reviewer's name](https://shoprocket.io/img/help/import-reviews/imported-review.webp)

The **Verified Purchase** badge means the reviewer bought the product from your shop, and Shoprocket can only prove that for orders placed here. An imported review may be completely genuine, but nothing in the file proves who wrote it, so the label tells customers it came from somewhere else. The label also keeps you on the right side of rules against misleading reviews.

Imported reviews do count toward your star rating, and they are sent to Google with your other reviews. See [Star ratings on Google](https://shoprocket.io/help/google-review-stars.md).

After an import, you can tidy an imported review's author and text, but not its stars. See [Edit a review](https://shoprocket.io/help/edit-a-review.md).

## Why you cannot add a review by hand

There is no button to type in a review yourself. A review written by the seller is not a customer review, however faithfully it repeats what the customer said. Adding one is exactly what the rules on fake reviews forbid.

Instead, click **Request a review** on the **Reviews** screen and enter the customer's name and email. They get an email with a link to review the product in their own words. See [Collect and show product reviews](https://shoprocket.io/help/product-reviews.md).

Reviews that sellers typed in before this changed are kept, show **Manual** as their source in your dashboard, and carry the **Imported** label in your shop. They are not sent to Google.

## Related

- [Open the reviews import in your dashboard](https://app.shoprocket.io/go/reviews/import)
- [Collect and show product reviews](https://shoprocket.io/help/product-reviews.md)
- [Edit a review](https://shoprocket.io/help/edit-a-review.md)

---

- HTML version: https://shoprocket.io/help/import-reviews
- Language: English (en)
- Also in: [العربية](https://shoprocket.io/ar/help/import-reviews.md), [Deutsch](https://shoprocket.io/de/hilfe/bewertungen-importieren.md), [Ελληνικά](https://shoprocket.io/el/help/import-reviews.md), [Español](https://shoprocket.io/es/ayuda/importar-resenas.md), [Français](https://shoprocket.io/fr/aide/importer-des-avis-depuis-une-autre-plateforme.md), [עברית](https://shoprocket.io/he/help/import-reviews.md), [हिन्दी](https://shoprocket.io/hi/help/import-reviews.md), [Bahasa Indonesia](https://shoprocket.io/id/bantuan/impor-ulasan.md), [Italiano](https://shoprocket.io/it/aiuto/importare-recensioni.md), [日本語](https://shoprocket.io/ja/help/import-reviews.md), [Lietuvių](https://shoprocket.io/lt/pagalba/importuoti-atsiliepimus.md), [Norsk](https://shoprocket.io/nb/hjelp/importer-anmeldelser.md), [Nederlands](https://shoprocket.io/nl/hulp/reviews-importeren.md), [Polski](https://shoprocket.io/pl/pomoc/import-opinii.md), [Português](https://shoprocket.io/pt/ajuda/importar-avaliacoes.md), [Română](https://shoprocket.io/ro/ajutor/import-recenzii.md), [Русский](https://shoprocket.io/ru/help/import-reviews.md), [ไทย](https://shoprocket.io/th/help/import-reviews.md), [Türkçe](https://shoprocket.io/tr/yardim/yorumlari-ice-aktarma.md), [中文](https://shoprocket.io/zh/help/import-reviews.md)
