Importing Reviews from Shopify Product Reviews
Welcome to Growave! Discover how to effortlessly migrate your product reviews from Shopify Reviews to Growave. Learn how to import and configure your reviews within our app to enhance their impact on your business. Whether it's adjusting settings or utilizing advanced features, we're here to support you every step of the way. Let's optimize your reviews for even greater success together!
IN THIS ARTICLE:
Export reviews from Shopify
- From your Shopify admin, click Settings > Apps and sales channels.
- From the Apps and Sales Channels page, click Product Reviews.
- Click Open app.
- Click Settings
- Click Export.
A CSV spreadsheet file downloads in your browser.
Product reviews CSV file
Exported product reviews are formatted into a CSV spreadsheet file. The following table describes the headers of the spreadsheet and the types of information that belong in each column:
| Header name | Product review information |
|---|---|
| product_handle | This is the tail end of your product's URL. For example, if your product is displayed on your online store at https://johns-apparel.com/products/blue-t-shirt, then the product_handle is blue-t-shirt. |
| state | The status of the review, such as approved or published. |
| rating | A score from 0-5, where 5 represents the most positive product review. |
| title | A short, bolded title summarizing the customer's experience. For example, "Awesome!" |
| author | The first and last name connected to the customer account that submitted the review. |
| The customer's email address. | |
| location | The customer's address, such as their city and country. |
| body | A longer description of the customer's experience. They can elaborate on what they liked or did not like about your product. |
| reply | An optional response to the review. |
| created_at | The date and time when the customer created the product review. |
| replied_at | The date and time when the reply was created |
NOTE: If you're using an Online Store 2.0 theme, then the Product Reviews app saves rating data in Product Rating and Product Rating Count standard metafields. This means that your rating data is stored as additional data with your product. Because this data is stored in standard metafields, it might be compatible with other apps. Other apps can also contribute to your product rating data by writing to these metafields.
Import reviews to Growave
After installing the Growave app, seamlessly managing your reviews is a breeze. Easily import your reviews using a preformatted CSV file. Detailed instructions on how to complete this process are provided below.
Step 1. Go to admin panel of Growave -> Choose Import/Export section -> Select import type Reviews
Step 2. Upload a CSV file
Step 3. Select import type
Step 4. Go through the validation process.
As soon as a CSV file is uploaded for import, it will be validated for the following parameters (data matching).
Here are the required and optional parameters for Review import:
| Header name | Review information | Required✅-Optional💠 |
| Customer ID | Personal code of a customer (if you have a customer's email, customer ID is not needed) |
💠 |
| Customer's email | ✅ |
|
| Title | Title of a review | 💠 |
| Body | Content (text) of review | ✅ |
| Product | Product ID, product handle, or product URL (if not set then the review belongs to your site review) |
✅ |
| Rating | Numerical rating from 1-5 | ✅ |
| Name | Name of a person who left a review (if none “Anonymous will be used”) |
💠 |
| Created_at | date when a review was left (format: YYYY-MM-DD default value is Now) |
💠 |
| Images | links to images associated with a review | 💠 |
|
RepliedAt
|
date when reviews were replied to (format:
YYYY-MM-DD default value is Now) |
💠 |
|
Reply
|
body (text content) of a reply | 💠 |
NOTE: links to images associated with a review (maximum: 5 pics per review with 5 links separated by comma, 10 MB for all pics, ex: 'http://image-url/image1.jpg', 'http://image-url/image1.jpg', 'http://image-url/image1.jpg%27')
When exporting a CSV product review file from Shopify for import into Growave, you'll find it contains different parameters than we require. To simplify this process, we recommend removing unnecessary columns with excess data before importing the file into Growave. This approach not only makes the file more compact but also simplifies the import process, making it more efficient and convenient for use in Growave.
NOTE: The file is first checked for errors (validation). The admin then sees the results of this check, indicating which records are good and which are problematic. The admin can then decide to either upload a new file or proceed with the valid records. Once the import is complete, a report is generated about the records that didn't make it through. This report can be downloaded from the admin panel.
Step 5. Finish the import.
Finding Customer ID, Product ID, and Product handle
Product ID
From your Shopify admin, go to Products -> Select the product you want to find the ID for ->
The product_id is the number string at the end of the URL.
Product Handle
Go to a live product page on your Shopify store -> The product_handle is everything that comes after "product/" in the product URL.
Customer ID
From your Shopify admin, go to Customers -> Select the customer you want to find the ID for ->
The customer ID is the number string at the end of the URL
If you encounter any questions or difficulties with importing the file into Growave, we're always here to help. Just contact us at support@growave.io or use the chat icon in the bottom-right corner, and we'll assist you promptly.