This article discusses how to troubleshoot your Product Feed. To learn more about implementing a Product Feed, click here.
If you are leveraging a non-Google Product Feed to pass your products to PowerReviews, there are steps you can take to ensure the feed will be able to be ingested without issue. These steps can minimize the need to make corrections to the file after your Implementation Team reviews it.
Validating Your Product Feed File Type and Encoding
PowerReviews accepts .csv (comma-separated values) file type for Product Feeds. Additionally, these files should be UTF-8 encoded without a BOM.
Escaping Double Quotes
In some cases, you may have fields which contain double quotes (such as indicating the size of a product in inches). In this case, it is necessary to escape your double quotes.
5" Super Widget
This should be encoded as:
5\" Super Widget
Please ensure you are escaping all double quotes throughout the entirety of your Product Feed file.
Wrapping Fields that May Contain Commas
Often in Product Feeds, fields like name or description may contain commas. Because we use comma-separated values for Product Feeds, it is important to wrap these fields in double quotes to ensure those commas do not break the file parsing.
"Our granola is fat free, sugar free, and gluten free!"