How to safely import reviews into Shopify (and undo it when something goes wrong)

If you're migrating from another reviews app — Loox, Judge.me, Yotpo, Stamped, or an export from an older platform — you'll be doing a CSV import. And at some point, you'll do it wrong.

You'll map the wrong column. You'll import to the wrong store. You'll forget to filter out reviews from a discontinued product. You'll discover the review dates are in MM/DD/YYYY format but you imported them as DD/MM/YYYY.

This guide walks through how to do imports safely — and what RightReviews does so that "you'll do it wrong" doesn't mean "you'll spend a Saturday in spreadsheets cleaning up."

Why imports go wrong

The three most common ways a reviews import gets botched:

1. Column mapping errors. Your CSV has columns named product_id, name, email, body, rating — but the import tool expects handle, customer_name, customer_email, content, stars. If even one column is misaligned, you get reviews attached to the wrong products or with the wrong star ratings.
2. Duplicate rows. You imported the same file twice. Now every product has duplicate reviews and your average rating just dropped because the algorithm thinks they're separate reviews.
3. Dirty data from the source. Reviews that mention competitor names, reviews from staff testing the system, reviews left blank, reviews that violated your terms but were imported anyway. Hundreds of these to delete one by one.

A reviews app that doesn't have an undo button leaves you with three options when an import goes wrong:

• Manually delete every review by hand (slow).
• Ask support to roll back via the database (depends on the app).
• Live with it.

None of those is fun.

What RightReviews does differently

Every CSV or Google Sheets import in RightReviews is rollback-able for 48 hours. The import history page shows every import you've run, when, with how many rows, and a one-click "Undo this import" button.

Undoing an import:

• Deletes only the reviews created by that import — never touches pre-existing reviews.
• Removes them from product pages immediately (the storefront widget re-renders within seconds).
• Logs the undo in the same import history so you have a paper trail.

48 hours is intentional. Long enough to catch errors you spot a day later when you actually look at the storefront. Short enough that you're not roll-backing a 6-month-old import that's been the source of truth since.

Step-by-step: a clean import workflow

Whether you're migrating from another app or uploading a fresh batch, the workflow looks the same.

1. Get a CSV in a known format

Most reviews apps let you export to CSV. If you're starting from a Google Sheet, export as CSV. If you're scraping reviews from your own database, generate a CSV with these required columns:

• product_handle — the Shopify product handle (e.g., mandala-bead-loom-kit)
• customer_name — display name on the review
• customer_email — used to match verified-buyer status
• rating — integer 1–5
• body — the review text
• review_date — ISO format YYYY-MM-DD (preferred) or any format we can parse

Optional but useful columns:

• title — review title/headline
• verified — true/false (we'll also re-verify against Shopify orders)
• photos — comma-separated image URLs (we'll re-host on Cloudflare R2)
• country — ISO country code

2. Download the RightReviews template

In the RightReviews admin: Import → Download template. The template has the right column headers, the right date format, and a few example rows showing what good data looks like. Paste your data into it.

3. Use a preset for known sources

If your source is Loox, Judge.me, Yotpo, or Stamped, choose the matching preset on the import page. RightReviews will auto-map their column names to ours so you don't have to rename anything.

4. Run the import on a small test batch first

Take your CSV, copy the first 10 rows into a separate file, and import that first. Check the storefront widget on one of those products. Are the reviews showing up with the right star count? Right author name? Right date?

If yes, run the full import. If no, fix the mapping in your CSV and try again. (This entire test loop takes about three minutes.)

5. Verify on the storefront

After the full import:

• Pick three products at random.
• Open them on your live storefront.
• Confirm star ratings match what you expected.
• Confirm the reviews are showing in the right language, right format, with photos rendering.

6. Wait 24 hours before considering the import "final"

Most import problems surface within the first day. New reviews come in and you notice they look different. Customers notice and email you. Pages render with weirdness you didn't catch in spot-checks.

Within 48 hours, you can still hit Undo. After 48 hours, you're committed.

Migrating from Loox to RightReviews

1. In Loox admin: Settings → Export → Export reviews as CSV.
2. Install RightReviews from the Shopify App Store.
3. Import → Loox preset → Upload CSV.
4. Verify on the storefront, wait 24 hours.
5. Remove Loox's theme blocks from your theme editor.
6. Add RightReviews' theme blocks.
7. Uninstall Loox.

Migrating from Judge.me to RightReviews

1. In Judge.me admin: Settings → Reviews → Export all reviews to CSV.
2. Install RightReviews from the Shopify App Store.
3. Import → Judge.me preset → Upload CSV.
4. Same verification, theme block swap, and uninstall as above.

Migrating from Yotpo, Stamped, or Okendo

The CSV exports from these platforms differ but they all include the core fields. Use the Generic CSV import option and map the columns once — RightReviews remembers your mapping for next time.

What to do if your import goes wrong

1. Go to Import → Import history in the RightReviews admin.
2. Find the bad import (sorted by date — usually it's the most recent).
3. Click Undo this import.
4. Confirm. The reviews are gone within seconds.

If 48 hours have passed and you can't undo, email support@rightreviews.app with the import ID — we can sometimes roll it back manually depending on what's happened to the data since.

Best practices that save Saturdays

• Always test on 10 rows first. Yes, even if you've done this a hundred times.
• Never import directly from a Google Sheet that someone else is editing. Export it, freeze it, then import.
• Keep your source file. If you need to roll back after the 48-hour window, the source CSV is your insurance.
• Don't import on a Friday afternoon. If something breaks, you want a full business day to debug.

Try a safe import

Free up to 50 orders/month, and the import history + 48-hour undo works on every plan including Free. Migrate a small store entirely on Free; upgrade when you outgrow it.

Install RightReviews on Shopify →

---

Loox is a trademark of Loox Productions Ltd. Judge.me is a trademark of Judge.me. Yotpo, Stamped, and Okendo are trademarks of their respective owners. RightReviews is not affiliated with any of these companies.