Syntax
=DRAGON_SALES_TOTALS(account, [ASIN/SKU], [marketplace], [fulfillment], [period], [period view], [basis], [view], [columns], [header], [transpose])
Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.
This page is also available inside Sheets – type
=DRAGON_SALES_TOTALS("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Example output from the Nordvik demo store – your sheet shows your own store's data.
A1fx
=DRAGON_SALES_TOTALS("Nordvik", "", "US", "FBA", "last_5_days")| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | sku | asin | 2026-10-12 | 2026-10-11 | 2026-10-10 | 2026-10-09 | 2026-10-08 |
| 2 | NV-HAT-CHARCOAL | B0KNIT0101 | 111.80 | 139.75 | 111.80 | 139.75 | 27.95 |
| 3 | NV-HAT-NAVY | B0KNIT0104 | 83.85 | 83.85 | 111.80 | 83.85 | 55.90 |
| 4 | NV-TEE-BLACK-L | B0KNIT0109 | 99.80 | 0.00 | 74.85 | 24.95 | 24.95 |
| 5 | NV-SWT-CHARCOAL-L | B0KNIT0121 | 0.00 | 49.95 | 149.85 | 99.90 | 99.90 |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account. |
| ASIN/SKU | Optional | Optional ASIN, SKU, or a list separated by ;. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list. |
| marketplace | Optional | One marketplace/country code such as US, CA, or MX. Blank = this sheet's default marketplace (Extensions > SellerDragon > Default Marketplace); without a default, enter one. |
| fulfillment | Optional | Optional fulfillment filter: FBA or FBM. |
| period | Optional | Optional period such as last 90 days, 2026-04, or 2026. Default: last 90 days. |
| period view | Optional | Optional period view: DAY, WEEK, MONTH, QUARTER, YEAR, or TOTAL. Default: DAY. |
| basis | Optional | Optional row basis: ASIN or SKU. ASIN rows use the larger of order lines and the Amazon per-ASIN business report per day (matches the dashboard); SKU rows and FBA/FBM filters use order lines. Default: ASIN. |
| view | Optional | Optional output view: DETAILS, SUMMARY, or TOTAL (one column with the total for the period, rows in your ASIN/SKU order). Default: DETAILS. |
| columns | Optional | Optional output columns separated by ;. Leave empty for ASIN/SKU; use none or - to suppress ASIN/SKU. Currently supported: currency, seller_id. |
| header | Optional | Use no, false, or 0 to suppress the output header row. Default: Yes. |
| transpose | Optional | Use yes, true, or 1 to transpose the output. |
The period accepts values like last_30_days, this_month, 2026Q1, or ranges like 2026-01-01..today – see the full period reference.
Columns
Columns are evaluated left to right: a field or group name adds columns, a leading - removes them. default and all select the default or full column set.
| Column | Default | Description |
|---|---|---|
| asin | Yes | Asin. |
| sku | Yes | Seller sku. |
| currency | Yes | Currency. |
| seller_id | No | Amazon seller id (merchant token) of the store. |
Examples
=DRAGON_SALES_TOTALS("Mystore", "", "US", "FBA", "last 12 months", "month", "asin")
=DRAGON_SALES_TOTALS("Mystore", "", "US", "", "last 12 months", "month", "asin", "summary")
=DRAGON_SALES_TOTALS("Mystore", "A1:A10", "US", "FBA", "7 days", "total", "asin", "details", "none", "no")
Notes
- view: DETAILS returns ASIN/SKU rows. SUMMARY returns Amazon daily totals with precomputed FBA/FBM splits. TOTAL returns one column with the sales for the whole period, rows in your ASIN/SKU order (add asin or sku in columns to show the id).
- basis: ASIN rows take, per day, the larger of order lines and the Amazon per-ASIN business report (Amazon reports 1-2 days late; orders carry those days). SKU rows and FBA/FBM filters use order lines, because the report has no SKU or fulfillment split.
- columns: leave empty for ASIN/SKU; use compact, none, or - to suppress ASIN/SKU. Use currency to show currency instead of ASIN/SKU.