AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
3.9K members online now
3.9K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Google Merchant Center Product Reviews - Issues With Review URL using Parameters

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

We are doing a manual upload of a reviews feed - about 50 reviews we're testing out. After submitting, we get this error :

An XML entity reference did not end with a semicolon. 

It is linked to the first Review URL in the XML feed. It specifically points to a "=" in the URL; see: https://mywebsite.com/ReviewsList.asp?SortBy=Oldest&Page=1&ProductCode=PRODUCT-CODE&Reviews=Y

 

Is there a way to address this in the feed or are URLs that use these types of parameters not accepted in the XML feed?

 

Thanks!

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Nick D
September

Google Merchant Center Product Reviews - Issues With Review URL using Parameters

Top Contributor
# 4
Top Contributor

You need to use CDATA to encapsulate the element data. As currently the review_url_type is not valid XML

 

https://en.wikipedia.org/wiki/CDATA

 

Hope it helps.

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

View solution in original post

Google Merchant Center Product Reviews - Issues With Review URL using Parameters

Top Contributor
# 2
Top Contributor

The provided link is not valid.

 

I recommend you review your XML document to ensure there are no errors and encoding issues.

 

If you provide us with the file, we might be able to assist.

 

Hope it helps.

 

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

Re: Google Merchant Center Product Reviews - Issues With Review URL using Parameters

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Emmanual, 

 

I removed our client specific information from the URL for privacy reasons - the actual URL is valid. The only issue I am getting after uploading the feed is the one I mentioned, which I now feel is caused by the dynamic parameters in the URL, specifically where the parameters are using the "&". I have uploaded other Review feeds in the past and have had successful uploads. I've included an example of the feed that I am uploading (removing any client-specific information) - the actual feed has 50 reviews in it.

 

<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:noNamespaceSchemaLocation=
 "http://www.google.com/shopping/reviews/schema/product/2.1/product_reviews.xsd">
    <aggregator>
        <name>Manual Reviews Aggregator</name>
    </aggregator>
    <publisher>
        <name>CLIENT NAME</name>
    </publisher>
    <reviews>
        <reviewer>
            <name>CUSTOMER NAME</name>
        </reviewer>
        <review>
           <review_timestamp>2009-06-30T00:00:00</review_timestamp>
            <title>REVIEW TITLE</title>
            <content>I want to thank you for getting the product to me so fast! They are exactly what I needed</content>
            <review_url type="group">
https://www.mywebsit.com/ReviewsList.asp?SortBy=Oldest&Page=1&ProductCode=product-MPN&Reviews=Y</review_url>
 <ratings>
                <overall min="1" max="5">5</overall>
            </ratings>
            <products>
                <product>
                    <product_ids>
                        <mpns>
                            <mpn>product-MPN</mpn></mpns>
</brand></brands>
</product_ids>
<product_url>https://www.mywebsite.com/product-page-url.htm</product_url>
                </product>
            </products>
        </review>    
    </reviews>
</feed>

Thanks for the help!

Marked as Best Answer.
Solution
Accepted by topic author Nick D
September

Google Merchant Center Product Reviews - Issues With Review URL using Parameters

Top Contributor
# 4
Top Contributor

You need to use CDATA to encapsulate the element data. As currently the review_url_type is not valid XML

 

https://en.wikipedia.org/wiki/CDATA

 

Hope it helps.

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

Google Merchant Center Product Reviews - Issues With Review URL using Parameters

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi Emmanual, 

 

Looks like that did the trick!

 

Thanks!