Syntax
=DRAGON_CATALOG(account, [ASIN], [marketplace], [language], [brand], [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_CATALOG("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_CATALOG("Myaccount", "B0C87GTM5G", "US", "Mybrand")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | asin | title | title_differentiation | brand | product_type | my_nick | my_group | … |
| 2 | US | B0EXAMPLE1 | Mybrand Classic Logo Tee (Black, L) | Logo Tee (Black) | Mybrand | SHIRT | Logo Tee (Black) | Logo Tee | … 19 more |
| 3 | US | B0EXAMPLE2 | Mybrand Classic Logo Tee (Navy, M) | Logo Tee (Navy) | Mybrand | SHIRT | Logo Tee (Navy) | Logo Tee | … 19 more |
| 4 | US | B0EXAMPLE3 | Mybrand Leather Patch Hat (Grey) | Patch Hat (Grey) | Mybrand | HAT | Patch Hat (Grey) | Patch Hat | … 19 more |
| 5 | US | B0EXAMPLE4 | Mybrand Ceramic Mug 11oz | Mug 11oz | Mybrand | MUG | Mug 11oz | Drinkware | … 19 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. |
| language | Optional | Optional listing language such as en, fr, or fr_CA. Defaults to the marketplace default language. |
| brand | Optional | Optional brand 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 | No | Seller id |
| marketplace | Yes | Marketplace |
| asin | Yes | ASIN |
| title | Yes | Title |
| title_differentiation | Yes | Item highlight |
| brand | Yes | Brand |
| product_type | Yes | Product type |
| my_nick | Yes | Seller-maintained product nickname |
| my_group | Yes | Seller-maintained product group |
| description | Yes | Description |
| keywords | Yes | Keywords |
| MAIN | Yes | MAIN |
| PT01 | Yes | PT01 |
| PT02 | Yes | PT02 |
| PT03 | Yes | PT03 |
| PT04 | Yes | PT04 |
| PT05 | Yes | PT05 |
| PT06 | Yes | PT06 |
| PT07 | Yes | PT07 |
| PT08 | Yes | PT08 |
| PT09 | Yes | PT09 |
| bullet_1 | Yes | Bullet 1 |
| bullet_2 | Yes | Bullet 2 |
| bullet_3 | Yes | Bullet 3 |
| bullet_4 | Yes | Bullet 4 |
| bullet_5 | Yes | Bullet 5 |
| created_date | Yes | Created date |
| last_updated_date | Yes | Last updated date |
Column groups
Groups select several columns at once and combine with single fields in the columns parameter.
compact asin, my_nick, my_group, title, title_differentiation, brand, product_type
identity asin, marketplace, my_nick, my_group, brand, product_type
content title, title_differentiation, description, keywords
images MAIN, PT01, PT02, PT03, PT04, PT05, PT06, PT07, PT08, PT09
image_meta main_image_url, main_image_height, main_image_width
bullets bullet_1, bullet_2, bullet_3, bullet_4, bullet_5
price min_price_amount, max_price_amount, price_currency
listing fulfillment, condition, parent_asin, variation_theme
dates created_date, last_updated_date
admin seller_id
Examples
=DRAGON_CATALOG("Myaccount", "B0C87GTM5G", "US", "Mybrand")
=DRAGON_CATALOG("Myaccount", "", "US", "", "identity,images")
Notes
- my_nick and my_group are direct dashboard-maintained values. Blank means unset.
- columns: use default, all, compact, identity, content, images, image_meta, bullets, price, listing, dates, or admin.
- columns are evaluated left to right. A field or group adds columns; prefix with - to remove a field or group. Example: identity,images,-PT09.