Google Base Feeder Support Thread [OLD]

vitalwares:

Hi,

I already submit a sitemap.xml to google, so will adding this google base feeder do something in addition to this ? If yes please explain exactly what or point to the right place for this info.

Grateful for your time and help on this.

There are different things.

Sitemaps is for google indexing your site to show up at google.com

Google Base Feeder is to insert in Froogle (aka Google Base, aka Google Products, aka Google Shopping) all or the category of prodcust you want to insert in its product comparation site, like Yahoo Shopping

Hope clarifies why 2 different modules

i had a problem after installing

i can't see my web page anymore
iam getting the below error message

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.39 Server at https://www.getafurniture.com Port 80

when i goto error log
i found the below errors

2008-02-03 22:27:09]: error: directory is writable by others: (/home/getatun7/public_html)
[2008-02-03 22:24:20]: error: directory is writable by others: (/home/getatun7/public_html)
[2008-02-03 22:22:41]: error: directory is writable by others: (/home/getatun7/public_html)
[2008-02-03 22:12:40]: error: directory is writable by others: (/home/getatun7/public_html)
[2008-02-03 21:53:22]: error: directory is writable by others: (/home/getatun7/public_html)
[2008-02-03 21:51:09]: error: directory is writable by others: (/home/getatun7/public_html)
[2008-02-03 21:46:25]: error: directory is writable by others: (/home/getatun7/public_html)
[Sun Feb 3 22:27:09 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/500.shtml
[Sun Feb 3 22:27:09 2008] [error] [client 76.89.163.113] Premature end of script headers: /home/getatun7/public_html/index.php
[Sun Feb 3 22:24:20 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/500.shtml
[Sun Feb 3 22:24:20 2008] [error] [client 76.89.163.113] Premature end of script headers: /home/getatun7/public_html/googlefroogle.php
[Sun Feb 3 22:23:22 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 22:23:22 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/feed/domain_documents.xml
[Sun Feb 3 22:22:41 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/500.shtml
[Sun Feb 3 22:22:41 2008] [error] [client 76.89.163.113] Premature end of script headers: /home/getatun7/public_html/googlefroogle.php
[Sun Feb 3 22:12:40 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/500.shtml
[Sun Feb 3 22:12:40 2008] [error] [client 76.89.163.113] Premature end of script headers: /home/getatun7/public_html/googlefroogle.php
[Sun Feb 3 21:53:22 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/500.shtml
[Sun Feb 3 21:53:22 2008] [error] [client 76.89.163.113] Premature end of script headers: /home/getatun7/public_html/index.php
[Sun Feb 3 21:51:09 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/500.shtml
[Sun Feb 3 21:51:09 2008] [error] [client 76.89.163.113] Premature end of script headers: /home/getatun7/public_html/googlefroogle.php
[Sun Feb 3 21:46:25 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/500.shtml
[Sun Feb 3 21:46:25 2008] [error] [client 76.89.163.113] Premature end of script headers: /home/getatun7/public_html/googlefroogle.php
[Sun Feb 3 21:37:54 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 21:37:54 2008] [error] [client 76.89.163.113] File does not exist: /home/getatun7/public_html/favicon.ico
[Sun Feb 3 21:19:36 2008] [error] [client 74.6.22.199] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 21:19:36 2008] [error] [client 74.6.22.199] File does not exist: /home/getatun7/public_html/robots.txt
[Sun Feb 3 19:00:24 2008] [error] [client 69.13.212.2] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 19:00:24 2008] [error] [client 69.13.212.2] File does not exist: /home/getatun7/public_html/AZenv/azenv.php
[Sun Feb 3 18:40:00 2008] [error] [client 66.249.67.170] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:40:00 2008] [error] [client 66.249.67.170] File does not exist: /home/getatun7/public_html/robots.txt
[Sun Feb 3 18:09:45 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:09:45 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/includes/templates/purple/images/header_bg.jpg
[Sun Feb 3 18:09:43 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:09:43 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/includes/templates/purple/images/header_bg.jpg
[Sun Feb 3 18:09:31 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:09:31 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/includes/templates/purple/images/header_bg.jpg
[Sun Feb 3 18:09:17 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:09:17 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/includes/templates/purple/images/header_bg.jpg
[Sun Feb 3 18:09:07 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:09:07 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/favicon.ico
[Sun Feb 3 18:09:06 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:09:06 2008] [error] [client 87.74.78.225] File does not exist: /home/getatun7/public_html/includes/templates/purple/images/header_bg.jpg
[Sun Feb 3 18:06:37 2008] [error] [client 91.108.192.9] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:06:37 2008] [error] [client 91.108.192.9] File does not exist: /home/getatun7/public_html/favicon.ico
[Sun Feb 3 18:06:36 2008] [error] [client 91.108.192.9] File does not exist: /home/getatun7/public_html/404.shtml
[Sun Feb 3 18:06:36 2008] [error] [client 91.108.192.9] File does not exist: /home/getatun7/public_html/includes/templates/purple/images/header_bg.jpg

my sql query result is like below

**Query Results:**SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id FROM zen_configuration_group WHERE configuration_group_title= 'Google Base Feeder Configuration' LIMIT 1;
DELETE FROM zen_configuration WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM zen_configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
INSERT INTO zen_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Base Feeder Configuration', 'Set Google Base Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE zen_configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Google Base FTP Username', 'GOOGLE_FROOGLE_USERNAME', 'ftp_username', 'Enter your Google Base FTP username', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base FTP Password', 'GOOGLE_FROOGLE_PASSWORD', 'ftp_password', 'Enter your Google Base FTP password', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Store Address', 'GOOGLE_BASE_ADDRESS', 'http://www.domain.com', 'Enter your website address', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Store Description', 'GOOGLE_BASE_DESCRIPTION', '', 'Enter a short description of your store', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Auction Site Attributes', 'GOOGLE_BASE_ASA', 'false', 'Activate Auction Site Attributes?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('), (NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array('id', 'model', 'UPC', 'ISBN', 'false'),'), (NULL, 'Show Quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Shipping Options', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your default condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array('new', 'used', 'refurbished'),'), (NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Magic SEO URLs', 'GOOGLE_BASE_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'domain', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base: - now - add Adjust to current date;

• product - add Adjust to product date (max(date_added, last_modified, date_available))', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('now', 'product'),'), (NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Tax Region', 'GOOGLE_FROOGLE_TAX_REGION', 'Tax applicable regions', 'Enter the tax region', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Show Tax Region', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display Tax Region?', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Max products', 'GOOGLE_FROOGLE_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
  Default=0', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Pickup', 'GOOGLE_FROOGLE_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false', 'do not display'),'), (NULL, 'Included Categories', 'GOOGLE_BASE_POS_CATEGORIES', '', 'Enter category names separated by commas
  (i.e. computers,software,televisions)
  Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'GOOGLE_BASE_NEG_CATEGORIES', '', 'Enter category names separated by commas
  (i.e. computers,software,televisions)
  Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Show Weight', 'GOOGLE_BASE_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Weight Units', 'GOOGLE_BASE_UNITS', 'pounds', 'What unit of weight measure?
  pounds OR kilograms', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('pounds', 'kilograms'),'), (NULL, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array('top', 'bottom', 'full'),');

i don't know what i did wrong.

how can i fix it.

Just upgrade my Google Feed install, with the hope that it would feed through my sale prices, instead of the original price of the items, however it's still only feeding the original price.

Could someone tell me how to feed the sale price, or at least the price that the customer pays - be it sale price, standard price or specials price etc?

Many thanks!

numinix:

hmm, why would your configuration settings have changed? All you had to do was overwrite the files. Anyways, it says to just use a word like "domain." So, in your case just put secret_garden. Then it should create a file called secret_garden_products.xml.

This upgrade made no changes to the code other than to the FTP so there is no reason for it to timeout if the previous version worked for you...

I had this same problem, but the readme file didn't explain this change.

I've now changed the filename in the configuration from feedname.xml to feedname

I also had to reconfigure my Google Base feed on Google, to accept the new file name - feedname_products.xml

As a note, if I use the original cron job (ie, before I upgraded to the latest version), a small xml file is created, with nothing in - feedname_.xml

Because of this, I had to change my cronjob aswell, so it included the &type=products switch at the end.

Just a note to those who have upgraded!

The default name for the feed is "domain" not "domain.xml"

I'll add some sanitization in the future to drop .xml on the filename if it exists.

It used to be "domain.xml", but since the upgrade, it has to be set to "domain" - and then your Google Base account also needs setting up again, to take the new file name, as the feed now exports the file as "domain_products.xml".

Could you please explain how to change the zen_sanitizer function so that it doesn't strip out double quotes in the title and descriptions? Google doesn't seem to have a problem with double quotes being left in those fields.

Thanks!

Matt

Is it possible to use the Google Feeder with Easy Populate installed?
I'm using ZC 1.3.7.1 and Google Feeder 1.5.3 and Easy Populate 2.76e_R1.

I've set up a Google Base account with FTP.
I've set up a cron task that creates the feed on a nightly basis.
The thing I'm missing is the UPC in the feed file so it is failing.

How do I get the UPC into my product feed? Do I need to make changes to the database to get it in there and if so, how do I do this and do I then need to modify Easy Populate so it accepts the UPC on import of new data?

Thanks,

techgorilla

You can use AUCTION SITE ATTRIBUTES to add the UPC to each product. You should also upgrade to the latest version of GBF.

I have installed today, can create the feed fine but when uploading get this message:

Google Base Feeder v.1.6.7 05.12.2007 12:53:59 started 2008/02/12 16:44:35
Feed file - /data/members/paid/k/u/kutuu.co.uk/htdocs/www/shop/feed/kutuugooglefeed_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Login failed:
Connected to: uploads.google.com
Upload failed...

Is it the username and password? I'm sure they're correct .....

Could it be the name of the feed? In the admin config I put "kutuugooglefeed" and in google base have tried registering it as "kutuugooglefeed" "kutuugooglefeed.xml" "kutuugooglefeed_products" and "kutuugooglefeed_products.xml". None have worked ....

I also tried downloading the xml file created and uploading it manually on the Google website but that told me there were errors with the xml file ... it seemed to be all the first section like the shop name so I cut all that out but now it says line 3 is wrong which just says <channel>

Any help would be great!

If I run the upload manually I get a successful upload with

../feed/froogler_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Uploaded Successfully

If I run the cron task, I don't get an upload and see...

../feed/froogler_.xml<br />
Processing: Feed - Yes, Upload - No<br />

The Cron task is...

GET ..../googlefroogle.php?feed=yes&upload=yes&type=products

Why would running it under CRON behave like this?

numinix:

Hi tj1,

Sorry, that hasn't been a priority, but I will keep it in mind. My Numinix site has never had over 500 products listed and now that I rely on Google Base even less I probably won't be looking to optimize the module for larger amounts. Actually your script is timing out even though it is still displaying the message. Otherwise, it would having the closing XML tag. I am planning to have an all-in-one script for most of the price comparison websites, including ones I've already released, that will be optimized for larger sites. Honestly though, your server plays a major roll. The script should be ready by early february and will depend largely on other projects that have to be finished first.

News updates will be posted on the Numinix website of what our future and current plans are.

Hi there, just checking to know if this all-in-one price feeder with optimized code is already available.
Is it available for purchase somewhere else?

Thanks

HI, I've installed the googleBase mod and can't get anywhere with it.
After uploading to google, google send me an email - see below;

Errors:
Error Bad data Line #
We did not understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1
We did not understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
1

Google Base Home - Privacy Policy - Terms of Service - Programme Policies - Google Home

tj1:

Hi there, just checking to know if this all-in-one price feeder with optimized code is already available.
Is it available for purchase somewhere else?

Thanks

Sorry no ETA at this time. Developing other modules at the moment.

upload not working through my site

Warning: ftp_put() [function.ftp-put]: Transfer complete. in /home2/public_html/googlefroogle.php on line 547
Second attempt (passive mode on): Upload Failed

hi, I had an older version installed on my 1.3.7 install, but now we we have 1.3.8a - I overwrote all the files, then ran the update, then when I ran the tool - it made 0 products... so I thought I messed something up and ran the uninstall sql script... then I ran the googlefroogle sql file and it opens all the code on a white page and says at the top "1062 Duplicate entry 'GOOGLE_FROOGLE_USERNAME' for key 2"

what can I do to get this working right?

thanks in advance... E

uninstalled froogle freeder from database using the code in the download to uninstall from database, delete all the files and reinstall.

5 min job reall.

kitcorsa:

uninstalled froogle freeder from database using the code in the download to uninstall from database, delete all the files and reinstall.

5 min job reall.

I did run the untinstall script, but when I try to reinstall I get the error

this is a great module, but when I install it, I met problem.
I copy the the content of googlefroogl.sql into the box install sql patch and click execute. the page error: Http error 406

anyone can help me?

the information below is my hosting information :

Server OS: Linux 2.6.9-67.0.1.ELsmp Database: MySQL 4.1.22-standard-log

PHP Version: 4.4.7 (Zend: 1.3.0)
HTTP Server: Apache/1.3.39 (Unix )

I have installed the module, upload all the file and installed the sql patch.
but after I installed the module and view my webpage. my webpage does not displayed properly. anybody can help me.
the error information is below:

Warning: variable passed to each() is not an array or object in /home/ /public_html/include/classes/db/mysql_factory.php on line 121

1064 you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near "EXPECTED_PRODUCTS_SORT limit MAX-DISPLAY-UPCOMING-PRODUCT" at line 7