Google Base - Suddenly throwing errors

[mr.chetanladdha]

Hi Experts,

I have been running google base without any problems since a long now.

Suddenly, all the products around 1000 on google base have been disapproved. Result : Sales Slumped by over 80%

I had a peek at the google base dashboard and it says :

"On Sept. 22, we started gradually enforcing the new Google products feed spec requirements."

Starting 1st October, all the products are deavtivated.

When I upload the product feed using the Zencart admin, there is no issue and the upload shows OK and the product feed is also created without any error. The error comes when it goes to google base for validation now.

The errors shown are :

1.

Item Errors - 878 items with errors 878 items affected
878
Missing required attribute: availability (878 errors, only affecting Product Search, Search API for Shopping)

Please make sure you include all required attributes in your data feed.
Examples: Examples:
Item ID Line Nr.
1232 49 Show Item
1324 217 Show Item
1238 469 Show Item
1310 1,288 Show Item
1298 1,456 Show Item

2.

Item Warnings - 1756 items with warnings 1756 items affected
878
Expiration date is too far in the future (878 warnings)

Please make sure the value doesn't exceed the default expiration date for your item type.
Learn more.
Examples: Examples:
Item ID Line Nr. Value
1260 75 2011-11-02T06:57:36 Show Item
1323 138 2011-11-02T06:57:36 Show Item
1321 180 2011-11-02T06:57:36 Show Item
1335 348 2011-11-02T06:57:36 Show Item
980 516 2011-11-02T06:57:36 Show Item
878


3.
Missing recommended attribute: google product category (878 warnings)

While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available


I tried looking for a similar issue faced by someone in the forum but couldnt get something on which I can act upon.

Please let me know how do I proceed with solving these errors through the admin in Zencart .

I would be very glad for the help.

Regards,
Chetan

[buildingblocks]

It's likely your feeder version doesn't include google product category.

This is the thread you need to see

http://www.zen-cart.com/forum/showth...67850&page=317

google feed specifications

http://www.google.com/support/mercha...4&expand=US#US

[mr.chetanladdha]

Hi,

I looked into the forum you said and also explored merchant center.
I had a look at my google base account also.

I see that there is just one problem with the feed which is causing problems.

The XML feed generated from Zencart does not contain the below attribute which is shown in RED by google base error.

<g:availability>in stock</g:availability>

Now, if there can be a way to include this attribute in the product feed, the error will go off.

Can you please suggest some modifications so that this can happen.

Regards,
Chetan

[mr.chetanladdha]

I could resolve he second warning of the expiration date too far in future by setting the configuration to 29 days.

However, the error for required attribute availability still remains along with the warning for Missing recommended attribute: google product category.

Hope i get some help for these two points. I guess I will have to update some files and some sql injection.

Request help at the earliest.

Chetan

[buildingblocks]

in your merchant center feeder configuration is your "show quantity" set to true?

[mr.chetanladdha]

Hi,

Yes its set to show qty is set to true.

Now what i did is, installed a new merchant feeder module by numinix which documentations says that it has included the availaibility atribute in it.

I installed it and created a feed. The feed did get successfully created. Out of all the products, however the feed got generated for only 127 items and they got inserted.

Now, there is a altogether new error which crops up.


XML formatting error - Error
Our system encountered an error when processing your data feed.
Learn more.
Examples: Examples:

Line Nr. Column Nr.
3,166 83


When I click on learn more,it says,

Error parsing/validating XML feed Our system encountered an error when processing your XML data feed. Please see the following Help Center topics for more information:

XML tag mismatch

Invalid RSS/Atom document format


Now, I wonder that how do i get all items to get uploaded.


Atleast I could get some breakthrough here. I guess there is a problem with the feed itself getting generated improperly or maybe somethin somewhere is truncating.

Please let me know your thoughts if anyone can help.

Regards,
Chetan

[buildingblocks]

Hi,

Yes its set to show qty is set to true.

Now what i did is, installed a new merchant feeder module by numinix which documentations says that it has included the availaibility atribute in it.

I installed it and created a feed. The feed did get successfully created. Out of all the products, however the feed got generated for only 127 items and they got inserted.

Now, there is a altogether new error which crops up.


XML formatting error - Error
Our system encountered an error when processing your data feed.
Learn more.
Examples: Examples:

Line Nr. Column Nr.
3,166 83


When I click on learn more,it says,

Error parsing/validating XML feed Our system encountered an error when processing your XML data feed. Please see the following Help Center topics for more information:

XML tag mismatch

Invalid RSS/Atom document format


Now, I wonder that how do i get all items to get uploaded.


Atleast I could get some breakthrough here. I guess there is a problem with the feed itself getting generated improperly or maybe somethin somewhere is truncating.

Please let me know your thoughts if anyone can help.

Regards,
Chetan

Turn on debug to see what messages you are give when generating a feed.

[honeypot]

Hi,
You are lucky I had the same problem. It does seem that you have installed the add on correctly. However, when you are creating the feed it does not complete because there is an error with one of your products within the feed. This could be for example if you have uploaded one of your images with an '&' symbol (which was the problem in my case). To find out exactly which product(s) are causing the problem you need to open up the feed file in internet explorer (you can also open in firefox to find the problem but you need an addon which will find the error in the source code). You should receive an error page instead of the xml feed. If you click on the link at the bottom of the error page it will tell you exactly which product is causing the issue. You can then correct it. Then reupdate the feed and repeat until all errors are resolved. On the final time you open in internet explorer you should see the xml feed instead of the error page. I am not sure if this process will work with earlier vesions of internet explorer. Once you have done this you will resolve the XML mismatch error because your feed is complete.

[mr.chetanladdha]

@ buildingblocks : Debug is ON. When i create a feed, it doesnt show any error. It is when it uploads, the error comes.

@ honeypot : You seem to be bang on target. Exactly, I do have images with & in them !!!

Let me try if what you say works !

Is your problem resolved now ?

Regards,
Chetan

[mr.chetanladdha]

Hi,

@ Honeypot : I have done as you said. Opened the feed file in IE and checked. The error i have attached as a screesnhot. You may please review. Here the product image seems that the & MAY be causing the error.

Would this necessarily mean that I have to change the image names of all images with the " & " in it ???

How did you go about this ?

Thanks,
Chetan