=AMAZON_SOLDUNITS() – Units sold over a date range

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

=AMAZON_SOLDUNITS(sku,date range)

Inputs

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

=AMAZON_SOLDUNITS(mysku123,"yesterday")

Returns the number of mysku123 units sold on Amazon yesterday.

=AMAZON_SOLDUNITS(A1:A100,"t30")

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

Historical Data

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