Populating Fields for the Google Shopping App

Highlighted
Tourist
9 0 4

I'm having a great deal of difficulty populating the Google Shopping App fields.  And I'm having more difficulty figuring out why it is so difficult to accomplish this task in bulk.  I understand I can edit this information one-by-one but I have tens of thousands of products and I'd prefer to have this set up before I die.

So in an attempt to complete this process myself and demystify it for others, I'm going to lay out the data sources for all of the Google Shopping fields and appeal to the Shopify community for help in completing the mapping.  I am using ChannelAdvisor to send my data to Shopify.  ChannelAdvisor allows users to send up to 25 metafields to Shopify.  But the challenge I encountered was what to call the Namespaces and Keys of the those metafields in order for the Google Shopping App to automatically pull them.  Here's what I've discovered.  I'm just down to trying to figure out what namespace and key will send the MPN to the Google Shopping App - any ideas?

Google Product Category

  • Metafield
  • Namespace: google
  • Key: google_product_type

MPN

  • I HAVE NOT DISCOVERED HOW TO POPULATE THIS VALUE.  THE FOLLOWING METAFIELD FAILED
  • Metafield
  • Namespace: google AND global (both failed)
  • Key: mpn

Condition

  • Metafield
  • Namespace: google
  • Key: condition

Age Group

  • Metafield
  • Namespace: google
  • Key: age_group

Gender

  • Metafield
  • Namespace: google
  • Key: gender

Custom Label 0

  • Metafield
  • Namespace: google
  • Key: custom_label_0

Custom Label 1

  • Metafield
  • Namespace: google
  • Key: custom_label_1

Custom Label 2 

  • Metafield
  • Namespace: google
  • Key: custom_label_2

Custom Label 3

  • Metafield
  • Namespace: google
  • Key: custom_label_3

Custom Label 4

  • Metafield
  • Namespace: google
  • Key: custom_label_4
1 Like
Tourist
8 0 1

Their own documentation says it can be done, yet it doesn't work:
https://help.shopify.com/manual/apps/apps-by-shopify/google-shopping/faq

In addition to the MPN not working, brand is not populated either. It doesn't look like you can control it via metafield either, it has to be with the products "vendor"...which is populated...but doesn't make it into the product data on Google Shopping.

So frustrating.

0 Likes
Highlighted
Tourist
9 0 4

Justin - thanks so much for your reply.  At least I know I'm not going crazy.  I'm so baffled as to why this is this isn't more straightforward.  I've contacted support and they either just refer me to the link you cited or they provide some contradictory information.  It's nuts.

0 Likes
Highlighted
Tourist
6 0 2

This post pointed me in the right direction, thanks guys! Now I can also give back to the community by allowing you to access the MPN field (sic, capital letters!)

You can access it using the bulk editor:

https://example.com/admin/bulk?direction=next&edit=metafields.google.google_product_type%3Astring%2C...

please note the capital spelling of the MPN field - apparently it is name sensitive, as metafields.global.mpn will not work, you have to use metafields.global.MPN

As information to anyone trying to debug the names of these fields:

this will give you something like this:

{"metafields":[{"id":(*),"namespace":"global","key":"description_tag","value":"This is a widget. do not buy.","value_type":"string","description":"Description of the product for search engines","owner_id":(*),"created_at":"(*)","updated_at":"(*)","owner_resource":"product"},{"id":(*),"namespace":"global","key":"MPN","value":"ah google shopping mpn 2","value_type":"string","description":"Manufacturer Part Number","owner_id":(*),"created_at":"(*)","updated_at":"(*)","owner_resource":"product"},

and so on.

(*) - edited for security purposes

my suggestion to make this thing more readable is to use Notepad++, and to use search and replace with Extended mode (supporting \n)

  • search and replace , with \n
  • search and replace { with \n\n

this will give you a nice more readable rendition of it, more useful for debugging.

0 Likes
Highlighted
Tourist
6 0 2

Another input which might be helpful to someone else - this forum post was helpful for that:

https://ecommerce.shopify.com/c/shopify-discussion/t/how-to-edit-variant-meta-data-in-bulk-editor-48...

Editing Variants:

https://<youraccount>.myshopify.com/admin/bulk?direction=prev&edit=metafields.global.MPN:string&resource_name=ProductVariant&show=image,full_title,variants,sku

Thus it is possible to edit individual metafields for the variants.

metafields.global.MPN as a ProductVariant entry will not override the global Product entry.

Also it will not show up in my export to DataFeedWatch, even if I delete the master entry in the Product resource (set metafields.global.MPN to an empty string). I suspect I have to use a different metafield, and route in DataFeedWatch accordingly.

also useful for filtering for certain products:

&query=<name of product>

Like this (product resource version):

https://example.com/admin/bulk?resource_name=Product&show=image,title&ids=&metafield_titles=&metafie...&query=widget

To edit the same in the Variants resource version:

https://example.com/admin/bulk?resource_name=ProductVariant&show=image,full_title,variants,sku&ids=&...

1 Like
Highlighted
Tourist
6 0 2
Highlighted
New Member
1 0 0

For those looking at this in 2019, The namespace is now:

 

mm-google-shopping

 

I've also found that the condition value needs to be all lower case (even though the google drop down has a capital letter for the first letter).

 

New -> new

Used -> new

Refurbished -> refurbished

 

I hope that helps!

 

 

 

0 Likes
Highlighted
Excursionist
42 0 11

Hoping one of you in the thread might know if shopify includes the mpn or sky in the content.api feed that is sent to Google Merchant Center when you se the Google Shopping App? I keep getting "Limited performance due to missing identifiers [gtin, mpn, brand]" on all my products even though Google Structured Data Testing Tools shows I have brand and mpn and sku defined. But I suspect the Content API feed that Shopify is sending does not contain mpn? 

 

I have been editing google shopping fields manually in the GUI bulk editor because csv import no longer works. If I had to type each mpn in the google shopping field in the GUI one by one it would be near impossible. 

 

What is the best way to get mpn to show up?

1 Like
Highlighted
New Member
2 0 0

Working on this myself, as well as how to get size to pull through.  Of all the things, you think size would populate.

0 Likes
Highlighted
Shopify Partner
689 101 233

@dlevens Hopefully I can clarify a few things to help:

 

1 - The Shopify Google Shopping App does not send MPN or SKU to Merchant Centre/Google Shopping by default

2 - To clear the "Limited performance due to missing identifiers [gtin, mpn, brand]" warning you are seeing in Merchant Centre your best bet is to use valid barcodes/GTIN's by putting these in the barcode field in Shopify

3 - If your products do not have barcodes, then yes you can send MPNs but to add these in bulk you need to add them to the relevant metafield in the Google Shopping app (if CSV isn't working for you, then try an app called Excelify)

4 - The Google Structured Data Testing Tool is not related to your shopping feed, it is to do with the structured data/schema you have on your site which is there for search engines to understand context when crawling your site for SEO purposes.

 

Hope that helps.

If helpful then please Like and Accept Solution
1 Like