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
Example output from the Nordvik demo store – your sheet shows your own store's data.
A1fx
=DRAGON_CATALOG("Nordvik", "", "US", "", "Nordvik")| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | marketplace | asin | title | title_differentiation | brand | product_type | my_nick | my_group | … |
| 2 | US | B0KNIT0101 | Nordvik Merino Wool Beanie, Ribbed Cuffed Knit Hat – Charcoal | Beanie (Charcoal) | Nordvik | HAT | Beanie (Charcoal) | Beanies | … 19 more |
| 3 | US | B0KNIT0104 | Nordvik Merino Wool Beanie, Ribbed Cuffed Knit Hat – Navy | Beanie (Navy) | Nordvik | HAT | Beanie (Navy) | Beanies | … 19 more |
| 4 | US | B0KNIT0109 | Nordvik Fjord Graphic T-Shirt for Men – Black, L | Fjord Tee (Black) | Nordvik | SHIRT | Fjord Tee (Black) | Fjord Tees | … 19 more |
| 5 | US | B0KNIT0121 | Nordvik Heavyweight Crewneck Sweatshirt for Men – Charcoal, L | Sweatshirt (Charcoal) | Nordvik | SWEATSHIRT | Sweatshirt (Charcoal) | Sweatshirts | … 19 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 | Optional | Optional ASIN or an ASIN 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. |
| language | Optional | Optional listing language such as en, fr, or fr_CA. Defaults to the marketplace default language. |
| brand | Optional | Optional brand filter. Separate several brands 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 | 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("Mystore", "B0MYASIN01", "US", "", "Mybrand")
=DRAGON_CATALOG("Mystore", "", "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.