Importing Reviews From a Spreadsheet
IN THIS ARTICLE
Importing with Google Sheets
To import reviews using the free spreadsheet app Google Sheets:
- Open the link here
- Copy the file:
- Fill in the review data according to the instructions in the spreadsheet below.
- Download the spreadsheet as a CSV file.
Click "File" > "Download" > "Comma-separated values (.csv, current sheet)"
- Upload the file in the Import tab, on your Loox admin:
Review Data Formatting:
| Column Title | Description | Example |
| product_handle (Required) | The handle is the last part of the product URL (after the last "/"). For example, for this product: store.com/products/blue-t-shirt the handle is blue-t-shirt. Please make sure not to enter the product title or the full product URL. |
blue-t-shirt |
| rating (Required) | Valid values are 1/2/3/4/5. Please use whole numbers only. |
5 |
| author (Required) | Reviewer name. The name will appear on the review exactly as inserted here. |
John D. |
| Reviewer's email address. You can leave this column empty if you don’t have the customer’s email address. |
[email protected] | |
| body (Required) | Review text. All Loox reviews have to include a review body. |
Great shirt, I loved it! |
| created_at (Required) | Review submission\creation date. Must be in the following format: YYYY-MM-DD HH:mm:ss UTC. Must at least include a date. The date must appear as Year-Month-Day, other formats will not be accepted. |
2020-01-09 08:45:00 UTC |
| photo_url | A public URL for the review photo. | cdn.shopify.com/photo.png |
| verified_purchase | Marking "TRUE" will add a "Verified purchase" badge to the review. Leaving the cell empty will not add the badge. |
TRUE |
If you don’t have a photo URL, you can create one by following these instructions:
- Save the relevant images to your computer.
- Go to your Shopify settings - Files.
- Click "Upload files".
- Choose one of the images and upload it.
- Copy its photo URL from the "URL" column once it has been uploaded.
Importing with Microsoft Excel:
To import reviews using Microsoft Excel:
- Download the Loox Import File Template.
- Fill in the review data according to the instructions in the spreadsheet above:
- Save the file in a CSV UTF-8 supported file format (To save in UTF-8 click here):
- Upload the file in the Import tab, on your Loox admin:
A CSV file that includes all the reviews that weren't uploaded will be attached.
Importing Reviews for Inactive Products on your Store
In order to import a review to your account, that review must be linked to an active product on your store.
With that being said, if you have reviews that you cannot attribute to a specific product (the product no longer exists, store reviews, etc.), you can still display these reviews on pages where all reviews from all products appear(i.e 'Happy Customers' page, homepage widget etc...).
You can do this by importing them to a new unavailable product.
To import reviews of products that don't exist on your store:
- Create a new product in your store (we suggest calling it "Reviews"):
- Mark the product as unavailable by removing it from all sales channels:
- Add your review data to a Loox import spreadsheet.
- In the "product_handle" column, please use the new, unavailable product's handle which can be found within the "SEO" section of the product:
- Continue following the import instructions as usual and import your file.
- Your reviews will now appear on all widgets that are set to display all reviews from all products.
If you have any questions regarding this workaround, or if you need help importing your reviews, please contact our Support team and we'll gladly advise!