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

About Shopping Attribute

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

Hello Experts,

 

Suppose I will sell pipe in australia. but i have no 

gtin brand mpn item group id

can i give the value FALSE in excel sheet?

 

these are compulsory in australia.

 

Kind Regards

1 Expert replyverified_user

Re: About Shopping Attribute

[ Edited ]
Top Contributor
# 2
Top Contributor


for an (excel) spreadsheet, simply type FALSE
in the cell under the column (attribute) named
identifier_exists for the item.

then, leave the gtin, mpn, and brand values entirely empty for the item.

never, ever, use FALSE for any global-trade-data (mpn, brand, gtin);
global-trade-data values must be either exactly as assigned by the
product's manufacturer -- or left entirety blank (entirely empty).

if there is no identifier_exists attribute in the spreadsheet
then, simply add a new column and name the new column
identifier_exists

if all inventory items have not been assigned any proper
global-trade-data (mpn, brand, gtin) by the manufacturer
then, the mpn, brand, and gtin columns may be deleted --
and all identifier_exists (cell) values should be FALSE

see also
https://support.google.com/merchants/answer/1344057
https://support.google.com/merchants/answer/160588
https://support.google.com/merchants/answer/160161
https://support.google.com/merchants/answer/188494#identifier_exists

Re: About Shopping Attribute

Follower ✭ ✭ ✭
# 3
Follower ✭ ✭ ✭
Thanks Celebird,

How Google Doc Sheet Fatch my products? Should I do this public and any other changes? I see online Google Doc sheet is private. Should i change any changes or no need?

Warm Regards

Re: About Shopping Attribute

Top Contributor
# 4
Top Contributor

first, you're welcome.

that depends on the file-format that was registered --
.txt tab-delimited (spreadsheet) or a google-sheet.

if a google-sheet was registered -- then, a fetch-now button
should be seen and the google-spreadsheet usually must be
(changed to) shared -- e.g. anyone-with-the-link -- and then,
fetched manually or via a schedule.

if a .txt file was registered -- then, a manual-upload button
should be seen, the google-spreadsheet can be private,
but the .txt file must be exported as tab-separated-values
and then re-uploaded manually, via ftp, or scheduled.

otherwise, forum members cannot look into the feed or account
however, a merchant-center support specialist may be contacted --
https://support.google.com/merchants/contactflow

see also
https://support.google.com/merchants#topic=3404780