Hi  Divyagor,

It looks like the error might be related to missing or blank product IDs in the file, as you mentioned. I recommend checking the JSON file to ensure that all product IDs are correctly populated. If they are blank or missing, that could be causing the issue.

If you need more assistance, feel free to reach out! I'm happy to help you with a more detailed solution or walk you through the steps to fix the file.

Hope that helps!

Hi ​@divyagor,

I believe the issue is you need to map the email to _Klaviyo’s_ built-in email field. You’re currently mapping the email to a custom profile field called “reviewer_email.” This means Klaviyo can’t create (or update) contacts because there’s no email/phone to find the contact.

If you need to add reviewer_email as a profile field, I believe you need to duplicate your reviewer_email field.

Map reviewer_email → reviewer_email (custom field)

Map reviewer_email → $email (built-in Klaviyo field)

Best,

Kevin.

product id is coming blank while exporting review from etsy, should i manually enter the product id ?

thanks for all your help

it still shows the same error even i made the another column $email

Hi @divyagor,

If the error persists after adding the $email column, please check:

1. Mapping: Ensure $email is mapped to Klaviyo’s built-in email field with no typos.
2. Data Format: Verify $email contains valid email addresses without empty or invalid entries.
3. Upload: Try uploading a file with just $email and necessary fields to isolate the issue.

Let me know if the issue continues or if further help is needed.

Thank you, may i know where can i get the product id to put it in Product_id column