Syntax
=DRAGON_INVENTORY_RESTOCK(account, [ASIN/SKU], [marketplace], [alert], [recommended action], [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_INVENTORY_RESTOCK("help") in any cell to get the same reference without leaving your spreadsheet.Sample output
Illustrative values – your sheet shows your account's live data.
A1fx
=DRAGON_INVENTORY_RESTOCK("Myaccount", "", "US")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | seller_id | marketplace | sku | fnsku | asin | item_condition | supplier | supplier_part_no | … |
| 2 | A1MYSELLERID | US | MB-TEE-BLK-L_FBA | X0EXAMPLE1 | B0EXAMPLE1 | – | – | – | … 23 more |
| 3 | A1MYSELLERID | US | MB-TEE-NVY-M_FBA | X0EXAMPLE2 | B0EXAMPLE2 | – | – | – | … 23 more |
| 4 | A1MYSELLERID | US | MB-HAT-GRY_FBA | X0EXAMPLE3 | B0EXAMPLE3 | – | – | – | … 23 more |
| 5 | A1MYSELLERID | US | MB-MUG-11OZ_FBA | X0EXAMPLE4 | B0EXAMPLE4 | – | – | – | … 23 more |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| ASIN/SKU | Optional | Optional ASIN, SKU, or comma/space separated list. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list. |
| marketplace | Optional | Optional marketplace/country code such as US, CA, or MX. |
| alert | Optional | Optional alert filter. |
| recommended action | Optional | Optional recommended action filter. |
| columns | Optional | Optional comma-separated output columns. |
| 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. |
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 – for example compact,-seller_id.
| Column | Default | Description |
|---|---|---|
| seller_id | Yes | Seller id. |
| marketplace | Yes | Marketplace. |
| marketplace_id | No | Marketplace id. |
| sku | Yes | Sku. |
| fnsku | Yes | Fnsku. |
| asin | Yes | Asin. |
| item_condition | Yes | Item condition. |
| supplier | Yes | Supplier. |
| supplier_part_no | Yes | Supplier part no. |
| currency | Yes | Currency. |
| price | Yes | Price. |
| sales_last_30_days | Yes | Sales last 30 days. |
| units_sold_last_30_days | Yes | Units sold last 30 days. |
| total_units | Yes | Total units. |
| inbound | Yes | Inbound. |
| available | Yes | Available. |
| fc_transfer | Yes | Fc transfer. |
| fc_processing | Yes | Fc processing. |
| customer_order | Yes | Customer order. |
| unfulfillable | Yes | Unfulfillable. |
| working | Yes | Working. |
| shipped | Yes | Shipped. |
| receiving | Yes | Receiving. |
| fulfilled_by | Yes | Fulfilled by. |
| total_days_of_supply | Yes | Total days of supply. |
| days_of_supply_afn | Yes | Days of supply afn. |
| alert | Yes | Alert. |
| recommended_replenishment_qty | Yes | Recommended replenishment qty. |
| recommended_ship_date | Yes | Recommended ship date. |
| recommended_action | Yes | Recommended action. |
| unit_storage_size | Yes | Unit storage size. |
| unit_storage_size_unit | Yes | Unit storage size unit. |
Column groups
Groups select several columns at once and combine with single fields in the columns parameter.
compact sku, asin, available, recommended_replenishment_qty, recommended_ship_date, recommended_action
identity sku, asin, marketplace
sales price, currency, sales_last_30_days, units_sold_last_30_days
stock available, total_units, inbound, unfulfillable
inbound inbound, working, shipped, receiving
reserved fc_transfer, fc_processing, customer_order
supply total_days_of_supply, days_of_supply_afn
action alert, recommended_replenishment_qty, recommended_ship_date, recommended_action
storage unit_storage_size, unit_storage_size_unit
admin seller_id, fnsku, item_condition, supplier, supplier_part_no, fulfilled_by
Examples
=DRAGON_INVENTORY_RESTOCK("Myaccount", "", "US")
=DRAGON_INVENTORY_RESTOCK("Myaccount", "", "US", "", "", "stock,action")
=DRAGON_INVENTORY_RESTOCK("Myaccount", "", "US", "", "", "all,-admin,-storage")
Notes
- columns: use default, all, compact, identity, sales, stock, inbound, reserved, supply, action, storage, or admin.
- columns are evaluated left to right. A field or group adds columns; prefix with - to remove a field or group. Example: stock,action,-alert.