Review import formats

This page lists 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 Meisei format.

Every format works like this:

Meisei reads the file as the format you picked. It refuses the file if the columns don't match.
Column names are matched loosely. Product Handle, product_handle and productHandle are the same column.
Skipped columns are listed. The import job lists every column the mapping doesn't carry across, with the reason.
Meisei's own site column is accepted alongside, for stores that sell the same catalog on more than one site.
No app's documented export says which reviews were rewarded, so imported reviews arrive without the Rewarded review label. Mark the ones you rewarded afterward, on each review's page. See Mark a rewarded review.

Yotpo

The Format picker listing Meisei, 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	Meisei 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. Meisei 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 Meisei'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 aren't imported. Meisei 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 Meisei, 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 Meisei 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".

Usually you picked the wrong format or downloaded the wrong export. Fix whichever it was and upload again.

#Review import formats

#Yotpo

#Judge.me

#Okendo

#Stamped

#Loox

#When Meisei refuses the file