AdWords
6.2K members online now
6.2K 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