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
Example output from the Nordvik demo store – your sheet shows your own store's data.
A1fx
=DRAGON_INVENTORY_RESTOCK("Nordvik", "", "US")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | sku | fnsku | asin | item_condition | supplier | supplier_part_no | currency | … |
| 2 | US | NV-HAT-CHARCOAL | X0KNIT0101 | B0KNIT0101 | – | – | – | USD | … 22 more |
| 3 | US | NV-HAT-NAVY | X0KNIT0104 | B0KNIT0104 | – | – | – | USD | … 22 more |
| 4 | US | NV-TEE-BLACK-L | X0KNIT0109 | B0KNIT0109 | – | – | – | USD | … 22 more |
| 5 | US | NV-SWT-CHARCOAL-L | X0KNIT0121 | B0KNIT0121 | – | – | – | USD | … 22 more |
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 | Optional marketplace/country code such as US, CA, or MX. |
| alert | Optional | Optional alert filter. |
| recommended action | Optional | Optional recommended action filter. Separate several with ;. |
| columns | Optional | Optional output columns separated by ;. |
| 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 | No | Amazon seller id (merchant token) of the store. |
| 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 fnsku, item_condition, supplier, supplier_part_no, fulfilled_by
Examples
=DRAGON_INVENTORY_RESTOCK("Mystore", "", "US")
=DRAGON_INVENTORY_RESTOCK("Mystore", "", "US", "", "", "stock; action")
=DRAGON_INVENTORY_RESTOCK("Mystore", "", "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.