This guide will walk you through the process of manually bulk adding reviews to products using the Stamped.io shopify app.
How To Import Your Reviews
Part A – Formatting the CSV
- Download this CSV
- Fill in the details of the reviews in the same format as the sample reviews in row #2 and #3. You can remove this sample review later. You can also refer to the “Data Fields” section below for information regarding these fields.
- Make sure the date is in the following format: YYYY-MM-DD.
- For example, 2020-12-13
- Make sure the product id is correctly entered, e.g., 44122744568127. You can find the ID when editing a product in Shopify. The digits after “products/” is the product ID (make sure it’s not the variant ID, which will be after “variants/”).
Important Notes:
- Make sure there are no duplicate entries
- The default headers in the template shouldn’t be changed or removed
- You can prepare the CSV using any decent editor or spreadsheet software, however, some programs like MS Excel tend to convert the values into scientific notation which might corrupt the intended format. Also, it may change the date format.
Part B – Upload Reviews
- login to the Stamped.io app
- Go to Importer > Import Reviews from the left navigation menu under Settings.
- Select Custom under Select provider source
- Click Select file and select the filled out CSV
- Click Upload
Voila! Your reviews are now imported.
Data Fields
The table here describes the headers of the CSV file (the top row) and types of information that belongs in each column:
| Header Name | Description | Example |
| product_id (Required) | The product’s numeric ID. | 123456 |
| product_handle (Optional) | The product handle. Found at the end of the URL on the product page. | goat-mug-16oz |
| productUrl (Required) | The product URL in your store | https://example.com/ products/mug |
| productImageUrl (Required) | The image URL of the product. You can retrieve your product image URL by right clicking on the product image, and select “Copy Image Address”. | https://ex.com/image.jpg |
| productTitle (Required) | The title of the product | Goat Mug 16oz (473mL) |
| rating (Required) | A score rating of 1 – 5, where 5 represents the most positive product review and 1 the least negative review | 5 |
| title (Optional) | Title of the review | Super awesome product! |
| author (Required) | Name of the reviewer | John Doe |
| email (Optional) | Email address of the reviewer * Will not be shown on display widgets | johndoe@example.com |
| body (Required) | Main content of the review | Super awesome product and I love it! You should get one too! |
| created_at (Required) | The date and time when customer submits the review. Format: YYYY-MM-DD | 2018-12-12 |
| published (Optional) | TRUE: Reviews visible on site. If left blank or other values: Reviews will be imported unpublished in the dashboard. | TRUE |
| reply (Optional) | Response to customer review | Thank you for your kind review! |
| replied_at (Required if “reply” is filled) | The date and time of response to customer review. Format: YYYY-MM-DD HH:MM:SS | 2018-12-13 13:00:00 |
| location (Optional) | Country of the customer | United States |