Feed format to set on Google Shopping

Developer
Fra Italy
Medlem siden apr. 2019

I'm asking what format I need to use for best compatibility with Google Shopping because the setting I've made seems to be producing errors.

These are the parameters I set:
Coding detected: UTF-8
Delimiter detected:Tab (\t)
File name: https://rausch.it/feeds/google_shopping.csv

This the error from Google Shopping:
title: Invalid or missing required attribute: offer_type description: Verifies that all required attributes are valid and included in the data feed. severity: ERROR attributeName: n:display_unit_type count: 36 parameters: Line number examples: { entries: 2 } examples: { entries: 3 } examples: { entries: 4 } examples: { entries: 5 } examples: { entries: 6 } learnMoreUrl: https://support.google.com/merchants/answer/1344057 code: 401

Thank you for a clarification that can help me get this feed properly picked up by Google.

tim
Founder
Fra Sweden
Medlem siden mai 2013
tim

[quote]title: Invalid or missing required attribute: offer_type
[/quote]
I have no idea what they mean by this. A title is a title, yet they are asking for offer_type in the title.

[quote]description: Verifies that all required attributes are valid and included in the data feed.[/quote]
The Google documentation states:

[ul]
[li]Accurately describe your product and match the description from your landing page.[/li]
[li]Don’t include promotional text like "free shipping," all capital letters, or gimmicky foreign characters.[/li]
[li]Include only information about the product. Don’t include links to your store, sales information, details about competitors, other products, or accessories.[/li]
[li]Use formatting (for example, line breaks, lists, or italics) to format your description.[/li]
[/ul]

[quote]severity: ERROR attributeName: n:display_unit_type count: 36 parameters: Line number examples: { entries: 2 } examples: { entries: 3 } examples: { entries: 4 } examples: { entries: 5 } examples: { entries: 6 } learnMoreUrl: https://support.google.com/merchants/answer/1344057 code: 401[/quote]
Even more cryptic. I have no idea.

Developer
Fra Italy
Medlem siden apr. 2019

If it helps, I can invite you (please send me your @gmail address) by adding it to my user management. The new Google Merchant Center (Business Manager) may have changed its parameters. 
I can't understand it either and it seems to me that everything should be fine with UTF-8 and tab spacing.

[i]It should also be said that for some time now I have been encountering error messages from Google that are clearly aimed at contacting their commercial service. At least that's my impression.[/i]

tim
Founder
Fra Sweden
Medlem siden mai 2013
tim

You need a Google Merchant specialist. See if you are entitled to book an appointment with one of their service helpers.

Developer
Fra Italy
Medlem siden apr. 2019

After several attempts at clarification by the Google Marchant specialists I finally received this answer which I will send you translated:

[quote]Greetings from Google,
On March 26, 2024 00:00:00 CET, we attempted to process a file named "scheduled_fetch_file_163750067" in Google Merchant Center to update your "PRODUCTS SOURCE 3" feed (Account ID: #########).
Unfortunately, the file was not processed because its format is not supported. As a result your product data has not been updated.
Check the file format for problems and try uploading it again. Visit https://support.google.com/merchants/answer/188476
to view the complete list of file formats supported by Google Merchant Center.
The Google Merchant Center team
This email was computer generated. Do not answer.[/quote]

I hope you can find something in this article to help you create your feed correctly for Google.

tim
Founder
Fra Sweden
Medlem siden mai 2013
tim

I have looked at your feed and it's a correctly tab limited CSV format. It does not contain "offer_type" or "display_unit_type" if that is what needs to be added? If this is something you added to merchant center you need to set it up in the feed.

There is no mentioning of this in the docs:
https://support.google.com/merchants/answer/7052112?hl=en#basic_product_data

Kindly ask Google again for the right documentation concerning "offer_type" and "display_unit_type".

Du
This website uses no cookies and no third party tracking technology. We think we can do better than others and really think about your privacy.