Solving CSV file import errors

I hope this article is helpful.

Yen Ma avatar
Written by Yen Ma
Updated over a week ago

If the CSV file you import does not match the required format, you will receive an error notification. What are these errors, and how can you fix them? Please continue reading this article to find out.


Missing required column name: product_handle, rating, author, email

This error means the name of the the required files are not correct or missing. Please correct them or fill data in the CSV file.

Please refer to this screenshot for the correct column name:


Invalid product_handle or email or author or rating in rows: 1,2,3,4

If you receive this error, it means the data entered in column product-handle, email, author, or rating is incorrect. Please open your CSV file and check in rows 1, 2, 3, 4 to correct the data.

Here are some notices to keep in mind if you receive this error:

  • The data which fill in product_handle column cannot include the spaces or '/'. It should be like that 2023-sexy-bandage-azteque-biquini-string-strappy. Click here to get more detail about product handle.

  • The correct format of rating is whole numbers between 1 and 5 (1, 2, 3, 4, 5).

  • The name entered in author column should be in text.

  • The email address can't have the space. Its format should be [email protected]


Empty product_handle or email or created_at or rating in rows: 1,2,3,4

This error indicates that the data of the product_handle, email, created_at, or rating in rows 1, 2, 3, or 4 is missing. Please fill in the data for the missing row(s).


You can download the original Ryviu import template here. If you got any questions, please feel free to let us know.


โ€‹

Did this answer your question?