Help Center
    Help Center
  1. Managing your business
  2. Business solutions & apps
  3. Wix Stores
  4. Promoting stores sales
    5. Fixing Common CSV Errors

Fixing Common CSV Errors

4 min read
While importing reviews to your Wix store, you may encounter some error messages. Reviews with errors may not be imported, or if imported, may not be displayed.
This article guides you on fixing these errors to ensure all your reviews can be imported and displayed on your Wix site.
In this article, learn more about:

Correcting product ID errors

The product_id column in the template is the place to enter your Wix product's unique product ID. This field allows Wix Reviews to connect each review to the relevant product. 
If you exported reviews that were displayed on another platform, those products have their own unique product identifier. 
Important:
  • Product identifiers from another platform will not connect the review to the relevant Wix product.
  • You do not receive an error message if your product identifier is incorrect. 
  • Reviews that are not connected to a product are not displayed on your live site. They only appear in your site's dashboard.

To add the correct product_id to the template:

  1. Open the template file which contains the reviews you want to import.
  2. Choose the first review whose product_id you want to add (e.g. row 2 in the file).
  3. Determine which of your store products the review was about (e.g. the green rug). 
  4. Go to Products in your site's dashboard.
  5. Select the product whose ID you want to locate (e.g. the green rug).
  6. Look at the URL for the relevant product.
  7. Copy the unique product ID for this product.
    Note: The URL has 2 long strings of numbers and letters separated by hyphens. The 2nd string is the ID number for the product. For example, the bolded section in the following URL:

    https://manage.wix.com/dashboard/12345678-1234-1234-1234-123456789abc /store/products/product/89623b5a-f144-d515-dd1ca5d0f478?referralInfo=stores.....
  1. Paste the product ID in the relevant row and column in the template file.
  2. Repeat steps 2 - 8 for each product to locate and add the product ID.
  3. When you're finished, save the CVS file.

Correcting additional errors

Below is a list of possible error messages and how to correct them.
Error Message
Understanding and correcting the error
Couldn't recognize created_at date format.
The format you used to enter the review creation date in the template file was incorrect. 
Change the date format one of the following:

mm/dd/yyyy  (e.g. 12/20/2023)
yyyy-mm-dd (e.g. 2023-12-20)
Mth d, yyyy (e.g. Dec 20, 2023)
yyyy-mm-dd hh:mm:ss (e.g. 2023-12-20 14:55:25)
Tip: The date can also include a time stamp (e.g. 2024-02-27 14:55:25)
Couldn't recognize  customer_email email format.
The format of your customer's email address is incorrect. For example, it has a space or is missing the @ symbol. Make sure the format is me@example.com
A required field  customer_email is missing.
The email address of the customer was missing. This is a mandatory field.
A rating must be a whole number between 1 and 5.
Make sure the rating is one of the following 1, 2, 3, 4, or 5. Ratings such as 4.5 are not allowed.
A required field rating is missing.
The review didn't have a rating. This is a mandatory field.
Max character length exceeded in column title.
Make sure the review title isn't more than 3000 characters long.
Max character length exceeded in column body. 
Make sure the body of the review isn't more than 3000 characters long.
Max character length exceeded in column store_reply.
Make sure the store reply isn't more than 1000 characters long.
Couldn't recognize  store_replied_at date format.
The format you used to enter the store reply date in the template file was incorrect. 

Change the date format one of the following: mm/dd/yyyy  (e.g. 12/20/2023)
yyyy-mm-dd (e.g. 2023-12-20)
Mth d, yyyy (e.g. Dec 20, 2023)
yyyy-mm-dd hh:mm:ss (e.g. 2023-12-20 14:55:25) Tip: The date can also include a time stamp (e.g. 2024-02-27 14:55:25)
A required field product_id is missing.
The review had no product id. Learn more about product IDs.
Couldn't recognize  review_image_url  format.
* Each image must have its own URL.
* You must separate image URLs with a semi-colon.
* Do not add a space after the semi-colon
Couldn't recognize  review_video_url format.
* You can only upload only 1 video URL per review.
* The format must be a URL.
Same customer_email value used more than once in a single column.
You have more than one review from the same customer. Remove the extra review(s).
Same customer_email used more than once for a single product_id. 
You have more than one review for the same product from the same customer. Remove the extra review(s).
Failed to parse this row.
A number of errors could cause this error message. 
* Commas in the review title, body, or store reply may cause an error message. To fix, remove commas from this row. Alternatively, you could put quotation marks around the text.
* If you added additional columns to the template file, they may cause this error. Delete the extra columns. 

Did this help?

|
In this article
  • Correcting product ID errors
  • Correcting additional errors

Hire a Professional

Get matched with a Wix Partner who can help you reach your site goals.
Get Matched