=SHOPIFY_SOLDUNITS() – Units sold over a date range

Functions / By

Want to sync your Shopify units sold data into Google Sheets? Then this is the function for you!

=SHOPIFY_SOLDUNITS(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_SOLDUNITS(mysku123,"yesterday")

Returns the number of mysku123 units sold on Shopify yesterday.

=SHOPIFY_SOLDUNITS(A1:A100,"t30")

Returns the number of units sold on Shopify over the trailing 30 days (31 days ago, through yesterday) 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_SOLDUNITS() function to go back up until the start of this time period.