> For the complete documentation index, see [llms.txt](https://docs.roadmap.so/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roadmap.so/reviews/migration-to-roadmap/import-reviews-to-roadmap-with-csv-template.md).
# Import reviews to Roadmap with CSV template
Before you start
Roadmap imports reviews from a CSV file. To make sure the CSV template matches your setup, start by confirming your review form is configured.
Set up your review form
In your Roadmap admin, go to **Reviews** → **Review Form** and complete your form setup (fields, required inputs, etc.).
Roadmap generates its *sample CSV* based on your current review setup. If you change your form later, download a fresh sample CSV before importing again.
{% stepper %}
{% step %}
#### Step 1: Download the sample CSV template
Download Roadmap’s template
1. In your Roadmap admin, go to **Reviews** → **Import**.
2. Select **Download Sample CSV**.
This file includes the exact columns and formatting Roadmap expects.
{% endstep %}
{% step %}
#### Step 2: Fill in your review data
Export reviews from your previous review app, then copy/paste (or map) values into the Roadmap template columns.
#### Formatting rules (important)
**Do not rename columns** in the sample CSV. Keep the header row exactly as downloaded.
#### Required fields
* `product_handle` — The product’s URL handle. Required if `Product_sku` is not provided. **Example:**`rhoda-boot-black-leather`
* `Product_sku` — The product’s SKU code. Required if `product_handle` is not provided. **Example:**`TRFC116`
* `type` — Determines whether this is a product or store review:
`review` = product review
`store-review` = store review
* `state` — Visibility status:
`published` = visible on the storefront
`approved` = visible in admin only
* `rating` — Star/number rating. **Example:**`4`
* `email` — Customer email. **Example:**`customer@example.com`
* `verified` — Whether the review is from a verified purchase:
`True` = shows verified badge
`False` = no badge
* `created_at` — When the review was submitted. **Format:**`YYYY-MM-DD` (time optional) **Example:**`2025-10-16 13:38:14`
#### Optional (recommended) fields
* `title` — Review title. **Example:**`Love these boots!`
* `author` — Customer name. **Example:**`Jane Doe`
* `location` — City/country. **Example:**`New York`
* `body` — Full review text. **Example:**`Great quality, fast shipping!`
* `reply` — Your response to the review. **Example:**`Thanks for your feedback!`
* `source` — Where the review came from. **Example:**`Roadmap`
* `order_number` — Helps match reviews to customers. **Example:**`123456789`
* `replied_at` — Reply timestamp (same format as `created_at`). **Example:**`2025-10-20 10:22:00`
If you’re importing a mix of product reviews and store reviews, double-check the `type` column before uploading. Incorrect values can cause reviews to be categorized incorrectly.
{% endstep %}
{% step %}
#### Step 3: Import your reviews
Upload the completed CSV
1. Go to **Reviews** → **Import**.
2. Select **Choose File** and pick your completed CSV.
3. Click **Import Reviews**.
Importing can take up to **10 minutes** depending on file size. You can import up to **3,000 reviews** per import.
{% endstep %}
{% step %}
#### Step 4: Fix any import errors
If Roadmap finds issues during import, they’ll show in a pop-up.
* Download the error file from the pop-up.
* Correct the rows with problems.
* Re-import only the fixed rows (using the same **Reviews** → **Import** flow).
{% endstep %}
{% step %}
#### Step 5: Assign reviews under Missing Products
If some reviews reference products that no longer exist in your Shopify product library (or can’t be matched by `product_handle`/`Product_sku`), they’ll appear in **Missing Products**.
Assign reviews to the correct products
1. Go to **Reviews** → **Missing Products**.
2. Next to an unassigned group, click **Manage**.
3. Click **Browse & Attach Products**.
4. In the picker, click **Browse**, then select the correct product(s).
5. Click **Apply Selection**.
6. Click **Update Products** to save.
7. When you’re done, click **Close**.
**Walkthrough:** You can follow this interactive guide for the **Missing Products** assignment flow.
  
{% endstep %}
{% endstepper %}
### What happens after import?
Once your reviews are imported and any missing products are assigned, reviews will start showing across your Roadmap review widgets on your storefront.
* Reviews appear on the correct product(s) (based on matching and assignments).
* They count toward your star ratings and total review counts.
* They’re available in Roadmap for moderation (approve, reply, and manage visibility).
### Troubleshooting (common issues)
My reviews imported but don’t show on the storefront
* Check the `state` column. Only `published` reviews display on the storefront.
* If reviews are in **Missing Products**, assign them to products so widgets can display them correctly.
Some rows fail to import
* Download the error file from the import pop-up and fix only the rows listed.
* Confirm dates use `YYYY-MM-DD` (time optional), and that required fields are filled.
* Make sure you didn’t rename the CSV headers from the Roadmap template.
Should I use product\_handle or Product\_sku?
Use whichever is more reliable for your catalog. Roadmap requires at least one of them for product reviews. If you provide both, keep them consistent with your Shopify data.
### Need help?
If you get stuck at any point (template mapping, errors, or Missing Products), contact your support team and share:
* your CSV file (or a small sample),
* the error file (if you downloaded one), and
* an example product that should have reviews but doesn’t.
Does Roadmap intergrate with headless Shopify stores?
No.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.roadmap.so/reviews/migration-to-roadmap/import-reviews-to-roadmap-with-csv-template.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.