Froogle Merchant Center merged into GoogleBase

[mydanilo]

Thank you woody! Yes jeking, this was my problem as well. Executing the SQL code in Admin was what was needed. I do have a prefix to my tables.

See, I knew there was somebody out there that has some more wits than me on this issue. Thank you to everybody in this Zen Cart forum. You guys ROCK! This is truly a great community. :))

[rcrosier]

WOOOOOOOHOOOOOOO!!!!!
Yes! It's working! Apparently I hadn't uploaded the new googlefroogle.php to the store's root. (Actually, I believe what happened is that I forgot to check "overwrite old file", and I uploaded but it did not overwrite the old file).

Just make sure you upload all the new files correctly, and use this SQL code (I wonder if someone could change it in the download section?)

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_MANUFACTURER';

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW';
UPDATE configuration SET configuration_description='Choose your product type' WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE';


SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;

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, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your Product\'s Condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),');

Hi,
I have the Froogle installed, and it's "working", except that I cannot get it to FTP the froogle.txt file to Froogle. I can manually upload it ONLY.

I'm on ZC 1.3.6, with some contribs.

Is there a newer version of the googlefroogle.php than v 1.3.2? Mine seems to have everything but Manufacturer and Condition... except for next question...

WHERE did you set the "overwrite old file"? That may be my problem.

Thanks!

[Woodymon]

Hi,
I have the Froogle installed, and it's "working", except that I cannot get it to FTP the froogle.txt file to Froogle. I can manually upload it ONLY.

Is there a newer version of the googlefroogle.php than v 1.3.2?

Mine seems to have everything but Manufacturer and Condition...

WHERE did you set the "overwrite old file"? That may be my problem.

Thanks!

Four questions above:

#1. What are the error messages you observe when FTPing to Google.

#2: Latest version of googlefroogle mod by andrew is 1.3.3.3 and it is in the ZC Downloads area.

#3 Manufacturer field is deprecated and not supported by Froogle (GoogleBase) any longer. Condition will be required very soon. You should upgrade to the newest GoogleFroogle version. More info in this thread.

#4. kbalona was referring to a config setting in his FTP program which he used to upload the new version of GoogleFroogle mod files to his server. Generally you want to configure your FTP program to ask you to overwrite files, before proceeding with uploading/overwriting an existing file of the same name, that is unless you like to live dangerously. (this setting is usually enabled by default... look in your FTP program help file)

Woody

[Woodymon]

jeking & mydanilo-

Good to hear that you were able to complete the install.

The tip regards to copy and pasting into the built in SQL Updater, and not uploading, came from Andrew awhile back. Yes that tips seems to work wonders.

Andrew just posted elsewhere that he has designed a ZenModsInstaller script that can be used with most any Zen Cart mod. So hopefully it can and will be adapted for this mod soon.

Woody

[Justwade]

I just installed this mod yesterday, haven't tried to connect with Google yet. I have the latest download. Everything seems to be where it should be so far, install was not that bad. I only installed the googlefroogle.sql and not any of the update choices, I think I did it right being I wasn't upgrading. It generated a product feed for me so I am optimistic about the next steps.

But my larger image popup on the products page is way too big now after the install. Yes, I have Image Handler installed and I know this mod was not designed for IH.

I did find a_berezin code to change in googlefroogle.php to make it work but I think this for making it work with froogle. It didn't help my large popups.
http://www.zen-cart.com/forum/showth...ogle+bad+image

I tried to control size in the Admin-Config-Images;

IH large image maximum width
IH large image maximum height

but that does nothing. I haven't found any references to this in the threads, sorry if I over looked it.

Does someone have an idea how I can adjust these popup product images smaller again?

[Crzipilot]

Anyone have the same problem???

Installed the last version available in the dowloads section. Installed the SQL patch. (the full one, not the updates)

Everything seemed to go in, went to make the froogle file, the window popped up, said it did 2300 or so items.

When I look at the file, all it has is just the header, bascially the names of the attributes....but no actual products...

Any ideas?

[mydanilo]

Crzipilot, are you sure there is nothing more in the file? Did you open the froogle.txt? Or did you name it something else in Google Froogle Configuration? Did you go trough all the settings? Then make sure you uploaded all the files in the mod. If you renamed your admin, you might have copied to the wrong directory. What else....maybe just re-upload again to make sure you got all the files on your server.

Hope these few pointers help.

[Crzipilot]

Yup, I've reuploaded everything, haven't changed any paths, or filenames. Haven't renamed admin directory,

I get the headers populated in the feed file. and it changes the file size from 0kb to 1kb. That's all I get.

1.3.7 zen cart, with IH,

[Woodymon]

When I look at the file, all it has is just the header, bascially the names of the attributes....but no actual products... Any ideas?

Update product feed again and copy contents of the pop-up window to this thread, obfuscating any private info you may not want to share.

And right after running the update check (via FTP) to ensure the feed file datetime stamp shows the time the feed was generated.

Woody

[Crzipilot]

Update product feed again and copy contents of the pop-up window to this thread, obfuscating any private info you may not want to share.

Woody

I updated the feed. and this is what the popup window showed...

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/02/18 10:57:33
Feed file - /kunden/homepages/11/d93880114/htdocs/feed/froogle.txt
Processing: Feed - Yes, Upload - No
Froogle File Complete In 2.118334 Seconds 2373 Records