=FAIRE_SOLDUNITS() – Units sold over a date range

Functions / By

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

=FAIRE_SOLDUNITS(sku,date range)

Inputs

  • sku: the Faire 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

=FAIRE_SOLDUNITS(mysku123,"yesterday")

Returns the number of mysku123 units sold on Faire yesterday.

=FAIRE_SOLDUNITS(A1:A100,"t30")

Returns the number of units sold on Faire over the trailing 30 days (31 days ago, through yesterday) for the SKUs in cells A1 through A100.

Historical Data

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