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

Google Merchan Account help And Advice Please

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, im brand new to google merchant, I have been trying to fill in the data feed as I want to individually put products on, all I get are error, I sell lingerie and clothing as well as other items which I dont want listed. I am trying to list the lingerie, but I am not fully understanding the exact format which is right for the data sheet. I am UK based. Is there any chance that someone could just post a demo of how it should look, I am not bothering with items with variations at the moment, just need to start simple.

I would really appreciate any advice or help.

Many thanks in advance

1 Expert replyverified_user

Re: Google Merchan Account help And Advice Please

[ Edited ]
Top Contributor
# 2
Top Contributor


(a) this will indicate the basic requirements --

https://support.google.com/merchants/answer/188486

https://support.google.com/merchants/answer/160637

(b) this will indicate the basic requirements for the website --
https://support.google.com/merchants/answer/2700318

https://support.google.com/merchants/answer/2704164

 

generally, there should be one, single, item

with one, single, price on the landing-page.

(c) this table will indicate what goes in the spreadsheet itself,
based on the type (category) of physical item being submitted --
https://support.google.com/merchants/answer/1344057
note that attribute is simply another word for column (heading)
and apparel (clothing) and apparel accessories (jewelry) have
specific requirements -- regardless of variants.

 

also, since lingerie was mentioned, most lingerie items

usually require an adult attribute with a value of TRUE

 

if the website generally targets adults then, the mature setting must

also be set in the account -- regardless of what is or is not submitted.


(d) requirements for each item (spreadsheet row) are indicated here --
https://support.google.com/merchants/answer/188494

https://support.google.com/merchants/answer/2700371

https://support.google.com/merchants/answer/1347943

spreadsheet instructions, examples, and supported formats, are here --
https://support.google.com/merchants/answer/160569
https://support.google.com/merchants/answer/160588
https://support.google.com/merchants/answer/160567

generally, be certain that all the required attributes (column headings)
exist in the spreadsheet for the type of item being submitted, have all
valid values, and no quotation-marks are seen within the saved .txt

tab-delimited file (check the .txt file in a browser window).

 

usually, edit the spreadsheet in its raw format, and then re-save as .txt;
the spreadsheet should be re-saved and submitted as tab-delimited --
unless a google-docs sheet was registered during initial feed setup.

 

also, check the quoted-fields settings for the feed within the merchant-center.

be certain there is only one feed registered and use the same feed
for all updates (all changes, all deletions, all additions) -- any missing
item in the feed is considered a delete and google tracks items by id.

a best-practice is to model id values after a sku --

be certain each id value never changes for the
physical item once assigned in the spreadsheet;

e.g. p1235, abc123, etc., and is unique per item.

 

all data submitted (but especially titles and descriptions) must use

standard (english) capitalization rules -- all caps are not allowed.

as a side note, for apparel, be certain that the brand submitted in the feed
is the manufacturer's brand, not the store's brand; if a brand does not exist
then submit an identifier_exists (column) with a value of FALSE for that item.

the store's brand is set in the account-settings, not the feed (spreadsheet).

also, be certain the inventory is not already being submitted
from another site or marketplace (e.g. ebay, etsy, etc.) --
https://support.google.com/merchants/answer/2796531

note that there other rules, policies, and recommendations --
https://support.google.com/merchants/#topic=3404779

also, indicating the exact error, exact spreadsheet being used,

and other details, here in the public forum, may allow others

to offer more specific suggestions.

see also
http://www.celebird.com/resources/pla/feed-templates/

 

Re: Google Merchan Account help And Advice Please

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thank you very much for the amount of information you have given me Celebird. It is no easy task as a beginner, there is alot of information to digest.