Froogle Merchant Center merged into GoogleBase

[Pixxi]

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.

[ccn1]

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

[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

[madk]

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.

[itguru]

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.

[birdoasis]

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.

[birdoasis]

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]

[ctcentralinfo]

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.

[birdoasis]

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.

[Pixxi]

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.