Shopify to Google Sheets API - Product Availability Information

Retired Boards Appdev Graphql Basics And Troubleshooting
1

Hi there Guys,

I’m needing some help with my Shopify to Google Sheets integration.

I am trying to export my products being sold on Shopify with an API to a Google Sheet. The information i am needing to get from the API is a stock available number with a SKU of the item.

I’ve managed to integrate the API but its not giving me the SKU data of each product but rather the Inventory Item ID.

The Request URL i’ve been using is from https://shopify.dev/api/admin-rest/2021-10/resources/location#get-locations-location-id-inventory-levels

Help would be greatly appricated.

2

Hi @gpcarlone

If you are okay using an app to do this, please use the Product & Inventory Export sheet on the Sheet Master app on the Shopify App Store

Please email me at anto@comstack.co if you need help getting set up. Here’s a video on how it works: