Why are certain product fields missing in my Shopify API response?

muhammad_haroon
Shopify Partner
29 0 1

I am using the Shopify Product.All REST API to retrieve all products from my store. I have observed that these specific fields are not included in the response of the REST API. However, when I manually export products from Shopify to a CSV file, these fields are present, and they contain data. But when I use the API to retrieve the data, these fields are not included in the response.

  1. Product Category
  2. SEO Title:
  3. SEO Description:
  4. Google Shopping / Google Product Category:
  5. Google Shopping / Gender:
  6. Google Shopping / Age Group:
  7. Google Shopping / MPN:
  8. Google Shopping / Condition:
  9. Google Shopping / Custom Product:
  10. Google Shopping / Custom Label 0:
  11. Google Shopping / Custom Label 1:
  12. Google Shopping / Custom Label 2:
  13. Google Shopping / Custom Label 3:
  14. Google Shopping / Custom Label 4:
  15. Variant Tax Code:
  16. Cost per item:
  17. Included / International
  18. Price / International:
  19. Compare At Price / International:
Replies 3 (3)

Ablestar_Daniel
Shopify Partner
95 13 17

Hi Muhammad,

 

These fields are available through the API but they're not stored directly on the product object so you'll need to make some additional API calls to get the data for the products:

  • The SEO and Google Shopping fields are stored as product metafields so you'll need to look at the metafields for each product to get those
  • The Product Category is only available through the GraphQL API, in the standardizedProductType field
  • The Cost and tax info are available on the InventoryItem object. You can find the inventory item's ID by looking at each variant for the inventory_item_id field
  • The international pricing is available through the GraphQL Markets API

If you want to download all the data for each products for a store another thing to checkout would be the GraphQL bulk operation API so you can get everything at once.

 

Best,

Daniel

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!

Jonathan-HA
Shopify Partner
320 25 100

Daniel pretty much covered it all.

 

For the SEO title/description and Google Shopping metafields specifically, here's a list of metafield namespaces and keys: https://www.highviewapps.com/kb/how-do-i-export-fields-from-shopifys-google-shopping-app/

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill

Kalen_Jordan
Shopify Partner
452 16 66

Are you building a Google Shopping feed?