---
title: "Creating a Targeted Product Review Request"
slug: "creating-a-targeted-product-review"
tags: ["WooCommerce", "Shopify", "Salesforce Commerce Cloud", "Volusion", "Shopify Plus", "Adobe Commerce (Magento)", "Reviews ", "Custom", "BigCommerce"]
updated: 2026-08-19T13:37:47Z
published: 2026-08-19T13:37:47Z
canonical: "support.yotpo.com/creating-a-targeted-product-review"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.yotpo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating a Targeted Product Review Request

Products

  

Reviews

###### Supported plans

Premium, Enterprise*

###### eCommerce Platform

Shopify, Shopify Plus, Adobe Commerce (Magento), BigCommerce, WooCommerce, Volusion, Salesforce Commerce Cloud, Custom

## Goals and Outcomes

Targeted product review requests allow you to proactively engage your customers by asking for reviews on specific products. It’s as simple as uploading a CSV file that includes your customer names, emails, and relevant product IDs. We’ll then trigger product review requests for each entry, helping you generate more reviews and drive more sales.

In this article, you'll learn how to create a targeted product review request email and send it to your customers.

> [!NOTE]
> ***Can’t find this in your Yotpo account?**
> 
> Targeted Product Review Requests are available only for **eligible accounts**. If the feature is not available in your account, please [reach out to our support team](https://reviews.yotpo.com/#/?modal=contact_support).

## Targeted Product Review Requests: Overview

### When to Use Targeted Product Review Requests

Targeted product review requests are especially useful when **certain orders are not automatically captured by Yotpo** - for example, purchases made in physical stores via a POS (Point of Sale) system. Because these orders aren’t synced to Yotpo, customers who buy in-store wouldn’t normally receive an automatic review request.

In such cases, you can send targeted product review requests by uploading a CSV file with customer and product details.

This ensures that all of your customers - whether they purchase online or in-store - have the chance to share feedback, helping you collect more authentic reviews and strengthen trust across every sales channel.

### How It Works

You can send a targeted product review request to a single email address or upload a CSV file containing multiple addresses along with their corresponding product IDs.

Review request emails are sent in accordance with [Yotpo’s email policies](https://support.yotpo.com/docs/email-policies). Submitted reviews appear in the Yotpo [**Manage Reviews page**](https://app.yotpo.com/reviews/manage/moderation), where they can be reviewed and approved. To learn more about managing reviews, read our [Help Center article](https://support.yotpo.com/docs/reviews-moderation-1).

Additionally, reviews are syndicated to Google and may appear in Google Shopping. For more details, see our guide on [Google Shopping Syndication](https://support.yotpo.com/docs/google-shopping-syndication).

### Limitations

- You can send up to **2,500 targeted product review requests** in total.
- A CSV file can contain up to **2,500 recipients**, provided you have enough targeted review requests remaining.
- Once you reach the limit, you cannot send additional targeted product review requests.

### Before You Start

Before sending targeted product review requests, make sure your product catalog is up to date.

To learn how to update your catalog, select your eCommerce platform:

- [Shopify](/v1/docs/keeping-your-shopify-and-yotpo-product-catalogs-updated)
- [Other eCommerce platforms](/v1/docs/importing-product-catalogs)

### Review Verification Process

When a customer submits a review, Yotpo checks whether their email address is associated with a previous purchase for that product. Based on this verification, the review will receive one of the following badges:

- **Verified Buyer**: If the email address used in the targeted product review request matches a past purchase of the reviewed product, the review is marked as a **Verified Buyer**.
- **Verified Reviewer**: If no matching purchase is found for that product, the review is marked as a **Verified Reviewer**.

## Setting up the Targeted Product Review Email

To set up a targeted product review request email:

1. From the Yotpo Reviews main menu, go to **Emails > Email Setup >** [**Targeted Product Review Requests**](https://reviews.yotpo.com/#/emails/email-setup/targeted-review-requests).
2. Choose whether you want to send the request to an individual customer or multiple customers.

- If you choose the **Multiple recipients** option, you will be able to download a CSV template and fill in the customer names, email addresses, and products to review. Once the file is filled, click **Upload CSV** to upload the file.

![](https://cdn.document360.io/f3c2ab59-fe4c-4f93-9614-2872f40e8aa7/Images/Documentation/image(533).png?sv=2026-02-06&spr=https&st=2026-10-31T21%3A09%3A57Z&se=2026-10-31T22%3A09%3A57Z&sr=c&sp=r&sig=L1NJPF7foLY9ISpeaFrKzUHF58Nuhr4rGEdi7XM%2F8Hs%3D)

## Customizing the Email

### Changing the Design

When choosing the design for your targeted product review emails, you can choose to apply the main email design you have chosen for your [Review Request Email](https://reviews.yotpo.com/#/collect-reviews/automatic-requests) or change it by using the advanced email editor.

> [!TIP]
> **Tip**
> 
> Еmail apps may display colors differently in **Dark and Light mode**. To help ensure star ratings remain visible for all recipients, **avoid** using **pure white** or **pure black colors.**

### ![](https://cdn.document360.io/f3c2ab59-fe4c-4f93-9614-2872f40e8aa7/Images/Documentation/image(534).png?sv=2026-02-06&spr=https&st=2026-10-31T21%3A09%3A57Z&se=2026-10-31T22%3A09%3A57Z&sr=c&sp=r&sig=L1NJPF7foLY9ISpeaFrKzUHF58Nuhr4rGEdi7XM%2F8Hs%3D) Editing the Text

You can edit the email subject line and email body. You can also add personalization tags.

**Adding personalization tags to your email**

Personalization tags are dynamic parameters for engagement and use data from your store to turn each email into a specific email rather than sending out a general email every time.

These are the tags you can use:

| Shortcode | Description |
| --- | --- |
| Shopper name | Automatically add the customer’s name to your message. |
| Store name | Automatically add your store’s name to your message, as written under your [account settings](https://settings.yotpo.com/#/general_settings). |
| Product name | Automatically add the product’s name to your message, as listed in your product catalog. |

These tags can be used in the email subject and body fields. If you want to add the tags to the subject line, you need to manually add the relevant tag in the following format:

- {{customer.name}}
- {{store.name}}
- {{product.name}}

> [!CAUTION]
> Note
> 
> The test email shows the content and design. Personalization tags and product photos are not substituted with real data.

## Spam Filter

The Spam Filter helps you avoid sending your customers too many review request emails.

If the filter is **turned off**, we’ll send a targeted product review request to customers who have not received any of the following emails over the past 14 days:

- [Automatic (product) review request](/v1/docs/creating-a-review-request-premium-enterprise) (for the **same** product)
- [Reminder emails (product)](/v1/docs/creating-a-review-request-premium-enterprise#creating-reminder-emails) (for the **same** product)
- [Resent review request](/v1/docs/resending-an-automatic-review-request-email) (for the **same** product)
- Targeted product review request (for the **same** product)

If the filter is **turned on**, we’ll send a targeted product review request to customers **who have not** received any of the following emails over the past 14 days:

- Any [automatic review request (site or product)](/v1/docs/creating-a-review-request-premium-enterprise)
- Any [reminder email (site or product)](/v1/docs/creating-a-review-request-premium-enterprise#creating-reminder-emails)
- Any targeted ([site](https://support.yotpo.com/docs/creating-a-targeted-site-review) or product) review request
- Any [resent automatic review request](/v1/docs/resending-an-automatic-review-request-email)

The shopper must also **not be due** to receive any review request emails within the next 2 days.

## Uploading a CSV File of Your Target Customers

> [!TIP]
> Tip
> 
> - We recommend that you download the sample file and edit it
> - We recommend using [LibreOffice](https://www.libreoffice.org/) or [Google Sheets](https://www.google.com/sheets/about/) when working with the downloaded file.

### Downloading the Example CSV File

To download the example CSV file:

1. Click **Download example.**
2. Save the file according to your browser.

### CSV File Structure

The structure of the CSV file must be **identical** to the example you downloaded.

| Email | Name | Product ID |
| --- | --- | --- |
| randy@example.com | Randy Schultz | 123456 |
| helen@example.com | Helen Harden | 987654 |

To learn how to find the correct product ID, see [Finding Product IDs in Your E-Commerce Platform](/v1/docs/finding-product-ids-in-your-ecommerce-platform).

### CSV File Encoding

The CSV file must be saved in UTF-8 format. If you are unable to do so through your Excel version, follow the steps given [here](/v1/docs/saving-a-csv-file-in-utf-8-with-google-spreadsheet).

Make sure you do that before proceeding to the next step of uploading the file.

> [!CAUTION]
> Important
> 
> - The CSV file you upload must contain only three columns: **Email, Name, and Product ID**, with up to **2,500 recipients**.
> - The file must include the header row and be in the UTF-8 encoding format.
> - Product specification values are **case-sensitive.**

### Error Message

If the number of recipients exceeds the allowed limit, the file cannot be uploaded. You’ll see the following message:

![](https://cdn.document360.io/f3c2ab59-fe4c-4f93-9614-2872f40e8aa7/Images/Documentation/image(535).png?sv=2026-02-06&spr=https&st=2026-10-31T21%3A09%3A57Z&se=2026-10-31T22%3A09%3A57Z&sr=c&sp=r&sig=L1NJPF7foLY9ISpeaFrKzUHF58Nuhr4rGEdi7XM%2F8Hs%3D)

| Message | Explanation | Solution |
| --- | --- | --- |
| **We couldn't upload your file** Try uploading your recipients in smaller batches. | The file contains more than 2,500 recipients or exceeds **your remaining** targeted review request allowance. | Edit the file and re-upload it with a number of recipients that does not exceed your **remaining** targeted review request allowance. |

## Sending the Emails

> [!CAUTION]
> Note
> 
> Once a customer submits a review via a targeted product review request, the review will be marked as either **Verified Buyer** or **Verified Reviewer**, depending on whether Yotpo can match the customer to a previous purchase of that product.

Once you have uploaded the CSV file and are happy with the email content, click **Send**. The review request emails are sent out according to Yotpo email policies.

After the list is processed, you receive an email with a delivery summary and an attached CSV file that indicates specific errors.

*"****Hi Yotpo Reviews,*** *300 Emails were sent successfully. 5 Emails were invalid or failed to send.*

*Download the attached file to view the report."*

Reviews submitted through targeted product review requests appear on your product pages according to your review managing settings.

## Error Messages

Error messages are shown in the "Failures" column in the CSV file that is sent to your email after the targeted emails are processed and sent:

| Message | Explanation | Solution |
| --- | --- | --- |
| Product ID doesn't exist | The product ID in the row does not appear in the catalog. | Edit the product ID in the Targeted Product Review Request CSV file or correct it in the product catalog. |
| Product ID is required | The product ID is missing. | Add a product ID and re-upload. |
| Invalid Product ID | The Product ID can only contain alphanumeric (a...z, A...Z, 0...9), '_' and '-' characters. | Check the Product ID and re-upload. |
| Product ID should contain alphanumeric (a...z, A...Z, 0...9), '_' and '-' characters. | Invalid Product ID | Please make sure your product ID answers follow these rules: - Any combination of **leading zeros** (“0”), **leading spaces,** and **leading dashes** (“-“) are automatically stripped from the product specification values - Product specification values support **alphanumeric** (a...z, A...Z, 0...9), "_" and "-" characters only - Product specifications values are **case-sensitive** |
| Email is required | The row does not contain an email address. | Enter an email address. |
| Insert valid email address | The email address does not use the format user@domain. | Check the email address. |
| Name is required | The row does not contain a reviewer name. | Add a name and re-upload. |
| Duplicate email | The email address is included more than once in the file. | Remove any duplicate email addresses. |
| Exceeds review request limit | You have sent the maximum number of emails. | - |
| User unsubscribed | The customer has requested not to receive product review requests. | - |
| A review request was sent within the last 14 days | You sent a targeted product review to the customer within the past 14 days. | You must wait at least 30 days. |
| Another review request is scheduled for this customer within one day | The customer is due to receive an Automatic Request within the next day. | - |
| Failed to send email (General error) | The number of undelivered emails. Failure to deliver an email can occur if the recipient's mailbox is full (over quota), the recipient's email server is down or offline, the email message is too large, or if the email triggered a spam filter. | - |

## Related

- [About Targeted Review Requests](/about-targeted-review-requests.md)
- [Creating review requests](/creating-reviewrequests.md)
- [Optimizing review requests](/optimizing-review-requests.md)