Product Review XML file Generation

[Caprineal]

How to make this work for Product Review XML feed for Google Merchant Centre Review Data Source Feed?

[Ashley-Butcher]

Maybe it's not very helpful, but I modded gshoppingflux a while back (version 1.7.3) to include extensions for Google Merchant Centre and Facebook... I always had the intention of doing pull requests for the changes but.. uhh.. life got in the way.

If it's any use to you, I've added a patch file here. There's only a few minor changes to add a few extra required fields.

gshoppingflux.php-1.7.3-gmc-facebook.patch

[Caprineal]

Well Ashley, I understand your point. But my main issue with this module file is, though it send all the required product data to google merchant centre, except the Product Reviews/Ratings. It would be amazing if we can solve this. Or we can modify the code? Or add additional fields for Product Ratings as per Google Schema?

[Ashley-Butcher]

I'm not from this project, so I can't make any decisions on how the module will change, but yes it's a simple change to add a new field to send to GMC. The difficulty for reviews is that they are usually added to a site by another module, specific for reviews, so the question will come down to which module(s) to support. My client doesn't have product reviews/ratings on their shop, so I can't comment. I think it's up to the project maintainers to remark on this one.

[Caprineal]

My client uses a third party module, I have details about it. Can you suggest how/where to add/edit the module file so that it can produce/export the Review/Rating XML file which they can further feedback to GMC.

[cdigruttola]

Hi @Caprineal,

I forked the repo in https://github.com/cdigruttola/gshoppingflux/. I can add the new feed, could you confirm that are you refering to https://support.google.com/merchants/answer/14620732?hl=en?

Thanks,
Carmine

[Caprineal]

Hi @cdigruttola Carmine,

Yes, we are referring the same Google Merchant Product Review Feed Topic, Confirmed 👍

[cdigruttola]

Hi @Caprineal,
you can see the new feed in the repo https://github.com/cdigruttola/gshoppingflux/
Carmine

[Caprineal]

Hey @cdigruttola,
I havnt tried it, let me try it first. I will update the response here, so can you please elaborate what all changes you did within this repo to make it work for reviews in GMC too?

[cdigruttola]

Hi @Caprineal,

I added a new section reviews to create the file.

Carmine

[Caprineal]

Hey @cdigruttola,

I really appreciate efforts you have made, but when we tried it, it surely adds another field to export one more XML file, but the XML file it generates is for the "Local Inventory", not for the product reviews. When we give it a name, and Save & Export, it generates an XML file which is for the Product ID, Product Price, Product Discount Price in this format "https://yourdomain.com/[BB_googleshopping-local-inventory-s1-en-INR.xml & the other file is https://yourdomain.com/[BB_googleshopping-s1-en-INR.xml](https://brownboi.in/BB_googleshopping-s1-en-INR.xml ....you need to check on this and try adding that it gets the data from Prestashop Product comment from its native inbuilt module & or from a third party review module.

[cdigruttola]

Can you see this section? You have to use my fork.

[Caprineal]

Hey @cdigruttola OMG,
I did not notice that, can you please elaborate it more to me? i simply updated the module.

[Caprineal]

Hey @cdigruttola ,
I did use your fork, i can now see the reviews section, but the problem i am facing is, this is picking only few reviews which were captured by native prestashop module at the time we launched our store. Later we started collecting reviews by some third party providers like Yotpo & REVWS by Datakick which are supported by google as well. So how can we make your fork work in such a way so that it picks the thousands of Verified Reviews from that third party module & export it into the Review XML file? waiting on you, and i really appreciate your great work :)

[cdigruttola]

Hi @Caprineal,
this appears to be more complicated and require more effort. I can think about it.
Carmine

[Caprineal]

Hi @cdigruttola ,
That would be a great help for us, or if you can suggest a code which we can insert in our review module, which can generate the XML file within itself? Instead of letting other module to fetch it? I guess this would be a better choice. What do you think?

[Caprineal]

Hi @cdigruttola,
FYI, our Product Review Module is integrated with Prestashop's Native code line. It also has a public URL where all these thousands of Reviews are sitting & can be viewed by the public. Does that make any sense? Can this Shopping flux Review Section Fetch the Review data from there? We tried another module to fetch the XML file of all the Reviews it got the success and pulled almost 99% reviews but it doesn't know the Google Schema for product Review. Hence we got stuck.

[cdigruttola]

Hi,

What is the other module you tried? What is the module you are using for the review?
Can you link them?

[Caprineal]

Hey @cdigruttola ,
The name of the module is Revws by DataKick, i figured out, it generates the XML file of all the Reviews in its database and has an Import feature as well from prestashop main "Product Comment" native module. I treid exporting the XML review file from our REWVS module, it did generate, but the issue is, it did not follow the Google Merchant Schema, where as , when i tried your XML it clearly shows the google Merchant Centre (GMC) Schema. anything which we can do in order to update this Raw XML data into our gshoppingflux module? or vice-versa?

[cdigruttola]

Hi @Caprineal,
are you referring to https://github.com/getdatakick/revws?

[Caprineal]

Hey @cdigruttola ,
Yes , this is the one, sorry i did not read your entire message. We are using this. It has the feature of exporting the XML files of all the reviews, but not on the GMC standard.

[cdigruttola]

Hi @Caprineal,
I can try to analyze their module and try to modify my fork to add the reviews, this can take some times.

[Caprineal]

Hey @cdigruttola ,
Sure please take your time, I really appreciate your efforts & the logical skills. I am awaiting on you. We just need their Module "DataKick Revws" to export the Product review XML file in GMC schema, the same way you did in gshoppingflux.

[cdigruttola]

Hi @Caprineal,
in the fork you can find the updated version of the module.
Please test it to ensure everithing is correct.

[Caprineal]

Hey @cdigruttola,
Let me further check it. I will update you in a while. Hoping it works fine.

[Caprineal]

I couldn't find your fork into Datakick>Revws Module. Can you send me the direct link?

[cdigruttola]

Hi @Caprineal,
please check https://github.com/cdigruttola/gshoppingflux/. I added the reviews in this repo.

[Caprineal]

Hey @cdigruttola , I tried the updated Repo with your Fork, it now generates all the Reviews from DataKick>Revws Module, it can fetch the data, but final XML file is showing XML parse Error, "This page contains the following errors:
error on line 2011 at column 29: xmlParseEntityRef: no name
Below is a rendering of the page up to the first error."

above error code in Red, and i dont see those google Schema as it was shown earlier with your last Fork.

and when we see the XML data, it is unable to generate the Product URL , it instead generates this "https://yourdomain.com/Products/16-Array.html"

[cdigruttola]

Hi @Caprineal,

to better understand what's going wrong, I need to check your backoffice and your db to better understand what's going wrong.

[Caprineal]

Ok @cdigruttola,

We will work on that. Let me tell you, your Fork, can now fetch few modules data including "Datakick Revws" module's reviews as well. But when it generates the XML file, it doesn't have any Google Schema Format. When we access other XML files, they have a format. But this one is not collecting required fields as per the Google Schema. It's just the raw data without any XML format. If that helps you understanding?

[cdigruttola]

Hi @Caprineal,

I'm sorry but I cannot understand. My fork actually works with productcomments and revws modules.
I wrote the two queries to extract information from this two modules. The two queries extract the same information that I use to create the XML in the Google Schema Format.

I need to check the output of my fork and also the products that are causing the error.

[Caprineal]

Okay, Sure. I got it, I will give you the access, i will make your credentials. So that you can check it across. Allow me some time for that.

[cdigruttola]

Hi @Caprineal,
you can email me, please find the email in the github bio.