This article discusses how to implement a PowerReviews-Specific Product Feed. To learn more about leveraging a Google Merchant Product Feed instead, click here. To learn more about Product Feeds and their features and considerations, click here.
This article contains the following sections:
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.
|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.
PowerReviews uses API calls to gather data. 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||This field is also used by the Follow-Up Email Order Data.|
|The URL of the product detail page on your website. If your participate in Google PLAs, provide canonical URLs or consider sending PowerReviews your Google Merchant Product Feed.||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.|
|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.|
|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.||This field is required if you participate in Syndication.|
|upc||872760558488 (upc) or 0872760558488 (ean)||The 12-digit Universal Product Code or the 13-digit International Article Number. If you participate in Google PLAs, this field is required. You can also send PowerReviews your Google Merchant Product Feed.||Must be 12 or 13 numeric characters.||
This field is required if you participate in Syndication.
Only one UPC is supported per product. If you have multiple UPCs, you will need to include a line for each variant. To learn more about variants, please see Page IDs and Page ID Variants.
|manufacturer_id||xlslmpprod-1790001-a||The manufacturer model number.||No limit.||This field is required if you participate in Syndication.|
The fields listed in the table below are optional for every PowerReviews Product Feed import. If you elect to use them, match the exact spelling and formatting to ensure your code is accurate.
|page_id_variant||1234_blue||The variant of the product. This field is used primarily when the page_id has multiple item-level variants such as color or quantities. For more information on how to include variants in your Product Feed, see Page IDs & Page ID Variants.||Up to 50 characters|
|The hyperlink to add the product to the customer's cart.||Up to 650 characters|
|in_stock||1||The indication of in-stock status of the product. A value of 0 indicates no, and a value of 1 indicates yes.||1 character|
|price||1099.99||The current selling price of the item. International currency formatting isn't supported. Include the decimal point in the price, but don't include any dollar signs or commas.||Up to 650 characters|
|asin||B00005N5PF||Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters and/or numbers that identify items - used for the Share to Amazon feature.||Must be 10 characters|
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.||up to 10,000 characters.||You must escape all double quotes. If your data contains special characters, ensure you enclose the entire value in quotes. Do not include HTML or line breaks.|
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.
Creating Your Product Feed
1. Prepare your file to send to PowerReviews, noting the requirements above. You should format the file with UTF-8 encoding, and with no byte order mark (BOM).
- Click to download a Product Feed sample CSV file.
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 Implementation Team or PowerReviews Technical Support to request them.
- Ensure that the filename and location are static. When we configure the Product Feed import on our backend, it relies on looking for the same file each time. If you need to rename your file or move it to another location, you will need to contact us when this occurs so that we can update your configuration.
5. Once you've completed these steps, please reach out to your Implementation Team or PowerReviews Technical Support to request that we configure your Product Feed for import into our system.
We highly recommend that you automate this process on your end, to ensure that whenever your product information changes we receive that data in an updated Product Feed file automatically. Otherwise, it will be important to make sure that the file is updated manually and placed in the location where we are looking for it on a recurring basis.
Processing Your Product Feed
Product Feeds are typically processed every 48 hours. If you upload a new Product Feed, please allow this time for any changes to be imported into our system. If, after that time, you do not see your updates to your data, please contact your Implementation Team or PowerReviews Technical Support so that we can ensure that this process was triggered.