Import Shopify Reviews not working

Solved
scvdz
Tourist
10 0 1

Hi guys,

 

I'm working on importing reviews with the Shopify Reviews app. 

I downloaded the example CSV and tested it with some products, which succeeded after a while.

Now I want to keep adding new reviews the same way, but I just keep getting errors like these no matter what I try. 

 

"Line 1 - Error: Could not find product ""."

 

"Line 1 - Error: Rating must be between 1-5, Title can't be blank, Body is too short (minimum is 3 characters), Name can't be blank, Email is invalid, and Created at has blank or invalid date format."

 

I'm so confused why I doesn't work anymore, does anyone have this problem too? 

 

Best regards,

Samantha 

Accepted Solution (1)

Accepted Solutions
JokerDeluxe
Tourist
3 1 2

This is an accepted solution.

Hi, actually I found how to do it. You should use Google form.

You can use this template if you'd like. 

https://docs.google.com/spreadsheets/d/1YxQ38GIml5-3WaHpYjNSb-X3lISJNuVU9-7cbrDK5UM/edit?usp=sharing

 

Once you filled everything (you can leave some columns blank), download it as "comma-separated-values, csv" and import the file into the app. It should work. 

 

Hope they would have documented it correctly, would have saved me hours of trying and errors. 

 

Best, 

Raphael

View solution in original post

Replies 10 (10)
JokerDeluxe
Tourist
3 1 2

Hello there, 

 

Did you get any support on this?

I've got the same issue, going crazy over it. I tried everything and I keep having these errors... 

 

All the best, 

Raphael 

instasuccess
New Member
8 0 0

I have the same issue. Have checked for all the commoin errors, separation, UFT8-encoding etc. Its just broken...

 

JokerDeluxe
Tourist
3 1 2

This is an accepted solution.

Hi, actually I found how to do it. You should use Google form.

You can use this template if you'd like. 

https://docs.google.com/spreadsheets/d/1YxQ38GIml5-3WaHpYjNSb-X3lISJNuVU9-7cbrDK5UM/edit?usp=sharing

 

Once you filled everything (you can leave some columns blank), download it as "comma-separated-values, csv" and import the file into the app. It should work. 

 

Hope they would have documented it correctly, would have saved me hours of trying and errors. 

 

Best, 

Raphael

instasuccess
New Member
8 0 0

@JokerDeluxe wrote:

Hi, actually I found how to do it. You should use Google form.

You can use this template if you'd like. 

https://docs.google.com/spreadsheets/d/1YxQ38GIml5-3WaHpYjNSb-X3lISJNuVU9-7cbrDK5UM/edit?usp=sharing

 

Once you filled everything (you can leave some columns blank), download it as "comma-separated-values, csv" and import the file into the app. It should work. 

 

Hope they would have documented it correctly, would have saved me hours of trying and errors. 

 

Best, 

Raphael


Haha this is mad! It worked! When comparing the new exported file from Google Apps with my locally exported file from Excel, they are identical. It must be something hidden within the encoding that is different. Crazy, i spent a good 4hrs with this last night. Thanks!

scvdz
Tourist
10 0 1

Thank you, that works! 😄

instasuccess
New Member
8 0 0

Update: First attempt on a 10 row sheet worked perfect. I then added 40 more for a total of 50 rows. Exporting the same file again with 50 rows gave me 32 error lines again, and i cant see the pattern....

JokerDeluxe
Tourist
3 1 2
Weird... I personally imported over 100 of my reviews with this template and it worked fine.

CSV files need to be formatted exactly, one extra space or comma can cause errors.

Hope you’ll sort it out !

Best,
Raphael
instasuccess
New Member
8 0 0

Solved now, it was my bad. I assumed that product SKU = product_handle, to me this was the case with ~50% of the products, but some had changed so the error handling was actually correct. Once i updated the handle under Product -> Edit SEO to match the SKU it all worked fine.

sanagar
New Member
2 0 0

I have figured out a different solution. 

Edit everything in Excel, then change date format to YYYY-MM-DD HH:MM:SS right before exporting to CSV (Comma delimited) (*.csv).

When you go to Import Reviews, do not check the box "Import using month/day/year date format."

MUSTAFA_Y_9675
New Member
1 0 0

YES THAT SOLUTION IS WORKING