If this is your first visit, check our documentation. To post, register or login.
Forums / All Other Contributions/Addons / Froogle/Google Feed

Froogle/Google Feed

Started by threekni on 31 Jan 2007, 7:09 PM · Views: 8,206

Results 1 to 12 of 12
31 Jan 2007, 7:09 PM
#1
threekni avatar

threekni

New Zenner

Join Date:
Jan 2007
Posts:
9
Plugin Contributions:
0

Froogle/Google Feed

I downloaded the add on and got it all installed but when i ran the SQL patch I got the following error

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 zen_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, '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, 'Show Manufacturer', 'GOOGLE_FROOGLE_MANUFACTURER', 'false', 'Display Manufacturer Name', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Show Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW', 'false', 'Display Product Type', @configuration_group_id, 11, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'If Display Product Type is True, choose your product type', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array('book', 'music', 'video', 'other'),'), (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:

I am running the following on my server - **Database: **MySQL 4.1.21-standard
**PHP Version: **4.4.4 (Zend: 1.3.0)
Zen Cart 1.3.6

Database Patch Level: 1.3.6

9 Feb 2007, 10:58 PM
#2
dootch avatar

dootch

New Zenner

Join Date:
Jan 2004
Posts:
14
Plugin Contributions:
1

Re: Froogle/Google Feed

Anything on this same problem here???

10 Feb 2007, 2:16 PM
#3
kbalona avatar

kbalona

Zen Follower

Join Date:
Oct 2006
Posts:
213
Plugin Contributions:
0

Re: Froogle/Google Feed

Yep, a bunch of us have this problem and I haven't found a solution yet.

12 Feb 2007, 9:58 PM
#4
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Froogle/Google Feed

I have a problem with the froogle/Google Base feeds as well, slightly different:( and froogle/googlebase will not accept my feeds anymore.

So I have altered the Easypopulate Froogle download to include an ID and weight , and then I am using a simple Python script to produce a txt file with additional attributues and exp dates you can alter up to how ever many days you need, PM me and I will email you the script. At present you would just need Python 2.4 installed, but I am looking into link it to a database (Mysql) on the PC to add additional custom attributes and automatic updates direct to google and possibly XML and RSS feeds to upload to my website(the latter is future thinking).
I have tested it out in the last couple of days and is working well, but I do think google are still not quite finished it what it is going to do with GoogleBase.

12 Feb 2007, 10:18 PM
#5
kbalona avatar

kbalona

Zen Follower

Join Date:
Oct 2006
Posts:
213
Plugin Contributions:
0

Re: Froogle/Google Feed

Oh but we have a fix for GoogleFroogle! (btw, the latest version of GoogleFroogle for 1.3.7 satisfies Google...for now).
You need to download the new version of GoogleFroogle, upload the files, but don't use the included SQL code. Use the code that I pasted in this post:
http://www.zen-cart.com/forum/showpost.php?p=327813&postcount=386

14 Feb 2007, 2:42 PM
#6
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Froogle/Google Feed

kbalona:

Oh but we have a fix for GoogleFroogle! (btw, the latest version of GoogleFroogle for 1.3.7 satisfies Google...for now).
You need to download the new version of GoogleFroogle, upload the files, but don't use the included SQL code. Use the code that I pasted in this post:
http://www.zen-cart.com/forum/showpost.php?p=327813&postcount=386

@kbalona - threenki was referring to a sql error when doing a fresh install of the mod, whereas your fix was for the upgrade sql. Of course both are SQL patch related but they are completely separate and different issues.

@threenki & dootch & scrat - Best to post in the support thread for the specific mod you are having issue with.

17 Feb 2007, 11:30 PM
#8
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Froogle/Google Feed

qhome:

So does the latest google froogle feeder support the new GoogleBase fields as opposed to the old froogle fields? should this contrib be renamed to GoogleBase Feeder to avoid confusion?

Q-

As stated above: "Best to post in the support thread for the specific mod you are having issue with". :wink2:

So in this instance that would be...

Froogle Merchant Center merged into GoogleBase
http://www.zen-cart.com/forum/showthread.php?t=37317

"Froogle" is still service term used by Google. See http://froogle.google.com/

That should answer your second question.

Answer to your first question is Yes.

Woody

17 Feb 2007, 11:52 PM
#9
qhome avatar

qhome

Totally Zenned

Join Date:
Feb 2004
Posts:
1,702
Plugin Contributions:
5

Re: Froogle/Google Feed

Woodymon:

Q-

As stated above: "Best to post in the support thread for the specific mod you are having issue with". :wink2:

So in this instance that would be...

Froogle Merchant Center merged into GoogleBase
http://www.zen-cart.com/forum/showthread.php?t=37317

"Froogle" is still service term used by Google. See http://froogle.google.com/

That should answer your second question.

Answer to your first question is Yes.

Woody

You confused me more :)

First, I dont see any contrib that has what I want "Googlebase upload file" so this and easy populate are the closest I could find. Froogle merged into Googlebase seems more like a statement to me.

Also, Froogle is still used as a term, but they have switched to the googlebase format, so still having a froogle feed file is moot. Googlebase still accepts it, but gives you warnings about it being incomplete, and eventually might drop support for the old feed format.

So which file do i want to export googlebase format? This froogle/google contrib seemed to be right.. but i was too lazy to check it.

12 Apr 2007, 2:25 PM
#10
freerangepc avatar

freerangepc

New Zenner

Join Date:
Apr 2006
Posts:
65
Plugin Contributions:
0

Re: Froogle/Google Feed

Help!

I have been using the goodlefroogle feed to upload to pangora and it has been working fine up until SSL was put onto my admin pages etc.

I get this warning now when I didnt before. Anyone tell me what it means?

warning: ftp_rawlist() [function.ftp-rawlist]: php_connect_nonb() failed: Connection timed out (110) in /home/freerang/public_html/uk/googlefroogle.php on line 348
Upload Failed
Connected to: upload.pangora.comLogin ok:Current Directory Is: /Warning: ftp_put() [function.ftp-put]: php_connect_nonb() failed: Connection timed out (110)

13 Apr 2007, 5:46 PM
#11
birdoasis avatar

birdoasis

Inactive

Join Date:
Jun 2005
Location:
Cheney WA
Posts:
1,123
Plugin Contributions:
0

Re: Froogle/Google Feed

qhome,

Google is causing the confusion by keeping the froogle in the url and using it in other ways. Even though googlebase is the official froogle, the froogle feeder should still work.

John Patrick
A Zen Cart Advocate!

24 Mar 2011, 3:59 PM
#12
banshee000 avatar

banshee000

New Zenner

Join Date:
Feb 2011
Posts:
11
Plugin Contributions:
0

Re: Froogle/Google Feed

Hello,

Can someone just please write the shortest procedure step by step what do we need to do to be able to upload the product to google feed, instead of reading every possible forum on google feed like a bunch of idiots....?

I haven't seen on any of these forums where it shows you from the beginning to the end what a person needs to do in order to be able to do this themselves....

It seems that no one knows....:shocking: