=SHOPIFY_INVENTORY() – Get the Shopify inventory for a SKU

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.