Hi @Empath Designs!

Here’s our Help Center article on this topic if you’re interested:

• How to import reviews data from another platform (Troubleshoot a failed upload)

Can you provide a screenshot of the part where you are stuck? As long as Rivo allows you to export a .CSV, and the .CSV is formatted as recommended in the above Help Center article, you should be able to import the reviews. Perhaps some further information will allow myself and others obtain a better understanding of the issue.

Best,

Brian

Hi Brian! Thank you for your reply.

I’ve attached a screenshot of the csv I exported from Rivo. 

I even tried clicking ‘export reviews’ from Klaviyo , and manually input the reviews from Rivo into the Klaviyo format, but I can’t upload it without selecting one of the providers listed in the dropdown (I tested using Shopify Product Reviews to see if I could bypass it). 

I’ve read that article but still stumped as to how I can import existing reviews.

@Empath Designs, I am facing this same issue while attempting to import reviews from Trustpilot (also not listed as  a selectable option for csv formatting.) Following this thread, and hopeful we’ll be met with a solution! :)

Hey @Empath Designs,

From that screenshot, it looks like the Product IDs in that column are in scientific notation instead of a long number format. Hence why you’re getting a “Product not found” error after import. 

I would recommend making sure that those Product IDs are in the correct number format. This change in format can happen automatically sometimes when it’s opened in Excel and saved as a .CSV again.

David

 @Brian Turcotte @David To I am facing this same issue in attempting to import reviews from Trustpilot. Though I am also received the error message “Product Not Found” just like @Empath Designs has experienced, my Product ID’s are correctly in long number format. It seems the issue could lie with having to select a review platform we are migrating from, even though our platforms are not listed as options.

I am moving reviews from Squarespace CSV and facing the same issue with the products not being found. Confirmed the product IDs are correct in Klaviyo. 

Hey @MyJuly,

Great feedback there! You’ll be glad to hear that our Product Team is hard at work expanding on the number of selectable review platforms when migrating. One of the difficulties - which you’ve already touched upon  - is not all review platforms share the same file structure when exported. Even minor differences - an underscore here or a capitalization there - can cause a misunderstanding through the importer. 

In the interim, since you’re migrating from a non-listed provider, I would suggest reformatting your .CSV to align with the default format below and import as Yotpo. 

In order to have a successful import, your .CSV file must contain the columns with the following information - as denoted by the *Required in the example above:

• Product IDs - that exactly match the product IDs synced to Klaviyo
• Reviewers emails
• Reviewers display name
• Review content
• Review score
• Review creation date

Don’t forget, if you’re copy and pasting the data (even the example headers above), I would highly suggest pasting without format as best practice. 

@FloraGlow Studio, because Squarespace is a non-listed platform, I would suggest the above solution as well if you’ve ensured the Product ID data are in the correct format. 

David