Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

DivaVocals:

The SUPPORT THREAD for this module is NOT the right place to ask opinions about a COMPETING module.. IJS..

Sorry, didn't realize this was a support thread for only one product, I was just looking for a place to ask and found this under the All Other Contributions/Addons. My mistake.

Jim

thanks for the reply

yes there is more infront of the url but i removed that as holds potentally sensitive data etc. I dont have a cron for the Site maps as i tend to do that manually on an evening as its only a button press, but seems i have to create 10 xml files for my google product feed, id like it as a cron as it does take time.

i tried alot of wget and s curl etc etc etc, ill try them all again and see what i get. Will also try the URL as well to see if that fixes my issue, will report back next week

I have this installed in 1.5.1 on a Linux server

I'm curious as to the file name this feed produces. Should it be:

froogle_products_en.xml_products_en.xml

I've looked into the code in case this is a duplication issue but can't find anything. If i change the name it matches my feed name at google and all is well.

any insights appreciated.

I just have to say, THANK YOU FOR THIS MOD. I've been using varieties of it for years and this is the slickest!

I have another error that i have found...

many of my products on google are being disapproved as images are missing. I have checked the feed and checked the error and it showing my images in the location https://www.mysite.com/images/image.jpg however i have product images in subfolders ie https://www.mysite.com/images/brand/image.jpg how can i fix this error??

anyone??

The source of the file name is still a mystery to me. Anyone?

athena:

I have this installed in 1.5.1 on a Linux server

I'm curious as to the file name this feed produces. Should it be:

froogle_products_en.xml_products_en.xml

I've looked into the code in case this is a duplication issue but can't find anything. If i change the name it matches my feed name at google and all is well.

any insights appreciated.

I just have to say, THANK YOU FOR THIS MOD. I've been using varieties of it for years and this is the slickest!

Just to clairify, the name of my file in the Admin > Configuration > Output file name is correct:

froogle_products_en.xml

but when the feed is produced, it has the duplicate file name: froogle_products_en.xml_products_en.xml

athena:

Just to clairify, the name of my file in the Admin > Configuration > Output file name is correct:

froogle_products_en.xml
Actually it's not.. Your entry in "Admin > Configuration > Output File Name" should be JUST "froogle". The resulting file name will then be froogle_products_en.xml. (as you can see the module appends "_products_en.xml" to the Output File Name setting)

athena:

but when the feed is produced, it has the duplicate file name: froogle_products_en.xml_products_en.xml

OK... I'm an idiot! Knew it had to be something that stupid! West coast girls weren't designed for these long winters...

we must have posted about the same time... it just dawned on me during a cup of tea... but thank you for indulging my lapse...

I have searched this thread and cannot find any posts on this same set of symptoms..
Zen Cart v 1.3.9
Google Merchant Center Feeder v1.14.2

The feed APPEARS to run.. I get a message saying it was created successfully, but there is NO FILE in the feed/google folder.

Google Merchant Center Feeder v1.14.2 started 2014/03/07 23:26:56
Feed file - /home/XXXXXXX/public_html/shop/feed/google/our-company_products_en_500.xml

Processing: Feed - Yes, Upload - No

No error logs. I don't begin to know what to look for.. Any ideas???

Hi all and please help

We have the Google merchant feeder on our new 1.5.1 website. Our products are being disapproved by Google Merchants because the URLs are displaying '&' in the URL as '&'

The thing is using http://shaftdirect.com/index.php?main_page=product_info&products_id=2&language=en&currency=GBP as an example, there is no such URL. However with the '&' there is.

I have tried everything! I have tried <![CDATA[ ]]> &, Google Support, everything and this is just a vicious circle

This was working fine in 1.3.9 and on this one is just hates us :cry: Please could anyone help?

Thanks in advance.

Hi

We have a problem with our feed in that we show both with and without VAT in the shop but have had to set it back to just show prices with VAT in the shop due to the feed being rejected by Google. How can we set the feed to send with VAT prices to Google whilst allowing us to show both with and without VAT in the shop?

Thanks

Hello Everyone,

I am using Zencart 1.50 and the latest version of Google Merchant Feeder. Other than time out and memory issues..., My biggest problem is that it will not generate any product feeds for items with Product ID's over 20000. *(From 1 to 20000 it will generate files in batches of 500 to 1000 or so). *

Normally, I would just Switch the Product ID's of the items over 20000 with products that are not as important and have a lower Product ID number. However, my Product ID's from around 20000 to about 28000 have NUMEROUS attributes associated with them and swapping them would be a nightmare.

So, my question is... Is there a way to increase the number of product ID's and/or the max limit of Product ID's that this plugin can process?

Thanks All,
Danny

Hello.

I cannot get the weight attribute to come through the Google Feed.

Thanx

Hi,

I have installed this module and so far it works great. Now I need to add a field (required by Google) to the products, the Gtin fields. I don't need it to be displayed in the store, just in the admin part when modifing the products.

What I did:

• I added the filed in the products TABLE, same properties as products_model, so i have the products_gtin field.

• Modified the files in /admin/includes/modules/product according to this instructions : How-To: Add new Properties to your Products

• Tested and work fine, i'm able to see, modify and save the new data

• Modified the file of the add-on /includes/class/google_base.php adding few lines as stated in the reply #107 (just changed the "products_model" to match my need):

if ($products->fields['products_gtin'] != '') {
$gtin = $dom->createElement('g:gtin');
$gtin->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_gtin'])));
$item->appendChild($gtin);

• I also added a few line before, cause i need also a mpn number in the feed: ```php
  if ($products->fields['products_model'] != '') {
  $gtin = $dom->createElement('g:gtin');
  $gtin->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_model'])));
  $item->appendChild($gtin);

Now when i generate the feed, i got the model number like:
<g:mpn>
<![CDATA[ INCBAL1500000 ]]>
</g:mpn>

But the gtin is always void like:
<g:gtin>
<![CDATA[ ]]>
</g:gtin>

What am I missing? Feel like i'm not seeing an elephant behind a pole :(

izar74,
your code and the results does not make sense. first off, are you sure you have the proper closing curly bracket '}' for each if statement?

second, your products_model looks wrong. from the feed output, i see an XML element called <g:mpn>; but you are not creating that in the code that i see here. these lines:

if ($products->fields['products_model'] != '') {
$gtin = $dom->createElement('g:gtin');
$gtin->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_model'])));
$item->appendChild($gtin);

would more appropriately be:

if ($products->fields['products_model'] != '') {
$mpn = $dom->createElement('g:mpn');
$mpn->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_model'])));
$item->appendChild($mpn);
}

you can reuse the variable $gtin, but for product model, it looks like you need g:mpn in the createElement line....

again, i am not sure how you got the output that you did based on the code supplied, but i would definitely look into the closing curly braces to start and some of the other things i mentioned.

hope that helps.

Hi,
zen cart 1.51 and google merchant center feeder 1.14.2
Suddenly without any apparent reason all the accented words are now like this for è "è" without ""
Google merchant center is refusing all the products containing that garbage.
Anyone has knews about? Is this a google problem or my server problem?
Up to may 5th the problem was not there, now 81 products are not used by google merchant center.
Please help if possible.
Thanks
ciao from Italy
enzo

Hi againg,
firts Enzo look if the option "Enable Advanced XML Sanitization" is "true" if not change it. The problem is related to charset.

Carl thanks for your advice, the code i posted is not the one i'm using... i was probably confused by a file i was working on... here is the code actually used:

      // only include if less then 30 days as 30 is the max and leaving blank will default to the max
      if (GOOGLE_PRODUCTS_EXPIRATION_DAYS <= 29) {
        $item->appendChild($dom->createElement('g:expiration_date', $this->google_base_expiration_date($products->fields['base_date'])));
      }
        $item->appendChild($dom->createElement('link', $link));
      if ($products->fields['products_model'] != '') {
        $mpn = $dom->createElement('g:mpn');
        $mpn->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_model'])));
        $item->appendChild($mpn);
      }
      if ($products->fields['products_gtin'] != '') {
        $gtin = $dom->createElement('g:gtin');
        $gtin->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_gtin'])));
        $item->appendChild($gtin);
      }

This is the code around line 388-402 of /includes/classes/google_base.php
the output is exactly as i wrote and like this:
<g:mpn>

</g:mpn>
<g:gtin>

</g:gtin>

The problem as You can see is that i got the gtin void even if in the database it has a value

I forgot another thing :P
I've some products that i DON'T want to be listed in the XML, i was thinking that a IF statement checking for the ID of the article would be a easy solution, to put it simply It should be something like :
If the products_Id ="XXX" skip it.
Is that doable? Any suggestion would be appreciated :D

izar74:

Hi againg,
firts Enzo look if the option "Enable Advanced XML Sanitization" is "true" if not change it. The problem is related to charset.
Thanks for your answer.
Unfortunately it is not.
The sanitization is enabled, I tryed to disable but I get this error

This page contains the following errors:
error on line 110 at column 29: Encoding error.

Since yesterday the feed became corrupted for all the accented words but no changes was made to the setting or the core files.
For istance:

"ù has become ù"
"à has become à"
Without the ""

Thanks for your help.
enzo