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

  1. Navigate to Magento.

  2. Enable the Module Review API setting.

  3. 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

  1. Provide Listrak with PowerReviews FTP URL and Credentials.

  2. 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

  1. Provide Listrak with Bazaarvoice FTP URL and Credentials.

  2. 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

  1. Provide Listrak with API Key and API Secret from Yotpo interface.

  2. 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

CreateDate

Datetime

Yes

Date the review was submitted in IOS 8601 format

ModifiedDate

Datetime

Suggested

Date the review was updated in IOS 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

Available Import Values for Boolean Values

Import fields marked as Boolean accept any of the following import string values:

⚠️ These values are NOT case sensitive

Import Value

Boolean Value

1

True

True

True

0

False

False

False

Next Steps

After you've completed the applicable steps explained above, please coordinate with your Project Manager to complete the validation process.

Did this answer your question?