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

Invalid GTIN Value in tab delimited feed upload

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have read every thread on this topic, but the suggestions never provide format examples except for clothing items which apparently have different requirements.  When people recommend things like "simply set identifier_exists as false" this suggestion does not explain how to position those values in a tab delimited file.  I have tried over 10 file uploads trying different values and always have invalid GTIN error.

 

I have talked to 3 Adwords support personnel and none of them have provided the same answer or an answer that works.  I have a phone appointment with an Adwords Feed Specialist in a few days . . but I keep trying anyway.

(these screen shots are from Excel for clarity . . I submit in tab-delimited)

 

I have tried this based on explicit instructions from an Adwords support person
excel11.png

 

I have tried this based on everything else I have seen 

excel2.png

 Everything I have tried results in invalid GTIN value

2 Expert replyverified_user

Invalid GTIN Value in tab delimited feed upload

[ Edited ]
Top Contributor
# 2
Top Contributor

under the identifier_exists column, set the cell-value to no (or FALSE) --
then, under the brand, mpn, and gtin columns, leave each cell value

entirely empty.

if all items submitted have the identifier_exists (cell) value set to no then,
the brand, mpn, and gtin columns may be deleted, altogether, from the sheet.

 

see also

https://docs.google.com/spreadsheets/d/1HKR9iGI6oi836p7xW0aokzBkIcK5Q34eaMgeMzjJt0U/edit#gid=1995720...

 

https://docs.google.com/spreadsheets/d/10boSjly4C5tOUfiqpFD5WKPnTCzsp37HdEgGQMl6C8k/edit?usp=sharing

 

Re: Invalid GTIN Value in tab delimited feed upload

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

You said  "


Celebird wrote:

under the identifier_exists column, set the cell-value to no (or FALSE) --


Do you mean the cell value is literally    "no (or FALSE)"

or do you mean                        use "no"  or use "FALSE"

 

If you leave brand and mpn values blank, that means that 2 or 3 tabs in the file with no values will keep subsequent values in the associated with the correct identifier above ?    right ?

 

Also Google warns missing values or identifier_exists >  false will likely lead to suspending the add in the future. 
Do you think that is true ?

 

Invalid GTIN Value in tab delimited feed upload

[ Edited ]
Rising Star
# 4
Rising Star

I recommend to check out celebird's spreadsheet example, it shows without any confusion what the correct value is.

 

If the manufacturer has assigned a bar code you need to add this value in the GTIN column and set the Brand and remove the value identifier exists for that product.

If there is no bar code, remove gtin, brand and mpn. Than assign identifier exists to false

 

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’

Invalid GTIN Value in tab delimited feed upload

[ Edited ]
Top Contributor
# 5

Re: Invalid GTIN Value in tab delimited feed upload

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Thanks for your comments.   I have it all working now.  I never saw an example feed file for a product with no brand etc.   It all so simple "after you know".

 

Thanks.