# Fixing Common CSV Errors Source: https://support.wix.com/en/article/fixing-common-csv-errors (updated 2025-07-02) Related: Wix developer documentation, https://dev.wix.com/docs/llms.txt; Help Center index, https://support.wix.com/en/llms.txt While [importing reviews](https://support.wix.com/en/article/wix-stores-importing-reviews-into-wix-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](https://www.wix.com/my-account/site-selector/?buttonText=Manage%20Products&title=Select%20a%20Site&autoSelectOnSingleSite=true&actionUrl=https:%2F%2Fwww.wix.com%2Fdashboard%2F%7B%7BmetaSiteId%7D%7D%2Fstore%2Fproducts%3FreferralInfo%3Dsidebar) 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. ![](https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/8769cf44-f342-494c-b25f-cc98c9da3e82/2024/01/07/b776bdc9-6d10-4e18-a0ce-eaca695cd7f8/ae1c1719-c804-4afe-b5de-16fc0dc43166.png) 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. ![](https://d2x3xhvgiqkx42.cloudfront.net/12345678-1234-1234-1234-1234567890ab/8769cf44-f342-494c-b25f-cc98c9da3e82/2024/01/07/56e00b9e-522f-48dd-bbcc-4aeca0df0421/bec09637-4160-440f-b85a-4427f025ecb7.png) 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](https://support.wix.com/en/article/fixing-common-csv-errors#correcting-product-id-errors). | | 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. |