Populating Fields for the Google Shopping App

vittiegrocer
Tourist
9 0 6

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
Replies 19 (19)
Justin54
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.

vittiegrocer
Tourist
9 0 6

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.

buyzero_de
Tourist
6 0 3

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.

buyzero_de
Tourist
6 0 3

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=&...

buyzero_de
Tourist
6 0 3
ChrisV
New Member
1 0 1

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!

 

 

 

dlevens
Explorer
45 0 17

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?

dlrhymes
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.

JonWright
Shopify Partner
818 123 351

@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

Owner of Neuralcandy Shopify Agency
dlevens
Explorer
45 0 17

@JonWright 

 

Thanks Jon, I very much am in the dark and so appreciate your insight. 

 

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

Is it possible to view the raw feed that Shopify is sending? I see Content API in my Google Merchant Center but not sure how I can view what is in it. I did find .../collections/all.atom which seems to include vendor and sku. So I was thinking of creating a feed rule in Merchant Center of attribute: mpn set to: Content API.sku to see if it can tell Google that sku is mpn

 

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

For 95% of our products (we sell cotton fabric by the yard) we do not have a GTIN barcode, but we do have a mpn and brand...for instance one product has an mpn of 6218D. So I assumed I should set custom product to false and then input my mpn numbers in the Google Shopping field mpn.

 

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)

I would consider my self an excel guru, have done some insane excel formulas to migrate our shop from another ecom platform...the issue is Shopify ignores all of the google shopping columns when using csv imports. That feature worked until they updated their Google Shopping app, now those fields are worthless and there no way to update in bulk anymore. The closest they have is the GUI bulk editor but I have no way to pull sku and paste it into mpn without copy/paste 3000+ times. I suspect I may need to learn how to do this via API which is why I found this thread, but I do not know how to even start to access the API.

 

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.

Thanks, I has suspected this, and it makes complete sense now that I think about it. One is for the spiders to view and the feed is completely different. 

JonWright
Shopify Partner
818 123 351

Q - Is it possible to view the raw feed that Shopify is sending?

A - Kind of. In Merchant Centre got to "products" > "all products" and then click on a specific product. Scroll down and you'll see a heading called "Raw feed attributes:Shopify" expand that and you'll see what is been sent over by the API

- Ignore the Atom feed, that is something else unrelated.

 

Q - So I assumed I should set custom product to false and then input my mpn numbers in the Google Shopping field mpn.

A - Yes that is correct

 

Q- I have no way to pull sku and paste it into mpn without copy/paste 3000+ times

A - Wasn't aware the default Import functionality had issues here now but try Excelify as I'm pretty sure that will work and it's free to try it on 10 products to check before you pay for it. A lot quicker then messing around with the API

 

Q - One is for the spiders to view and the feed is completely different

A - Yep, exactly. Only minor caveat, without wanting to confuse matters, is that Google does also scan your website to check that the data you are sending them in the feed is the same as the data on your site (e.g. price is the same, to stop people trying to game Shopping) and I assume it uses Structured data for this if you have it. But other than that, irrelevant.

If helpful then please Like and Accept Solution

Owner of Neuralcandy Shopify Agency
dlevens
Explorer
45 0 17

Just completed another round of testing...I can confirm that the csv product import option ignores every column that starts with Google. I did a few imports to attempt to update these items and every one was ignored. So not able to update mpn in bulk

Google Shopping / Google Product CategoryGoogle Shopping / GenderGoogle Shopping / Age GroupGoogle Shopping / MPNGoogle Shopping / ConditionGoogle Shopping / Custom Product

 

I found the raw feed data like you said in merchant center and setting mpn field does fix the issue I am having. Google accepts these products fine. 

 

So the last issue to solve is how best to set the mpn field in bulk? Are you sure the Content API feed from shopify does not include sku? So that I cannot just do a feed mapping rule for sku to mpn?

 

Excelify I think would work because they are using API to make the edits to mpn and can do the mappings, but trying to avoid a monthly cost for a one time fix. We can add the mpn as we list manually so I just need to add mpn to about 4000 products. 

 

What about a secondary feed in google merchant center? To pull that off I would need the unique product id and sku exported, I could then change the column from sku to mpn and upload as a secondary feed, but the product export does not export product id. So frustrating this.

JonWright
Shopify Partner
818 123 351

- Definitely no sku sent but you can prove it to yourself. Add a couple in Shopify, wait a few hours and then go look for them in the raw feed data in Merchant Centre. They won't be there 🙂

 

- Not pushing Excelify as I have nothing to do with them other than as a user but you don't need to keep paying for it. Use it for the one off job and then end your subscription. So basically it will cost you $20 to fix your issue. Sounds like a better bet to me than messing around with secondary feeds etc. Also, it does export the Product ID, if you did want to go down the secondary feed route.

If helpful then please Like and Accept Solution

Owner of Neuralcandy Shopify Agency
JonWright
Shopify Partner
818 123 351

One other thing. I take it you trying to add MPNs at a Product level rather than at a Variant level? (because I'm pretty sure the metafields in the Google Shopping App are only at a Product level, so just thought I'd check)

If helpful then please Like and Accept Solution

Owner of Neuralcandy Shopify Agency
dlrhymes
New Member
2 0 0
My problem is also not being able to set up a secondary feed because the IDs from the content API don't match to anything on the Excel product sheet.
JonWright
Shopify Partner
818 123 351

@dlrhymes as mentioned, you can get the IDs and match them to Merchant Centre by using Excelify. I've just checked and they are in the extract.

 

Other option is to use a more comprehensive feed tool than the Shopify one e.g. FeedArmy, DataFeedWatch etc

If helpful then please Like and Accept Solution

Owner of Neuralcandy Shopify Agency
dlevens
Explorer
45 0 17

Thanks again for the guidance, looks like a tool is the way to go. Shopify support said I should checkout “Feed For Google Shopping” but exelify looks perfect for what I need so will start there and see how it goes. I do like that I would be repairing the actual product as opposed to building a custom feed which would require on going costs.

 


Also you were correct, I am only interested in mpn at product level, as my variants all share that same mpn.

 

thanks again for the help, stay safe.

sampymishra
Shopify Partner
135 3 15

Hi, We have developed an app to make your task easier. It is the Google Shopping Feed app by AdNabu. We have added the product metafiels feature which allows you to map any metafield from your Shopify to any attribute on the merchant center. Please let me know your feedback regarding this.

Sampy Mishra | Customer Success Manager @ AdNabu

 - Was my reply helpful? Click Like to let me know! 

 - Was your question answered? Mark it as an Accepted Solution

 - Try our Google Shopping Feed App from Shopify App Store. 

capocopa
Tourist
8 0 7

it's two days that i'm trying to find the namespace of google shopping app metafields

thank you so much

this should be written in some guide of google shopping app...

anyway just to prevent this error in future.. how can you find the namespaces?