13 min read
TL;DR
- 93% of consumers say online reviews influence their purchase decisions, making review imports critical during platform migrations or store launches.
- CSV import is the most accessible DIY method, supported by Judge.me (free), Loox ($9.99+/month), Yotpo ($119+/month for migration), and Stamped.io ($23+/month).
- Exact field mapping (
product_handle,rating,author,body,created_at) is required; mismatches cause silent failures. - Imported reviews can generate Google rich snippets only when the app outputs valid Product schema – verify with Google Rich Results Test post-import.
- Amazon review imports carry legal risk under Amazon's Terms of Service and the FTC's 2023 fake review rule (effective Oct 2024).
Why Importing Reviews to Shopify Matters
93% of consumers say online reviews influence their purchase decisions, yet many store owners lose this social proof when migrating platforms or launching new storefronts. The stakes are concrete: products with five reviews see 270% higher purchase likelihood than those with none.
Review imports matter in three critical scenarios. First, if you're migrating from WooCommerce, BigCommerce, or Etsy to Shopify, your existing reviews represent months or years of customer trust – losing them means starting conversion optimization from zero. Second, if you're consolidating reviews from multiple sales channels (Amazon, Google, Trustpilot), importing them to Shopify creates a unified social proof layer. Third, if you're launching a new Shopify store and have reviews from a previous platform, importing them accelerates initial credibility.
Shopify's native Product Reviews app was deprecated, meaning all review imports now flow through top-rated Shopify review apps. This guide covers four import methods: CSV files (the most common DIY approach), app-based imports from competing platforms, cross-platform migrations (Amazon, Google, WooCommerce), and API-driven imports for developers.
Key Takeaway: Review imports directly impact conversion rates. A 500-product store with an average of 10 reviews per product represents 5,000 data points of social proof – losing them during migration can reduce conversions by 15-30%.
What Import Methods Are Available for Shopify Reviews?
Before diving into implementation, understand your options. Each method has different costs, time requirements, and technical barriers.
| Method | Best For | Cost | Time to Import | Technical Skill |
|---|---|---|---|---|
| CSV Upload | DIY bulk imports, <5K reviews | Free–$15/month | 15–30 min | Low |
| App-to-App Migration | Switching review platforms | $0–$119+/month | 5–10 min | None |
| Manual Entry | <50 reviews, high-value testimonials | Free | 2–4 hours | None |
| API Integration | 10K+ reviews, real-time sync | $0–$500/month | 1–2 hours setup | High |
| Platform Export + CSV | WooCommerce, Etsy, Trustpilot | Free | 30–60 min | Medium |
CSV upload is the dominant method because it's free, works across all major review apps, and requires no coding. App-to-app migration is fastest if you're switching from Judge.me to Yotpo (or vice versa), but only works between compatible platforms. Manual entry is impractical for stores with more than 100 reviews but useful for cherry-picking high-impact testimonials.
The method you choose depends on your app selection. Judge.me's free plan supports unlimited CSV imports, while Yotpo's migration tools require the Growth plan at $119/month. This $1,428 annual difference matters for small merchants.
Key Takeaway: CSV import is free and universal; app-to-app migration is fastest but platform-dependent. Choose CSV if you're cost-conscious or migrating from a non-standard platform.
How to Import Reviews via CSV File
CSV import is the most reliable DIY method. It works by uploading a spreadsheet where each row is one review, and columns map to review fields (rating, author, body, etc.). The process takes 15–30 minutes for most stores.
Step-by-Step CSV Import Process
1. Prepare Your CSV File
Create a spreadsheet with these required columns:
| Field Name | Required? | Format | Example |
|---|---|---|---|
product_handle |
Yes | Shopify product slug (lowercase, hyphens) | blue-ceramic-mug |
rating |
Yes | Integer 1–5 | 5 |
author |
Yes | Customer name | Sarah T. |
body |
Yes | Review text | Love this mug! Perfect size. |
created_at |
No | ISO 8601 date (YYYY-MM-DD) | 2024-11-15 |
email |
No | Reviewer email | sarah@example.com |
reply |
No | Merchant response | Thanks for the review! |
picture_urls |
No | Comma-separated image URLs | https://example.com/photo1.jpg |
Example CSV row:
product_handle,rating,author,body,created_at
blue-ceramic-mug,5,Sarah T.,"Love this mug! Perfect size.",2024-11-15
blue-ceramic-mug,4,Mike J.,"Good quality but shipping took 3 weeks.",2024-11-10
Critical: The product_handle must exactly match your Shopify product handle. If your product is titled "Blue Ceramic Mug" but the handle is ceramic-mug-blue, the import will fail silently – reviews won't appear, and you won't see an error message.
2. Export Your Shopify Product List
To avoid handle mismatches, export your product list first:
- Go to Products in Shopify admin
- Click Export (top right)
- Download as CSV
- Extract the
Handlecolumn and cross-reference it with your review data
3. Save the File with UTF-8 Encoding
This is critical. If you save in Excel's default format (.xlsx) or Latin-1 encoding, special characters (é, ñ, ü) will display as garbled text.
- Google Sheets: File → Download → CSV (.csv)
- Excel: Save As → CSV UTF-8 (.csv) → Confirm encoding dialog
- Text Editor: Save with UTF-8 encoding explicitly
4. Upload via Your Review App
Using Judge.me as an example:
- Log into Judge.me dashboard
- Go to Manage Reviews → Import
- Select CSV Upload
- Choose your file
- Map columns (usually auto-detected)
- Click Import
The app will validate the file and show a preview. Review counts and any errors before confirming.
5. Verify the Import
After upload, check your Shopify store:
- Visit a product page
- Confirm reviews appear with correct ratings, text, and dates
- Test that review counts show in product listings
- Use Google Rich Results Test to verify schema output (see SEO section below)
CSV Field Mapping Reference
Judge.me's CSV import documentation specifies these exact field names. Other apps (Loox, Yotpo, Stamped.io) use similar but sometimes different column names – always check your app's documentation.
| Field | Required | Accepted Format | Notes |
|---|---|---|---|
product_handle |
Yes | Lowercase slug with hyphens | Must match Shopify exactly; no spaces or special chars |
rating |
Yes | 1, 2, 3, 4, or 5 | Decimal ratings (4.5) not supported by all apps |
author |
Yes | Text (max 100 chars) | Can be first name only; "Anonymous" accepted |
body |
Yes | Text (max 5000 chars) | HTML tags stripped; plain text only |
created_at |
No | YYYY-MM-DD or YYYY-MM-DD HH:MM:SS | ISO 8601 format required; no other date formats accepted |
email |
No | Valid email format | Used for review verification; optional |
reply |
No | Text (max 1000 chars) | Merchant response to review |
picture_urls |
No | Comma-separated URLs | Images must be publicly accessible; HTTPS required |
Fixing Common CSV Import Errors
Error: "Product not found"
- Cause:
product_handledoesn't match any product in your Shopify store - Fix: Export your Shopify product list (Products → Export), find the exact handle, and update your CSV. Example: if your product is "Blue Mug" but the handle is
mug-blue, usemug-bluein the CSV.
Error: "Invalid date format"
- Cause: Date is in MM/DD/YYYY or other non-ISO format
- Fix: Convert all dates to YYYY-MM-DD. In Excel:
=TEXT(A1,"YYYY-MM-DD"). In Google Sheets: use theTEXT()function or manually reformat.
Error: "Encoding error" or garbled characters
- Cause: File saved in .xlsx, Latin-1, or other non-UTF-8 encoding
- Fix: Re-save as CSV with UTF-8 encoding. In Excel: File → Save As → CSV UTF-8 (.csv). In Google Sheets: File → Download → CSV.
Error: "Rating out of range"
- Cause: Rating is 0, 6, or a decimal (4.5)
- Fix: Ensure all ratings are integers 1–5. Remove or round decimals.
Silent failure (reviews don't appear, no error message)
- Cause: Usually a handle mismatch or encoding issue
- Fix: Re-check handles against your Shopify product list. Re-save the CSV with UTF-8 encoding. Try uploading a test file with 1–2 reviews first.
Key Takeaway: CSV import fails silently on handle mismatches. Always export your Shopify product list first and cross-reference handles before uploading. UTF-8 encoding is non-negotiable for special characters.
How to Import Reviews from Amazon, Google, and Other Platforms
Cross-platform review migration is common when consolidating sales channels or switching storefronts. Each platform has different export capabilities and legal constraints.
Amazon Reviews: Export and Legal Considerations
Amazon reviews cannot be directly imported due to Amazon's Conditions of Use, which prohibit extracting or distributing review data without permission. However, if you're an Amazon seller and want to migrate reviews you collected independently (e.g., reviews from your own email campaigns), you can export them manually.
Process:
- Go to Amazon Seller Central → Reports → Customer Reviews
- Select date range and product
- Copy reviews manually or use a third-party tool (with caution – verify ToS compliance)
- Reformat as CSV with the fields above
- Upload to Shopify via your review app
Legal note: The FTC's 2023 rule on fake reviews and testimonials (effective Oct 21, 2024) prohibits importing reviews of unclear provenance. Only import reviews you can verify came from genuine customers who purchased from you. Importing reviews scraped from Amazon without permission violates both Amazon ToS and FTC regulations.
Google Reviews: Display vs. Import
Google reviews cannot be imported to Shopify in the traditional sense. Google My Business reviews are tied to your Google Business Profile and cannot be exported as a dataset.
What you can do instead:
- Embed Google reviews via widget apps (Judge.me, Loox, and others offer Google review widgets)
- Display ratings from Google in your product schema for SEO benefit
- Manually copy high-impact reviews from Google and re-submit them to Shopify (with customer permission)
If you want Google reviews visible on your Shopify store, use a review widget app rather than attempting import.
WooCommerce Reviews: Export and Reformat
WooCommerce stores reviews in the wp_comments database table. You can export them as CSV and import to Shopify.
Export process:
- Install the WooCommerce Product Reviews Export plugin or use a database tool
- Export reviews as CSV
- Map WooCommerce columns to Shopify format:
comment_content→bodycomment_author→authorcomment_date→created_at- Custom meta field
rating→rating
- Add
product_handleby matching WooCommerce product IDs to Shopify handles - Upload to Shopify via CSV
Etsy Reviews: Manual Export Required
Etsy does not provide a bulk review export tool. You have two options:
- Manual copy: Visit each product page, copy reviews, and paste into a spreadsheet (time-intensive for 100+ reviews)
- Etsy API: Use the Etsy API v3 to programmatically fetch reviews if you're comfortable with code
Trustpilot, Capterra, and G2 Reviews
These platforms also restrict bulk export. You can:
- Manually copy reviews (limited by platform UI)
- Contact the platform's support team to request a data export (may require business justification)
- Use third-party data extraction tools (verify ToS compliance)
Platform compatibility matrix:
| Source Platform | Judge.me | Loox | Yotpo | Stamped.io |
|---|---|---|---|---|
| CSV (generic) | ✅ | ✅ | ✅ | ✅ |
| Judge.me | ✅ | ✅ | ✅ | ✅ |
| Yotpo | ✅ | ✅ | ✅ | ✅ |
| Loox | ✅ | ✅ | ✅ | ✅ |
| Stamped.io | ✅ | ✅ | ✅ | ✅ |
| WooCommerce | ✅ (via CSV) | ✅ (via CSV) | ✅ (via CSV) | ✅ (via CSV) |
| Etsy | ❌ (manual) | ❌ (manual) | ❌ (manual) | ❌ (manual) |
| Amazon | ❌ (ToS risk) | ❌ (ToS risk) | ❌ (ToS risk) | ❌ (ToS risk) |
| ❌ (embed only) | ❌ (embed only) | ❌ (embed only) | ❌ (embed only) |
Key Takeaway: CSV is universal; app-to-app migration works between Judge.me, Loox, Yotpo, and Stamped.io. Amazon and Etsy require manual export or API access. Google reviews cannot be imported – use widgets instead.
Which Shopify Apps Support Review Imports?
Your app choice determines which import methods are available and what you'll pay. Here's a detailed comparison of the four leading review apps.
Judge.me
Judge.me's free Forever Free plan supports unlimited CSV imports, making it the most accessible option for small merchants. The app also supports imports from Yotpo, Stamped, and Okendo.
Pricing: Free (Forever Free), $0–$15/month for paid tiers CSV import: ✅ Unlimited on all plans Photo reviews: ✅ Supported Data export: ✅ Full CSV export available Best for: Budget-conscious stores, DIY imports
Loox
Loox starts at $9.99/month and supports photo review imports on all paid plans. Photo reviews are a key differentiator – they drive higher engagement than text-only reviews.
Pricing: $9.99–$99/month CSV import: ✅ Supported on paid plans Photo reviews: ✅ Import via URL in CSV Data export: ✅ Available Best for: Stores prioritizing visual social proof, fashion/beauty merchants
Yotpo
Yotpo's advanced migration tools require the Growth plan at $119/month or higher. The free plan has limited import functionality. Yotpo excels at enterprise-level migrations with dedicated support.
Pricing: Free–$119+/month CSV import: ⚠️ Limited on free plan; full support on Growth+ Photo reviews: ✅ Supported Data export: ⚠️ Varies by tier; some plans restrict export Best for: Enterprise stores, complex migrations, white-glove onboarding
Stamped.io
Stamped.io supports multi-platform imports (CSV, AliReviews, Judge.me, Yotpo) starting at $23/month. It's a strong middle-ground option for stores migrating from multiple sources.
Pricing: $23–$99+/month CSV import: ✅ Supported on all plans Photo reviews: ✅ Supported Data export: ✅ Available Best for: Multi-platform consolidation, mid-market stores
Cost Comparison Example
For a 500-product store with 5,000 existing reviews:
- Judge.me: $0/month (free plan) = $0/year
- Loox: $9.99/month = $119.88/year
- Stamped.io: $23/month = $276/year
- Yotpo Growth: $119/month = $1,428/year
If you're importing once and don't need advanced features, Judge.me's free plan saves $1,428 annually compared to Yotpo. However, Yotpo's migration team handles complex imports, which may justify the cost for enterprise stores.
Recommendation by Store Size
- Stores <100 reviews: Judge.me free plan (unlimited imports, no cost)
- Stores 100–1,000 reviews: Loox ($9.99/month) if you want photo reviews; Judge.me if text-only
- Stores 1,000–5,000 reviews: Stamped.io ($23/month) for multi-platform support
- Stores 5,000+ reviews or complex migrations: Yotpo Growth ($119/month) for white-glove onboarding
Key Takeaway: Judge.me free plan is unbeatable for cost; Yotpo's $119/month Growth plan is justified only for enterprise migrations with dedicated support. For most merchants, Loox ($9.99/month) or Stamped.io ($23/month) offer the best value.
Does Importing Reviews Affect Your Shopify SEO?
Yes – imported reviews can contribute to Google rich snippets, but only if the review app outputs valid structured data.
Google supports Product rich results with aggregateRating schema, which displays star ratings and review counts in search results. When you import reviews into a Shopify app, the app automatically generates JSON-LD schema markup that includes:
{
"@context": "https://schema.org/",
"@type": "Product",
"name": "Blue Ceramic Mug",
"aggregateRating": {
"@type": "AggregateRating",
"ratingValue": "4.7",
"reviewCount": "42"
}
}
This schema is rendered on your product pages, and Google indexes it. The result: your product appears in search results with a star rating and review count, which increases click-through rates.
Important caveat: Google evaluates review quality signals, including date authenticity. If you import reviews with backdated created_at values to artificially inflate recency, Google's systems may flag this and reduce your eligibility for rich snippets. Always use the original review date, not the import date.
Verification step: After importing reviews, use Google Rich Results Test to confirm your product schema is valid and includes aggregateRating. Paste your product URL, and the tool will show whether Google recognizes your reviews.
Key Takeaway: Imported reviews generate rich snippets only when the app outputs valid Product schema. Verify with Google Rich Results Test post-import. Use original review dates, not import dates, to avoid quality signal penalties.
Frequently Asked Questions
Can I import reviews to Shopify for free?
Direct Answer: Yes. Judge.me's free Forever Free plan supports unlimited CSV imports, and CSV upload itself is free on all review apps.
You only pay if you choose a paid app tier for additional features (photo reviews, advanced analytics, email campaigns). For basic CSV import, Judge.me free is the lowest-cost option.
How long does it take to import reviews to Shopify?
Direct Answer: 15–30 minutes for CSV upload; 5–10 minutes for app-to-app migration.
CSV import time depends on file size and validation. A 1,000-review CSV typically uploads in 5–10 minutes. If you're migrating from another review app (Judge.me to Yotpo, for example), the process is faster – usually one click and 5 minutes.
Will imported reviews show up in Google Shopping rich snippets?
Direct Answer: Yes, if the review app outputs valid Product schema with aggregateRating.
Google's Product rich results require valid structured data. Most major review apps (Judge.me, Loox, Yotpo, Stamped.io) automatically generate this schema. Verify by running your product URL through Google Rich Results Test after import.
What is the difference between importing reviews and embedding reviews?
Direct Answer: Importing stores reviews in your Shopify store's database; embedding displays reviews from an external source (like Google) via a widget.
Imported reviews are owned by you and appear natively on your product pages. Embedded reviews (e.g., Google reviews via a widget) pull data from the external platform in real-time. Import if you want full control; embed if you want to display reviews from platforms that don't allow export (Google, Trustpilot).
Can I import reviews from Amazon to Shopify?
Direct Answer: Technically yes, but Amazon's Conditions of Use prohibit extracting review data without permission, and the FTC's 2023 fake review rule prohibits importing reviews of unclear provenance.
You can manually export reviews you collected independently and re-submit them to Shopify. Do not use scraping tools or third-party services that claim to extract Amazon reviews – this violates both Amazon ToS and FTC regulations.
What happens to imported reviews if I switch review apps?
Direct Answer: It depends on the app. Judge.me allows full CSV export at any time, so you can migrate reviews out. Some Yotpo tiers restrict export, creating vendor lock-in.
Before committing to an app, confirm it allows data export. Always maintain a master CSV backup of all your reviews before importing into any platform.
Is there a limit to how many reviews I can import to Shopify?
Direct Answer: No hard limit, but practical limits depend on your app and file size.
Judge.me supports unlimited imports on all plans. Most apps handle 10,000+ reviews without issue. If you're importing 50,000+ reviews, contact your app's support team to discuss bulk import options or API access.
Conclusion
Importing reviews to Shopify is a straightforward process when you understand the method (CSV is most common), the field mapping (product_handle must match exactly), and the app landscape. The stakes are high – 93% of consumers say reviews influence purchase decisions, so losing reviews during a platform migration directly impacts revenue.
Start with CSV import if you're cost-conscious or migrating from a non-standard platform. Use app-to-app migration if you're switching between Judge.me, Loox, Yotpo, or Stamped.io. Always verify handles against your Shopify product list, save files as UTF-8, and test with a small batch before uploading thousands of reviews.
After import, run your product URLs through Google Rich Results Test to confirm schema validity. This ensures your reviews contribute to search visibility and conversion optimization.
For merchants seeking a dedicated review management solution, Cited Review Store provides a centralized platform for importing, organizing, and displaying reviews across your Shopify store. Whether you're consolidating reviews from multiple platforms or managing imports at scale, Cited Review Store simplifies the process and ensures compliance with FTC guidelines on review authenticity.
The investment in proper review import – whether through free tools or dedicated platforms – pays dividends in conversion rate optimization and customer trust.
More from Cited Review Store: SEO Benefits of Product Reviews for Ecommerce (2026) · Migrate Reviews to Shopify From Other Platforms (2026)
More from Cited Review Store: Cited Review Store