Google Base Feeder Support Thread [OLD]

[jofera]

hello guys,

My problem is that when I set up "Español" language on the Google Merchant Feeder Configuration and run up feeder tool I get a blank page. I had uploaded languages files to Spanish dir (includes and admin ones) but it does not work for me.

If I let default language configuration (English), I can run the tool but all products description in English are empty, so obviously no one product is saved to file.

Google Merchant Center Feeder v1.9.0 started 2011/05/06 17:01:16
Feed file - /home/tucachim/www/feed/google/domain_products.xml
Processing: Feed - Yes, Upload - No
id: 4, price: 10.9, description length: 0 - skipped, price below zero, description length less than 15 chars, or title less than 3 chars - failed

Google Merchant Center File Complete In 0.009620 Seconds 0 Records

Anyone knows how can I fix it?

Thanks!

[RescoCCC]

First, my google base feed has been working flawlessly since I installed it almost two years ago. Thank you to the developers of this mod! Now, my issue, a minor but annoying one related to the new Google requirements. The shipping part is my problem right now, I'll worry about the product identifiers later.

I use calculated shipping on my site, both USPS and UPS. In order to fulfill the Google requirement for shipping to appear, I set it up in the merchant center as calculated since there is no option for calculated under select shipping method, (which I have set to none), in the Google Base Feeder Configuration.

Here is the issue: Much of what I sell is lightweight and can ship First Class Mail. There is no option for First Class in the Google merchant center shipping setup, so I had to select Priority Mail as the default, This means that the shipping costs showing in product search are way too high for many of my items that could ship First Class, and way off for heavy items that could ship UPS Ground.

Is there a mod available that adds calculated shipping as an option in the shipping method section for the feeder configuration?

[stitchnkitty]

OK I am back at this again - I have gotten all the other tweekings done to this upgrade but am have One H of a time getting the google froggle on this site - I have it on my primary site and it works great but the secondary site is not doing so well -


Also I have no Idea why it is listing Discover because I dont have discover listed as a card to accept.

this is what I get in the feed and of course Google will not accept it.


http://www.stitchnframeonline.com/wi...ncense_med.jpg



<g: payment_accepted>Discover</g: payment_accepted>


Ideas anyone - the feed is installed onto windflower grove folder.

[icecold]

My host provider limited my database bandwidth, therefore I need to set up a local server to generate the feed and then upload the XML file to the server.

I was wondering if the module can work locally and generate the XML file with the right path, or it has to be manually fixed, before uploading to the server ...

Now the file only generates 24k products from over 50k, so unless this is a module limitation ... I will try this approach.

[torvista]

First, make sure you are using the latest version 1.91.

My problem is that when I set up "Español" language on the Google Merchant Feeder Configuration and run up feeder tool I get a blank page. I had uploaded languages files to Spanish dir (includes and admin ones) but it does not work for me.

No it wont work.
The code is written to use the language name as the directory,which is obviously not reliable.
The easiest fix is to change your language name to Spanish (case does not matter).

Or you can change the code:

1) admin/includes/functions/extra_functions/googlefroogle.php

change:

$languages = $db->execute("select code, name from " . TABLE_LANGUAGES);
$languages_array = array();
while (!$languages->EOF) {
$languages_array[] = array('id' => $languages->fields['name'],
'text' => $languages->fields['name']);
$languages->MoveNext();

to

$languages = $db->execute("select code, name, directory from " . TABLE_LANGUAGES);
$languages_array = array();
while (!$languages->EOF) {
$languages_array[] = array('id' => $languages->fields['directory'],
'text' => $languages->fields['directory']);
$languages->MoveNext();

2) catalog/google_froogle.php
change

$languages = $db->execute("select code, languages_id from " . TABLE_LANGUAGES . " where name='" . $language . "' limit 1");

to

$languages = $db->execute("select code, languages_id from " . TABLE_LANGUAGES . " where directory='" . $language . "' limit 1");

I have submitted this and and other suggestions to Numinix, don't know whether they will incorporate them.

In any case if you are not getting any products in your feed in english, you have another problem. and you should fix that first before playing around with the code - switch on the debug option in the feed config for more info when generating the feed and look in your cache directory for debug info if something is crashing the feed generation.

[countrycharm]

Hi,
in v1.91,
I was finding
a) some items descriptions were becoming 0 characters and so being omitted from the feed file and
b) debug errors in the cache:
[FONT=Courier New]PHP Warning: htmlentities() [<a href='function.htmlentities'>function.htmlentities</a>]: Invalid multibyte sequence in argument in D:\My Documents\....\tienda\includes\classes\google_base.php on line 276[/FONT]

I found that it was symbols like the TM trademark and copyright that were crashing the google_base_sanita function.

So, in google_base.php
around line 277 look for

$str = html_entity_decode($str); 

and change it to

$str = html_entity_decode($str, ENT_QUOTES, 'UTF-8'); 

Otherwise I find this version to work ok.

This almost works. It corrects the items and descriptions that were becoming 0 characters and so being omitted from the feed file, but the feed file still doesn't finish before it times out. Working on this.

[chandra_prak]

Hi

Currently I'm using zencrat1.3.9h verson with about 90 products in my catelog. I've also installed the Ceon URI Mapping (SEO) plugin. Everything going good till now. Finally I've installed the Google Merchant Center Feeder(google_base_froogle_feeder_1-9-0).
now I'm facing the issue. Whenever I goo inside Tools >> Google Merchant Center Feeder inside the admin and click confirm for creating the Product feed type, a popup window comes up and displaying my home page with the URL (http://mywebUrl.com/mystore/googlefr...key=544b32e9e0)

Even I've excluded all file's path of Google merchant center feeder inside the Ceon URI Mapping.

contents of my .htaccess file is as follows:

RewriteEngine On

# ONLY rewrite URIs beginning with /zen139h/
RewriteCond %{REQUEST_URI} ^/zen139h/ [NC]
# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
#RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
RewriteCond %{REQUEST_URI} !\.[a-zA-Z]{2,5}$ [OR]
RewriteCond %{REQUEST_URI} \.(html|htm|php)$ [NC]
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/zen139h/new-admin [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/zen139h/editors [NC]
# Don't rewrite cPanel directories
RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]
# Handle all other URIs using Zen Cart (index.php)
RewriteRule .* index.php?%{QUERY_STRING} [L]

Pls help me to resolve this issue.

[torvista]

I changed the product type to full and so it included some accented words (spanish) from the category titles for the first time in the feed. Some incorrect &amp, etc combinations were created from the sanitize function that google didn't like once uploaded.

I made this change to fix it (note MY database is utf-8, maybe this is relevant), in
catalog/googlefroogle.php, in this section:

} elseif (GOOGLE_BASE_PRODUCT_TYPE == 'bottom') {
$bottom_level = $product_type[sizeof($product_type) + 1]; // sets last category in array as bottom-level
$bottom_level = htmlentities($bottom_level);
$content["product_type"] = '<g:product_type>' . $google_base->google_base_xml_sanitizer($bottom_level) . '</g:product_type>';
} elseif (GOOGLE_BASE_PRODUCT_TYPE == 'full') {
$full_path = implode(",", $product_type);
$full_path = htmlentities($full_path')
$content["product_type"] = '<g:product_type>' . $google_base->google_base_xml_sanitizer($full_path) . '</g:product_type>';
}

to

} elseif (GOOGLE_BASE_PRODUCT_TYPE == 'bottom') {
$bottom_level = $product_type[sizeof($product_type) + 1]; // sets last category in array as bottom-level
$bottom_level = htmlentities($bottom_level, ENT_QUOTES, 'UTF-8');//steve added optional parameters
$content["product_type"] = '<g:product_type>' . $google_base->google_base_xml_sanitizer($bottom_level) . '</g:product_type>';
} elseif (GOOGLE_BASE_PRODUCT_TYPE == 'full') {
$full_path = implode(",", $product_type);
$full_path = htmlentities($full_path, ENT_QUOTES, 'UTF-8');//steve added optional parameters
$content["product_type"] = '<g:product_type>' . $google_base->google_base_xml_sanitizer($full_path) . '</g:product_type>';
}

[torvista]

This almost works. It corrects the items and descriptions that were becoming 0 characters and so being omitted from the feed file, but the feed file still doesn't finish before it times out. Working on this.

I only have 263 products so don't have any timeout issues.

[lruskauff]

Sorry, this should have gone under the "Google Basde Thead" but I can't see to figure out how to post to a thread.

I still haven't figured this out. I can upload the file manually though. Anyone?

Thanks