Google Base Feeder Support Thread [OLD]

[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

[numinix]

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/showth...765#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

[numinix]

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.

[holbrja]

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

[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!

[BlessIsaacola]

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!

[numinix]

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.

[motti]

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

[sirryche]

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

[BlessIsaacola]

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!