Skip to main content

How to Import Existing Product & Store Reviews to Roadmap

Want to bring your existing customer reviews into Roadmap? No problem! Here's a step-by-step guide to help you import reviews smoothly and get them showing on your storefront in no time.

Thom Sussex avatar
Written by Thom Sussex
Updated this week

Step 1: Set up your review form

In order for us to export the correct sample csv out of Roadmap, you need to setup your review form. Please see the steps here:

Step 2: Download the Sample CSV Template

Start by downloading the sample CSV file directly from your Roadmap admin:

Go to: Reviews > Import > Download Sample CSV

This template provides all the necessary columns and formats you'll need.
​


Step 3: Fill in Your Review Data

Take the review export from your previous review app and copy the data into the corresponding columns in the Roadmap template.
​

Make sure to follow these formatting rules carefully:


Required Fields

  • product_handle

    • The product’s URL handle.

    • Must be filled in if Product_sku is not.

    • Example: rhoda-boot-black-leather

  • Product_sku

    • The product’s SKU code.

    • Must be filled in if product_handle is not.

    • Example: TRFC116

  • type

    • This determines if the review is a product or a store review

    • review = product review

    • store-review = store review

  • state

    • Indicates the visibility status of the review.

    • published = visible on storefront

    • approved = visible in admin only

  • rating

    • The star or number rating given by the customer.

    • Example: 4

  • email

    • Customer’s email address.

    • Example: customer@example.com

  • verified

    • Indicates if the review is from a verified purchase.

    • True = shows verified badge

    • False = no badge shown

  • created_at

    • Date the review was submitted.

    • Format: YYYY-MM-DD (time optional)

    • Example: 2025-10-16 13:38:14

Optional but Recommended Fields

  • title

  • Title of the review.

  • Example: Love these boots!

  • author

  • Customer’s name.

  • Example: Jane Doe

  • location

  • City or country.

  • Useful when managing multiple store instances.

  • Example: New York

  • body

  • Full text of the review.

  • Example: Great quality, fast shipping!

  • reply

  • Your response to the customer’s review.

  • Example: Thanks for your feedback!

  • source

  • Indicates how the original review was collected.

  • Example: Roadmap

  • order_number

  • Helps Roadmap match the review to the customer.

  • Example: 123456789

  • replied_at

  • Date/time of your reply (same format as created_at).

  • Example: 2025-10-20 10:22:00

Step 4: Import Your Reviews

Once your CSV is ready:

  1. Go to Reviews > Import

  2. Click Choose File and select your completed CSV

  3. Click Import Reviews

🕒 Note: Importing can take up to 10 minutes, depending on the number of reviews. You can import up to 3,000 reviews at once.

Step 5: Review Any Errors

If any errors occur during import, they’ll appear in a pop-up. You can download a file containing these issues, make corrections, and re-import just those reviews.
​
​


​

Step 6: Assign Reviews for Missing Products

If any reviews are linked to products no longer in your Shopify product library, they’ll appear under the Missing Products tab.

To fix this:

  1. Go to Missing Products

  2. Click Manage next to a group of unassigned reviews

  3. Search for the correct product

  4. Click Assign

Repeat for each group of missing product reviews.
​
​https://app.arcade.software/share/wnGOViDootB5NXwtnG7d
​

That’s It!

Once everything is imported and assigned, your reviews will start showing across all Roadmap review widgets on your storefront. 🎉
​
The reviews will:

  • Appear on the correct product/s.

  • Count toward your star ratings and review totals.

  • Be available for moderation (approve, reply, or share across products).
    ​

Need Help?

If you get stuck or run into any issues, feel free to reach out to our support team—we’re happy to help!

Did this answer your question?