Zen Cart Logo
Forums / All Other Contributions/Addons / Froogle Merchant Center merged into GoogleBase

Froogle Merchant Center merged into GoogleBase

Views: 157,263

Results 341 to 360 of 662
1 Feb 2007, 3:55 PM
#341
jla avatar

jla

Zen Follower

Join Date:
Jul 2005
Posts:
128
Plugin Contributions:
0

Froogle Merchant Center merged into GoogleBase

Yes, it can be hard coded but it seems it should be pretty easy to duplicate what Andrew did for the product type field

There are two approaches that one can use

Since ZEN does not have the ability currently to specify whether a product is new, used or refurbished, perhaps just as Andrew did for product type, we can specify for all products "see description" for the condition field.

It says on Google

Appropriate values include which to means does not mean LIMITED TO so the "see description" should be appropriate

Regardless, the FAQ about required attributes is no longer valid at least according to our contact at Google. All feeds MUST have these fields period.

1 Feb 2007, 3:56 PM
#342
jla avatar

jla

Zen Follower

Join Date:
Jul 2005
Posts:
128
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

j0ney3:

Hrm...

http://base.google.com/base/products.html

Are we reading the same info? It appears to me that the only items that are REQUIRED are listed up top, the other's (by product) only help, but won't invalidate your upload if not present. Please correct me if I'm reading wrong.

Required Attributes
Attributes for all products
You are required to include these attributes for all of the items in your bulk upload file.

brand
condition
description
expiration_date
id
image_link
link
price
product_type
title

1 Feb 2007, 4:45 PM
#343
jgarabot avatar

jgarabot

New Zenner

Join Date:
Dec 2006
Posts:
17
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

Yes, every time I tried is a conection time out. It has to be some thing else. I will like to to have this fix by the time the problem with google is fix.

1 Feb 2007, 7:14 PM
#344
j0ney3 avatar

j0ney3

New Zenner

Join Date:
Jun 2004
Posts:
36
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

JLA,

Ok, I've just installed this mod, works very similar to the one I've got. To add in a static condition value you can find the following around line 85 in <catalogdirectory>/googlefroogle.php:

$output["title"]            = "title";
$output["description"]      = "description";
$output["link"]             = "link";
$output["price"]            = "price";
$output["image_link"]       = "image_link";
$output["expiration_date"]  = "expiration_date";
$output["label"]            = "label";
$output["id"]               = "id";

And add in the following:

$output["title"]            = "title";
$output["description"]      = "description";
$output["link"]             = "link";
$output["price"]            = "price";
$output["image_link"]       = "image_link";
$output["expiration_date"]  = "expiration_date";
$output["label"]            = "label";
$output["id"]               = "id";
$output["condition"]        = "condition"; // Added for March required update

Then, around line 150 find the following:

$output = array();
$output["title"]  = zen_froogle_sanita($products->fields['products_name'], true);
$output["description"] = zen_froogle_sanita($products->fields['products_description']);
$output["price"] = number_format($price, 2, '.', '');
$output["image_link"] = zen_froogle_image_url($products->fields['products_image']);
$output["expiration_date"] = zen_froogle_expiration_date($products->fields['base_date']);

And add in this line at the end:

$output = array();
$output["title"]  = zen_froogle_sanita($products->fields['products_name'], true);
$output["description"] = zen_froogle_sanita($products->fields['products_description']);
$output["price"] = number_format($price, 2, '.', '');
$output["image_link"] = zen_froogle_image_url($products->fields['products_image']);
$output["expiration_date"] = zen_froogle_expiration_date($products->fields['base_date']);
$output["condition"]  = "new"; // Added for Google's required March update

Of course you can change "new" to whatever you'd like, JLA suggested "see description"

If anyone has any questions, suggestions, please post. I realize this is just a quick hack to tide us over for a bit, if I've missed anything please let me know.

1 Feb 2007, 8:13 PM
#345
jgarabot avatar

jgarabot

New Zenner

Join Date:
Dec 2006
Posts:
17
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

can you link the file to replace the old one, for the one of us who does not have editing skills?

1 Feb 2007, 8:26 PM
#346
dashizna avatar

dashizna

Zen Follower

Join Date:
Mar 2006
Posts:
424
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

Yea who can just send us the files that we need to change already changed so we can just upload them.. Not everyone understands all this editing on these files...

1 Feb 2007, 9:19 PM
#347
j0ney3 avatar

j0ney3

New Zenner

Join Date:
Jun 2004
Posts:
36
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

All,

I've PM'd a_berezin, the creator of this file and am going to wait until I get the ok from him to post a link to my modified version of his file. Keep in mind, my quick hack only puts one value in the condition field, only "new". Please don't stress about it, I will do my best to see that everyone is sorted out WELL before this new cutoff, I just don't want to mod/link a_berezin's file w/o permission.

Thanks!

1 Feb 2007, 9:43 PM
#348
dashizna avatar

dashizna

Zen Follower

Join Date:
Mar 2006
Posts:
424
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

thats understandable

1 Feb 2007, 10:14 PM
#349
jgarabot avatar

jgarabot

New Zenner

Join Date:
Dec 2006
Posts:
17
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

I was looking at the export file.txt, and it does not create the id, only id header

1 Feb 2007, 10:30 PM
#350
j0ney3 avatar

j0ney3

New Zenner

Join Date:
Jun 2004
Posts:
36
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

jgarabot:

I was looking at the export file.txt, and it does not create the id, only id header

jgarabot,

That is a configuration option

go to Configuration->Google Froogle Configuration, then there is an option called "Show Offer ID", u must set it to either "id" or "model" for it to show in the file.

1 Feb 2007, 11:28 PM
#351
j0ney3 avatar

j0ney3

New Zenner

Join Date:
Jun 2004
Posts:
36
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

Ok,

I spoke w/ a_berezin and he was totally cool w/ me posting a mod, actually, he wanted me to do some real work, not just throw up an ugly hack, but I'm too lazy, sorry LOL! ;)

So, here it is, a quick patch for those of you whom already have a_berezin's wonderful GoogleFroogle Add-On.

Steps:

  1. Download the files http://www.lethalperformance.com/GoogleFroogleMod.zip
  2. Unzip
  3. Upload as usual
  4. Run the sql patch as normal
  5. Configure the "condition" option that will now be available

Seeing as the condition is soon to be required, I set it to always be there, so if you don't want condition set to something, stay away from this mod!

CAVEAT: I've tested this of course, however, my upload file still hasn't been processed by google base so USE AT YOUR OWN RISK!

If this breaks your stuff, sorry. To revert this, just re-upload the original googlefroogle.php from a_berezin.

Thanks,
Jonas

2 Feb 2007, 10:46 AM
#352
jgarabot avatar

jgarabot

New Zenner

Join Date:
Dec 2006
Posts:
17
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

Thanks j0ney3
I still have the problem with the ftp part keeps giving me a time out error maybe some setting in my server, I don't know. I have it install in two shoping cart with two diferente froogle account and it is the same error in both.

Warning: ftp_rawlist(): php_connect_nonb() failed: Connection timed out (110) in /hsphere/local/home/jgarabot/shopdidoo.com/googlefroogle.php on line 418
Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110)

2 Feb 2007, 11:34 AM
#353
a_berezin avatar

a_berezin

Deceased

Join Date:
Aug 2004
Location:
Saint Petersburg, Russia
Posts:
1,782
Plugin Contributions:
5

Re: Froogle Merchant Center merged into GoogleBase

j0ney3:

So, here it is, a quick patch
Nice work j0ney3! Thank's! I add it later to mod.

2 Feb 2007, 2:57 PM
#354
j0ney3 avatar

j0ney3

New Zenner

Join Date:
Jun 2004
Posts:
36
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

jgarabot:

Thanks j0ney3
I still have the problem with the ftp part keeps giving me a time out error maybe some setting in my server, I don't know. I have it install in two shoping cart with two diferente froogle account and it is the same error in both.

Warning: ftp_rawlist(): php_connect_nonb() failed: Connection timed out (110) in /hsphere/local/home/jgarabot/shopdidoo.com/googlefroogle.php on line 418
Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110)

jgarabot,

I have a lot of the php ftp functions on lockdown on my box, could you have something similar? Maybe check out "disable_functions" in your php.ini. Also, have you tried connecting via terminal from your server?

As a workaround, you could generate the file, save it and upload it to your base account yourself, I know, not the best way, but just a workaround

2 Feb 2007, 2:58 PM
#355
j0ney3 avatar

j0ney3

New Zenner

Join Date:
Jun 2004
Posts:
36
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

a_berezin:

Nice work j0ney3! Thank's! I add it later to mod.

a,

Thank you for the mod. I'm sure someone can come up w/ a more elegant solution for this, but hopefully this will work for now.

6 Feb 2007, 8:54 PM
#356
anjordan77 avatar

anjordan77

Zen Follower

Join Date:
Jun 2006
Location:
Midlothian, Virginia, United States
Posts:
110
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

How would we add Attributes such as color, size, etc.

And how would we factor in multiple attributes?

7 Feb 2007, 3:18 AM
#357
gid avatar

gid

New Zenner

Join Date:
Oct 2005
Location:
Chattanooga
Posts:
62
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

Thanks j0ney3!

7 Feb 2007, 4:10 PM
#358
lestatbp avatar

lestatbp

New Zenner

Join Date:
Jul 2005
Location:
NoVa
Posts:
65
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

Sorry if I am being dense - but I can't get a feed.

I installed the latest Google Froogle Feeder with the mod to add "new" and when I go to Admin-Tools-Google Gfroogle Feeder and click "STEP 1: Click [HERE] to create / update your product feed." I get an "Internet Explorer cannot display the webpage." I have double checked my installation and re-read the read me files to see if I missed anything and I do not think I did. I tried scanning this thread and either did not see a mention of it or I looked over it.

Kelli

7 Feb 2007, 4:57 PM
#359
lestatbp avatar

lestatbp

New Zenner

Join Date:
Jul 2005
Location:
NoVa
Posts:
65
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

I managed to fix it but I don't know how. I uninstalled and reinstalled on the assumption that I must have done something wrong the first time. Sorry I can't say what it was to help anyone out.

Kelli

7 Feb 2007, 5:04 PM
#360
anjordan77 avatar

anjordan77

Zen Follower

Join Date:
Jun 2006
Location:
Midlothian, Virginia, United States
Posts:
110
Plugin Contributions:
0

Re: Froogle Merchant Center merged into GoogleBase

good job, anyone figure out a way to have the feeder export the Colors, Sizes, etc.?