=SHOPIFY_DAILYUNITS() – Average daily units sold over a date range

Functions / By

This function allows you to sync the average units sold per day, for any given Shopify SKU, into Google Sheets.

=SHOPIFY_DAILYUNITS(sku,date range)

Inputs

  • sku: the Shopify SKU of the product you want to get units sold data for.
  • date range: the date range to filter for (read this guide for formatting and tips). For example:
    • “yesterday”
    • “t30”
    • “last month”
    • “2022-08-02 to 2022-08-06″‘
    • “2022-01-15”

Examples

=SHOPIFY_DAILYUNITS(mysku123,"t30")

Returns the average number of units mysku123 sold each day on Shopify over the last 30 days (total units sold divided by 30).

=SHOPIFY_DAILYUNITS(A1:A100,"ytd")

Returns the average daily units sold on Shopify year to date for the SKUs in cells A1 through A100.

Historical Data

When you connect a Shopify account to Synchronize, we scrape 1 year of historical data. You can use the =SHOPIFY_DAILYUNITS() function to go back up until the start of this time period.