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

Merchant Center Feed Google Sheets

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Dear Advertisers, 

 

I've an issue with the upload of my Google Sheets to my Merchant Center product feed. 

Somehow my products can't be uploaded and I can't start a campaign for a client of mine. 


The Google Sheets are complete, but my product doesn't have a GTIN or MPN, therefore I used FALSE to the tag.

 

Can someone give me more informations how this works because in my opinion it should be completed.

 

Thank you in advance.
Toni 

2 Expert replyverified_user

Merchant Center Feed Google Sheets

Top Contributor
# 2
Top Contributor

That is because you can not add false as a value to GTIN or MPN.

 

If the manufacturer has not assigned a bar code to the product than do below :

 

You need to set identifier_exists to the value of no

Than do not submit, or have an empty cell for Brand, MPN and GTIN.

 

If the manufacturer has assigned a bar code, you must submit Brand and GTIN.

 

Data feed requirements can be found here :

 

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

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

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

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

 

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’

Merchant Center Feed Google Sheets

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thank you very much for your fast answer, but I might have expressed myself wrongly. 

 

I have used the value "identifier_exists" as 'FALSE'. 
The Google Sheets are complete and in the right form, but somehow It can't be uploaded as a product or as a feed. 

 

The field "Last Upload Date" is empty (-) and I'm trying to find a solution. 

 

Thank you in advance
Toni

Merchant Center Feed Google Sheets

[ Edited ]
Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
 

Merchant Center Feed Google Sheets

Top Contributor
# 5
Top Contributor

As we have no account access, we would not really know what your issue is.

 

I recommend you simply create a new feed and use Google's template than copy paste the data from your original file to the template. This should than work.

If not, please provide more in depth links, screenshots, explanation so we can help.

 

Alternatively if that is not possible, contact Google directly : https://support.google.com/adwords/answer/7218750

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’

Merchant Center Feed Google Sheets

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

https://docs.google.com/spreadsheets/d/e/2PACX-1vT4pO3LVfyqIZX6LsBfNE0BZ4uBtCmqKEQZNNZLGiS3cRz02LuME...

 

This is the link that I can provide for you. Note it is on German, but you might understand it easily.

 

How long does it take to verify the products? This would be my first Google Shopping AdWord.  

Merchant Center Feed Google Sheets

Top Contributor
# 7
Top Contributor

Your spreadsheet seems fine to me. You will need to wait 3 business days up to 5 in certain conditions.

 

I recommend after 3 business days you give them a call.

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’

Merchant Center Feed Google Sheets

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Thank you sincerely and I will keep you updated and will close this thread when everything is alright. 

Merchant Center Feed Google Sheets

[ Edited ]
Top Contributor
# 9
Top Contributor

Also make sure to check for errors in Google Merchant > Product > Feeds > click on your feed

and

Google Merchant > Product > diagnostics

 

Than resolve the issues listed, if no errors are listed you should just need to wait.

 

Just noticed that the shipping price is missing the currency.

 

Here is the reference : https://support.google.com/merchants/answer/6324484?hl=en&ref_topic=6324338

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’

Merchant Center Feed Google Sheets

Top Contributor
# 10