d1m007 / gshoppingflux

PrestaShop Google Shopping Flux Module
98 stars 61 forks source link

Product Review XML file Generation #113

Open Caprineal opened 1 week ago

Caprineal commented 1 week ago

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

Ashley-Butcher commented 1 week ago

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 commented 1 week ago

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 commented 1 week ago

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 commented 1 week ago

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 commented 1 week ago

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 commented 1 week ago

Hi @cdigruttola Carmine,

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

cdigruttola commented 1 week ago

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

Caprineal commented 1 week ago

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 commented 6 days ago

Hi @Caprineal,

I added a new section reviews to create the file.

Carmine

Caprineal commented 6 days ago

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 commented 6 days ago

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

Screenshot 2024-10-23 at 11 11 04
Caprineal commented 6 days ago

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

Caprineal commented 6 days ago

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 commented 6 days ago

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

Caprineal commented 6 days ago

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 commented 6 days ago

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 commented 6 days ago

Hi,

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

Caprineal commented 5 days ago

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 commented 5 days ago

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

Caprineal commented 5 days ago

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 commented 5 days ago

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 commented 5 days ago

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 commented 1 day ago

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

Caprineal commented 1 day ago

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

Caprineal commented 1 day ago

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

cdigruttola commented 1 day ago

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

Caprineal commented 18 hours ago

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 commented 14 hours ago

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 commented 13 hours ago

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 commented 13 hours ago

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 commented 12 hours ago

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 commented 7 hours ago

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