Google Base Feeder Support Thread [OLD]

[khopek]

The last 3 weeks I have tried to create and upload a new feed to Google Base and the upload fails every time. It's worked perfect up until recently. Was there an update to the mod or Google Base? What else would cause this?

[milkyway]

We have a tax problem with Google Base generated file, we export the file and checked is using MS Excel.

In the last column (tax), only certain products has tax, in addition we have Illinois tax setup in our admin. This applies to all prodducts, but in Google base generated file, almost 60% of theproducts doesn't have their tax, it is just blank.

Anyone can give us a hint?

Thanks!

[fusionsp]

ok i have seen tons of ppl talking about the connection issue with google base. But i have yet to see a solution?

not that it matters because I just scheduled google to fetch my feed, but this module cannot connect to google?

everything creates fine, but connection to google fails? So, if I scheduled google base to fetch this file itself then does it really mater if this wont connect on its own?

[countrycharm]

ok i have seen tons of ppl talking about the connection issue with google base. But i have yet to see a solution?

not that it matters because I just scheduled google to fetch my feed, but this module cannot connect to google?

everything creates fine, but connection to google fails? So, if I scheduled google base to fetch this file itself then does it really mater if this wont connect on its own?

Scheduling Google to fetch it is ever bodies best bet. As long as Google will do that their no since in worrying about doing it yourself.

[kburner]

Scheduling Google to fetch it is ever bodies best bet. As long as Google will do that their no since in worrying about doing it yourself.

How did you get Google to do it? How do I apply?
I have account. And the only thing I have seen is where you do the manual load. And that does not work. Only gives 29 products out of about 10,000.

Thanks, Kim

[fusionsp]

How did you get Google to do it? How do I apply?
I have account. And the only thing I have seen is where you do the manual load. And that does not work. Only gives 29 products out of about 10,000.

Thanks, Kim

when you register your data feed. Next to the feed is a option that says schedule. it pops open a new window and its a simplified version of the cron job. Then you link it back to where the feed is located...and there it is, like someone else said it lightens the load on your server.

and yea, I am having to figure out what products of mine that did not enter yet. I have 850 and it gave me 785. But looking thru here, it could be lots of reasons. Too short desc, etc.

hope that helps

[fusionsp]

Its all working now, but as I go thru all the products it uploaded I am noticing that the feed missed some items.

I have to manually change some items??

• payments accepted
• local pick up--on or off

its showing missing attributes?

[countrycharm]

How did you get Google to do it? How do I apply?
I have account. And the only thing I have seen is where you do the manual load. And that does not work. Only gives 29 products out of about 10,000.

Thanks, Kim

I am running the latest version of Google Base 1.7.3 but Google wasn't excepting all my product, so I replaced this portion of the sanitizer code in includes/classes/google_base.php in 1.7.3A with the one from 1.7.0
This is the difference in \includes\classes\google_base.php
Here is the section from 1.7.0a

function google_base_xml_sanitizer($str, $cdata = false) {
$_strip_search = array("![\t ]+$|^[\t ]+!m",'%[\r\n]+%m'); // remove CRs and newlines
$_strip_replace = array('',' ');
$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "\t" => "", " " => "");
$str = html_entity_decode($str);
$str = strtr($str, $_cleaner_array);
$str = preg_replace($_strip_search, $_strip_replace, $str);
$str = strip_tags($str);
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?äÂÄöÖüÜß]", "", $str);
$str = utf8_encode(htmlentities($str));
//$str = $str;
$str = str_replace('&', '&', $str);
//if (!$cdata) {
//$str = htmlentities(html_entity_decode($str));
//$in = $out = array();
//$in[] = "®"; $out[] = '(r)';
//$in[] = "©"; $out[] = '(c)';
//$in[] = "™"; $out[] = '(tm)';
//$str = html_translate($str);
$str = trim($str);
if ($cdata) {
$str = '<![CDATA[' . $str . ']]>';
}
return $str;
}

Here is the section from 1.7.3

function google_base_xml_sanitizer($str, $cdata = false) {
$str = str_replace(array("\t" , "\n", "\r"), ' ', $str);
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?äÂÄöÖüÜß]", "", $str);
$str = htmlentities(html_entity_decode($str));
$str = utf8_encode(str_replace(array("&reg;", "&copy;", "&trade;"), array('(r)', '(c)', '(tm)'), $str));
$str = $this->real_strip_tags($str, array('br', 'p'), false);
$out = "";
$length = strlen($str);
for ($i = 0; $i < $length; $i++) {
$current = ord($str{$i});
if ( (($current == 0x9) || ($current == 0xA) || ($current == 0xD) || (($current >= 0x20) && ($current <= 0xD7FF)) || (($current >= 0xE000) && ($current <= 0xFFFD)) || (($current >= 0x10000) && ($current <= 0x10FFFF))) && ($current > 10) ) {
$out .= chr($current);
} else {
$out .= " ";
}
}
$str = trim($out);
$str = str_replace(array("&lt;", "&gt;"), array("<", ">"), $str);
if ($cdata) {
$str = '<![CDATA[' . $str . ']]>';
}
return $str;
}

function real_strip_tags($i_html, $i_allowedtags = array(), $i_trimtext = FALSE) {
if (!is_array($i_allowedtags))
$i_allowedtags = !empty($i_allowedtags) ? array($i_allowedtags) : array();
$tags = implode('|', $i_allowedtags);

if (empty($tags))
$tags = '[a-z]+';

preg_match_all('@</?\s*(' . $tags . ')(\s+[a-z_]+=(\'[^\']+\'|"[^"]+"))*\s*/?>@i', $i_html, $matches);

$full_tags = $matches[0];
$tag_names = $matches[1];

foreach ($full_tags as $i => $full_tag) {
if (!in_array($tag_names[$i], $i_allowedtags))
if ($i_trimtext)
unset($full_tags[$i]);
else
$i_html = str_replace($full_tag, '', $i_html);
}

return $i_trimtext ? implode('', $full_tags) : $i_html;
}

After I replaced the portion of the sanitizer code in includes/classes/google_base.php in 1.7.3A with the one from 1.7.0 Now Google accepts all my products. I hope this help some of you out.

[fusionsp]

I am running the latest version of Google Base 1.7.3 but Google wasn't excepting all my product, so I replaced this portion of the sanitizer code in includes/classes/google_base.php in 1.7.3A with the one from 1.7.0
This is the difference in \includes\classes\google_base.php
Here is the section from 1.7.0a

Here is the section from 1.7.3


After I replaced the portion of the sanitizer code in includes/classes/google_base.php in 1.7.3A with the one from 1.7.0 Now Google accepts all my products. I hope this help some of you out.

Hmmm, now im confused? You say that the second section is from 1.7.3? Here is that version of mine that I got from numinix site. it stated that was also version 1.7.3 but it doesnt have the same info as yours. ??

    // sanitizes code for XML 
    function google_base_xml_sanitizer($str, $cdata = false) {
      $str = str_replace(array("\t" , "\n", "\r"), ' ', $str);
      $str = html_entity_decode($str);  
      $str = strip_tags($str);
      $str = htmlentities($str);
      $str = utf8_encode(str_replace(array("®", "©", "™", " "), array('(r)', '(c)', '(tm)', ' '), $str));
      $str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?ÀÂÄßÈÉÊËÎÏÔÖÙÛÜàâäèéêëîïôöùûüÿÇç«»]", "", $str);
      $out = "";
      $length = strlen($str);
      for ($i = 0; $i < $length; $i++) {
        $current = ord($str{$i});
        if ((($current == 0x9) || ($current == 0xA) || ($current == 0xD) || (($current >= 0x20) && ($current <= 0xD7FF)) || (($current >= 0xE000) && ($current <= 0xFFFD)) || (($current >= 0x10000) && ($current <= 0x10FFFF))) && ($current > 10) ) {
          $out .= chr($current);
        } else {
          $out .= " ";
        }
      }
      $str = trim($out);
      $str = str_replace(array("&lt;", "&gt;"), array("<", ">"), $str);
      if ($cdata) {
        $str = '<![CDATA[' . $str . ']]>';
      } 
      return $str;
    } 

after that section it goes into creating the url for the product image? So, what version do i have?