Brand user-generated content (UGC) is a critical factor for generating sales on retailer websites. Connecting the most recent UGC to retail products early in the product's lifecycle maximizes the impact on consumer shopping behaviors and conversions.
PowerReviews offers easy Syndication integration to ensure fresh UGC appears on your retailer partner websites in the PowerReviews network. This integration involves two components:
- Product Data, such that we can match your brand's products to the retailer's products
-
UGC, including Ratings and Reviews and Visual Content (Q&A is not included)
This article contains the following sections:
Product Data
PowerReviews will use the Product Data you provide us to match products across the Open Network. This information should be provided via a Product Feed.
To create a Product Feed:
1. Click to download a sample CSV file. You should format the file with UTF-8 encoding, and with no byte order mark (BOM).
2. Edit the sample file you downloaded with your own product catalog information, keeping the PowerReviews' field names as column headers.
3. Upload your file to your own SFTP, the PowerReviews-provided SFTP, or provide a public URL. If you choose to use your own SFTP, provide PowerReviews the necessary location and credentials required to access the file. If you wish to use the PowerReviews-provided SFTP (best practice) and do not have your credentials, please reach out to your Account Team.
Required Fields
The fields listed in the table below are required for every PowerReviews Product Feed import. Match the exact spelling and formatting to ensure your code is accurate.
| Field | Example | Description | Length | Additional Notes |
| page_id | 439178561578 | The unique product identifier; typically the product, id, SKU, style number, item number, or UPC. This field is case-sensitive and should not include spaces. As a best practice, you should only use alphanumeric characters in your page_id, however, PowerReviews still supports the use of hyphens and underscores. | Up to 50 characters |
|
| product_url |
http://www.example.com/ |
The URL of the product detail page on your website. | Up to 650 characters | This field shouldn't contain spaces. |
| name | Widget1 | The name of the product. | Up to 500 characters | Encode all special characters. |
| image_url | http://www.example/com/ image/1234.jpg |
The URL of the product image. Ensure you use a high-quality image. It's best practice to not use special characters in your image URL and name without URL encoding the name. | Up to 650 characters. | The image should be at least 350 pixels in one dimension. |
| description | A superior widget for every requirement. An essential part of any widget collection. | The long product description. HTML markup shouldn't be included in the description. | No limit | You must escape all double quotes. If your data contains special characters, ensure you enclose the entire value in quotes. |
| category | Shoes > Sandals | The product's inventory classification. To indicate a hierarchy, use the greater than (>) symbol as a delimiter between categories, similar to the example. Depending on your website's navigation model, the inventory classification may correspond to navigation categories. | Up to 300 characters | |
| brand | Samsung | The product brand. This value must accurately match the brand name given on your website. | Up to 50 characters | |
| upc | 872760558488 (upc) or 0872760558488 (ean) |
The 12-digit Universal Product Code or the 13-digit International Article Number. | Must be 12 or 13 numeric characters. | |
| manufacturer_id | xlslmpprod-1790001-a | The manufacturer model number. | No limit |
Note: You must escape all double quotes in the 'description' field. If your data contains special characters, ensure you enclose the entire value in quotes.
UGC Integration
To ingest your UGC into PowerReviews for Syndication to retailers, we require a CSV file containing all required fields. This is the only format we are able to accept for this process.
1. Click to download a sample CSV file. You should format the file with UTF-8 encoding, and with no byte order mark (BOM).
2. Edit the sample file you downloaded with your own UGC information, keeping the PowerReviews' field names as column headers.
3. Upload your file to your own SFTP, the PowerReviews-provided SFTP, or provide a public URL. If you choose to use your own SFTP, provide PowerReviews the necessary location and credentials required to access the file. If you wish to use the PowerReviews-provided SFTP (best practice) and do not have your credentials, please reach out to your Account Team.
Required Fields
You must provide the following fields in your file for PowerReviews to be able to import your data.
| Field | Permitted Values | Description |
| Review Id | String | The unique ID for the review |
| Page Id | String. The maximum length for this value is 50 characters. | The unique ID for the product |
| Review Display | String. The maximum length for this value is 40 characters. | The user's nickname on the review |
| Review Title | String. The maximum length for this value is 60 characters. | The user-entered review title |
| Review Date | Date. Use MM/DD/YYYY or any other valid date format. | The date the user wrote the review |
| Review Location | String. The maximum length for this value is 40 characters. | The physical location of the reviewer |
| Review Text | String | The main body or comments on the review |
| Rating | 1-5. Whole numbers only. | The star rating value |
| Verified Buyer | Yes/No | States whether or not the user is a verified buyer |
| Review Status | Approved, Pending, or Rejected | Valid status of the review |
Optional Fields
You may also include any of the following optional fields in your file.
| Field | Permitted Values | Description |
| Locale | Valid locale like en_US, de_DE, or es_MX. | The language locale of the collected reviews |
| Recommended | Yes/No | States whether or not the user would recommend the product to a friend |
| Helpful Votes | Numeric, non-negative | The number of users who voted that the review was helpful |
| Not Helpful Votes | Numeric, non-negative | The number of users who voted that the review wasn't helpful |
| User ID | String | Your unique ID for the user. Leave this blank if the reviewers weren't authenticated before writing the review. |
| Service Comments | String | The customer service or delivery comments associated to the user experience |
| User Email | Valid email | The reviewer's email address |
| Images | Valid external URL list | A pipe separated list of image URLs associated with the review |
| Image Captions | Alphanumeric list | A pipe separated list of image titles and/or captions associated with the review |
| IP Address | Valid IP Address | The IP address of the reviewer. This field is required for Syndication |
| IovationBlackBox | String | The authentication information from iOvation. This field may be required for Syndication. |
| Pros | Valid Pros list | A pipe separated list of pros associated with the review |
| Cons | Valid Cons list | A pipe separated list of cons associated with the review |
| Merchant Response | String | The merchant's response provided to the reviewer to appear along with the review |
| Variant | String | The variant ID of the product |
| Videos | Valid YouTube list | A pipe separated list of YouTube URLs associated with the review |
| Video Captions | Alphanumeric list | A pipe separated list of video titles and/or captions associated with the review |
| Disclosure Code | String | Accepted values are sampling and sweepstakes |
If you have any questions regarding these Syndication requirements, contact your PowerReviews Account Team.