Here at HelpfulCrowd, we try to make the migration and importing of reviews simple and painless,
If you need to use the customer import csv template, there are some important tips and tricks that we'd like to share with you to make it as easy and painless as possible.
Imported review files are either imported incorrectly, rejected entirely or specific lines due to the following common reasons:
- Incorrect product IDs
- Customer names linked to email addresses
- Date formats
- Indirect or incorrect Photo/video URL link
- Using Excel to edit and generate CSV files
We'll cover off each of these in the following sections, so that you have a pain free and quick import process.
So let's get started....
Incorrect Product IDs
The Product ID is a unique reference that cannot usually be changed after the product has been created.
For clarification, the Product ID is not the SKU, EAN or any other additional product descriptor.
Product IDs can be found either in the HelpfulCrowd App or on your eCommerce platform.
The Product ID is highlighted in the purple rectangle below. DONOT include the # that preceds the number
ECWID Product ID
When logged into Ecwid and on the product page in the catalog, the Product ID can be located in the URL.
Shopify Product ID
When logged into Shopify and on the product page in the catalog, the Product ID (Product Handle) can be located in the URL.
Note: If there is NO a product ID is incorrect or missing, then the review will automatically be imported as a Business Review i.e. because it has no readily identifiable Product ID attached to the review. It is possible to identify a Business review in the importing preview stage, as the review will not have a product name attached to the reviews. These reviews should be discarded and product ID's checked once again in the review file.
Customer names and email addresses
It is usual that an email address only has a single name associated with it. This is how HelpfulCrowd treats email addresses and names.
In HelpfulCrowd, the first name associated with an email address is the only name that will be associated with that email address, and displayed on review widgets for reviews. This is irrespective of any subsequent customer names associated with the same email address in upload files.
By default, HelpfulCrowd requires an email address attached to each review imported. The challenge arises when an email address is not available from the export platform, like Etsy which doesn't export the customers email addresses with reviews.
In these scenarios, to correctly display the reviewers name in widgets, a unique 'dummy' email account needs to be created and added to each review item in the import file.
The easiest way to do this is with a gmail account. Gmail allows you to create alias email accounts on the fly. As an example, let's say you had a gmail account called firstname.lastname@example.org. To create alias email accoutns, you simple add +[sometext] after the user name e.g. email@example.com, firstname.lastname@example.org etc.
When the review file is imported, each alias gmail account will have the unique reviewers name associated with it, which will then be displayed on the review widgets.
Dates MUST be in the format one of following formats:
- 2011-05-19 10:30:14 EST
Here is a short video showing how to correctly format the dates using Google Sheets and the yy-mm-dd format:
NB: Incorrect date formats or a blank date filed will result in the line item being rejected and requiring re-processing.
Indirect or incorrect Photo/video URL link
A photo or video link needs to be either start with http:// or https://, be a direct URL link to the asset (not indirect or webpage) and be publicly accessible.
The following is a list of some platforms where photos and videos MAY NOT have a direct URL link:
To avoid issues, we recommend first downloading your media (if not provided as a link in a review export file from a competitor) and then uploading the media to a temporary cloud storage solution that provides a direct link to the uploaded media.
One site that many of our customers use for this purpose is: https://uguu.se/
Note: If the media link is detailed in an export file from another review service, then the file will usually be readable and importable.
Using Excel to edit and generate CSV Files
We strongly recommend NOT to use Excel for editing and exporting the CSV file, as many customers have reported issues when importing with Excel generated CSV files.
We also recommend reading: