A NEW ERA OF INTELLIGENT QUANTITATIVE ECOMMERCE - THAT WORKS FOR YOU ECOMMERCE - THAT WORKS FOR YOU
Strategy Centre

Google Shopping Capabilities of the IRP

  
29 November 2017
  

This article describes some of the key data that is required and used by Google Shopping Feeds.

Firstly the article covers the model data that is required for a product to be included in a Google Shopping Feed.

There follows two tables that detail which feeds are available in which countries, which languages are allowed, whether English is available and whether English is a secondary language of the feed. Unique currency names and ISOs are also described.

Finally, changes are described in Feed Specifications from the previous setup to the current one.


GOOGLE SHOPPING CRITERIA


The following data is required for a product to be included in a Google Shopping Feed:

  • Model must be active
  • Model is not marked 'Kit Item Only'. If the Model is a Fixed Kit, the ‘is_bundle’ attribute will be set to the value 'yes'.
  • Stock must be active
  • Brand must be active
  • Category must be active
  • Must have a price (i.e. cannot be a free item)
  • Must have an image
  • Must have a short description:
    • For territories where English is the target language, an English short description must be present
    • For territories where English is not the target language, there are two options:
      • Use English short description where translated version is missing
      • Only include product when a short description in the target language is present — these feed specifications are post-fixed with '(Strict)'

There are additional exclusions that can be set up based on the Feed Exclusions functionality — this would only be for items that cannot be shipped to the target territory, or are banned from being advertised on Google Shopping either by the manufacturer/supplier or for legal reasons.

There is a setting against each model, Has Manufacturer-Issued UPIs, which indicates whether the items in the model should have one of the following database fields populated correctly:

  • ISBNNumber — ISBN Number of books
  • UPCAPartCode — UPC-A article number
  • EAN13PartCode — EAN-13 article number
  • PartCode — Manufacturer Part Code

ISBN, UPC-A and EAN-13 all relate to an item's 'barcode'. The PartCode field is generally assigned to the product by the manufacturer to uniquely identify it in their product range. For the vast majority of branded products, there should be at least one of these values assigned to them.

Your feeds will NOT include these products unless you have populated one of these four fields correctly.

If a product does not have any of the identifiers, e.g. hand-made jewellery, unchecking the 'Has Manufacturer-Issued UPIs' checkbox against the model in question will allow the items within it to go up in your feeds. However, Google will quickly realise if you are sending products that actually do have these values, and you simply haven't entered them into the IRP.

Availability

In Stock status will not affect whether an item in is the feed. However, the availability field is populated according to the following criteria

If an item has InStock > 0 or StockHeldExternally, it will go up with the value 'in stock'. In all other circumstances, it goes up with the value 'out of stock'.


AVAILABLE SUMMARY


The following table shows which feeds are available in which countries, which languages are allowed, whether English is available and whether English is a secondary language of the Feed.

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

Table 1: Feed Availability by Country, Language and Currency - Total 37
COUNTRY
Total 37
PRIMARY LANGUAGE(S)CURRENCY ISOCURRENCY NAMEAVAILABLE IN ENGLISH
Yes 26, No 11
IS ENGLISH SECONDARY
Yes 13, No 13, N/A 11
IS BETA
Yes 7, No 30
Argentina Spanish ARS Argentinian Peso No N/A Yes
Australia English AUD Australian Dollar Yes No No
Austria German EUR Euro Yes Yes No
Belgium French, Dutch EUR Euro Yes Yes No
Brazil Portuguese BRL Brazilian Real No N/A No
Canada English, French CAD Canadian Dollar Yes No No
Chile Spanish CLP Chilean Peso No N/A Yes
Colombia Spanish COP Colombian Peso No N/A Yes
Czechia Czech CZK Czechian Koruna Yes Yes No
Denmark Danish DKK Danish Krone Yes Yes No
France French EUR Euro No N/A No
Germany German EUR Euro Yes Yes No
Hong Kong Traditional Chinese HKD Hong Kong Dollar Yes Yes Yes
India English INR Indian Rupee Yes No No
Indonesia Indonesian IDR Indonesian Rupiah Yes Yes Yes
Ireland English EUR Euro Yes No No
Italy Italian EUR Euro No N/A No
Japan Japanese JPY Japanese Yen No N/A No
Malaysia English MYR Malaysian Ringgit Yes No No
Mexico Spanish MXN Mexican Peso Yes Yes No
Netherlands Dutch EUR Euro Yes Yes No
New Zealand English NZD New Zealand Dollar Yes No No
Norway Norwegian NOK Norwegian Krone Yes Yes No
Philipines English PHP Philippine Peso Yes No Yes
Poland Polish PLN Polish Zloty No N/A No
Portugal Portuguese EUR Euro No N/A No
Russia Russian RUB Russian Ruble No N/A No
Singapore English SGD Singapore Dollar Yes No No
South Africa English ZAR South African Rand Yes No No
Spain Spanish EUR Euro No N/A No
Sweden Swedish SEK Swedish Krona Yes Yes No
Switzerland English, German
French, Italian
CHF Swiss Franc Yes No No
Taiwan Traditional Chinese TWD New Taiwan Dollar Yes Yes Yes
Turkey Turkish TRY Turkish Lira Yes Yes No
United Arab Emirates English AED United Arab Emirates Dirham Yes No No
United Kingdom English GBP British Pound Yes No No
United States English USD US Dollar Yes No No


UNIQUE CURRENCIES


The following table describes unique currency names and ISOs.

Table 2: Unique Currencies - Total 29
CURRENCY ISOCURRENCY NAME
AED United Arab Emirates Dirham
ARS Argentinian Peso
AUD Australian Dollar
BRL Brazilian Real
CAD Canadian Dollar
CHF Swiss Franc
CLP Chilean Peso
COP Colombian Peso
CZK Czechian Koruna
DKK Danish Krone
EUR Euro
GBP British Pound
HKD Hong Kong Dollar
IDR Indonesian Rupiah
INR Indian Rupee
JPY Japanese Yen
MXN Mexican Peso
MYR Malaysian Ringgit
NOK Norwegian Krone
NZD New Zealand Dollar
PHP Philippine Peso
PLN Polish Zloty
RUB Russian Ruble
SEK Swedish Krona
SGD Singapore Dollar
TRY Turkish Lira
TWD New Taiwan Dollar
USD US Dollar
ZAR South African Rand


FEED UPDATE SUMMARY


The following table details the changes in Feed Specifications from the previous setup to the current one. In the 'Notes' column, the meaning of the numbers is as follows:

  1. Returned products restricted to those with Translated Descriptions only
  2. Introduction of custom labels
  3. New ID Suffix
  4. New ‘is_bundle’ attribute. This will be set to the value 'no' unless the Model is a Fixed Kit - in this case the value will be 'yes'
Table 3: Feed Updates - Total 83
NEW FEEDCOUNTRYLANGUAGEIS STRICTFEED NAMEOLD FEED NAMENOTES
No Argentina Spanish No Google Shopping - Argentina - Spanish Google Shopping - Argentina 2,4
Yes Argentina Spanish Yes Google Shopping - Argentina - Spanish (Strict)   1,2,4
No Australia English   Google Shopping - Australia - English Google Shopping - Australia 2,4
Yes Austria English   Google Shopping - Austria - English   2,3,4
No Austria German No Google Shopping - Austria - German Google Shopping - Austria 2,4
Yes Austria German Yes Google Shopping - Austria - German (Strict)   1,2,4
Yes Belgium Dutch No Google Shopping - Belgium - Dutch   2,3,4
Yes Belgium Dutch Yes Google Shopping - Belgium - Dutch (Strict)   1,2,3,4
Yes Belgium English   Google Shopping - Belgium - English   2,3,4
No Belgium French No Google Shopping - Belgium - French Google Shopping - Belgium 2,4
Yes Belgium French Yes Google Shopping - Belgium - French (Strict)   1,2,4
No Brazil Portuguese No Google Shopping - Brazil - Portuguese Google Shopping - Brazil 2,4
Yes Brazil Portuguese Yes Google Shopping - Brazil - Portuguese (Strict)   1,2,4
No Canada English   Google Shopping - Canada - English Google Shopping - Canada 2,4
Yes Canada French No Google Shopping - Canada - French   2,3,4
Yes Canada French Yes Google Shopping - Canada - French (Strict)   1,2,3,4
No Chile Spanish No Google Shopping - Chile - Spanish Google Shopping - Chile 2,4
Yes Chile Spanish Yes Google Shopping - Chile - Spanish (Strict)   1,2,4
No Colombia Spanish No Google Shopping - Colombia - Spanish Google Shopping - Colombia 2,4
Yes Colombia Spanish Yes Google Shopping - Colombia - Spanish (Strict)   1,2,4
No Czech Republic Czech No Google Shopping - Czech Republic - Czech Google Shopping - Czech Republic 2,4
Yes Czech Republic Czech Yes Google Shopping - Czech Republic - Czech (Strict)   1,2,4
Yes Czech Republic English   Google Shopping - Czech Republic - English   2,3,4
No Denmark Danish No Google Shopping - Denmark - Danish Google Shopping - Denmark 2,4
Yes Denmark Danish Yes Google Shopping - Denmark - Danish (Strict)   1,2,4
Yes Denmark English   Google Shopping - Denmark - English   2,3,4
No France French No Google Shopping - France - French Google Shopping - France 2,4
Yes France French Yes Google Shopping - France - French (Strict)   1,2,4
Yes Germany English   Google Shopping - Germany - English   2,3,4
No Germany German No Google Shopping - Germany - German Google Shopping - Germany 2,4
Yes Germany German Yes Google Shopping - Germany - German (Strict)   1,2,4
No Hong Kong Chinese No Google Shopping - Hong Kong - Chinese Google Shopping - Hong Kong 2,4
Yes Hong Kong Chinese Yes Google Shopping - Hong Kong - Chinese (Strict)   1,2,4
Yes Hong Kong English   Google Shopping - Hong Kong - English   2,3,4
No India English   Google Shopping - India - English Google Shopping - India 2,4
Yes Indonesia English   Google Shopping - Indonesia - English   2,3,4
No Indonesia English   Google Shopping - Indonesia - Indonesian Google Shopping - Indonesia 2,4
No Ireland English   Google Shopping - Ireland - English Google Shopping - Ireland 2,4
No Italy Italian No Google Shopping - Italy - Italian Google Shopping - Italy 2,4
Yes Italy Italian Yes Google Shopping - Italy - Italian (Strict)   1,2,4
No Japan Japanese No Google Shopping - Japan - Japanese Google Shopping - Japan 2,4
Yes Japan Japanese Yes Google Shopping - Japan - Japanese (Strict)   1,2,4
No Malaysia English   Google Shopping - Malaysia - English Google Shopping - Malaysia 2,4
Yes Mexico English   Google Shopping - Mexico - English   2,3,4
No Mexico Spanish No Google Shopping - Mexico - Spanish Google Shopping - Mexico 2,4
Yes Mexico Spanish Yes Google Shopping - Mexico - Spanish (Strict)   1,2,4
No Netherlands Dutch No Google Shopping - Netherlands - Dutch Google Shopping - Netherlands 2,4
Yes Netherlands Dutch Yes Google Shopping - Netherlands - Dutch (Strict)   1,2,4
Yes Netherlands English   Google Shopping - Netherlands - English   2,3,4
No New Zealand English   Google Shopping - New Zealand - English Google Shopping - New Zealand 2,4
Yes Norway English   Google Shopping - Norway - English   2,3,4
No Norway Norwegian No Google Shopping - Norway - Norwegian Google Shopping - Norway 2,4
Yes Norway Norwegian Yes Google Shopping - Norway - Norwegian (Strict)   1,2,4
No Philippines English   Google Shopping - Philippines - English Google Shopping - Philippines 2,4
No Poland Polish No Google Shopping - Poland - Polish Google Shopping - Poland 2,4
Yes Poland Polish Yes Google Shopping - Poland - Polish (Strict)   1,2,4
No Portugal Portuguese No Google Shopping - Portugal - Portuguese Google Shopping - Portugal 2,4
Yes Portugal Portuguese Yes Google Shopping - Portugal - Portuguese (Strict)   1,2,4
No Russia Russian No Google Shopping - Russia - Russian Google Shopping - Russia 2,4
Yes Russia Russian Yes Google Shopping - Russia - Russian (Strict)   1,2,4
No Singapore English   Google Shopping - Singapore - English Google Shopping - Singapore 2,4
No South Africa English   Google Shopping - South Africa - English Google Shopping - South Africa 2,4
No Spain Spanish No Google Shopping - Spain - Spanish Google Shopping - Spain 2,4
Yes Spain Spanish Yes Google Shopping - Spain - Spanish (Strict)   1,2,4
Yes Sweden English   Google Shopping - Sweden - English   2,3,4
No Sweden Swedish No Google Shopping - Sweden - Swedish Google Shopping - Sweden 2,4
Yes Sweden Swedish Yes Google Shopping - Sweden - Swedish (Strict)   1,2,4
No Switzerland English   Google Shopping - Switzerland - English Google Shopping - Switzerland 2,4
Yes Switzerland French No Google Shopping - Switzerland - French   1,2,3,4
Yes Switzerland French Yes Google Shopping - Switzerland - French (Strict)   1,2,3,4
Yes Switzerland German No Google Shopping - Switzerland - German   1,2,3,4
Yes Switzerland German Yes Google Shopping - Switzerland - German (Strict)   1,2,3,4
Yes Switzerland Italian No Google Shopping - Switzerland - Italian   1,2,3,4
Yes Switzerland Italian Yes Google Shopping - Switzerland - Italian (Strict)   1,2,3,4
No Taiwan Chinese No Google Shopping - Taiwan - Chinese Google Shopping - Taiwan 1,2,4
Yes Taiwan Chinese Yes Google Shopping - Taiwan - Chinese (Strict)   1,2,4
Yes Taiwan English   Google Shopping - Taiwan - English   2,3,4
Yes Turkey English   Google Shopping - Turkey - English   2,3,4
No Turkey Turkish No Google Shopping - Turkey - Turkish Google Shopping - Turkey 1,2,4
Yes Turkey Turkish Yes Google Shopping - Turkey - Turkish (Strict)   1,2,4
No United Arab Emirates English   Google Shopping - United Arab Emirates - English Google Shopping - United Arab Emirates 2,4
No United Kingdom English   Google Shopping - United Kingdom - English Google Shopping - United Kingdom 2,4
No United States English   Google Shopping - United States - English Google Shopping - United States 2,4

Comments

Anonymous - Very informative.... these capabilities are very poweful.
05 Dec 2017 18:28
Anonymous - great article William for both SI's and Clients as well as their PPC providers
01 Dec 2017 09:57
You must be logged in to comment on this article.


Copyright © 2018 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy
IRP Commerce is a Trading Name of Export Technologies Limited, a Deloitte Fast 50 Company six times: 2010, 2011, 2012, 2013, 2014 & 2018   Deloitte.