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

Delivering Shop Feed via Spreadsheet. Do not have MPN/GTIN. What should I do?

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey there! I am trying to submit my shop feed to google shopping, but for the products I am listing, there's no MPN or GTIN.
I am currently creating my feed with google sheets, so how should I proceed to properly submit the data. Simply don't include the fields for GTIN/MPN? Hope someone can help me out. Thanks and best regards, Antonio

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Antonio V
November 2016

Re: Delivering Shop Feed via Spreadsheet. Do not have MPN/GTIN. What should I do?

[ Edited ]
Top Contributor
# 2
Top Contributor

for a spread-sheet, if the product does not have valid mpn or gtin:
(a) add a column (header) labeled: identifier_exists
(b) for all such items, insert an identifier_exists (cell) value of: no
(c) leave brand, gtin, and mpn cells entirely blank (entirely empty);
be certain the brand, gtin, and mpn cells have no values, whatsoever.

 

of course, if the sheet already has an identifier_exists

column/header then, step (a) may simply be skipped.

 

if any product does have valid global-trade-data
then, set identifier_exists to yes and add the
exact valid brand, gtin, and mpn if applicable,

within their appropriate cells, for the item.

 

if *all* products being submitted do not have any valid gtin or mpn
then, the three columns for gtin, brand, and mpn may be selected
and deleted altogether; use only the identifier_exists column, with
all identifier_exists cell-values, for all products, set to no

 

see also
https://support.google.com/merchants/answer/188494#identifier_exists
http://www.gs1.org/barcodes/ean-up

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Antonio V
November 2016

Re: Delivering Shop Feed via Spreadsheet. Do not have MPN/GTIN. What should I do?

[ Edited ]
Top Contributor
# 2
Top Contributor

for a spread-sheet, if the product does not have valid mpn or gtin:
(a) add a column (header) labeled: identifier_exists
(b) for all such items, insert an identifier_exists (cell) value of: no
(c) leave brand, gtin, and mpn cells entirely blank (entirely empty);
be certain the brand, gtin, and mpn cells have no values, whatsoever.

 

of course, if the sheet already has an identifier_exists

column/header then, step (a) may simply be skipped.

 

if any product does have valid global-trade-data
then, set identifier_exists to yes and add the
exact valid brand, gtin, and mpn if applicable,

within their appropriate cells, for the item.

 

if *all* products being submitted do not have any valid gtin or mpn
then, the three columns for gtin, brand, and mpn may be selected
and deleted altogether; use only the identifier_exists column, with
all identifier_exists cell-values, for all products, set to no

 

see also
https://support.google.com/merchants/answer/188494#identifier_exists
http://www.gs1.org/barcodes/ean-up

Delivering Shop Feed via Spreadsheet. Do not have MPN/GTIN. What should I do?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks so much for the quick and useful reply. That worked for me Smiley Happy

 

best regards,

 

Antonio