Migrating from another reviews app

What comes across when you import a Yotpo, Judge.me, Okendo, Stamped or Loox export with Format set to that app, and what doesn't. For the steps, see Importing reviews.

Warning

These mappings were written from each app's published documentation, not from a real export file. Compare the table for your app against your own export before you upload. If a column name differs, tell us and we'll fix it; in the meantime, rename the column in a spreadsheet, or reshape the file and use the Cascade format.

Four things are true of every format:

The picker is not a guess. Cascade reads the file as the format you picked, and refuses it if the columns don't match.
Column names are matched loosely. Product Handle, product_handle and productHandle are the same column.
Nothing is dropped quietly. Every column the mapping doesn't carry across is listed on the import job with the reason.
Cascade's own site column is accepted alongside, for stores that sell the same catalog on more than one site.

Yotpo

The Format picker listing Cascade, Yotpo, Judge.me, Okendo, Stamped and Loox

Yotpo identifies products by ID rather than handle, so connect your Shopify store first, or make sure product_url points at pages whose last path segment is your product slug.

Yotpo column	Becomes	Notes
`review_id` or `id`	`externalId`	Required. What makes a re-run safe.
`reviewer_email` or `email`	`customer`	Required.
`review_score`, `score` or `rating`	`rating`	Required. Rounded to a whole star.
`product_id` or `external_product_id`	`productExternalId`	Required. Matched against the Shopify product ID.
`product_url`	`productUrl`	The fallback when the ID does not resolve.
`review_title` or `title`	`title`
`review_content`, `content` or `body`	`body`
`review_created_at`, `created_at` or `date`	`createdAt`
`published`	`published`
`review_state` or `status`	`moderationStatus`	`spam` rows are not imported.
`verified_buyer` or `verified`	`verifiedBuyer`
`order_id` or `external_order_id`	`orderReference`
`images`, `image_urls`, `review_images`, `video_urls`	`imageUrls`	All of them together.
`review_comment` or `comment`	`response`	Your reply to the review.
`comment_created_at`	`responseCreatedAt`
`reviewer_name`, `display_name`	Not imported	Names belong to the customer.
`votes_up`, `votes_down`	Not imported	Cascade counts helpful votes from its own widget.
`sentiment`	Not imported
`deleted`	Not imported	Remove deleted reviews from the file before you upload.
`product_title`	Not imported
`custom_fields`	Not imported	Put the ones you need in a `metadata` column as JSON.
`source`	Not imported

Check the deleted column. Cascade imports every row, so an export that still carries deleted reviews brings them back. Filter them out in a spreadsheet first.

Judge.me

Judge.me exports the Shopify handle, which is Cascade's product slug, so this migration works with or without a connected store.

Judge.me column	Becomes	Notes
`id` or `review_id`	`externalId`	Required. What makes a re-run safe.
`reviewer_email` or `email`	`customer`	Required.
`rating`	`rating`	Required.
`product_handle` or `handle`	`product`	Required.
`product_id`	`productExternalId`	The fallback when the handle has been renamed.
`product_url`	`productUrl`
`title`	`title`
`body` or `review_content`	`body`
`review_date` or `created_at`	`createdAt`
`published`	`published`
`hidden`	`hidden`	The opposite of published.
`curated`	`moderationStatus`	`spam` rows are not imported.
`verified`	`verifiedBuyer`	`buyer` counts as verified.
`order_id`, `order_number`	`orderReference`
`picture_urls`, `pictures`, `photo_urls`	`imageUrls`	All of them together.
`reply`	`response`	Your reply to the review.
`reply_date`	`responseCreatedAt`
`reviewer_name`, `name`	Not imported	Names belong to the customer.
`ip_address`	Not imported
`custom_questions`	Not imported	Put the ones you need in a `metadata` column.
`votes_up`, `votes_down`	Not imported
`product_title`, `location`, `source`	Not imported

Custom question answers are the loss to plan for. Cascade has no field for Judge.me's "How did it fit?" answers. If you need them, copy the columns into a metadata column of JSON before you upload.

Okendo

Okendo identifies products by Shopify ID, so connect your store first.

Okendo column	Becomes	Notes
`reviewId` or `id`	`externalId`	Required. What makes a re-run safe.
`reviewerEmail` or `email`	`customer`	Required.
`rating`	`rating`	Required.
`productId`	`productExternalId`	Required. Matched against the Shopify product ID.
`productUrl`	`productUrl`	The fallback when the ID does not resolve.
`title`, `reviewTitle`	`title`
`body`, `reviewBody`, `reviewText`	`body`
`dateCreated`, `reviewDate`	`createdAt`
`published`	`published`
`status`	`moderationStatus`	`spam` rows are not imported.
`verifiedPurchase`, `verified`	`verifiedBuyer`
`orderId`	`orderReference`
`media`, `mediaUrls`, `imageUrl`, `videoUrl`	`imageUrls`	A JSON array of URLs is read as a list.
`response`, `reply`	`response`	Your reply to the review.
`responseDate`	`responseCreatedAt`
`reviewerName`, `displayName`	Not imported	Names belong to the customer.
`attributes`, `customAttributes`	Not imported	Put the ones you need in a `metadata` column.
`helpfulVotes`, `upVotes`, `downVotes`	Not imported
`productName`, `source`	Not imported

Okendo often exports media separately. If your export has no media column, the photos are in a second file keyed by review ID. Join the two in a spreadsheet into one media column of comma-separated URLs before you upload, or import the reviews now and their photos later with a two-column file of externalId and imageUrls.

Okendo attributes (fit, size, your own questions) have no field in Cascade, the same as Judge.me's custom questions.

Stamped

Stamped column	Becomes	Notes
`id` or `reviewId`	`externalId`	Required. What makes a re-run safe.
`email` or `authorEmail`	`customer`	Required.
`reviewRating` or `rating`	`rating`	Required. Rounded to a whole star.
`productId`	`productExternalId`	Required. Matched against the Shopify product ID.
`productHandle`	`product`	Used first when the export carries it.
`productUrl`	`productUrl`
`reviewTitle`, `title`	`title`
`reviewMessage`, `message`, `body`	`body`
`reviewDate`, `dateCreated`	`createdAt`
`published`, `isPublished`	`published`
`reviewState`, `status`	`moderationStatus`	`spam` rows are not imported.
`verifiedBuyer`, `verified`	`verifiedBuyer`
`orderId`, `orderRef`	`orderReference`
`reviewPhotos`, `photos`, `photo`, `photo1` to `photo3`, `reviewVideo`	`imageUrls`	All of them together.
`reviewReply`, `reply`	`response`	Your reply to the review.
`replyDate`	`responseCreatedAt`
`author`, `reviewerName`	Not imported	Names belong to the customer.
`customFields`, `reviewQuestions`	Not imported	Put the ones you need in a `metadata` column.
`reviewVotesUp`, `reviewVotesDown`, `location`, `productTitle`	Not imported

Loox

Loox exports the Shopify handle, so this migration works without a connected store.

Loox column	Becomes	Notes
`id` or `review_id`	`externalId`	Required. What makes a re-run safe.
`email`	`customer`	Required.
`rating` or `stars`	`rating`	Required.
`product_handle` or `handle`	`product`	Required.
`product_id`	`productExternalId`
`product_url`	`productUrl`
`title`	`title`
`body`, `review`, `text`	`body`
`date`, `created_at`	`createdAt`
`published`	`published`
`status`	`moderationStatus`	`spam` rows are not imported.
`verified`	`verifiedBuyer`
`order_id`, `order_name`	`orderReference`	Usually what marks a Loox reviewer as a verified buyer.
`photo`, `photos`, `photo_url`, `image_url`, `video`	`imageUrls`	All of them together.
`reply`	`response`	Your reply to the review.
`reply_date`	`responseCreatedAt`
`name`, `reviewer_name`	Not imported	Names belong to the customer.
`product_title`, `featured`, `source`	Not imported

When Cascade refuses the file

If the columns aren't the format's, nothing is imported and the job says what it looked for and what it found:

This file does not look like a Yotpo export.
Missing the review id column: expected "review_id" or "id".
Missing the product id column: expected "product_id" or "external_product_id".
Your file has: "email", "rating", "body".

That's almost always the wrong format picked or the wrong export downloaded. Fix whichever it was and upload again.

#Migrating from another reviews app

#Yotpo

#Judge.me

#Okendo

#Stamped

#Loox

#When Cascade refuses the file