Help Center · Sheet Functions · Listing

DRAGON_ATTRIBUTES

Shows listing attribute values wide: one row per ASIN, one column per attribute (color, size, material, and any other attribute Amazon carries for the product type).

Syntax

=DRAGON_ATTRIBUTES(account, [ASIN], [marketplace], [language], [attributes], [header], [transpose])

Parameters in [brackets] are optional. Leave an optional parameter blank to include everything.

This page is also available inside Sheets – type =DRAGON_ATTRIBUTES("help") in any cell to get the same reference without leaving your spreadsheet.

Parameters

ParameterRequiredDescription
accountRequiredAccount nickname, account number (1, 2, ...) or Amazon account id. Leave empty if you have only one account.
ASINOptionalOptional ASIN or an ASIN list separated by ;. Output preserves this order. Also accepts a cell range like A2:A100 or INDIRECT() pointing to a list.
marketplaceOptionalOptional marketplace/country code such as US, CA, or MX.
languageOptionalOptional listing language such as en, fr, or fr_CA. Defaults to the marketplace default language.
attributesOptionalOptional attribute keys separated by ; to show as columns, such as color, size, material. Leave empty (or use all) for every descriptive attribute.
headerOptionalUse no, false, or 0 to suppress the output header row. Default: Yes.
transposeOptionalUse yes, true, or 1 to transpose the output.

Examples

=DRAGON_ATTRIBUTES("Mystore", "B0MYASIN01", "US", "", "color; size")
=DRAGON_ATTRIBUTES("Mystore", A2:A50, "US", "", "color; size; material")

Notes

  • attributes: attribute keys separated by ; become columns, in the order given. Any key is accepted verbatim.
  • Leave attributes empty (or use all) to output every descriptive attribute present, most common first. Pricing, offer, and fulfillment keys are suppressed in that mode.
  • asin accepts one ASIN, several ASINs, a cell range, or INDIRECT() pointing to a list; output rows follow that order.