Froogle Merchant Center merged into GoogleBase

The latest download is now the Zen downloads section.

GoogleFroogle is the name of the mod.

'GoogleBase' is what Google calls their service now - install the mod and (in the mod) generate your feed, then click the option (in the mod) to upload the feed to GoogleBase.

Thank You Pixxi

I wish I had asked about two hours ago. Your explanation has cleared up my confusion. Thank you.

Paul

ccn1:

Hi All,

Quick question before my eye's close up totaly, Has anyone had a problem in that only a certain amount of products get generated and not the whole lot.

Only creates 1,444 out of approx 7,000 products (File size is exactly 1mb also... Hmmm strange)

After reading a lot of threads, it looks like it may be a timeout issue but I cannot find a fix !

Details here of file creation:
Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/02/28 22:49:51
Feed file - /xxxxx/local/home/xxxx/boardgameclub.co.uk/feed/xxxxxxxtxt
Processing: Feed - Yes, Upload - No

Any ideas welcome and thanks in advance.

Chris

How many seconds did the feed generation run for?

30 seconds is usually the minimum timeout on a server - but you should manage a lot more than 1444 products in 30 seconds.

Take a look in your admin->tools->server info and search for 'timeout' - see what is set and report back.

Hey Pixxi,

Thanks for the reply, I have had a look and found the following related to timeout:

Timeouts Connection: 300 - Keep-Alive: 15
Keep-Alive timeout=15, max=100
mysql.connect_timeout 60 60
default_socket_timeout 60 60

Is this what you meant ?

Thanks

Chris

I was having issues with mine as well. I solved my googlefroogle timeout problem by making changes in my php.ini configuration file to the following:

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

Just installed the Froogle Feeder onto a new Zen install. Everything went smoothly with no errors or anything.

When I create my feed I get this:

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/01 12:51:37
Feed file - /home/bhstore/public_html/feed/froogle.txt
Processing: Feed - Yes, Upload - No

and my froogle.txt is empty. Also I noticed that no ending time is listed which I have seen in other posts.

Would this mean that the process is timing out? Store has close to 7500 products listed so I could understand if this is the case. I do have access to my php.ini file but would not know which settings to adjust.

Any assistance would be greatly appreciated.

Please help.
I’m running ZC 1.3.7 after installation of your GoogleFroogle feed module I'm missing step 4. Go to Admin->Tools>Google Froogle Feeder; completely. I do not have GoogleFroogle feeder under my tools menu at all. I did install all the patches and then googlefroogle.sql I also moved all the other files in my store's root directory.

Your help is much appreciated.

Thanx in advance.
Mike.

ITGuru, I just installed it and the menu came up.

However I had to make sure that all the files installed. I don't know why they didn't just ftp as normal but they didn't.

Check the admin files as well. Ftp from the contribution folders.

Now I have a problem with the sql part of the install, I'll do a new post on it.

I'm getting the following error. Any ideas?

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/01 18:09:55
Feed file - /home/birdoasi/public_html/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - No

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 'ORDER BY p.products_id ASC' at line 10
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC]

BlessIsaacola:

I was having issues with mine as well. I solved my googlefroogle timeout problem by making changes in my php.ini configuration file to the following:

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

My php.ini is already has these settings, still no luck.

I thought I figured out my problem.

I installed the update 1.3.3.sql file instead of the googlefroogle.sql file. Duh!

So I tried the uninstall.sql and it seemed to work, but when I try to install the googlefroogle.sql flie I get that dang 1064 error again.

There's an 'uninstall.sql' file in the mod - make a note of your Froogle settings then run that via phpmyadmin (or whatever SQL client you're using).

Then run the full googlefroogle.sql install.

Then report back.

itguru:

I also moved all the other files in my store's root directory.

Upload all the files in the mod again - make sure all the files in the mod are copied to where they should be on your server - mirror the folder/paths in the mod exactly.

ITGURU

I was having the same problem as you with step 4. My problem was simple. I don't have an admin folder, I renamed it for security...bet you did too. Just put those files under admin, in your admin folder, whatever it is named.

CR

Guys

Where is this php.ini file your all talking about ?, I cant find it !

Hey Pixxi, did you see my reply listing "Timeout's" ??

Regards
Chris

BlessIsaacola:

I was having issues with mine as well. I solved my googlefroogle timeout problem by making changes in my php.ini configuration file to the following:

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

ccn1:

Guys

Where is this php.ini file your all talking about ?, I cant find it !

Hey Pixxi, did you see my reply listing "Timeout's" ??

Regards
Chris

You should be able to find the location of this file by clicking on server information from your Zen Cart Admin.

Not all servers/hosts allow you to have a php.ini file, which is maybe why you can't find it.

You could try setting those parameters via your .htaccess file - if your host allows it. Remember to check in admin->tools->server info after to see if the changes have taken.

php_flag max_execution_time 300
php_flag max_input_time 90
php_flag memory_limit 32M

You can also check the value set in

admin->configuration->My Store->Set max_execution_time for processes

Pixxi:

Not all servers/hosts allow you to have a php.ini file, which is maybe why you can't find it.

You could try setting those parameters via your .htaccess file - if your host allows it. Remember to check in admin->tools->server info after to see if the changes have taken.

php_flag max_execution_time 300
php_flag max_input_time 90
php_flag memory_limit 32M

You can also check the value set in

admin->configuration->My Store->Set max_execution_time for processes

I don't think that the php.ini file is the issue, besides unless you have a semi-dedicated server I don't think your host company will allow you to access this file do to security issues(I know I wouldn't) I ran easy populate advanced and it generated a file containing almost 50,000 products in no time flat. the issue has something to do with the froogle google base mod. Since I am not a coder, I don't know where to start.

I uploaded my feed manually for the first time yesterday. It is showing as "Pending, awaiting approval" in my account. When I click "details" it says there are errors in the feed and a bad data line. I have not received any emails from froogle telling me the feed has not been approved or about any errors.

Is this normal and to do with their system while the file awaits approval or are there really errors in the feed? If there are errors how do I fix them? The file was auto-generated by googlefroogle.php

Thanks for any help

I uploaded all of the files for the Froogle/Google base upload file and I received this error when I ran the SQL Patch:

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 hotnbottconfiguration (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, 'Froogle Password', 'GOOGLE_FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Froogle 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', 'true', '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, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'Choose your product type', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array('book', 'music', 'video', 'other'),'), (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'),');]

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.

Does anyone know what this means?