Syntax
=DRAGON_BUYBOX(account, [ASIN], [marketplace], [fulfillment], [eligibility], [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_BUYBOX("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_BUYBOX("Myaccount", "B0C87GTM5G", "US")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | seller_id | asin | marketplace | is_my_offer | condition | subcondition | fulfillment | is_buybox_winner | … |
| 2 | A1MYSELLERID | B0EXAMPLE1 | US | No | New | – | FBA | No | … 5 more |
| 3 | A1MYSELLERID | B0EXAMPLE2 | US | Yes | New | – | FBA | Yes | … 5 more |
| 4 | A1MYSELLERID | B0EXAMPLE3 | US | Yes | New | – | FBA | Yes | … 5 more |
| 5 | A1MYSELLERID | B0EXAMPLE4 | US | No | New | – | FBA | No | … 5 more |
Parameters
| Parameter | Required | Description |
|---|---|---|
| account | Required | Account nickname or Amazon account id. |
| ASIN | Optional | Optional ASIN or comma/space separated ASIN 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. |
| fulfillment | Optional | Optional fulfillment filter: FBA or FBM. |
| eligibility | Optional | Optional Prime eligibility filter: NATIONAL or NONE. |
| 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 | Offer seller id. |
| asin | Yes | Asin. |
| marketplace | Yes | Marketplace. |
| marketplace_id | No | Marketplace id. |
| is_my_offer | Yes | Is my offer. |
| condition | Yes | Condition. |
| subcondition | Yes | Subcondition. |
| fulfillment | Yes | Fulfillment. |
| is_buybox_winner | Yes | Is buy box winner. |
| listing_price | Yes | Listing price. |
| shipping_price | Yes | Shipping price. |
| landed_price | Yes | Landed price. |
| currency | Yes | Currency. |
| prime_eligibility | Yes | Prime eligibility. |
| offer_source | No | Offer source. |
| buying_option_type | No | Buying option type. |
| request_item_condition | No | Request item condition. |
| request_offer_type | No | Request offer type. |
| customer_membership | No | Customer membership. |
| sample_postal_country_code | No | Sample postal country code. |
| sample_postal_code | No | Sample postal code. |
| glance_view_weight_percentage | No | Glance view weight percentage. |
| shipping_price_currency | No | Shipping price currency. |
| points_number | No | Points number. |
| points_amount | No | Points amount. |
| points_currency | No | Points currency. |
Column groups
Groups select several columns at once and combine with single fields in the columns parameter.
compact fulfillment, is_buybox_winner, listing_price, shipping_price, landed_price, currency, prime_eligibility
Examples
=DRAGON_BUYBOX("Myaccount", "B0C87GTM5G", "US")
=DRAGON_BUYBOX("Myaccount", "B0C87GTM5G", "US", "", "NATIONAL")
=DRAGON_BUYBOX("Myaccount", "B0C87GTM5G", "US", "", "", "compact")
Notes
- eligibility: use NATIONAL or NONE. Leave empty to include all eligibility values, including blank rows.
- columns: use compact to drop seller, marketplace, ASIN, ownership, condition, and subcondition context. default and all are also supported.
- columns are evaluated left to right. A field or group adds columns; prefix with - to remove a field or group.