How to retrieve the Product ID Number in Google Sheets?

[specklefarms]

I'm trying to grab the Shopify Product ID number so I can use a formula to edit the MPN field with Google Sheets. It's a few hundred items, and I'd rather use a formula rather than Google Merchant Center's awfully slow editor, and Shopify's Bulk Editor is not advanced enough.

This will be fed back into Google Merchant's Supplemental Feed and it requires a Product ID Number.

How does one grab this? Shopify's Product Export does not give me the Product ID Number. Should I create a feed on Google Merchant to grab the feed?

I do not want to install a Shopify app.

[EmmanuelFlossie · Accepted solution]

Go to google merchant center > products > all products > download all your products.

Please note that an MPN stands for Manufacturer Part Number, this means this value is given only by the manufacturer.

This means resellers can not make up there own data, as that will most likely cause issues. Such as product disapprovals or limited performance.

Reference: https://support.google.com/merchants/answer/6324482

[specklefarms]

What happens if I make my MPN up if the manufacturer doesn't have an MPN? The majority of them that my store deals with do not have these.

[EmmanuelFlossie]

What happens is -->>  You can get product disapprovals or limited performance or in a worse case scenario suspension.

If you don't have MPNs than there is no need to add this info.