{"id":1323,"date":"2021-05-12T22:29:05","date_gmt":"2021-05-12T22:29:05","guid":{"rendered":"https:\/\/www.opinew.com\/help-center\/?post_type=ht_kb&#038;p=1323"},"modified":"2023-10-12T22:33:03","modified_gmt":"2023-10-12T22:33:03","slug":"how-can-i-migrate-reviews-to-opinew-from-a-custom-csv-file","status":"publish","type":"ht_kb","link":"https:\/\/www.opinew.com\/help-center\/knowledge-base\/how-can-i-migrate-reviews-to-opinew-from-a-custom-csv-file\/","title":{"rendered":"How can I migrate reviews to Opinew from a custom CSV file?"},"content":{"rendered":"\n<p>If you used a different review system before installing Opinew, you can easily migrate reviews to Opinew. Using our custom CSV importer you only need to follow our template file to start uploading past reviews without using the structure of another major Shopify review app.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">You will need a custom CSV file to import reviews only<strong> if you can&#8217;t find your previous review provider in the drop-down<\/strong> under &#8220;Other app&#8221;.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">CSV Reviews File Structure<\/h2>\n\n\n\n<p>You can download our ready-to-upload template below in order to migrate reviews to Opinew quickly:<\/p>\n\n\n\n<a href=\"https:\/\/cdn.opinew.com\/global\/custom-csv-template-v4.csv\"><button style=\"margin-bottom:20px;\">Download Custom CSV Template<\/button><\/a>\n\n\n\n<h3 class=\"wp-block-heading\">Structure and Required Values<\/h3>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">The order of the columns is necessary to be exactly as follows, and every required value will be detailed in the list items; values without the &#8216;Required&#8217; tag are optional and leaving them empty would be a valid value.<\/p>\n\n\n\n<ul><li>body <strong>(Required)<\/strong>: String of text with the body of the review <\/li><li>rating <strong>(Required)<\/strong>: Number with the rating of the review<\/li><li>review_date <strong>(Required)<\/strong>: Date with the following format: 2021-03-25 22:54:53 UTC<br>(Single digits are also valid: 2021-3-25)<\/li><li>state <strong>(Required)<\/strong>: It must be one of two valid values: published \/ unpublished<\/li><li>reviewer_name <strong>(Required)<\/strong>: String of text with the name of the author<\/li><li>reviewer_email: String of text with the email of the author<\/li><li>product_id <strong>(Required)*<\/strong>: Number with the Shopify id of the product<\/li><li>product_handle <strong>(Required)<\/strong>*: Shopify Product URL ending.<\/li><li>reply: String of text with the body of merchant reply to the review. It will show under the review.<\/li><li>reply_date: Date with the following format: 2021-03-25 22:54:53 UTC (Single digits are also valid: 2021-3-25)<\/li><li>picture_urls: This cell can be filled in two ways:<ul><li>One single URL<\/li><li>Several URLs separated by commas<\/li><\/ul><\/li><li>SKU <strong>(Required)<\/strong>*: Product&#8217;s SKU code<\/li><li>barcode <strong>(Required)<\/strong>*: Product&#8217;s barcode<\/li><li>region: ISO 639-1 country code (eg. us, fr)<\/li><\/ul>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-danger\">* At least one of the following values is required to migrate reviews to Opinew:<strong> product_id, product_handle, SKU, <\/strong>and<strong> barcode<\/strong>. <br>You must have at least one for the reviews to be imported. Having more than one is not necessary but it doesn&#8217;t affect the import process.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example of a Valid Custom CSV File Structure<\/h3>\n\n\n\n<p><strong>Example for product_handle:&nbsp;<\/strong><\/p>\n\n\n\n<p>https:\/\/demo.opinew.com\/collections\/frontpage\/products\/<strong>mega-helmet<\/strong> <\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">The product handle is &#8220;mega-helmet&#8221;.<\/p>\n\n\n\n<p><strong>Example for one image URL: <\/strong>https:\/\/vrdev.storage.googleapis.com\/Video\/ba9268719cab777d36241ea87d843334.jpg<\/p>\n\n\n\n<p><strong>Example for several image URLs: <\/strong>https:\/\/vrdev.storage.googleapis.com\/Video\/ba9268719cab777d36241ea87d843334.jpgExample,https:\/\/vrdev.storage.googleapis.com\/Video\/ba9268719cab777d36241ea87d843334.jpgExample,https:\/\/vrdev.storage.googleapis.com\/Video\/ba9268719cab777d36241ea87d843334.jpg<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Migrate reviews to Opinew from another Shopify app<\/h2>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">Make sure you have&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/apps.shopify.com\/photo-reviews\" target=\"_blank\">Opinew<\/a>&nbsp;installed on your Shopify store.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Navigate to Reviews &gt; Import Reviews<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"594\" src=\"https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu-1024x594.png\" alt=\"Go to migrate reviews menu\" class=\"wp-image-2949\" srcset=\"https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu-1024x594.png 1024w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu-300x174.png 300w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu-768x445.png 768w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu-50x29.png 50w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu-60x35.png 60w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu-100x58.png 100w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/import-reviews-menu.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: On the&nbsp;<strong>\u201cImport Reviews\u201d<\/strong>&nbsp;page, click on&nbsp;<strong>\u201cMigration from other apps &amp; CSV\u201d&nbsp;<\/strong>to open the migration panel.<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"594\" src=\"https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps-1024x594.png\" alt=\"click on migration from other apps\" class=\"wp-image-2947\" srcset=\"https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps-1024x594.png 1024w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps-300x174.png 300w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps-768x445.png 768w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps-50x29.png 50w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps-60x35.png 60w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps-100x58.png 100w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/11\/choose-migration-from-other-apps.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Select &#8220;Custom File&#8221; and click the \u2018Add File\u2019 button.<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"594\" src=\"https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV-1024x594.png\" alt=\"migrate reviews to Opinew with custom file\" class=\"wp-image-2986\" srcset=\"https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV-1024x594.png 1024w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV-300x174.png 300w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV-768x445.png 768w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV-50x29.png 50w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV-60x35.png 60w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV-100x58.png 100w, https:\/\/www.opinew.com\/help-center\/wp-content\/uploads\/2021\/05\/select-custom-file-and-upload-CSV.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Having issues when trying to migrate reviews to Opinew?<\/h3>\n\n\n\n<p>Reach out with the name of the provider &amp; (if possible) a .csv file of your review data from them and your .myshopify.com domain name, for example: opinew.myshopify.com<\/p>\n\n\n\n<p>You can contact us via email (<a href=\"mailto:support@opinew.com\" class=\"rank-math-link\">support@opinew.com<\/a>) or chat with us at the bottom right-hand side of your Opinew dashboard. We&#8217;ll get on processing your import right away &amp; as long as you provide all the info we need, we try to get it done within 48 hours (though it&#8217;s often less).<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">When you migrate reviews&nbsp;to Opinew, we ask you to use only&nbsp;genuine reviews from your customers. People are quite good at spotting fake reviews and increasingly there are more consumer protection laws and court cases around those laws that may negatively impact your business: <a href=\"https:\/\/www.mycustomer.com\/experience\/voice-of-the-customer\/the-legal-challenge-that-could-make-fake-reviews-a-thing-of-the\" class=\"rank-math-link\">US fake reviews court case news articles<\/a>, and <a href=\"https:\/\/www.mycustomer.com\/experience\/voice-of-the-customer\/the-legal-challenge-that-could-make-fake-reviews-a-thing-of-the\" class=\"rank-math-link\">FTC case documents<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you used a different review system before installing Opinew, you can easily migrate reviews to Opinew. Using our custom CSV importer you only need to follow our template file to start uploading past reviews without using the structure of another major Shopify review app. CSV Reviews File Structure You&#8230;<\/p>\n","protected":false},"author":7,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[21],"ht-kb-tag":[26],"_links":{"self":[{"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/ht-kb\/1323"}],"collection":[{"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/comments?post=1323"}],"version-history":[{"count":33,"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/ht-kb\/1323\/revisions"}],"predecessor-version":[{"id":3119,"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/ht-kb\/1323\/revisions\/3119"}],"wp:attachment":[{"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/media?parent=1323"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/ht-kb-category?post=1323"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.opinew.com\/help-center\/wp-json\/wp\/v2\/ht-kb-tag?post=1323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}