Froogle Merchant Center merged into GoogleBase

[samad64]

the mod works fine with "special" prices - however, it has issues with sale prices. I'm not sure why that is but here's the easiest solution - temporarily take off the sales.. upload your feed.. wait until its approved, then restart the sale. google only really crawls it while in the processing mode, and then won't check again until you resubmit. The only downfall of this is that the regular price is shown on Froogle and not your sale price.. so you lose out there

In regards to the label attribute.. are you running the latest version of this mod (from Andrew's web page)? I'm not sure if he's fixed this attribute thing or not.. i'll probably have this issue on the next upload

[longstockings]

I've flipped through most pages of this exhausting thread but did not spot the answer to my problem

When trying to create a froogle feed I receive this error

---------------------------------------

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/03/17 13:37:10
Feed file - /home3/between/public_html/feed/froogle.txt
Processing: Feed - Yes, Upload - No

Fatal error: Maximum execution time of 30 seconds exceeded in /home3/between/public_html/includes/classes/bmz_image_handler.class.php on line 438

---------------------------------------

Line 438 in bmz_image_handler.class.php reads

---------------------------------------

if (($threshold > -1) && ($color['alpha'] > $threshold)) {
$color = $background_override;
} else {
$color = imagecolorallocatealpha($background, $color['red'], $color['green'], $color['blue'], $color['alpha']);
}
imagesetpixel($background, $x + $startwidth, $y + $startheight, $color);
}
}
return $background;
}

---------------------------------------

I'm using seo urls and image handler 2 and wonder if these are not playing nice with the froogle feeder

Any help would be appreciated.

[samad64]

the max_execution time is actually a PHP setting. Try setting it to 60 seconds and see if it helps. If you have a lot of products on your site, that may be what is causing the problems

[Woodymon]

the max_execution time is actually a PHP setting. Try setting it to 60 seconds and see if it helps. If you have a lot of products on your site, that may be what is causing the problems

Can you recommend how and where to configure this? ;-)

Thanks,
Woody

[birdoasis]

I would think php settings are in the php.ini file. however you have to have root access for that.

Perhaps if you can find the command you can put it in your .htaccess file instead.

[Peaches]

SQL query:
# MySQL returned an empty result set (i.e. zero rows).
SELECT @configuration_group_id := configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Google Froogle Configuration'
LIMIT 1 ;


MySQL said:
#1146 - Table 'annscera_zc1.configuration_group' doesn't exist


I tried uploading the sql file, copying and pasting it, and then uploading through phpmysql
Got these types of errors every time.

[longstockings]

Max execution time has been raised from 30 seconds to 60 but the same error is being reported. The site has just over 1000 products so this should be a piece of cake.

I don't want the froogle feeder to touch any image handler stuff but do not know where I can edit this out.

I have another shop using 1.3.5 which uses sefu and image handlere and the froogle feeder works perfectly. I used a different version of the froogle feeder though which I believe had a donation box on it.

I really do need to get this working.
Are there any other versions of the froogle feeder that work with 1.3 that I can try

Thanks

[Woodymon]

I used a different version of the froogle feeder though which I believe had a donation box on it.

http://breakmyzencart.com/froogle

But Tim has NOT been developing his mod version for a very long time now and it was not updated for ZC 1.2x. So you don't want to go there (but his ImageHandler2 mod works on 1.3x)

As far as I can see there is no developer currently actively developing or even maintaining a GoogleBase/Froogle mod for Zen Cart. As you probably read in this thread Andrew quit working on the mod as he can't use it from his location.

You might be able to massage Andrew's RSS2 mod to output a Froogle compliant feed. He recently updated the RSS2 mod to support GoogleBase namespace. I'm not aware of anyone that has utilized it in that way yet.

Maybe contact Google and request they put some available extra cash into updating Andrew's mod and in assisting to solve the timeout issues and/or put some Google Summer of Code people on the project. And while you're at it ask them to do the same for Google Checkout

Woody

[Woodymon]

MySQL said:
#1146 - Table 'annscera_zc1.configuration_group' doesn't exist


I tried uploading the sql file, copying and pasting it, and then uploading through phpmysql. Got these types of errors every time.

As you can observe above you have a prefix assigned to your database tables (annscera_zc1). This prefix was created when you installed Zen Cart. The prefix is stored in your two configure.php files.

But the patch file for the mod does not know of the prefix. Only Zen Cart knows the prefix you assigned when installing Zen Cart.

Thus patching via phpmyadmin will not automatically "append" table prefixes. Only patching via Zen Cart can that be done. But the automatic application of the prefix fails for a variety of reasons and is a known issue.

Many folks report troubles patching their database when a database table prefix has been assigned. Different solutions appear to apply to different folks.

Try copy and pasting the SQL via Tools > SQL Patches (DON'T UPLOAD).

If that does not work then suggest manually editing the patch SQL file (with a text editor) and pre-append your table prefix to the very beginning of each and every table reference in the file (being very careful do not change anything else). Then save that file as a different name (text format). Then copy and paste that edited SQL into Tools > SQL Patches and try patching again. If that does not work try uploading the new SQL file you just edited and saved.

BACKUP YOUR FILES AND DATABASE BEFORE ATTEMPTING!

Woody

[Woodymon]

For those folks having issues FTPing from within the mod, try creating/generating the feed file, then manually FTPing with your web browser or FTP client. Instructions on how to manually FTP are on the GoogleBase support site.

http://base.google.com/base/FTP.html
http://base.google.com/support/bin/topic.py?topic=2928

Then at the very least you will know that part is working and will have a record of correct FTP server authentication parameters to experiment within the mod's admin config.

Woody