Re: Shopify to Google Sheets API - Product Availability Information

Shopify to Google Sheets API - Product Availability Information

gpcarlone
Visitor
1 0 0

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

 

Help would be greatly appricated.

Reply 1 (1)

Anto_S
Shopify Partner
152 4 19

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:

 

 

Automating Commerce at Comstack
Email: anto@comstack.com