Google Base Feeder Support Thread [OLD]

[marcelo63]

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

[tuncay]

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

[OJM]

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!

[OJM]

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!

[numinix]

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.

[OJM]

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

[lankeeyankee]

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

[techgorilla]

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

[numinix]

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

[Kutuu]

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!