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

4.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 values

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am getting this error message:

 

Invalid GTIN value.
Please make sure the value is a valid UPC-A (GTIN-12), EAN/JAN (GTIN-13), or GTIN-14.
 
The value is showing up in 6.44E+12 format. No matter what I enter, it keeps changing back to this format.
 
1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by Emmanuel F (Top Contributor)
June

Invalid GTIN values

[ Edited ]
Top Contributor
# 2
Top Contributor

a value showing up as 6.44E+1 or similar,

typically indicates that the spreadsheet is

improperly configured.

 

generally, select the entire column,

remove all formatting, and change

the format to plain-text.

 

the details depend on the spreadsheet being used --

microsoft-excel, google-sheets, libreoffice-calc, etc.

 

all the data entered and submitted to google should be plain text --

never numbers, html, css, special characters, or anything similar.

 

otherwise, post, here in public, more exact information

about the exact, specific, spreadsheet-program being

used, and possibly also post a public, read-only, url link,

to the exact spreadsheet being submitted, so that other

forum-members may offer more specific suggestions.

 

otherwise, the best likely course is to contact google.

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by Emmanuel F (Top Contributor)
June

Invalid GTIN values

[ Edited ]
Top Contributor
# 2
Top Contributor

a value showing up as 6.44E+1 or similar,

typically indicates that the spreadsheet is

improperly configured.

 

generally, select the entire column,

remove all formatting, and change

the format to plain-text.

 

the details depend on the spreadsheet being used --

microsoft-excel, google-sheets, libreoffice-calc, etc.

 

all the data entered and submitted to google should be plain text --

never numbers, html, css, special characters, or anything similar.

 

otherwise, post, here in public, more exact information

about the exact, specific, spreadsheet-program being

used, and possibly also post a public, read-only, url link,

to the exact spreadsheet being submitted, so that other

forum-members may offer more specific suggestions.

 

otherwise, the best likely course is to contact google.

 

Re: Invalid GTIN values

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
I was assuming something like that, but how do I get rid of it?

Invalid GTIN values

[ Edited ]
Top Contributor
# 4
Top Contributor

as was indicated, the exact instructions will depend on
the specific spreadsheet being used, and how the feed

was initially registered in the merchant-center.

this is primarily a peer-to-peer public community forum --
forum-members do not have access to the feed or accounts.

generally, the steps are:
(a) change the format of all columns, in the spreadsheet, to plain-text;
(b) visually verify that all the data in the spreadsheet is accurate;
(c) navigate to the merchant-center-account under the products-feeds-tab:
https://merchants.google.com/mc/products/sources
(d) click on the registered-feed's name -- then,
click fetch-now, or select upload-input-file by clicking on the
three-dot-menu, under the processing-tab -- depending on

how the feed was initially registered.
(e) wait a few hours for google to process the changes --
verify processing by inspecting the feed-processing-tab and
verify per-item status by clicking on the item's title, under
the products-list-tab.

 

if the messages were under the processing-tab, then the messages

will be gotten rid of, if the spreadsheet changes were made properly

and the fetch/upload was successful, after a few hours time --

if the messages were under the diagnostics-tab, then the message

will be gotten rid of, if the spreadsheet changes were made properly

the fetch/upload was successful, and after google crawls the website,

typically after 72-hours or so; the diagnostics-tab is a historic-log, for

for investigative, root-cause-analysis, and diagnostic purposes, so
any messages or reported issues may remain for about 30-days.

otherwise, the best likely course is to contact google --
so that a person at google can look into the details and
possibly offer more account-specific instructions.