When importing customer reviews into The Vital, you may encounter import errors. These errors typically arise from issues with the CSV file, such as incorrect formatting, missing fields, or invalid product handles. Here's how to troubleshoot and fix the most common import errors:

Common Import Errors and Fixes:

1. Product Not Found Error
   Cause: This error occurs when the product handle in the CSV file does not match any product in your Shopify store.
   Solution:

   • Ensure the product handle matches the URL of the product. You can find the product handle by following these steps:
     • Go to your Shopify product page.
     • Copy the part of the URL after /products/. For example, in https://yourstore.myshopify.com/products/product-name, the handle is product-name.
   • Double-check the handles in the CSV file and correct any errors.

2. Missing Required Fields
   Cause: A required field in the CSV file, such as customer_email, rating, or review, is missing or blank.
   Solution:

   • Make sure that all required fields in the CSV file are filled.
   • The required fields for importing reviews are: customer_email, customer_name, rating, review, handle. Ensure there are no blank rows or missing values.

3. Invalid Review Date
   Cause: The review_date field is not formatted correctly or is missing.
   Solution:

   • Ensure that the review_date field is in the correct format (e.g., YYYY-MM-DD).
   • If the date is missing or incorrectly formatted, update the CSV file and try importing again.

4. Incorrect CSV Formatting
   Cause: The CSV file is not formatted properly, with issues like extra columns or incorrect headers.
   Solution:

   • Use the Vital Review Template to structure your file correctly. Make sure the headers and columns match the template exactly.
   • Double-check that the CSV file is saved with the correct UTF-8 encoding.

5. Duplicate Reviews
   Cause: The system identifies duplicate reviews based on customer_email or review_date.
   Solution:

   • Remove any duplicate reviews from the CSV file before importing.
   • Check the review history to ensure you're not importing reviews that already exist in your store.

6. Sync Products to Avoid Errors
   Cause: Sometimes, product sync issues can lead to errors, especially if you've recently added or updated products in Shopify.
   Solution:

   • Use the Sync Products option in the Vital Dashboard to refresh your product list. This ensures that the products are up-to-date and prevents errors during the review import.

Additional Tips for a Successful Import:

• Review Data Formatting: Ensure that the review text is free of special characters that may cause errors.
• CSV File Preview: Before importing, preview the CSV file to check for any anomalies or formatting issues.
• Test Small Batches: Start by importing a small number of reviews to ensure everything works smoothly before uploading the entire file.

By following these troubleshooting steps, you can effectively resolve any errors during the review import process and ensure that your reviews are correctly displayed on your Shopify store.