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.4K members online now
4.4K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Google Merchang center feeds error

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I'm testing the google merchant center feed out with a google spreadsheet with all the title, description, price, condition, and shipping filled out. After fetching the spreadsheet, I'm getting a list of errors below. Could some one tell me what is wrong? I have link and image link filled out but the error is telling me those fields are missing.

 

Version:1.0 StartHTML:000000268 EndHTML:000461928 StartFragment:000447467 EndFragment:000461651 StartSelection:000447566 EndSelection:000461645 SourceURL:https://merchants.google.com/mc/products/sources/detail?a=118816016&dataSourceId=107047926&tab=proce... Center

keyboard_arrow_down 16 errors, 2 warnings
keyboard_arrow_down 2 ERROR: Insufficient product identifiers: Missing two out of three attributes [GTIN, brand, mpn].
Hard goods must have values for two out of the following attributes: gtin, brand, mpn. Please make sure to include this required attribute in your data feed.
Row Nr.
3
4
keyboard_arrow_down 2 ERROR: Invalid or missing required attribute: availability.
Please make sure all required attributes are valid and included in your data feed.
Row Nr.
3
4
keyboard_arrow_down 2 ERROR: Invalid or missing required attribute: condition.
Please make sure all required attributes are valid and included in your data feed.
Row Nr.
3
4
keyboard_arrow_down 2 ERROR: Invalid or missing required attribute: id.
Please make sure all required attributes are valid and included in your data feed.
Row Nr.
3
4
keyboard_arrow_down 2 ERROR: Invalid or missing required attribute: link.
Please make sure all required attributes are valid and included in your data feed.
Row Nr.
3
4
keyboard_arrow_down 2 ERROR: Invalid or missing required attribute: price.
Please make sure all required attributes are valid and included in your data feed.
Row Nr.
3
4
keyboard_arrow_down 2 ERROR: Invalid or missing required attribute: title.
Please make sure all required attributes are valid and included in your data feed.
Row Nr.
3
4
keyboard_arrow_down 1 ERROR: Too few subattributes for attribute: Shipping.
Please make sure the attribute includes the correct number of subattributes. All colons between subattributes, even for blank values, are required.
Cell
I2
keyboard_arrow_down 1 ERROR: Too few subattributes for attribute: Tax.
Please make sure the attribute includes the correct number of subattributes. All colons between subattributes, even for blank values, are required.
Cell
J2
keyboard_arrow_down 2 WARNING: Invalid or missing recommended attribute: image link.
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
Row Nr.
3
4
1 Expert replyverified_user

Google Merchang center feeds error

Top Contributor
# 2
Top Contributor

1) Make sure you have a Brand, GTIN and or MPN if the manufacturer has assigned one, if they have not then remove all 3 fields and set identifier exists to no

https://support.google.com/merchants/answer/6324351

https://support.google.com/merchants/answer/6324461

https://support.google.com/merchants/answer/6324482

https://support.google.com/merchants/answer/6324478

 

2) Make sure you have one of the 3 availability assigned in stock, out of stock or preorder

https://support.google.com/merchants/answer/6324448

 

3) Make sure you have assigned a condition, new, used, refurbished

https://support.google.com/merchants/answer/6324469

 

4) Make sure every product has an id, link, price, title and image

 

5) Make sure you have assigned the correct shipping attribute value for example: US:::6.49 USD

https://support.google.com/merchants/answer/6324484

 

6) Make sure you have assigned the correct tax attribute for example : US::6.49:yes

https://support.google.com/merchants/answer/6324454

 

I recommend reading all documentation.

 

Hope it helps.

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

Google Merchang center feeds error

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Emmanuel,

 

Thank you for your reply above - i am having the same errors and I could not overcome till now.

 

Is it possible you share with us a sample of a working Tab delimited file? perhaps with one row

 

I tried all combinations and it has become frustrating.

 

Thank you in advance

Sam

Google Merchang center feeds error

Top Contributor
# 4
Top Contributor

Sure here is an official example : https://drive.google.com/open?id=1c6dQwJfVbMP1vFwFJE93tTXfUvsAm54OvY0YQw84VjI

 

Hope it helps

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

Google Merchang center feeds error

[ Edited ]
Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hello @Emmanuel F

Where can I see identifier exists?

I have really problem.
I have the feed in Merchat Center and the list that include about 1.500 products. I use .xml file.
All products good for Belgium (Dutch and French).
But products' list not good for Netherland. My shopping campagnie work good for Belgium. But don't work for Netherlands.
What is problem?

Google Merchang center feeds error

Top Contributor
# 6
Top Contributor

I would not know what your problem is, we have no access to your accounts, you will need to contact Google to resolve this : https://support.google.com/adwords/answer/7218750

 

With regards to where can I see Identifier Exists, simply go to Google Merchant > Product > List > click on a product and scroll to the bottom of the page and view data supplied.

 

If you don't see it, it means it is set to yes / true

 

I recommend for future reference to always create a new thread, not reply on an existing one. As each merchant might have the sounding problem, it will always be a different solution. This will also allow other forum members to better help you.

 

Hope it helps

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’