AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
4.6K members online now
4.6K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Problem with shopping feed

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

 

i have some problems with the data feed im submitting for Google Shopping. 

The error reporting in the merchant center says:

File pre-processing: Failure
Basic product data completeness and correctness
DOWNLOAD REPORT
 
in the report, it says just ""XML-Formatierungsfehler",Fehler,,"  which is german and means "XML formatting error, error"
 
--> So nothing in detail
 
When validating the feed against the xsd like suggested in one google doc I found with:
 
i get the error:  "element rss: Schemas validity error : Element 'rss': No matching global declaration available for the validation root. googleShoppingFeed.xml fails to validate"
 
But as I am submitting the feed in Rss2.0 format I am not even sure if valiadating against this XSD is the right way to do it?!?! 
Just validating the xml in a XML validator gives no errors. 
 
I limited the number of items to just 3 now for debugging, and here is the feed:
 
<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
                        <channel>
                        <title>Arbeitsmoden.de Shopping Feed</title>
                        <link>http://www.arbeitsmoden.de/public/uploads/googleShoppingFeed.rss</link>
                        <description>Alle Artikel verfügbar in unserem Shop für Berufsbekleidung und Corporate Fashion Arbeitsmoden.de</description><item>
                             <title>Ziertuch Kunstfaser kupfer</title>
                             <link>http://www.arbeitsmoden.de/CS/Ziertuch-Kunstfaser-kupfer/18330</link>
                             <description><![CDATA[Aus stabiler Poly-Faser gefertigt, ist dieses stilvolle Ziertuch in orange nicht nur im professionellen Bereich eine gute Idee. Das Tuch ist 25 x 25 cm groß.]]></description>
                             <g:mpn>CS0811T</g:mpn>
                             <g:id>CS0811T</g:id>
                             <g:image_link>http://www.arbeitsmoden.de/images/articles/CS0811T_md.jpg</g:image_link>
                             <g:price>3.3193</g:price>
                             
                             <g:availability>in stock</g:availability>                             
                             <g:condition>new</g:condition>
                             <g:feature>handmade</g:feature>                                 
                             <g:size>one size</g:size>
                             <g:brand>Puccini</g:brand>
                             
                             <g:pattern>Uni</g:pattern>
                             <g:material>Mikrofaser</g:material>
                             <g:google_product_category>Apparel &amp; Accessories &gt; Clothing Accessories &gt; Handkerchiefs</g:google_product_category>
                             <g:color>Orange</g:color><g:gender>male</g:gender>                   
                             <g:age_group>adult</g:age_group></item><item>
                             <title>Damen-Bluse 6515  Hotelbekleidung Bleu 62% Baumwolle, 35% Polyester, 3% Elasthan, 130 - elastisch, Kent-Kragen, breite Doppelknopfmanschette</title>
                             <link>http://www.arbeitsmoden.de/GR/Damen-Bluse-6515-Hotelbekleidung-Bleu/26608</link>
                             <description><![CDATA[&lt;ul&gt;&lt;li&gt;elastisch&lt;/li&gt;&lt;li&gt;Kent-Kragen&lt;/li&gt;&lt;li&gt;breite Doppelknopfmanschette&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;Trendig, funktional und pflegeleicht ist diese langarm Bluse f&amp;uuml;r Frauen. Das elastische Mischgewebe sorgt f&amp;uuml;r die notwendige Bewegungsfreiheit im Arbeitsalltag. Ein schlichter Kent-Kragen unterstreicht die klassische Linie von diesem Blusenmodell. Eine breite Doppelknopfmanschette dient als schicker Verschluss am Arm. Insgesamt stehen 10 verschiedene Farben zur Auswahl, so dass auch f&amp;uuml;r Ihren Betrieb die passende Farbe dabei sein wird. Bei dem wei&amp;szlig;en Modell bieten wir noch eine zus&amp;auml;tztliche Konfektionsgr&amp;ouml;&amp;szlig;e an (Gr. 54).&lt;/p&gt;]]></description>
                             <g:mpn>6515.1120.029-50</g:mpn>
                             <g:id>6515.1120.029-50</g:id>
                             <g:image_link>http://www.arbeitsmoden.de/images/articles/6515.1120.029_md.jpg</g:image_link>
                             <g:price>38.6512</g:price>
                             
                             <g:availability>in stock</g:availability>                             
                             <g:condition>new</g:condition>
                             <g:feature>handmade</g:feature>                                 
                             <g:size>50</g:size>
                             <g:brand>Greiff</g:brand>
                             
                             
                             
                             <g:google_product_category>Apparel &amp; Accessories &gt; Clothing &gt; Shirts &amp; Tops</g:google_product_category>
                             <g:color>Bleu</g:color><g:gender>female</g:gender>                   
                             <g:age_group>adult</g:age_group></item><item>
                             <title>Bistro-Schürze 4192 Sand - 100 x 80 cm</title>
                             <link>http://www.arbeitsmoden.de/GR/Bistro-Schuerze-4192-Sand/23090</link>
                             <description><![CDATA[&lt;ul&gt;&lt;li&gt;Einzelpack&lt;/li&gt;&lt;li&gt;Stoffband&lt;/li&gt;&lt;li&gt;Breite/L&amp;auml;nge 100 x 80 cm&lt;/li&gt;&lt;/ul&gt;Die Bistrosch&amp;uuml;rze ist perfekt geeignet f&amp;uuml;r Servicekr&amp;auml;fte, die sich viel bewegen m&amp;uuml;ssen. Mit einer L&amp;auml;nge von 80 cm ist eine optimale Bewegungsfreiheit in jedem Fall gew&amp;auml;hrleistet. Das strapazierf&amp;auml;hige Stoffband hindert die Sch&amp;uuml;rze am Verrutschen. Die Sch&amp;uuml;rze ist in verschiedenen leuchtenden Farben erh&amp;auml;ltlich. Selbstverst&amp;auml;ndlich erf&amp;uuml;llt die Bistrosch&amp;uuml;rze ihre wichtigste Aufgabe mit Bravur und sch&amp;uuml;tzt die Kellnerkleidung zuverl&amp;auml;ssig vor Verschmutzungen. Durch ein widerstandsf&amp;auml;higes Mischgewebe aus Polyester und Baumwolle l&amp;auml;sst sich die Sch&amp;uuml;rze leicht reinigen. Eine W&amp;auml;sche bei 95&amp;deg; erf&amp;uuml;llt dabei h&amp;ouml;chste Hygienestandards.]]></description>
                             <g:mpn>4192.6000.037-verstellbar</g:mpn>
                             <g:id>4192.6000.037-verstellbar</g:id>
                             <g:image_link>http://www.arbeitsmoden.de/images/articles/4192.6000.037_md.jpg</g:image_link>
                             <g:price>9.52</g:price>
                             
                             <g:availability>in stock</g:availability>                             
                             <g:condition>new</g:condition>
                             <g:feature>handmade</g:feature>                                 
                             <g:size>verstellbar</g:size>
                             <g:brand>Greiff</g:brand>
                             
                             
                             
                             <g:google_product_category>Apparel &amp; Accessories &gt; Clothing &gt; Skirts</g:google_product_category>
                             <g:color>Sand</g:color><g:gender>unisex</g:gender>                   
                             <g:age_group>adult</g:age_group></item></channel></rss>
Thank you in advance.
Kind regards,
Manuel Wiese
 
 
 
 
 
1 Expert replyverified_user

Problem with shopping feed

[ Edited ]
Top Contributor
# 2
Top Contributor


this is mainly a peer-to-peer community forum --
forum-members do not have access to details,
such as which target-country the feed was registered,
how the feed was registered, how exactly the feed was
uploaded, and the exact error details within the account.

a link to the exact, specific, file being uploaded,
and some more specific details, posted here
within the public-forum, may allow others to
offer more specific suggestions.

otherwise, the best likely course would be to contact google directly.

when submitting that particular xml snippet, for a feed registered for germany,
there is no such preprocessing failure -- but, the following errors are shown:

Artikel-ID,Zeilennummer,Meldung,Typ,Werte,Artikeltitel
,"24","Nicht unterstützte Währung in Attribut: preis",Fehler,&quot;Wert=38.6512&quot;,
,"5","Nicht unterstützte Währung in Attribut: preis",Fehler,&quot;Wert=3.3193&quot;,
,"43","Nicht unterstützte Währung in Attribut: preis",Fehler,&quot;Wert=9.52&quot;,
"CS0811T","5","Ungültiges oder fehlendes erforderliches Attribut: preis",Fehler,,&quot;Ziertuch Kunstfaser kupfer&quot;
"4192.6000.037-verstellbar","43","Ungültiges oder fehlendes erforderliches Attribut: preis",Fehler,,&quot;Bistro-Schürze 4192 Sand - 100 x 80 cm&quot;
"6515.1120.029-50","24","Ungültiges oder fehlendes erforderliches Attribut: preis",Fehler,,&quot;Damen-Bluse 6515 Hotelbekleidung Bleu 62% Baumwolle, 35% Polyester, 3% Elasthan, 130 - elastisch, Kent-Kragen, breite Doppelknopfmanschette&quot;

 

also, id values are best as all alphanumeric --

plain text, no symbols, and a mix of letters

and numbers (e.g. abc123).

 

also, price/currency must be fixed and cannot be

automatically converted to other currencies, by

merchants; normally, fixed-price precision should

be two digits; e.g. 38.65

also, handmade items require identifier_exists set to no
and mpn, brand, and gtin should not be submitted, at all.

global-trade-data (brand, mpn, gtin)
cannot be self-assigned by merchants.

 

global-trade-data is mainly for manufactured

items that are also sold by multiple merchants.

the seller/business brand, as set in the account,
will automatically be submitted by google and there
is no need to submit any brand, again, in the feed,
for such handmade items.

also, there is no such google-defined attribute as feature.

also, that xsd is for a ratings-feed not for a products-feed --
product-feeds are not standard rss2.0 and there is no current,
published, xsd by google for a products-feed; a products-feed
uses a google-xml derivative/hybrid of the standards.

see also
https://www.de.advertisercommunity.com/t5/Google-Shopping-Merchant-Center/bd-p/shopping

 

Problem with shopping feed

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi,

thank you very much. You really helped me.

Do you have an idea why i dont get

these errors shown you submitted:

when submitting that particular xml snippet, for a feed registered for germany,
there is no such preprocessing failure -- but, the following errors are shown:

Artikel-ID,Zeilennummer,Meldung,Typ,Werte,Artikeltitel
,"24","Nicht unterstützte Währung in Attribut: preis",Fehler,&quot;Wert=38.6512&quot;,
,"5","Nicht unterstützte Währung in Attribut: preis",Fehler,&quot;Wert=3.3193&quot;,
,"43","Nicht unterstützte Währung in Attribut: preis",Fehler,&quot;Wert=9.52&quot;,
"CS0811T","5","Ungültiges oder fehlendes erforderliches Attribut: preis",Fehler,,&quot;Ziertuch Kunstfaser kupfer&quot;
"4192.6000.037-verstellbar","43","Ungültiges oder fehlendes erforderliches Attribut: preis",Fehler,,&quot;Bistro-Schürze 4192 Sand - 100 x 80 cm&quot;
"6515.1120.029-50","24","Ungültiges oder fehlendes erforderliches Attribut: preis",Fehler,,&quot;Damen-Bluse 6515 Hotelbekleidung Bleu 62% Baumwolle, 35% Polyester, 3% Elasthan, 130 - elastisch, Kent-Kragen, breite Doppelknopfmanschette&quot;

 

For me it just gives: 

Feedname,Feed-ID,Kundennummer,Uhrzeit des Uploads
"AMD alle Produkte","103754965","116893312","15.09.2017 14:40 MESZ"

Artikel-ID,Zeilennummer,Meldung,Typ,Werte,Artikeltitel
,,"XML-Formatierungsfehler",Fehler,,

 

and thats it (in the error report). How can i see the detailed errors you submitted?

 

Thank you very much

Manuel Wiese

Problem with shopping feed

Top Contributor
# 4
Top Contributor

first, you're welcome.

one possibility is that there is an issue with the file itself,
that is lost or removed, when using a copy-and-paste of

the data, here in the forum.

without, at least, a link to the exact file being submitted,
a description of the exact steps being used to submit the

data, a screen-capture of the  products-feed section of

the account, and a screen-capture of the details section

under the feeds-tab, pinpointing the issues will become

rather problematic, and fast becomes beyond the scope

of the forum.

even with those details, there is no substitute for a direct inspection.

otherwise, the best likely course is to simply contact google --
so a person, at google, may download the exact file being

submitted, and inspect all related account details, directly;

also, if there is an issue with the processing itself, not with

the file, then only a person at google will be able to address

the issue properly.

 

Problem with shopping feed

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi,

thank you.

I wanted to contact a person at google, but someone said you cant catch them directly but go over a community forum..

How do i contact someone from google?

 

Problem with shopping feed

[ Edited ]
Top Contributor
# 6
Top Contributor

first, you're welcome.

 

to contact a person at google, login to google, go to the linked ad-account,
and simply click on the gear-icon, near the upper-right-hand-corner --
https://adwords.google.com/

or, login to the associated google-account and use the following link --
https://support.google.com/merchants/contactflow

weekdays, during normal business-hours, is usually best.

when contacting or communicating, with google, be certain to clearly indicate,
early on, that the issue relates to the merchant-center (feed) for shopping-ads;
mentioning shopping-ads/shopping-campaign/merchant-center, usually helps.