CATEGORY - Get the category a product is listed under

Formula Generator

Get the main category a product is listed under for any SKU or ASIN. To refine your results further, use the optional parameters (e.g. filter by marketplace or category type).

Fill in the fields below, then copy and paste your formula.

Enter the nickname chosen for the Amazon seller account, in your Getmydata dash.

Get categories for a specific SKU or ASIN. You can also type A1:A115 to show categories for SKUs within that cells range.

=GET_CATEGORIES("Nickname", "SKU or cell range")

Optional parameters

Select between Main, Child, or All to show the main and sub-categories the product is listed under.

Use Default for the seller default marketplace. Other valid values are country codes US, UK, CA, etc.

=GET_CATEGORIES("Nickname", "SKU or cell range")

More Formulas

Getmydata

Our platform automatically syncs your Amazon seller data to Google Sheets with AI insights and alerts.

Contact Info

71-75 Shelton Street
Covent Garden, London
support@get-mydata.com