TABLE OF CONTENTS
- Overview
- What do I need to get started?
- Step 1) Product catalogue - Download CSV template
- Step 2) Review data for import - Download CSV template
- Do you have images to accompany the reviews?
- Got your files, what’s next?
- How long will they take to show?
Overview
Feefo enables the import of verified reviews, categorising them as Feefo Verified feedback within the Hub. This approach is primarily used when manufacturers collaborate with us to bring in reviews from third-party sources, allowing for seamless syndication across our network.
What do I need to get started?
There are 2 key requirements:
- Products must exist in the Feefo database against your account– this can be done via a Product Catalogue
- The Review Data for import
Both files must be supplied as a CSV and UTF-8 format.
Step 1) Product catalogue - Download CSV template
For product reviews to be imported, the products must exist in the Feefo database. If you already have an account set up, you can check if this is the case by going to Products > Manage Product Catalogue – and checking the entries here.
If these are new products, you must supply the data as per the example template above. Some details about the fields are outlined below:
Field name | Required/ optional | Format | Description |
Search Code | Required | Alpha-numeric | An identifier for the product. |
Title | Required | Alpha-numeric | The name of the product. |
URL | Required |
| The URL to the product page for the product. |
Product Description | Required | Alpha-numeric | The description of the item purchased. |
Merchant Identifier | Required | Alpha-numeric | Your unique Feefo identifier. |
Image Link | Required | Alpha-numeric | The URL to the product's main image. Must be supplied in quote marks: ”"likethis.com/image.jpeg""" |
GTIN | Required | Numeric | 8-14 digit long numeric value |
MPN | Optional | Alpha-numeric | Manufacturer Part Number
|
Brand | Optional | Alpha-numeric | Manufacturer/Brand Name |
Tags | Optional | Alpha-numeric | Categorise products. |
Parent Search Code | Optional | Alpha-numeric | Unique identifier. |
Product Attributes | Optional | Alpha-numeric | Enter attributes to rate. |
For all fields, you must ensure they do not contain special characters or commas.
Step 2) Review data for import - Download CSV template
The file must contain the following mandatory columns in this specific order:
Name: The name of the person leaving the review.
- Email: The email address of the reviewer.
- Sale Date: The date of purchase (in DD/MM/YYYY format).
- Feedback Date: The date the review was submitted (in DD/MM/YYYY format).
- Product ID: GTIN/Ean’s must be provided and relate to the data in your product catalogue for this to syndicate.
- Product Rating: 1 – 5 rating provided by the reviewer to reflect their overall satisfaction with a product.
- Product Comment: The feedback provided by the reviewer that elaborates on their experiences with a product. If there is no comment, please leave blank.
Note: You may leave optional columns blank; however, the header should remain in the file to ensure a smooth import process.
Do you have images to accompany the reviews?
Great news, we have the option to include consumer images and product images during the review import process. To upload images, follow the steps below:
- Image Hosting: The images must be hosted on a server accessible by Feefo without any additional security (such as username/password protection).
- File Format: It is recommended that images be in JPG/JPEG format.
- Image Parameters:
- For consumer service images, use the header consumerserviceimage.
- For product images, use the header consumerproductimage.
- Image Validation: All images must be unique and valid. Invalid or duplicate images will result in a failed upload attempt.
Got your files, what’s next?
Once your CSV files are formatted correctly and images are hosted properly, you can send them over to us to upload the reviews. This process will import the reviews into the Feefo Hub where they will be classified as Feefo Verified feedback.
How long will they take to show?
Syndicated reviews may take up to three days to appear across widgets on merchant sites within our network.
Key checklist:
Files are UTF-8 formatted
No special characters are supplied in any column
Date format is DD/MM/YYYY
GTIN / MPN or brand are supplied
Reviews to import file should be no more than 9000 lines per file – if more than this, send separate files.
Please note that once we review and process the files, they will be imported as they have been provided, and we will not make any amends. Any issues or changes to the files will be charged for as appropriate – so please ensure you have checked all supplied information.
For further assistance or if you have any questions about the import process, feel free to contact our support team.