Google Base Feeder Support Thread [OLD]

[kelvyn]

First, sorry if this has been discussed before. I used Search and it only pointed out this thread, but not which page on the thread. I don't have the time to read through over 50 pages...

I just installed the G Base patch. Since I'm running ZenCart 1.37, I used patch v1.5.3, the last one listed as compatible with Zen 1.3.7. After pasting in the content of googlefroogle.sql, I got this response:

8 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

The upgrade_exceptions table shows this record:

upgrade_exception_id: 1
sql_file: SQLPATCH
reason: Cannot insert configuration_key "" because it already exists
errordate: 2008-06-03 22:37:09
sqlstatement: 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

As a result, Admin -> Configuration -> Google Base Feeder Configuration only shows an empty table with columns Title/Value/Action and no content and Admin -> Tools -> Google Base Feeder brings PHP errors when clicking on the links in Step 1 and Step 2.

What can I do? Thanks!

I'm getting this too, as well as on the Google Sitemap Admin contrib.

I have run the uninstall sql too.

[robsnowden]

My google feed failed in style today. It is a feed on my test site www.pleasuredisc.co.uk and has been working away every day without failure until today. I have attached below the failure results as per the google site report and would appreciate it if anyone can help with this. A further annoyance is that I also installed this mod on a client's site yesterday and got the same failures today so it is not site related as far as I can see.

Many thanks - and if I have been a proper muppet in doing something wrong then I bow to that in advance :)

My test site has 7 items but clearly I have only shown the result for one of them as they are all the same failure.

GOOGLE FAILURE REPORT TEXT:

Feed status details


Outcome: Data feed upload failed. No items are live. help
Number of items processed: 7
Number of inserted items: 0
Uploaded at: Jun 5, 2008 7:04 pm BST
Processed at: Jun 6, 2008 7:56 am BST


Errors:
Error Bad data Line #
We recommend including this attribute. help mpn
28
We recommend including this attribute. help isbn
28
We recommend including this attribute. help upc
28
We recommend including this attribute. help brand
28
The item is missing a required attribute. help description
28
This expiration date is too far in the future. help expiration date:2009-04-07
33
You entered a payment method that is not currently available. help payment accepted:Maestro
45

Many thanks in advance.

Rob

[countrycharm]

Errors:
Error Bad data Line #
We recommend including this attribute. help mpn
28
We recommend including this attribute. help isbn
28
We recommend including this attribute. help upc
28
We recommend including this attribute. help brand
28
The item is missing a required attribute. help description
28
This expiration date is too far in the future. help expiration date:2009-04-07
33
You entered a payment method that is not currently available. help payment accepted:Maestro
45

I'm getting the same thing from Google Base

[numinix]

I'm getting the same thing from Google Base

This issue was solved in a previous post.

[robsnowden]

Hi and thanks for this but I have trawled through all 900+ posts and I cannot see this. As it has only just happened today after many weeks of working fine I assumed that it was a recent issue but still cannot see this. I will go search again but of you could point me to the post I would greatly appreciate it.

Thanks

Rob

[robsnowden]

I think I found what I am looking for and really wasn't trying to be lazy in asking first without looking. Now I just need to get my head around the 'recommendations' given by google such as using mpn, isbn, upc and brand attributes because as things stand right here and now - this may as well be in chinese.

Anyhow I see where I need to make a few alterations in admin but still wonder why it has taken until today after many weeks of uploading without errors, for the feed to suddenly fail. Could it be that google has changed something?

Cheers

Rob

[MachaNeko]

This issue was solved in a previous post.

where? i didn't see it and i've been reading all 100 pages.

[numinix]

The message from Google clearly states that a description is required for all products. It also recommends certain attributes such as UPC. Finally, you need to set an expiry date within their limits.

[MachaNeko]

The message from Google clearly states that a description is required for all products. It also recommends certain attributes such as UPC. Finally, you need to set an expiry date within their limits.

firstly, it is an issue when the information is required to properly post your products. the attributes is all im asking about. i dont know how to add certain attributes without killing the php thats why im posting here. i dont need upc or isbn just models. and finally, i didnt ask about the date, thats been set.

[andyshea]

Hi,

i am using version 1.3.7 and just installed google base feeder 1.6.14a. under the folder "sql updates", i just copy and paste all the updates from the 1_6_12 backward until mysql told me that there is a duplicate entry.

everything goes fine and i can generate a xml feed without any problem. but when i tried to open the xml file in IE, it told me that there is a problem at this particular line. i do a comparison with my previous working version and discover this:

original text on my website: Hörbiger
the working version of xml: Hrbiger
after upgrade: Hörbiger

Can someone advise me what should i do with the utf code? it it those weird code (Hörbiger) that cause ie and google fail to read the xml file. tks a million

andy