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

[dharrison]

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?mai...p;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 Please could anyone help?

Thanks in advance.

[gsb2007]

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

[danielosko]

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

[compserv]

Hello.

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

Thanx

[izar74]

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:

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

[carlwhat]

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.

[enzo-ita]

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

[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.

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>
<![CDATA[ INCBAL1500000 ]]>
</g:mpn>
<g:gtin>
<![CDATA[ ]]>
</g:gtin>

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

[izar74]

I forgot another thing
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

[enzo-ita]

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:

"&#249; has become &#195;&#185;"
"&#224; has become &#195;&#160;"
Without the ""

Thanks for your help.
enzo