Importing Product Reviews from a CSV File
The Vitals Product Reviews app makes it simple to import reviews by uploading them via a CSV file. Follow these steps to successfully import reviews into your store.
Step 1: Download the CSV Template
- Download the empty template: vitals-reviews-template.csv.
Step 2: Fill in the Required Fields
Use the template to add your reviews. Below are the fields explained in detail:
| Field | Description |
|---|---|
| product_handle | The Shopify product handle. Example: If your product URL is https://yourshop.myshopify.com/products/awesome-product , the handle is awesome-product . |
| state | Determines if the review is published or in the moderation queue. Possible values: published or unpublished . |
| rating | The star rating for the review, between 1 and 5 . |
| title | The review title (used for compatibility with other apps but not displayed in Vitals). |
| author | The name of the reviewer. |
| The reviewer's email address. | |
| location | The reviewer's location (used for compatibility with other apps but not displayed in Vitals). |
| body | The content of the review. |
| imageUrl | URL of the review image(s). For multiple images, separate URLs with commas. |
| reply | If the merchant replied to the review, include the reply here. |
| created_at | Date when the review was created. Format: YYYY-MM-DD HH:MM:SS (e.g., 2019-10-01 09:50:00 ). |
| replied_at | Date when the reply was added. Format: YYYY-MM-DD HH:MM:SS . |
Mandatory Fields:
product_handleratingbody
Ensure these fields are never left blank.
Step 3: Upload the CSV File
- Open the Vitals Product Reviews app.
-
Navigate to the Import tab.
- Click the Import button and upload the completed CSV file.
Tips for a Smooth Import
- Use Recommended Editors: For better UTF-8 support and quoting, use tools like LibreOffice or OpenOffice, or Microsoft Excel.
-
When saving the file (in OpenOffice or LibreOffice), enable the "Quote all text cells" option to prevent cutting off review contents.
- Avoid Using MacOS Numbers: This application may corrupt CSV files. Use Excel or LibreOffice instead.
- For product handles with special symbols (e.g., ™️), save the file as UTF-8 CSV.
💡 Important Notes:
- Ensure reviews in the CSV are verified and genuine, as Shopify prohibits displaying fake or manipulated reviews according to their Acceptable Use Policy.
-
If you encounter any issues during upload, contact our support team. We can help review the file for errors and assist with re-uploading it.
Below are the different columns found in the different importer sources in the app. All the other columns can be empty, especially the "optional" ones.
Growave
| Field | Remarks |
|---|---|
| customer_name |
|
| customer_email |
|
| product_id | mandatory |
| product_handle | mandatory only if the product_id is empty |
| body | mandatory |
| rating | mandatory |
| created_at | mandatory |
| published | 1 or 0 only |
| reply |
|
| images |
|
JudgeMe
| Field | Remarks |
|---|---|
| curated | ok = published/anything else = pending |
| rating | Mandatory |
| reviewer_name |
|
| reviewer_email |
|
| body | Mandatory |
| review_date |
|
| product_id | Mandatory |
| product_handle | Mandatory |
| picture_urls | optional, comma-separated |
| reply | optional |
| reply_date | optional, ISO-8601 |
Loox
| Field | Remarks |
|---|---|
| status | Active = published/anything else = pending |
| id |
|
| rating | Mandatory |
| nickname |
|
| review | Mandatory |
| date |
|
| productId | Mandatory |
| handle | Mandatory |
| img | comma-separated |
|
|
|
| reply | optional |
| replied_at | optional, ISO-8601 |
Ryviu
| Field | Remarks |
|---|---|
| status | automatically published |
| rating | Mandatory |
| author |
|
| body_text | Mandatory |
| created_at | ISO-8601 |
| product_handle | Mandatory |
| photo_urls | JSON-encoded |
|
|
Shopify
| Field | Remarks |
|---|---|
| state | approved or published = published/anything else = pending |
| rating | Mandatory |
| author |
|
|
|
|
| body | Mandatory |
| created_at | ISO-8601 |
| product_handle | Mandatory |
| imageUrl | comma-separated |
| reply | optional |
| replied_at | optional, ISO-8601 |
Stamped
| Field | Remarks |
|---|---|
| rating | Mandatory |
| author |
|
| body | Mandatory |
| product | title, Mandatory |
|
|
|
| state | optional; published = published/anything else = pending |
| imageUrl | optional, comma-separated |
| reply | optional |
Yotpo
(note: The fields have spaces, and each field is mandatory to be in the CSV file)
| Field |
|---|
| Review Status |
| Review Score |
| Reviewer Display Name |
| Review Content |
| Reviewer Email |
| Review Creation Date |
| Product ID |
| Product Handle |
| Product Title |
| Published Image Url |
| Comment Content |
| Comment Date |
By following these guidelines, you can seamlessly import product reviews and enhance your store’s credibility! 🎉