Google Base Feeder Support Thread [OLD]

[numinix]

Has anyone been able to use this script with over 1000 products without editing the php.ini or .htaccess files?

[numinix]

Google Froogle Feeder has been found to be incompatible with Zen Manager. Zen Manager is a script for adding products to your store. Somehow, the manager stores products slightly differently and the Google Froogle Feeder is unable to pull these values. I verified this on a store that could only produce the first line of the feed (non database values). We created a product the regular way and the product was added to the feed without a problem. Thus, the feeder was not timing out at all.

However, there may still exist a timeout issue which a workaround, although not ideal, is being implemented for v1.3.6. I'll have it ready for testing tonight.

[numinix]

v 1.3.6 http://www.numinix.com/zen-cart/goog...eder_1.3.6.zip

View readme for updates. Will post to contribution after no errors other than known issues are reported.

[numinix]

v1.3.6 is now available in the downloads section

1. Updated the Google Base logo;
2. Added a counter to help combat timeouts and allow user to set maximum number of products to process;
3. Added tax region;
4. Removed product_type from the configuration;
5. Code optimization;

I've uploaded all contributions to my website as well and can be downloaded by visiting the Numinix Technology website.

[numinix]

Update:

Conflicts with Zen Manager have been resolved. If you use Zen Manager, please download the latest patches recently released by that author.

[tharrison]

Hello numinix,

I've just install the v1.3.7 version of your Google Froogle Feeder on a new install of ZC v1.3.7. using MySQL 5. After installing the SQL file, I get this:
--------------------------------------------------------------------------------------------
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 'true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD',' at line 1
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, 'Froogle Username', 'GOOGLE_FROOGLE_USERNAME', 'froogle_username', 'Enter your Froogle username', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Google Base Password', 'GOOGLE_FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 3, NOW(), NULL, NULL), (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', 'false'),'), (NULL, 'Display quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'The shipping options available for an item', '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 Product's 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, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'froogle.txt', '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);]
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.
--------------------------------------------------------------------------------------------
The page to configure your Google Base account is blank. Any suggestions?

[Elfboy]

I'm gettting the same error. No other mods installed except ImageHandler2. I did my best to remove an old version of Froogle Feed Generator.

It happens after I attempt to upload googlefroogle.sql

The Google Froogle Configuration page is blank.

Please help!

[findl16]

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!

[milobloom]

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?

[jackyer]

I'm currently using Google Base Feeder 1.7.4 for Zen Cart Version 1.3.8a.When I "Create Product Feed" I get 7000 products out of 8000.Where is 1000 products? How can I fix it? Thanks in advance.