Google Base Feeder Support Thread [OLD]

I'm running the latest version of Zen Cart. I installed the google base feeder, but it's not working. I tried installing the patch update, it seemed to take, however I still can't get any products to generate.

How can I fully remove google base feeder? I need to try reinstalling. I tried running the uninstall sql script, but it seems there are still some things in the db, as I can't reinstall.

Any ideas?

Thanks.

actionmedia:

I'm running the latest version of Zen Cart. I installed the google base feeder, but it's not working. I tried installing the patch update, it seemed to take, however I still can't get any products to generate.

How can I fully remove google base feeder? I need to try reinstalling. I tried running the uninstall sql script, but it seems there are still some things in the db, as I can't reinstall.

Any ideas?

Thanks.

Hello Actionmedia,
Please post any error messages you are getting while trying to do the reinstall. That would help anyone trying to assist you.

When I try to apply the update_1_7_1 sql patch, I receive this:

1062 Duplicate entry 'GOOGLE_BASE_MAP_PRICING' for key 2
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I ran the uninstall script, and tried reinstalling just the googlefroogle.sql query, and can't. I receive this:

1062 Duplicate entry 'GOOGLE_BASE_MAP_PRICING' for key 2
in:
[INSERT INTO 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, 'Google Base PASV', 'GOOGLE_BASE_PASV', 'true', 'Turn PASV mode on or off for FTP upload?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (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 (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (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, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 3, 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, 'Include Zero Quantity', 'GOOGLE_BASE_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Default Quantity', 'GOOGLE_BASE_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, NULL), (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, '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, 'Display Tax', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display tax per product?', @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. 1,2,3)
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. 1,2,3)
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'),'), (NULL, 'Payments Accepted', 'GOOGLE_BASE_PAYMENT_METHODS', 'Cash,Check,Visa,MasterCard,AmericanExpress,Discover,WireTransfer', 'What payment methods do you accept?', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Payment Notes', 'GOOGLE_BASE_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Image Handler', 'GOOGLE_FROOGLE_IMAGE_HANDLER', 'false', 'Resize images using image handler (separate module required)?', @configuration_group_id, 36, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

guys, i need help. I have just installed Google Base Feeder according to instruction. But when i click on "Create Product Feed" it shows white blank pop up window and nothing going on further :blink: . What i am doing wrong, please help?

yorick00:

guys, i need help. I have just installed Google Base Feeder according to instruction. But when i click on "Create Product Feed" it shows white blank pop up window and nothing going on further :blink: . What i am doing wrong, please help?
Are you sure you have it configured correctly in Admin>Configuration>GoogleBaseFeederConfiguration ??

limelites:

Are you sure you have it configured correctly in Admin>Configuration>GoogleBaseFeederConfiguration ??
It has few lines to configure :blink:

Google Base PASV
Google Base Server
Google Base FTP Password
Google Base FTP Username
Store Description
Store Address
Auction Site Attributes

I soopose they influense on gogle bease account acces for file uploading. But something must be created before uploading.

I configured them, but feed even not created file (mystore/feed/index.html is empty)

when i click on "Create Product Feed" it shows blank pop up window and nothing going on. I am completely stuck. :lookaroun

There's a pretty good readme file with this mod that explains the set up process step by step by step.

Open the readme file and go through each step meticulously.

It sounds like you don't even have a Google Base account yet!? Read the step by step install guide which explains how to open an account and also how to configure it correctly.

Do this and you'll get it working... You need to know your account details (Google Base FTP Password and Google Base FTP Username) so that you can output a txt file to upload to google base.

Hi All,
v1.7.3a installed on zen 1.3.8a
I'm having a couple of problems, the first is that when I try to enter my domain name in Configuration>Google Base Feeder Configuration, I get an error:'Forbidden
You don't have permission to access /admin/configuration.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. '

Should it really be trying to write to configure.php? I didn't want to change permissions, as I don't know what it wants to change...

Next problem;
When I installed the sql files, the first (googlefroogle.sql) went fine but the upgrade (update_1_7_3.sql) gave an error:'1062 Duplicate entry 'GOOGLE_BASE_DEBUG' for key 2
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Debug', 'GOOGLE_BASE_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.'

I assume this is of no consequence, as debug appears in the configuration menu just fine, but wanted to check.

I mention all the above as it may be contributory to my final problem; although an xml file is created just fine, and google grabs it with gusto, it only contains 68 of 216 products. I've not excluded any categories, and the products which are included come apparently randomly from across 2 categories only, not including the whole inventory of either category.
I've probably explained this in the longwindedest way possible, for which I apologise, but if you can help point me in the right direction, I'll be a very grateful zennite.

Thanks, and regards,

Sean

I forgot: No error messages received from google, either...

sorrysorrysorry...
I just found the debug feature, and it seems that my products were skipped for lack of descriptions. ho hum....

Hi, Can anyone really help me install this. I am having trouble in step 2. If you could walk me through I would be forever thankful.
Just email me letting me know when you can help me. My email address is [email protected] and my site is https://www.microbelift.net
Thanks for the help
Howard

limelites:

There's a pretty good readme file with this mod that explains the set up process step by step by step.

Open the readme file and go through each step meticulously.

It sounds like you don't even have a Google Base account yet!? Read the step by step install guide which explains how to open an account and also how to configure it correctly.

Do this and you'll get it working... You need to know your account details (Google Base FTP Password and Google Base FTP Username) so that you can output a txt file to upload to google base.

i know pretty good about read me file and always read this twice before whine on forums. this file are complete unclear ... i try to explain, probably you misunderstanding me:

look, please, at this screen of admin panel>conf>GBF conf

than according user manual file:

1. Unzip and upload all files to your store directory (except .sql files); DONE! IT IS CLEAR.

2. Chmod feed directory to 777 DONE! IT IS CLEAR.

3. Go to Admin->Tools->Install SQL Patches and install googlefroogle.sql by copying and pasting (do not upload); DONE! IT IS CLEAR.

4. Go to http://base.google.com and create/sign to your account. Follow the link on the right hand side of their website to create your FTP account. DONE! IT IS CLEAR.

5. Go to Admin->Configuration->Google Base Configuration and setup all parameters; DONE! IT IS CLEAR.

6. Register your bulk upload .xml file using the same name in your Google Base Configuration at base.google.com FAILED! IT IS UNCLEAR! According to my screen there are no any lines for same name. Or there is any other configuration options??? What kind of same name he talking about? My feed file name is "omfgsamename.xml" on which field i should enter it, frankly speaking i can not find any suitable.

7. Go to Admin->Tools>Google Base Feeder and follow instructions to create, view, and upload feed file. FIALED. When i click on Create Product Feed: Click [HERE] to create / update your products feed - GOES nothing - plugin generates new pop-up blank window with none content or any kind of text, steps or other info, tested on 3 different browsers.

So it even do not creates product feed ... :dontgetit

So, please, could anybody help me with this problem i am stuck 2 days ahead. :frusty: i will be thankful for ages. thanks in advance.

It seems half of the installation I tried helping another ZC forum poster with went well. I can view and make changes to the configuration page for the feeder program, but yet I cannot find the listing under the Admin > Tools category. Can anyone tell me what file is missing or where it should be to get the Google Base Feeder option to show up?

Thanks!

blakdeth77:

It seems half of the installation I tried helping another ZC forum poster with went well. I can view and make changes to the configuration page for the feeder program, but yet I cannot find the listing under the Admin > Tools category. Can anyone tell me what file is missing or where it should be to get the Google Base Feeder option to show up?

Thanks!

Make sure that you copied files direct into your custom admin folder on the server. Your custom admin folder ex.: "myadmin" can differ from default one "admin" from plugin folder tree.

hope it will help:smile:

yorick00:

Make sure that you copied files direct into your custom admin folder on the server. Your custom admin folder ex.: "myadmin" can differ from default one "admin" from plugin folder tree.

hope it will help:smile:
Tell me about it!! I had this exact same problem and it took me almost a day to suss it out!! I'd renamed my ADMIN folder fr security reasons and hadn't even thought about it as I was that used to just dragging and dropping the folders into site/root ....

Basically, rename ADMIN to match YOURADMIN before uploading it :-)

I am using Zen Cart v1.3.8a/v1.3.8 and I have downloaded the Google Base Feeder.

Initially I downloaded all the update SQL files by cutting and pasting in the sql patches section. I then found out that I did not require to do this as it was a first install so I deleted these from the sql database. I had also been unable to access google base feeder configuration but on searching google discovered that I had not changed the permissions on file public_html/admin/configuration and public_html/admin/admin.php in my root folder from 777 to 755 after download and getting instead an Internal Server Error like the one I have been reading about in this thread.

After transferring all the files via ftp and inserting the googlefroogle.sql file I attempted to use the google base feeder. It appeared to be successful and it was generating the RSS feed. The transfer also appears to have been successful and this is the result of the steps I took

Step 1: Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2009/03/16 13:32:01
Feed file - /home/xxxxxx/public_html/feed/xxxxxx_products.xml
Processing: Feed - Yes, Upload - No
Google Base File Complete In 0.461483 Seconds 98 Records

Step 2: Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2009/03/16 13:32:28
Feed file - /home/xxxxxxx/public_html/feed/xxxxxxxx_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Uploaded Successfully
-r--r----- 1 ftp · root · 104333 Mar 16 11:32 Accessorize_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp · root · 104333 Mar 16 11:32 Accessorize_products.xml

but it has not appeared on google base and this is what appears when I click here:

You may view Google Base FTP content.

Google Base FTP content:
Connected to: uploads.google.com
/
total 0

Can anyone tell me what I am doing wrong?

I cannot understand how I am getting the RSS feed showing when I click on this:

NOTE: You may view your product feed file before proceeding to step 2.

I am using the correct password and think I have configured the Google Base Configuration correctly.

I have looked to see how I can download this feed to my computer to do it manually but cannot see a way of doing this. Can anyone help please.

Upload ok!

What I am looking to do is have my Google Feeder
Send out the Lowest Cost for each item.
I know there has to be a way because if I search a product
on all the competitors websites.

Is there a simple veritable I should change?

Hi i have uploaded the latest version of google base and am using the latest zencart version 1.3.8a. I have created a datafeed and have viewed it..all looks fine by default it created the patch as domain_products.xml
i get errors.

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.

before the message shows up i get a blank screen in the new window for about 15 secs saying that its waiting for my site.

any idea

I have zen cart 1.3.6 and have had this installed and working properly. Worked like a dream. All of a sudden it has stopped working. when I view the product feed it is empty.

Again, this was working fine and all of sudden just stopped.

When I view the feed it is blank. When I upload it only shows 7 items processed by Google.

Any thoughts?

chriskelm1:

I have zen cart 1.3.6 and have had this installed and working properly. Worked like a dream. All of a sudden it has stopped working. when I view the product feed it is empty.

Again, this was working fine and all of sudden just stopped.

When I view the feed it is blank. When I upload it only shows 7 items processed by Google.

Any thoughts?

You must have changed something, trace back your last few steps and think what you've altered recently between the times you remember it was working.