how to match reviews for variable products to product feed for google shopping

  • Hi,

    we are using your plugin to create two feeds for google to add our virtual products to google shopping:

    Feeds we are using:
    1) Google Shopping
    2) Google Product Review

    For standard products google is showing the average rating of our products in google shopping. This is working perfect.

    But for products with different variations reviews are unfortunately not visible in google shopping. Google shopping presents the parent product, but no reviews.

    Is there any possibility to configure the two feeds to ensure google can match reviews of variable products to the parent product? Or is this possible in paid version of the plugin?

    Settings for Google Shopping Feed:
    – Country: Germany
    – Channel: Google Shopping
    – Include all product variations: Yes
    – Only include default variation: no
    – Only include lowest price product variation: no
    – File format: XML

    Settings for Google Product Review feed:
    – Country: Germany
    – Channel: Google Product Review
    – Include all product variations: Yes
    – Only include default variation: no
    – Only include lowest price product variation: no
    – File format: XML

    Thanks in advance,
    Andreas

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi Andreas,

    Thanks for using our plugin and reaching out to us.

    The Google Shopping feed does not contain parent variable products as Google doesn’t allow so, please see: https://adtribes.io/can-i-add-mother-products-to-my-feed-and-leave-out-the-variations/, so the shopping feed only contains product variations. The same goes for your product review feed, this should only contain reviews attached to the variations and not to the parent products so therefor they really should match.

    Did you check your review feed already for the product ID of product variations and if those are in?

    Thread Starter raetseldetektive

    (@raetseldetektive)

    Hi,

    thanks for the quick answer. Yes, it looks like both my product and my review feed only contain variations and not the parent product. So this should be fine.

    Yes, I have checked the XML content of both feeds. In my point of view the product ID (MPN) should match in both streams. Have a look at example entries of my two feeds shown below. We are selling self created virtual products, so we do not have a gtin. But we of course have set a MPN and a brand. Could it be a problem that we have set MPN to same value as SKU?

    Product Feed:

    <g:title>
Piraten Schnitzeljagd: Die r?tselhafte Flaschenpost (verschiedene Altersklassen) 5-7 Jahre
</g:title>
<g:description>Variante 5-7 Jahre</g:description>
<g:link>
https://raetseldetektive.de/produkt/schnitzeljagd-die-raetselhafte-flaschenpost/?attribute_pa_variante=5-7-jahre&utm_source=Google%20Shopping&utm_campaign=Google%20Merchant&utm_medium=cpc&utm_term=35963
</g:link>
<g:image_link>
https://raetseldetektive.de/wp-content/uploads/2020/01/raetseldetektive.de_Schnitzeljagd_Pirat_Deckblatt.jpg
</g:image_link>
<g:availability>in stock</g:availability>
<g:price>EUR 15,99</g:price>
<g:google_product_category>8038</g:google_product_category>
<g:brand>R?tseldetektive</g:brand>
<g:mpn>SJ-4796-A</g:mpn>
<g:condition>New</g:condition>
<g:item_group_id>4796</g:item_group_id>
<g:identifier_exists>yes</g:identifier_exists>
</item>

    Review Feed:

    <review>
<review_id>86116</review_id>
<reviewer>
<name>Stephanie</name>
<reviewer_id>0</reviewer_id>
</reviewer>
<review_timestamp>2021-02-15T20:05:01Z</review_timestamp>
<title>
Piraten Schnitzeljagd: Die r?tselhafte Flaschenpost (verschiedene Altersklassen) 5-7 Jahre
</title>
<content>
Supertolles Preis-Leistungs-Verh?ltnis! Und mit ein bisschen Vorbereitung ein voller Erfolg!
</content>
<review_url type="singleton">
https://raetseldetektive.de/produkt/schnitzeljagd-die-raetselhafte-flaschenpost/?attribute_pa_variante=5-7-jahre&utm_source=Google%20Product%20Review&utm_campaign=google%20reviews&utm_medium=cpc&utm_term=35963
</review_url>
<ratings>
<overall min="1" max="5">5</overall>
</ratings>
<products>
<product>
<product_ids>
<mpns>
<mpn>SJ-4796-A</mpn>
</mpns>
<skus>
<sku>SJ-4796-A</sku>
</skus>
<brands>
<brand>R?tseldetektive</brand>
</brands>
</product_ids>
<product_name>
Piraten Schnitzeljagd: Die r?tselhafte Flaschenpost (verschiedene Altersklassen) 5-7 Jahre
</product_name>
<product_url>
https://raetseldetektive.de/produkt/schnitzeljagd-die-raetselhafte-flaschenpost/?attribute_pa_variante=5-7-jahreandamp;utm_source=Google%20Product%20Reviewandamp;utm_campaign=google%20reviewsandamp;utm_medium=cpcandamp;utm_term=35963
</product_url>
</product>
</products>
</review>

    Thanks in advance,
    Andreas

    Google matches Google Shopping feeds and review feeds either on GTIN or on MPN. In your case Google really should match the reviews on MPN however perhaps they are getting confused because you also added a SKU to your review feed that has the exact same value as the MPN field. So perhaps you should try removing the SKU from your review feed (bit of a long shot though).

    Thread Starter raetseldetektive

    (@raetseldetektive)

    Hi,

    thanks a lot for the help. We have adopted our review feed to exclude SKU 3 days ago. It seems to take a few days until google is updating the results.
    We will keep you updated if the SKU field was causing the issues or not.

    Thanks again for the very fast response for not yet paying customers, we really appreciate this ??

    Andreas

    Hi,

    Assuming the issue at hand has been resolved or our support is no longer required I am going to close this topic for housekeeping reasons now.

    Please do not hesitate to reach out to our support-team again whenever you need our help.

    Thread Starter raetseldetektive

    (@raetseldetektive)

    Hi again,

    sorry for not answering for about 2 weeks. We had the feeling, that google shopping did not update any of our products for quite some time (so amount of reviews per product did not increment after new reviews where added), therefore I was not able to tell if removing SKU fixed the problem or not.

    But unfortunately till today our products with variations still do not have any rating shown in google shopping, while others did in the meantime get updated ratings.

    Below again the same example entry from our review feed now without SKU. As reviews are added in woocommerce for the product and not for each variation, the identical review below is shown for three different MPNs in our feed (matching the three variations of the product). I guess this is normal, but just wanted to double check with you

    <review>
<review_id>86116</review_id>
<reviewer>
<name>Stephanie</name>
<reviewer_id>0</reviewer_id>
</reviewer>
<review_timestamp>2021-02-15T20:05:01Z</review_timestamp>
<title>
Piraten Schnitzeljagd: Die r?tselhafte Flaschenpost (verschiedene Altersklassen) 5-7 Jahre
</title>
<content>
Supertolles Preis-Leistungs-Verh?ltnis! Und mit ein bisschen Vorbereitung ein voller Erfolg!
</content>
<review_url type="singleton">
https://raetseldetektive.de/produkt/schnitzeljagd-die-raetselhafte-flaschenpost/?attribute_pa_variante=5-7-jahre&utm_source=Google%20Product%20Review&utm_campaign=google%20reviews&utm_medium=cpc&utm_term=35963
</review_url>
<ratings>
<overall min="1" max="5">5</overall>
</ratings>
<products>
<product>
<product_ids>
<mpns>
<mpn>SJ-4796-A</mpn>
</mpns>
<brands>
<brand>R?tseldetektive</brand>
</brands>
</product_ids>
<product_name>
Piraten Schnitzeljagd: Die r?tselhafte Flaschenpost (verschiedene Altersklassen) 5-7 Jahre
</product_name>
<product_url>
https://raetseldetektive.de/produkt/schnitzeljagd-die-raetselhafte-flaschenpost/?attribute_pa_variante=5-7-jahreandamp;utm_source=Google%20Product%20Reviewandamp;utm_campaign=google%20reviewsandamp;utm_medium=cpcandamp;utm_term=35963
</product_url>
</product>
</products>
</review>

    Thanks again,
    Andreas

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘how to match reviews for variable products to product feed for google shopping’ is closed to new replies.