Google Base Feeder Support Thread [OLD]

numinix,

Well the installation went fine. I created the feed just fine. Nothing uploads. Yet it says it did. When I log into google base no file is there.
My username & password match. Filename at google & on my site match.
I have to manually upload the file from my computer. I thought maybe it was the settings for the file at google.
What settings for the file should I use at Google? UTF8 etc. ??? please post all settings needed to match the file format.
(using version 1.4.8)
Thanks,
grumpy
p.s. I have Ultimate SEO URLs installed.

It takes hours for the upload to appear in Google and you wouldn't be able to check it until it has been processed. By uploading it manually we cannot tell whether or not the original update succeeded. Please try the FTP upload again and check back tomorrow to see what time the last update was processed. If you are unable to use the FTP, you'll have to upload it manually.

GBF is SEO-URL friendly.

I too cannot get the feed to upload from Zencart - nor could I FTP it directly to GoogleBase, but I was able to upload it via Googlebase itself. :shocking:

(Having said that, it hasn't appeared in the FTP directory, but Google states it could take an hour to process it)

I also had trouble getting the file to write in the first place, constantly being given access denied errors even though directory permissions were correct. However, I managed to get around this by creating a file with the same name as my feed file, CHMODding that to 777, and voila! No problems with the file creation.

But back to the upload...after about 3 mins I get the foillowing error:

Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/30 23:27:52
Feed file - /hsphere/local/home/xxxxxxx/xxxxxxxxx/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...
Warning: ftp_rawlist(): php_connect_nonb() failed: Connection timed out (110) in /hsphere/local/home/xxxxxxx/xxxxxxxxx/googlefroogle.php on line 406 Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110) in

Upload failed...Suggestions welcome!

I've recently read archived support from the Google Froogle Feeder v1.3.3 and previous. Apparently some others have also had problems with using the ftp feature. I, however, have no problem uploading to Google Base and my upload was accepted every night while I was away on holidays.

I have not had recent issues generating the mod file. I do recall having some previous issues deleting or renaming the mod file and hosting provider intervention was required;-)

I have had only occasional issues either FTPing and uploading from ZC mod to GoogleBase. But such issues also seem to resolve themselves. So I suspect GoogleBase server is source of time outs and nothing to do with the mod.

I just uploaded via the mod (internal FTP) without issue.

I previously understood GoogleBase/Product Search only supported shops located in USA. Has this changed? Maybe upload and/or FTP success is negatively impacted based on the IP you are uploading from?

Maybe forward the php_connect error you are having to your hosting provider.

When using a distinct FTP client to upload what errors and/or log entries are you observing?

Woody

Ryk:

I too cannot get the feed to upload from Zencart - nor could I FTP it directly to GoogleBase, but I was able to upload it via Googlebase itself.

I also had trouble getting the file to write in the first place,...

But back to the upload...after about 3 mins I get the foillowing error:

Woodymon:

I previously understood GoogleBase/Product Search only supported shops located in USA. Has this changed? Maybe upload and/or FTP success is negatively impacted based on the IP you are uploading from?

Not sure about that - but following the upload via Googlebase itself last night, the products are now showing.

The site from which I'm trying to FTP via the mod is on a UK server, as is my own connection from which I'm trying to FTP direct. When I make the direct transfer, I don't get an error message but the file shows as 0kb in size and is not viewable in a text editor...but does that mean that google simply moves it elsewhere the moment it arrives?

I'll have a word with the host about the time-outs.

Ryk:

Google (lately) does seem to move it the moment it arrives - I haven't been able to 'view' it on the Google FTP server for quite some while. It might be an idea to remove that bit of text and link from the mod's admin screen.

Thanks for that Pixxi - that sort of ties in with what Google themselves say in that you can only see what you've FTP'd immediately after you've done it...looks like "immediately" is a matter of nanoseconds! :D

Well it was my bad I went brain dead :wacko: I was using the login for my eBay store.
I have a different account now for my website site & set up a new FTP log in.
I was able to manually upload & got no errors today. And not much of a wait time either.
Also I think that google may have been way busy yesterday since the upload I made yesterday hadn't finished processing but had done some of the items & showed me that I can't upload into the same account as my ebay store.

Hi,

I had a problem and partially solved it. I would like to know how to get the google base feeder (thank you very much for this contribution, it is Excellent) to work properly without my need to intervene.

Problem:
When the froogle.txt file is created, all the values for the field "brand" are empty. This causes google base to invalidate the upload.

Solution:
Add my store name in the "brand" field for every product and upload manually.

Question:
What is the field from my product database that is mapped to the "brand" field in the froogle.txt?; I just might add my store name to all the products for this value.
Is this a bug?

Thank you very much in advance

onlyrey:

Hi,

I had a problem and partially solved it. I would like to know how to get the google base feeder (thank you very much for this contribution, it is Excellent) to work properly without my need to intervene.

Problem:
When the froogle.txt file is created, all the values for the field "brand" are empty. This causes google base to invalidate the upload.

Solution:
Add my store name in the "brand" field for every product and upload manually.

Question:
What is the field from my product database that is mapped to the "brand" field in the froogle.txt?; I just might add my store name to all the products for this value.
Is this a bug?

Thank you very much in advance
Ok,

Here is a partial answer to the "brand" question.

I looked up the code, and the brand field in the froogle text file corresponds to the "manufacturer" field in Zen-cart.

I will solve this problem by applying a manufacturer to ALL my products.

So, if you have manufacturers as "none" you might have problems with the google validation (the actual feeder code is fine and sends an empty field, but the google side takes it as an error).

Thanks very much fot this wonderful module

Google doesn't take it as an error. The brand attribute is required and leaving it blank will cause your feed to not be validated. If your products are something that your own company produces/manufactures, then your company is definitely the brand name of the product.

IMPORTANT

More renegade code has been found in the UPC/ISBN mod and MAY be in the GBF as well. As I haven't heard of any problems, this is probably not the case. Either way, I am not going to release a patch and ask that anyone experiencing SQL problems from the UPC/ISBN mod included with GBF v1.4.8 please visit, and bookmark, this thread: http://www.zen-cart.com/forum/showthread.php?p=411765#post411765

You can fix this error by quickly moving the lines found by another forum member that lead to the release of UPC/ISBN v1.2

Woodymon:

I previously understood GoogleBase/Product Search only supported shops located in USA. Has this changed? Maybe upload and/or FTP success is negatively impacted based on the IP you are uploading from?

You may be on to something. I am in Canada myself but my host is in the USA. I've never used the manual FTP and have either used their webform or the FTP included with the GBF to upload the feed file. I suggest non-US with non-US hosting to email Google. They should allow everyone to use the service as long as prices are quoted in USD.

Hey Everyone,

If this was answered then sorry. I read everything on it and tried all the fixes but still a no go. My problem is the feeder creates my froogle.txt and can upload fine but not all products are in the txt file. I have 500 products and the txt file only shows 72. I do not think it is a timing issue as the 72 products are done in 3 sec. I also am not allowed to get to root for the php.ini file. If I put that code for the php.ini file in my .htaccess than zencart bombs until the lines are removed. Any help would be appreciated. My 72 products upload just fine to googlebase but I want all of the products up there. thanks again.

Jack

It would be great and cleaner to provide update SQL for this mod (especially since you took it over from where Andrew left off). The current SQL doesn't take into account that other mods your provided already created the UPC/ISBN fields in products table.

Not providing a cleaner upgrade path definitely leads to too many DB errors and makes using mod more complicated than it needs to be.

Thanks!

There is an undesired effect that is happening with this mod that didn't exist with the version that was created by Andrew. This version 1.4.8 is generating duplicate products if a product is linked. Previous version on generated one product no matter how many category the product is linked to. It would be great if this can be fixed. Thanks!

BlessIsaacola:

It would be great and cleaner to provide update SQL for this mod (especially since you took it over from where Andrew left off). The current SQL doesn't take into account that other mods your provided already created the UPC/ISBN fields in products table.

Not providing a cleaner upgrade path definitely leads to too many DB errors and makes using mod more complicated than it needs to be.

Thanks!

An error will not be produced, the SQL will ignore those lines. If an upgrade to the SQL is needed, an upgrade SQL file is provided. If one is not provided, the update merely requires file overwrites. The installation documentation has been greatly lengthened to avoid any issues.

There is an undesired effect that is happening with this mod that didn't exist with the version that was created by Andrew. This version 1.4.8 is generating duplicate products if a product is linked. Previous version on generated one product no matter how many category the product is linked to. It would be great if this can be fixed. Thanks!

Which version were you using before? Andrew's latest version was v1.3.3. This mod works by going through each productID until it reaches the end of the DB file. Unless your links are creating brand new productID's in the database, it will not include a duplicate of your product.

Hi

I must have done something not right.
The only way I am able to upload is by FTF my feed and froogle files, than I open the froogle copy /paste it to my feed ( look like froogle files are update better then the feed file) then I upload it manually thru Google., I can’t do it via Admin I always get error.

If that the best way around that’s ok, but if there is a way to make it more simple, please let me know
Thank you

hi

i was using 1.3.2 for all others wont create a file and i kept geting errors. i can create a file but have to use google to upload file with 1.3.2. i upgraded to 1.4.8 and dose the some thing but with out any errors. when i create a file i get

Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/31 22:36:58
Feed file - /home/content/s/i/r/sirryche5/html/feed/froogle.txt
Processing: Feed - Yes, Upload - No
Froogle File Complete In 15.527858 Seconds 3214 Records

with no errors and no up loads so i do step 2 AND GET

Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/31 22:37:56
Feed file - /home/content/s/i/r/sirryche5/html/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...

i it stays that way . i have let it run for over 10 hrs while i was at work and come home and still the same. when i check the google ftp view in step 2 i get

Google Base FTP content:
Connected to: uploads.google.com
Connection failed: uploads.google.com

but i can use my ftp program and i connect right up? would like to get the upload working with out going to google to upload any suggestions would be great. using zen 1.3.7

could it be that my data is to big. i have over 3000 items i was uploading. thanks

numinix:

An error will not be produced, the SQL will ignore those lines. If an upgrade to the SQL is needed, an upgrade SQL file is provided. If one is not provided, the update merely requires file overwrites. The installation documentation has been greatly lengthened to avoid any issues.

Which version were you using before? Andrew's latest version was v1.3.3. This mod works by going through each productID until it reaches the end of the DB file. Unless your links are creating brand new productID's in the database, it will not include a duplicate of your product.

I have reconfirmed that Andrew's version v 1.3.2 30.01.2007 7:05 DOES NOT produce duplicate, does not include products that have been deactivated and does not include products with $0 (free products).

However version 1.4.8 includes duplicates. The id for the duplicates are not different (which is expected because these are LINKED products not COPIED). If you like I can send you a sample of the file generated to show you how it's picking up duplicates. I have compared your googlefroogle.php in the root of the store to Andrew's and while there are differences I am not sure how and where these differences affect what's generated.

Are you saying that you have linked products on your site but when you generate Google Base yours doesn't include duplicates?

Thanks!