Upgrade to V11 and Google Product Search not accepted

[hammer]

Hello,

I just completed upgrading on Windows Server 2003 from v10 to v11, and now Google Product Search feed has failed. I can upload the file, but Google when not insert any of the products and is telling me that 130 of 130 products have errors, so I end up with 0 products.

Anyone have any idea what has changed? Google accepted by feed just fine while using v10, with all products inserted.

Any guidance appreciated.

[Jim]

Upgrading to 11 had nothing to do with the feed failing now. This was a change implement by Google in September. See the Kbase article at http://support.shopsite.com/KBase/questions/2539
for suggestions on how to work around the problem.

Note that ShopSite 11sp1 was recently released on Linux and will be released on FreeBSD and Windows shortly. It contains additional functionality for the Google requirements for clothing.

[hammer]

Hello Jim,

Thank you for the reply. Per your information, I went ahead and added the extra field for availability and did the global edit for in stock. I doubled checked all other required fields to make sure they were set up, i.e.

condition
availabilty
price
brand
description
mpn
product type
google product categroy (as an extra field)

and they are all set up. I checked and the last successful submission I had with Shopsite 10 sp2 (Windows server) was on 10/12/2011 when the froogle feed was submitted with nor errors for 115 products.

Tried three times today, and all the froogle feed is created an uploaded, but no products are inserted. 0 -115

Google Feed Status Details indicates I am missing the following required information for all 115 products:

Condition
availability
price
brand
description
mpn
google_product_category
imagelink
product type


Google Error Detail
________________________
Missing required attribute: condition
Processed Item:
Attribute Name Attribute Value
id PID#7
title Select Grade Two Pound Lobsters
link http://www.lobsters-online.com/catalog/lobster.html#7
n:expiration_date 2011-11-25T16:39:37
condition
Item submitted in your feed:
<entry>
<batch:id>PID#7</batch:id>
<batch:operation type="insert"/>
<sc:id>PID#7</sc:id>
<app:control><sc:required_destination dest="ProductSearch"/></app:control>
<sc:content_language>en</sc:content_language>
<sc:target_country>US</sc:target_country>
<sc:expiration_date>2011-11-02</sc:expiration_date>
<title><![CDATA[Select Grade Two Pound Lobsters ]]></title>
<scp:price unit="USD">38.95</scp:price>
<sc:image_link>http://www.lobsters-online.com/catalog/media/lobster_whiteplate_140.jpg</sc:im...

------------------------------------------
Error:
Missing required attribute: availability

Processed Item:
Attribute Name Attribute Value
id PID#34
title Lobster Clambake for Four
link http://www.lobsters-online.com/catalog/lobclmbk.html#34
n:expiration_date 2011-11-25T16:39:37
availability
Item submitted in your feed:
<entry>
<batch:id>PID#34</batch:id>
<batch:operation type="insert"/>
<sc:id>PID#34</sc:id>
<app:control><sc:required_destination dest="ProductSearch"/></app:control>
<sc:content_language>en</sc:content_language>
<sc:target_country>US</sc:target_country>
<sc:expiration_date>2011-11-02</sc:expiration_date>
<title><![CDATA[Lobster Clambake for Four]]></title>
<scp:price unit="USD">145.95</scp:price>
<sc:image_link>http://www.lobsters-online.com/catalog/media/lobster_clambake_140.jpg</sc:image_li...

------------------------------------
Error:
Missing recommended attribute: google product category

Processed Item:
Attribute Name Attribute Value
id PID#66
title Lobster Ravioli
link http://www.lobsters-online.com/catalog/lobstertails.html#66
n:expiration_date 2011-11-25T15:52:47
google product category
Item submitted in your feed:
<entry>
<batch:id>PID#66</batch:id>
<batch:operation type="insert"/>
<sc:id>PID#66</sc:id>
<app:control><sc:required_destination dest="ProductSearch"/></app:control>
<sc:content_language>en</sc:content_language>
<sc:target_country>US</sc:target_country>
<sc:expiration_date>2011-11-02</sc:expiration_date>
<title><![CDATA[Lobster Ravioli]]></title>
<scp:price unit="USD">9.95</scp:price>
<sc:image_link>http://www.lobsters-online.com/catalog/media/yankeeraviolilob2.JPG</sc:image_link>
<scp:quanti...

------------------------------------------------------
Error:
Missing required attribute: price

Processed Item:
Attribute Name Attribute Value
id PID#34
title Lobster Clambake for Four
link http://www.lobsters-online.com/catalog/lobclmbk.html#34
n:expiration_date 2011-11-25T16:39:37
price
Item submitted in your feed:
<entry>
<batch:id>PID#34</batch:id>
<batch:operation type="insert"/>
<sc:id>PID#34</sc:id>
<app:control><sc:required_destination dest="ProductSearch"/></app:control>
<sc:content_language>en</sc:content_language>
<sc:target_country>US</sc:target_country>
<sc:expiration_date>2011-11-02</sc:expiration_date>
<title><![CDATA[Lobster Clambake for Four]]></title>
<scp:price unit="USD">145.95</scp:price>
<sc:image_link>http://www.lobsters-online.com/catalog/media/lobster_clambake_140.jpg</sc:image_


and similar for other attributes.

I can e-mail you a copy of the froogle feed file if that would help figure out what is happening.

[Jim]

What version is your store currently? Go to the backoffice, click on the ShopSite image at the top - left of the navbar and in the footer there should be some text something like "ShopSite® Pro 11 sp1, StoreID: jimsp1".

Did you create appropriate attribute names for all of the extra product fields you are using for Google feed on the Preferences > Extra Fields screen?

Did you go to Merchandising > Google Services >Product Search > Configure and check all the Extra fields that will be used for Google feed?

Did you name the attributes exactly as Google requires, i.e. "availability" and not "Availability", since the names are case sensitive.

You can view what was actually sent to Google by going to Merchandising > Google Services > Product Search and click the Feed Last Submitted: date which is link. On that screen there will be a link near the top that says "Click here to view the original datafeed" . Are the attributes you enabled shown in the xml?

[hammer]

Hello Jim,

Thank you again for the reply. I am running ShopSite Pro v11 r1.1. for Windows Server 2003

I did successfully create the attribute names in Preferences > extra fields

I did go to Google Services > Product Search and configure the Extra fields for use in Google feed.

The syntax for extra field attributes match what is required, i.e. availability vs. Availability.

I downloaded from Google the file that was created when I uploaded the froogle_feed.xml file. Here is what I found:

Attributes in file:
mpn
condition
availability
price
Brand
google_product_category

Attributes not in file:
description
image link
product type

(please note: I checked against froogle-feed.xml file before uploading and the attributes are also found/missing as per the google download. In other words, same in, same out)
------------------------------

Details from Google on Missing Attributes from froogle_feed.xml for all 115 products
---------------------------------------
condition error missing
availability error missing
price error missing
brand warning missing
description warning missing
mpn warning missing
google_product_category warning missing
image link warning missing
product type warning missing

------------------------------------------------


The file One thing I did notice on Google for the froogle_feed.xml set up for uploading is that there are various settings. Google asks;

format
encoding
delimiter
quoted fields yes/no

what should these be set at for this file?

[Jim]

Regarding these attributes not in file:
description -- What do you have configured for this on Merchandising > Google Services > Product Search > Configure > Description
image link -- What do you have configured for this on Merchandising > Google Services > Product Search > Configure >Image
product type -- What do you have configured for this on Merchandising > Google Services > Product Search > Configure > Product type.

Does your product actually have anything in the fields that you have configured to be sent for those values? If they are blank ShopSite will not send them because Google won't accept blank data.

Regarding these format, encoding, delimiter, quoted fields yes/no
Those look like attributes of a text file not an xml file. All those things are specified in the header section of the xml file or in the data itself. What is the url to the page on Google where you saw those setting? I'll take a look at it and see what it is trying to say.

[hammer]

Hello Jim,

The url for the google setting is the Merchant Center > Data feeds using the edit button here:

http://www.google.com/merchants/bulkuploads click edit

http://www.google.com/merchants/updatefeed

---------------------------------------------------------
All the problem attributes have data in them.

Merchandising > Google Services > Product Search > Configure > Description Set to drop down "Product Description"

image link -- What do you have configured for this on Merchandising > Google Services > Product Search > Configure >Image Set to "Product"

product type -- What do you have configured for this on Merchandising > Google Services > Product Search > Configure > Product type Set to "Google Product Search (product type) which is filled in for all products.

[Jim]

My Google account has googlebase for the Format and Autodetect for the other fields and Quoted Fields is set to Yes. I believe these are all the default settings.

[TheEveningStore]

I have the exact same problem with ShopSite® Pro 10 sp2 r2.4

My feed is accepted, 93 products. But mpn and google-product-category are missing.

I see from this thread that there might be a way to configure this using spare fields. Haven't tried it yet.

We are the mfr so the mpn should simply be our style#.

The google-product-category is their taxonomic listing and that is very important for us as we sell evening gowns. In examining their warning (see below) SS is putting the data for this into product_type instead of google-product-category. The product_type is free-form as I recall while the category must exactly match the available google listings.

Any advice?

Chris

----


Error:
Missing recommended attribute: google product category

Processed Item:
Attribute Name Attribute Value
id PID#2
expiration date 2012-07-07
title Heidi
price 149
image link http://theeveningstore.com/store/media/products/119_pg.jpg
link http://theeveningstore.com/store/product2.html#2
product type Apparel & Accessories > Clothing > Dresses > Formal Dresses > Gowns
availability in stock
payment accepted Visa
payment accepted MasterCard
payment accepted Discover
payment accepted AmericanExpress
payment notes PayPalExpress
weight 3 lbs
condition New
brand TheEveningStore.Com
description Missy and Plus Sizes - Click for More Information Click on Imagefor More Information
currency USD
google product category
Item submitted in your feed:

<entry>
<g:id>PID#2</g:id>
<g:expiration_date>2012-07-07</g:expiration_date>
<title><![CDATA[Heidi]]></title>

<g:price>149</g:price>
<g:image_link>http://theeveningstore.com/store/media/products/119_pg.jpg</g:image_link>
<link rel='alternate' type='text/html' href='http://theeveningstore.com/store/product2.html#2'/>
<g:product_type><![CDATA[Apparel & Accessories > Clothing > Dresses > Formal Dresses > Gowns]]></g:product_type>
<g:Availability><![CDATA[in stock]]></g:Availability>
<g:payment_...

[robm]

Chris,

If you can upgrade to the latest version (11 SP2r3), then these new fields will be available for each product under "Edit Product Info".

If you cannot or do not want to upgrade, then you would have to use extra product fields to add these values. We have a blog post about it at:

http://www.lexiconn.com/blog/2010/08/new-google-product-search-requirements/

Rob