header-logo
Getting started with WixBuild your website and business with Wix. Try using our AI tools to create your website, customize templates, or hire professionals to build or enhance your online presence.
Creating a websiteRead how to use the Wix Editor and manage content on your site. Discover how to protect your visitors' privacy and make your site accessible.
Account & billingReview your account settings, manage your subscriptions and plans and understand your invoices.
Using the Wix mobile appsUse our mobile apps to run your business efficiently on the go and set up a dedicated app for your site members to stay in touch.
Connecting a domainFollow our step-by step guides to learn how to purchase, connect or transfer a domain for your site, and find out how to keep your site’s data secure.
Managing your businessGet tools to grow your business and web presence. Find the right tools for your specific needs, set up online payments and keep track of your site's analytics.
Promoting your siteLearn to make your site more visible promoting it on search engines, sending emails and running paid ads. Improve your online presence with practical tips.
Studio, Partners & EnterpriseGet the most out of your Studio or Enterprise account with advanced features that'll help you work more efficiently.
Need more help?Find solutions for site performance and technical issues, learn about issues we’re working to fix or contact us for help.
placeholder-preview-image
Wix LearnImprove your skills with our courses and tutorials.
Wix BlogGet tips for web design, marketing and more.
SEO Learning HubLearn to increase organic site traffic from search engines.
Website developmentBuild a custom site using our full-stack platform.
placeholder-preview-image
  1. Managing your business
  2. Business solutions & apps
  3. Wix Stores
  4. Promoting stores sales
  5. Fixing Common CSV Errors

Fixing Common CSV Errors

In this article
  • Correcting product ID errors
  • Correcting additional errors
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.

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 MessageUnderstanding 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

Did this help?

|