AdWords
2.2K members online now
2.2K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Correct filling the feed for digital products in the Merchant Account

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello. We draw digital maps. http://vectormap.info/ Company based in Dominican Rep. When i try (many times) to upload the FEED to Merch. Center, there are shown a lot of errors - but the feed are fulfill correctly, by the recomendations of MC https://support.google.com/merchants/answer/7052112?visit_id=1-636208273504478938-1909836284&rd=1 .
The problems are: 1. google_​​product_​​category Software > Digital Goods & Currency > Digital Artwork (500046) ??? - it's right as Google Category ! = What i must wright in this field?
2. Tax = What i must wright in this field? 3. GTIN, Brand (my company name?), mpn = What i must wright in this field? 4. Image link - all OK, no so long, no any wrong characters in link, image - right size, and opened OK. But system says "unrecogn. attr. image_link" ??? 5. identifier_​exists = What i must wright in this field? And, at last - 6. Missing recogn. attr. : image_​link - but the system SEE the image link before?  
////
id title description link image_​link availability price google_​product_​category brand identifier_​exists condition shipping tax
2017.08.01.SH.SW.GVL17.AI Printable Editable Vector Map Stockholm Printable Map, Sweden, exact vector street G-View City Plan Level 17 (100 meters scale) map, V.08.01. fully editable Adobe Illustrator http://vectormap.info/product/printable-map-stockholm-sweden-exact-vector-street-g-view-city-plan-le... http://vectormap.info/wp-content/uploads/2017/01/printable_map_stockholm_sweden_g_view_level_17_ai_1... In stock 63.00 Software > Digital Goods & Currency > Digital Artwork (500046) SolCity Navegacion no new US:::0.00 USD US:::no
2017.08.01.DV.CO.GVL17.AI Printable Editable Vector Map Denver Printable Map, Colorado, US, exact vector street G-View Plan City Level 17 (100 meters scale) map, V.08.01. fully editable, Adobe Illustrator http://vectormap.info/product/printable-map-denver-colorado-us-exact-vector-street-g-view-plan-city-... http://vectormap.info/wp-content/uploads/2017/01/printable_map_denver_colorado_us_g_view_level_17_ai... In stock 63.00 Software > Digital Goods & Currency > Digital Artwork (500046) SolCity Navegacion no new US:::0.00 USD US:::no
2017.03.01.JR.IR.GVL17.PDF Printable Editable Vector Map Jerusalem PDF Map, Israel, HEBREW vector map Adobe PDF editable G-View Level 17 (100 meters scale) V.07.01.17 http://vectormap.info/product/pdf-map-jerusalem-israel-hebrew-vector-map-adobe-pdf-editable-g-view-l... http://vectormap.info/wp-content/uploads/2017/01/printable_map_jerusalem_israel_g-view_level_17_v7_2... In stock 53.00 Software > Digital Goods & Currency > Digital Artwork (500046) SolCity Navegacion no new US:::0.00 USD US:::no
2017.03.01.JR.IR.GVL17.AI Printable Editable Vector Map Jerusalem Jerusalem Printable Map, Israel, HEBREW vector map Adobe Illustrator editable G-View Level 17 (100 meters scale) V.07.01.17 http://vectormap.info/product/printable-map-jerusalem-israel-hebrew-vector-map-adobe-illustrator-edi... http://vectormap.info/wp-content/uploads/2017/01/printable_map_jerusalem_israel_g-view_level_17_v7_2... In stock 53.00 Software > Digital Goods & Currency > Digital Artwork (500046) SolCity Navegacion no new US:::0.00 USD US:::no  

1 Expert replyverified_user

Feed Rules Updates in Merchant Center

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hello))) Can you help me???  
Hello. We draw digital maps. http://vectormap.info/ Company based in Dominican Rep. When i try (many times) to upload the FEED to Merch. Center, there are shown a lot of errors - but the feed are fulfill correctly, by the recomendations of MC https://support.google.com/merchants/answer/7052112?visit_id=1-636208273504478938-1909836284&rd=1 .
The problems are: 1. google_​​product_​​category Software > Digital Goods & Currency > Digital Artwork (500046) ??? - it's right as Google Category ! = What i must wright in this field?
2. Tax = What i must wright in this field? 3. GTIN, Brand (my company name?), mpn = What i must wright in this field? 4. Image link - all OK, no so long, no any wrong characters in link, image - right size, and opened OK. But system says "unrecogn. attr. image_link" ??? 5. identifier_​exists = What i must wright in this field? And, at last - 6. Missing recogn. attr. : image_​link - but the system SEE the image link before?  

Re: Feed Rules Updates in Merchant Center

[ Edited ]
Top Contributor
# 3
Top Contributor

first, that website's checkout-page is collecting user information
and does not seem to be https/ssl secure -- that is not allowed;
google will likely disapprove the items or suspend the account
or both.

 

all user data-collection, such as billing-details, must be https/ssl secure.

 

the website likely must be fixed first, before submitting any feed data --

typically by either adding https/ssl to those checkout-related pages or

removing any and all user data collection from the website.

 

as to the feed-related issues:

 

there are stray characters in the header (first column) -- that is not allowed;
retype the entire header so only plain text is used, for all the column names.

 

at least image_link, google_product_category, and identifier_exists --
have stray, invisible, invalid, characters and must be deleted and then

retyped or reentered in the feed file (spreadsheet).

 

also, google only wants information about the
item being sold -- not the business or website.

 

also, shopping-ads have strict rules related to digital downloads.

 

(1) google_product_category must be exactly as

google defines and relevant to the physical item.

 

either use the name or the number -- never both.

 

(2) tax is only required for a u.s. feed and
must reflect any u.s. tax you collect --

and may otherwise be deleted altogether.

 

(3) global-trade-data (gtin, brand, mpn) is only required
for items that already have a valid gs1-bar-code, from the
manufacturer and the item is being sold by multiple merchants.

 

otherwise, gtin, brand, mpn, must be entirely blank (entirely empty)
and identifier_exists must be submitted with a value of no

 

if all items have identifier_exists set to no
then the gtin, brand, and mpn (columns)

may be deleted altogether.

 

(4) image_link must contain a supported image format (jpg, png, etc.) --
the image must reflect exactly what the user will receive after purchase.

 

(5) for bespoke or self-made items, identifier_exists must be no

 

assuming this is for a u.s. registered feed, a fixed example is below:
https://docs.google.com/spreadsheets/d/10boSjly4C5tOUfiqpFD5WKPnTCzsp37HdEgGQMl6C8k/edit?usp=sharing

 

id	title	description	link	image_link	availability	price	google_product_category	identifier_exists	condition	shipping	tax
2017.08.01.SH.SW.GVL17.AI	Printable Editable Vector Map Stockholm	Printable Map, Sweden, exact vector street G-View City Plan Level 17 (100 meters scale) map; V.08.01. fully editable Adobe Illustrator	http://vectormap.info/product/printable-map-stockholm-sweden-exact-vector-street-g-view-city-plan-level-17-100-meters-scale-map-v-08-01-fully-editable-adobe-illustrator/	http://vectormap.info/wp-content/uploads/2017/01/printable_map_stockholm_sweden_g_view_level_17_ai_10_ai_pdf_00.jpg	in stock	63.00 USD	Software > Digital Goods & Currency > Digital Artwork	no	new	US:::0.00 USD	US::0.00:no

 

see also
https://support.google.com/merchants/answer/1188998
https://support.google.com/merchants/answer/7052112

Correct filling the feed for digital products in the Merchant Account

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

GREAT Thanks. 
0. ??? But the site doesn't collect any secret personal info (as credit card) - the checkout work via paypal (redirect to paypal page, and after payment - the user returned to the download page on the site), and the private data - stored only in the PayPal system. ??? 
1. I understood, OK
2. I understood, OK
3. I understood, OK
4. Of course, that is the image of map on JPG not so large. The physical size of vector map is about 2-5 meters, so, the preview image of full map can't diaplay small details, on the site we use the gallery of scaled images the parts of whole map.  And, of course, show, what the user will receive after purchase
5. I understood, OK

Now i trying to upload sheet )))  

GREAT Thanks

Correct filling the feed for digital products in the Merchant Account

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Oh, no. 

I corrected the sheet as you show here : https://docs.google.com/spreadsheets/d/10boSjly4C5tOUfiqpFD5WKPnTCzsp37HdEgGQMl6C8k/edit?usp=sharing  

Than, upload the test feed to MC
And what a see... 

Item Errors
1,287 errors. GTIN BRAND MPN
Hard goods must have values for two out of the following attributes: gtin, brand, mpn. Please make sure to include this required attribute in your data feed.


Item Warnings
5,148 warnings.

1. google_product_category : Your feed contains an attribute name our system doesn't recognize. Please verify your attribute name as necessary, and please be aware that this attribute may no longer be included in our Feed Specification.

2. image_link : Your feed contains an attribute name our system doesn't recognize. Please verify your attribute name as necessary, and please be aware that this attribute may no longer be included in our Feed Specification.

3. identifier_exists : Your feed contains an attribute name our system doesn't recognize. Please verify your attribute name as necessary, and please be aware that this attribute may no longer be included in our Feed Specification.

4. image_link : While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

------

The example part of sheet is here https://docs.google.com/spreadsheets/d/18iNvstFJufyXkaFqma7aFxcM75Bp-oyYPvKoiHgkOXY/edit?usp=sharing...

Correct filling the feed for digital products in the Merchant Account

[ Edited ]
Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Trying again (Use https:// links )

Some problems was resolved, but ??? 

Item Warnings
3,861 warnings.

1. Unrecognized attribute: google product category 1287 warnings
Your feed contains an attribute name our system doesn't recognize. Please verify your attribute name as necessary, and please be aware that this attribute may no longer be included in our Feed Specification. == Software > Digital Goods & Currency > Digital Artwork = There are right GOOGLE PRODUCT CATEGORY, what is a problem?

2. Unrecognized attribute: image link 1287 warnings
Your feed contains an attribute name our system doesn't recognize. Please verify your attribute name as necessary, and please be aware that this attribute may no longer be included in our Feed Specification. https://vectormap.info/wp-content/uploads/2017/01/printable_map_denver_colorado_us_g_view_level_17_a... - this is a right, workable link and right image ????

3. Missing recommended attribute: image link 1287 warnings
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
There are no link in the test window - but in the "2" item the system see the image link...

I did'nt understood.... 
The example part of the sheet   https://docs.google.com/spreadsheets/d/18iNvstFJufyXkaFqma7aFxcM75Bp-oyYPvKoiHgkOXY/edit?usp=sharing...

Marked as Best Answer.
Solution
Accepted by topic author Cyrell S
January 2017

Correct filling the feed for digital products in the Merchant Account

[ Edited ]
Top Contributor
# 7
Top Contributor

first, you're welcome.

 

the rules for data collection do not apply only
to secret personal info (such as credit card) --
the rules apply to any personal information such
as any information related to billing; if such details
are collected on an insecure page, that is a policy

violation, and is grounds for a disapproval or a

suspension from the program, at any time.

as to the spreadsheet -- again, the first line header *must* be
deleted and then retyped or google will not be able to properly
process the feed and those errors will not stop.

again, there are stray characters in the header (first column).

image_link, google_product_category, and identifier_exists
have invisible, invalid, characters that are not allowed.

retype the entire header (first column).

the entire header (first line) must be deleted and then carefully retyped --
otherwise, google will not process the feed and those errors will continue.

Correct filling the feed for digital products in the Merchant Account

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Thanks. IT WORK!!!!!!!!!!!!!!!!!!!! 
1. i deleted the headline row, added new row and re-type the new heads manually. 
2. Now all links have https:// prefix, and so, the product or image link look like this 

https://vectormap.info/product/printable-map-stockholm-sweden-exact-vector-street-g-view-city-plan-l...

So, the checkout page for users is there: 

https://vectormap.info/checkout/

Correct filling the feed for digital products in the Merchant Account

[ Edited ]
Top Contributor
# 9
Top Contributor

first, you're welcome and that sounds like good news.

 

be certain to inspect the entire website and all pages --

any and all links to that checkout-page should be

changed from http to https -- some links that are

pointing to that checkout-page seem to be http

not https.

e.g. always use:

https://vectormap.info/checkout/

never:

http://vectormap.info/checkout/

or any similar link that does not explicitly use https for checkout.