Import Reviews

Modified on Thu, 18 Jul at 6:35 PM

EpicApp import reviews option can be used to import reviews from any source to our app using our import template.

STEP 01: Download the import template csv file

You can download the csv file from the path:

EpicApp > Reviews Tab > Bulk Actions > Import Reviews > Download sample import template file

To edit the file:

Login to Google Sheet and create a new blank sheet.
Click File > Import > Upload and select the file above.
Keep the default settings and click Import data.

STEP 02: Fill the template with reviews data

Each column along with their meaning is defined below:

Column Name	Optional/Mandatory	Explanation
Product_ID	Mandatory	product_id in text format
Rating	Mandatory	acceptable values is any one of 1,2,3,4 or 5
Review_Title	Optional	title of the review. 1. if blank, default review titles will be used.
Review_Body	Optional with fallback	body of the review 1. if Review_body is blank, Review_Title will be used with rating. Review_Body will be empty 2. If both Review_body and Review_Title is blank, Rating is published with default review titles
Review_Date_dd/mm/yyyy	Optional with fallback	date when review was received (in dd/mm/yyyy format) 1. if date is blank, then date of import is taken
Public_Reply_To_Review	Optional	public reply to the review
Pictures_URLs	Optional	URLs of the images in the review. Supported .png, .jpg, .If there is more than one picture, please separate the URLs by a comma (https://picture1, https://picture2). We accept up to 5 pictures per review. If there are more than 5 URLs, we will only take the first 5.
Publish_Status	Optional with fallback	either Published or Unpublished if left blank, Publish_Status will have default value as Published
Reviewer_Name	Optional with fallback	name of the customer who gave the review If no name will be given, review will be posted under "Anonymous"
Reviewer_Email	Optional with fallback	email address of the customer who gave the review If empty, dummyemail@epicapp.store will be used
Order_Number	Optional	order number on shopify
Order_ID	Optional	order id on shopify
Customer_ID	Optional	customer id on shopify

STEP 03: Upload the file to EpicApp

When you’ve added the reviews, you can download the sheet by choosing File > Download > Comma Separated Value (.csv).

Go to path:
EpicApp > Reviews Tab > Bulk Actions > Import Reviews

Click on “Import Reviews” button.

STEP 04: Review upload errors (if any)

If some data rows have errors, they will be skipped and rest of the reviews will be imported
All errors will be listed. Press the “Copy Errors”
Rectify the errors and import the modified rows again.

Note: If there were any errors, then after modifying the data, import only the rows which had the errors. Do not import the rows again which were successful. It will lead to duplication of reviews.

Can’t find what you are looking for? Check our Knowledge Base for more detailed tutorials or contact our Epic! customer support team to address your specific issues.