Want to sync your Shopify inventory levels into Google Sheets? Then this is the function for you!
=SHOPIFY_INVENTORY(sku,[date])
Inputs
- sku: The Shopify SKU of the product you want to get the inventory level of.
- date (optional): Specify a historical date you would like to get the inventory level from. Only available for dates after your Synchronize signup date.
Examples
=SHOPIFY_INVENTORY(mysku123)
Returns the latest Shopify inventory count for mysku123.
=SHPOIFY_INVENTORY(mysku123,"2022-06-15")
Returns the Shopify inventory count for mysku123 on 2022-06-15. Historical inventory data starts being logged once you sign up for Synchronize and connect your Shopify account.