The Ratings and Reviews solution incorporates your best reviews into email campaigns, including Shopping Cart Abandonment and product-specific campaigns.

Listrak offers built-in integrations with select Marketplace Review Providers or allows you to utilize the custom integration for additional flexibility. The custom integration allows you to create a csv file to utilize reviews from a provider not specified below or your own custom integration. Click below to learn more about the steps to set up the integration based on your provider.

Integrating Marketplace Reviews Providers

Magento 1

Navigate to Magento.
Enable the Module Review API setting.
Contact your Listrak Project team so that Listrak can verify the product ratings and reviews data is being imported correctly via the API. Listrak will also confirm the correct URLs for the reviews are being provided in the Product Feed.

PowerReviews

Provide Listrak with PowerReviews FTP URL and Credentials.
Contact your Listrak Project team so that Listrak can verify the product ratings and reviews data is being imported correctly via the .xml file feed. Listrak will also confirm the correct review URLs for the reviews are being provided in the Product Feed.

BazaarVoice

Provide Listrak with Bazaarvoice FTP URL and Credentials.
Contact your Listrak Project team so that Listrak can verify the product ratings and reviews data is being imported correctly via the .xml file feed. Listrak will also confirm the correct review URLs for the reviews are being provided in the Product Feed.

Yotpo

Provide Listrak with API Key and API Secret from Yotpo interface.
Contact your Listrak Project team so that Listrak can verify the product ratings and reviews data is being imported correctly via the API. Listrak will also confirm the correct URLs for the reviews are being provided in the Product Feed.

Click here to learn more about Listrak's integration with Yotpo.

Integrating Custom Reviews

📌 Listrak's Custom Integration can be used for providers not listed in the built-in provider section above, including Magento 2 and TurnTo reviews. The custom integration would also be used for in-house built review programs.

CSV File Import

⚠️ Before continuing, please be sure to have your FTP integration created. Learn more the FTP setup in the Listrak Platform. You will need your username, password, and URL to complete the integration setup. You will then access the FTP server at ftp.listrak.com. Please contact your Project Manager with any questions.

File Import Specifications

A .csv formatted is required.
All column headers listed must be present in the file. The columns marked as required must contain data, others may be empty.
Accepted encoding: UTF-7, ASCII, UTF-8, Unicode.
Use text qualifiers when necessary.

File Details

The table below explains the data fields contained within the import files.

Header Name: the name of the header column when the file is imported.
Data Type: the accepted data types for the specific fields. Make sure to adhere to these data types. For example, the CreatedDate column must be a data type of Datetime. This means letters will not be accepted by the system for this field.
Requirement: indicates which fields are required, which fields are suggested, and which fields are completely optional to you.
Length: indicates a maximum character limit for the specified field. Boolean, Datetime, and Integer data types will be limited by their usage.
Description: a short description of each specification to provide context to what type of information should be expected within each field. It will also give some information pertinent to that specific column.

Header Name	Data Type	Required?	Length	Description
ProductID	Alphanumeric	Yes	100	The SKU or ProductID of the product being reviewed
ReviewID	Alphanumeric	Yes	100	ID for each individual reviews
Approved	Boolean	Yes		Flag to indicate if a review is approved
CreatedDate	Datetime	Yes		Date the review was submitted in ISO 8601 format
ModifiedDate	Datetime	Suggested		Date the review was updated in ISO 8601 format
HelpfulVotes	Integer	No		Number of times a review has been marked helpful
NonHelpfulVotes	Integer	No		Number of times a review has been marked not helpful
Headline	Alphanumeric	Yes	500	Title of the review
Comments	Alphanumeric	Yes	500	Body text of the review
Nickname	Alphanumeric	Yes	500	Nickname or username of user posting the review
Location	Alphanumeric	No	500	Location where review was submitted
Email	Alphanumeric	No	500	Email address of the user posting a review
OverallRating	Decimal	Yes		Rating of the product being reviewed
Recommended	Boolean	No		If the product is recommended