Functions to Pull Amazon Data into Google Sheets 

GORILLA_ASINLIST( ) Function

Description:

Return a list of active and inactive ASIN’s from your marketplace(s).

Syntax:

GORILLA_ASINLIST([marketplace], [filter_sku])

for Gorilla AGENCY, the syntax is

GORILLA_ASINLIST(sellerID, [marketplace], [filter_sku])

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

filter_asin

OPTIONAL – Part of an ASIN to filter result. The filter will act only on the start of the ASIN like ASINPART*. 

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_ASINLIST()

If no attributes are entered, it will list all your current active and inactive ASIN from all marketplaces.

=GORILLA_ASINLIST(“ALL”,”B43″)

Lists all ASIN’s from all marketplaces where the ASIN starts with “B43”.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_ASINLIST(“SELLER ID)

=GORILLA_ASINLIST(“SELLER ID”, “ALL”, “B43”)

GORILLA_CATEGORY( ) Function

Description:

Get the categories a product is listed under. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_CATEGORY(sku, [marketplace], [queryType], [returnStyle])

for Gorilla AGENCY, the syntax is

GORILLA_CATEGORY(sellerID, sku, [marketplace], [queryType], [returnStyle])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

queryType

OPTIONAL – What to retrieve (defaults to “top”):

• top = Top Level category;
• all = All categories (only 1 SKU/ASIN allowed);
• child = Child category.

returnStyle

OPTIONAL – Return style (defaults to “full”):

• full = Full category path;
• inner = Only inner-most category name.

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_CATEGORY(“B00YD545CC”, “US”, “all”, “full”)

Returns all categories and child categories the product is listed under. If B00YD545CC is a garlic press, the result will show both “Home&Kitchen” and “Home&Kitchen->Kitchen Utensils”

=GORILLA_CATEGORY(“B00YD545CC”, “US”, “all”, “inner”)

Returns all categories and child categories the product is listed under. If B00YD545CC is a garlic press, the result will show “Home&Kitchen” and “Kitchen Utensils” instead of the full category path.

=GORILLA_CATEGORY(“B00YD545CC”, “US”, “top”, “full”)

If “top” is selected, you may use it for array inputs to bulk display the category information. “Top” returns only the main category. If B00YD545CC is a garlic press, the result will show only the main category “Home&Kitchen”.

For Gorilla AGENCY, the same formulas will start with the seller ID:

=GORILLA_CATEGORY(“SELLERID837834”, “B00YD545CC”, “US”, “all”, “full”)

=GORILLA_CATEGORY(“SELLERID837834”, “B00YD545CC”, “US”, “all”, “inner”)

=GORILLA_CATEGORY(“SELLERID837834”, “B00YD545CC”, “US”, “top”, “full”)

GORILLA_CHARGETOTAL( ) Function

Description:

Get the financials breakdown of the sales and charges related to the sale of a product. Supports getting the total account financials or narrowing down by SKU.

IMPORTANT: This is NOT an accounting tool. Amazon reports via the API are inconsistent and subject to change on a regular basis. Use this to identify areas of your business and spot anything that needs attention. It can help with tax returns, but should NOT be used solely for tax and financial statements.

A bookkeeper is required to match your numbers to the nearest cent.

Syntax:

GORILLA_CHARGETOTAL(period, [marketplace], [sku], [chargeType], [event])

for Gorilla AGENCY, the syntax is

GORILLA_CHARGETOTAL(sellerID, period, [marketplace], [sku], [chargeType], [event])

Examples:

=GORILLA_CHARGETOTAL(“This Month”) or =GORILLA_CHARGETOTAL(“2019-04”)

Simplest formula allowed to return all sales and charges for the selected period. This will return an unsorted list of all the categories. For a more organized list, see the following examples.

=GORILLA_CHARGETOTAL(“Last 30 Days”,”ALL”,,”ShippingTax”, “shipment”) or =GORILLA_CHARGETOTAL(“Last 30 Days”,”ALL”,,”ShippingTax”)

Will return the total ShippingTax related charges. sales and charges for the last 30 days. For the full list of periods, and the different types of charges you can narrow it down to, see the table after the examples.

=GORILLA_CHARGETOTAL(“This Year”,”default”,,, “shipment”)

Returns all shipment related sales and charges for this year to date, default marketplace and for all charges. No sku has been specified and so it will pull for total SKU’s.

=GORILLA_CHARGETOTAL(“2019Q2″,”US”,”B038434K3″, , “refund”)

Returns all refund related charges for Q2 of 2019, in the US marketplace, for ASIN B038434K3.

=GORILLA_CHARGETOTAL(“Last 30 Days”,”ALL”,,, “ADJUSTMENT”)

Returns all adjustment related charges for the last 30 days across ALL marketplaces. Sku’s have been left out which will default to all sku’s.

=GORILLA_CHARGETOTAL(“2109Q1″,”DE”,,, “OTHER”)

Returns all other charges that are not grouped under shipment, refund, adjustment. Returns values for Q1 of 2019 for German marketplace.

For Gorilla Agency, the formulas will start with the seller ID:  

=GORILLA_CHARGETOTAL(“SELLER384k3”, “This Month”) or

=GORILLA_CHARGETOTAL(“SELLER384k3”, “2019-04”)

=GORILLA_CHARGETOTAL(“SELLER384k3”, “Last 30 Days”,”ALL”,,”ShippingTax”, “shipment”)

=GORILLA_CHARGETOTAL(“SELLER384k3”, “Last 30 Days”,”ALL”,,”ShippingTax”)

=GORILLA_CHARGETOTAL(“SELLER384k3”, “2019Q2″,”US”,”B038434K3″,, “refund”)

=GORILLA_CHARGETOTAL(“SELLER384k3”, “Last 30 Days”,”ALL”,,, “ADJUSTMENT”)

=GORILLA_CHARGETOTAL(“SELLER384k3”, “2109Q1″,”DE”,,, “OTHER”)

GORILLA_CHARGETOTAL Attributes

Period Attribute:

Event Attribute

GORILLA_CHARGETYPE( ) Function

Description:

Returns a list of the line item names for all “charges” to your Amazon account when it is related to sales. Names includes charges related to both income and expense.

Syntax:

GORILLA_CHARGETYPE([marketplace], [filter_fee], [direction], [full_list])

for Gorilla AGENCY, the syntax is

GORILLA_FEETYPE(sellerID, [marketplace], [filter_fee], [direction], [full_list])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

queryType

OPTIONAL – What to retrieve (defaults to “top”):

• top = Top Level category;
• all = All categories (only 1 SKU/ASIN allowed);
• child = Child category.

returnStyle

OPTIONAL – Return style (defaults to “full”):

• full = Full category path;
• inner = Only inner-most category name.

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_CHARGETTYPE()

If no attributes are entered, it will list all the line items categorized as fees related to the Amazon account..

=GORILLA_FEETYPE(“US”, “Marketpl”, “Column”, “No”)

Lists all fee types for the US marketplace, searching for any fees that start with “Marketpl”, displayed in a column and only displaying the charges associated with the Amazon account. If “YES” is used, it will return all Amazon chargetype names.

For Gorilla AGENCY, the same formulas will start with the seller ID:

=GORILLA_FEETYPE(“SELLER349d3”)

=GORILLA_FEETYPE(“SELLER349d3”, “US”, “Marketpl”, “Column”, “No”)

Direction Attributes:

• Column
• Row

Full_list Attributes:

• No – only shows fees related to the account
• Yes – shows all fee names

GORILLA_FEESESTIMATE( ) Function

Description:

Get the estimated fees associated with the product. (Not the actual settlement product fees and charges to your accounts).

Syntax:

GORILLA_FEESESTIMATE(sku, [marketplace], [returnStyle])

for Gorilla AGENCY, the syntax is

GORILLA_FEESESTIMATE(sellerID, sku, [marketplace], [returnStyle])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

marketplace

OPTIONAL – Marketplace filter. Use “Default” for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER. 

returnStyle

OPTIONAL:

• Full – displays full information of each seller offering the product without header information.
• Fullwithheader – autocreates a header row and displays fulls information of each seller offering the product.

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_FEESESTIMATE(D2)

Uses the ASIN or SKU entered in cell D2 and shows the total estimate fee (Fulfillment fee + referral fee) for the SKU. If Amazon does not have the price information, no estimate will be provided. 

=GORILLA_FEESESTIMATE(A2:C10)

Supports 2 dimensional ranges. Also works horizontally. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:C10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. 

=GORILLA_FEESESTIMATE(“738-JDUY-32F”, “default”, “fullwithheader”)

Entering all the attributes will display the full breakdown of the fee estimate for the product.“Default” refers to your main marketplace. “Fullwithheader” creates another row before the results with the table headers to make it easy to identify.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_FEESESTIMATE(“SELLERID832”, D2)

=GORILLA_FEESESTIMATE(“SELLERID832”, A2:C10)

=GORILLA_FEESESTIMATE(“SELLERID832”, “738-JDUY-32F”, “default”, “fullwithheader”)

GORILLA_FEETOTAL( ) Function

Description:

Get the financials breakdown of all fees related to the sale of a product. Supports getting the total account numbers or narrowing down by SKU.

IMPORTANT: This is NOT an accounting tool. Amazon reports via the API are inconsistent and subject to change on a regular basis. Use this to identify areas of your business and spot anything that needs attention. It can help with tax returns, but should NOT be used solely for tax and financial statements.A bookkeeper is required to match your numbers to the nearest cent.

Syntax:

GORILLA_FEETOTAL(period, [marketplace], [sku], [fee], [event])

for Gorilla AGENCY, the syntax is

GORILLA_FEETOTAL(sellerID, period, [marketplace], [sku], [fee], [event])

Examples:

=GORILLA_FEETOTAL(“This Month”) or =GORILLA_FEETOTAL(“2019-04”)

Simplest formula allowed to return all sales and charges for the selected period. This will return an unsorted list of all the categories. For a more organized list, see the following examples.

=GORILLA_CHARGETOTAL(“This Year”,”default”,,, “shipment”)

Returns all shipment related fees for this year to day, default marketplace and for all charges. No sku has been specified and so it will pull for total SKU’s.

=GORILLA_FEETOTAL(“2019Q2″,”US”,”B038434K3″,, “refund”)

Returns all refund related fees for Q2 of 2019, in the US marketplace, for ASIN B038434K3.

=GORILLA_FEETOTAL(“Last 30 Days”,”US”,,,”servicefee”)

Returns all adjustment related charges for the last 30 days across US marketplace. Sku’s have been left out which will default to all sku’s.

=GORILLA_FEETOTAL(“last year”,”US”,,,”other”)

Returns all other fee that are not grouped under shipment, refund, adjustment. Returns values for Q1 of 2019 for German marketplace.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_FEETOTAL(“SELLER384k3”, “2019-04″,,,”all”,)

=GORILLA_FEETOTAL(“SELLER384k3”, “This Year”,”default”,,”all”, “shipment”)

=GORILLA_FEETOTAL(“SELLER384k3”, “2019Q2″,”US”,”B038434K3″,”ALL”, “refund”)

=GORILLA_FEETOTAL(“SELLER384k3”, “Last 30 Days”,”ALL”,,”ALL”, “servicefee”)

=GORILLA_FEETOTAL(“SELLER384k3”, “last year”,”US”,,,”other”)

GORILLA_FEETOTAL Attributes

Period Attribute:

GORILLA_FEETYPE( ) Function

Description:

Return a list of the line item names associated as fees with to the Amazon account. All variables are optional.

Syntax:

GORILLA_FEETYPE([marketplace], [filter_fee], [direction], [full_list])

for Gorilla AGENCY, the syntax is

GORILLA_FEETYPE(sellerID, [marketplace], [filter_fee], [direction], [full_list])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

marketplace

OPTIONAL – Marketplace filter. Use “Default” for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER. 

returnStyle

OPTIONAL:

• Full – displays full information of each seller offering the product without header information.
• Fullwithheader – autocreates a header row and displays fulls information of each seller offering the product.

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_FEETYPE()

If no attributes are entered, it will list all the line items categorized as fees related to the Amazon account.

=GORILLA_FEETYPE(“US”, “FBA”, “Column”, “No”)

Lists all fee types for the US marketplace, searching for any fees that start with “FBA”, displayed in a column and only displaying the fee’s associated with the Amazon account. If “YES” is used, it will return all Amazon fee names whether it is charged by the account or not.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_FEETYPE(“SELLER349d3”)

=GORILLA_FEETYPE(“SELLER349d3”, “US”, “FBA”, “Column”, “No”)

Direction Attributes:

• Column
• Row

Full_list Attributes:

• No – only shows fees related to the account
• Yes – shows all fee names

GORILLA_INVENTORY( ) Function

Description:

Get inventory movement status of a product such as how many is in stock, transfer or inbound.

Syntax:

GORILLA_INVENTORY(sku, [marketplace], [status])

for Gorilla AGENCY, the syntax is

=GORILLA_INVENTORY(sellerID, sku, [marketplace], [status])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. 

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

status

OPTIONAL – Supply status. Valid values are:

• All
• InStock
• Inbound
• Transfer

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_INVENTORY(D2, “ALL”, “instock”)

Uses the ASIN or SKU entered in cell D2 and shows the total number of instock units across all marketplaces.

=GORILLA_INVENTORY(“B00YD545CC”, “EU”, “transfer”)

Gets the total number of units for ASIN B00YD545CC that are in transfer status for Italy marketplace.

=GORILLA_INVENTORY(A2:A10, “ALL”, “inbound”)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. 

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_INVENTORY(“SELLER63DJ3”, D2, “ALL”, “instock”)

=GORILLA_INVENTORY(“SELLER63DJ3”, “B00YD545CC”, “EU”, “transfer”)

=GORILLA_INVENTORY(“SELLER63DJ3”, A2:A10, “ALL”, “inbound”)

GORILLA_INVENTORY Attributes:

Status Attributes 

• All
• InStock
• Inbound
• Transfer 

GORILLA_MYPRICE( ) Function

Description:

Get the lowest seller price for the SKU or ASIN.

Syntax:

GORILLA_MYPRICE(sku, [marketplace], [condition], [subcondition], [priceType])

for Gorilla AGENCY, the syntax is

GORILLA_MYPRICE(sellerID, sku, [marketplace], [condition], [subcondition], [priceType])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. 

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

condition 

OPTIONAL – Acts as a filter. Valid values are:

• New
• Used
• Collectible
• Refurbished
• Club

SubCondition

OPTIONAL – Acts as a filter. Valid values are: 

• Mint
• Very Good
• Good
• Acceptable
• Poor
• Club
• OEM
• Warranty
• Refurbished Warranty
• Refurbished
• Open Box
• Other

priceType

OPTIONAL – Value to return. Valid values are: 

• LandedPrice
• ListingPrice
• ShippingPrice
• RegularPrice

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_MYPRICE(D2)

Uses the ASIN or SKU entered in cell D2 and shows the price being offered by the seller.

=GORILLA_MYPRICE(“B03H39FJ32”, “US”, “New”)

Will return the current price for ASIN B03H39FJ32 being sold in the US with new condition only. Will not return any prices for used or other conditions.

=GORILLA_MYPRICE(“B03H39FJ32”, “US”, “New”, “mint”, “ListingPrice”)

Filtering formula to get the price of ASIN B03H39FJ32 that is sold in the US, in new and mint condition. Returns the listing price.

=GORILLA_MYPRICE(A2:C10)

Supports 2 dimensional ranges. Also works horizontally. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:C10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. 

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_MYPRICE(“SELLER23HH”, D2)

=GORILLA_MYPRICE(“SELLER23HH”, “B03H39FJ32”, “US”, “New”)

=GORILLA_MYPRICE(“SELLER23HH”, “B03H39FJ32”, “US”, “New”, “mint”, “ListingPrice”)

=GORILLA_MYPRICE(“SELLER23HH”, A2:C10)

GORILLA_MYPRICE Attributes 

GORILLA_LOWESTOFFER( ) Function

Description:

Get the lowest offered listing price from any seller.

Syntax:

GORILLA_LOWESTOFFER(sku, [marketplace], [returnStyle], [priceType])

for Gorilla AGENCY, the syntax is

GORILLA_LOWESTOFFER(sellerID, sku, [marketplace], [returnStyle], [priceType])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. 

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

returnStyle 

OPTIONAL – Formatting of how the results are displayed. Valid values are:

• Full 
• Fullwithheader 

priceType

OPTIONAL – Value to return. Valid values are: 

• LandedPrice
• ListingPrice
• ShippingPrice
• RegularPrice

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_LOWESTOFFER(D2)

Uses the ASIN or SKU entered in cell D2 and shows the lowest price being offered for the SKU. The single lowest price is returned after comparing against all sellers.

=GORILLA_LOWESTOFFER(“738-JDUY-32F”, “default”, “fullwithheader”)

Entering all the attributes will display the full list of all offers on the listing. If there are multiple sellers for the SKU, this formula will create a row for each seller and display the full stats of each seller.“Default” refers to your main marketplace. “Fullwithheader” creates another row before the results with the table headers to make it easy to identify.

=GORILLA_LOWESTOFFER(A2:C10)

Supports 2 dimensional ranges. Also works horizontally. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:C10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_LOWESTOFFER(“SELLER3729”, D2)

=GORILLA_LOWESTOFFER(“SELLER3729”, “738-JDUY-32F”, “default”, “fullwithheader”)

=GORILLA_LOWESTOFFER(“SELLER3729”, A2:C10)

GORILLA_LOWESTOFFER Attributes

returnStyle Attributes:

• Full – displays full information of each seller offering the product without header information
• Fullwithheader – autocreates a header row and displays fulls information of each seller offering the product

priceType Attributes:

• LandedPrice
• ListingPrice
• ShippingPrice
• RegularPrice 

GORILLA_PRODUCT( ) Function

Description:

Get product information for a SKU or ASIN such as title, image URL, weight, color and other supported attributes.

Syntax:

GORILLA_PRODUCT(sku, attributes, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_PRODUCT(sellerID, sku, attributes, [marketplace])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

attribute

Product’s attribute to retrieve shown below.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER. 

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_PRODUCT(“IPHONE7382”, “SmallImage_URL”, “US”)

This formula will pull the main small image URL of SKU IPHONE7382 from the US marketplace. You can then combine it with the regular IMAGE( ) to display it as an image.

=IMAGE(GORILLA_PRODUCT(“IPHONE7382”, “SmallImage_URL”, “US”))

=GORILLA_PRODUCT(“B03H39FJ32”, “Scent”)

Displays the scent name for ASIN B03H39FJ32. If no marketplace is assigned, it will grab the data from the main marketplace.

=GORILLA_PRODUCT(A2:A10,”Title”)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_PRODUCT(“SELLER1378”, “IPHONE7382”, “SmallImage_URL”, “US”)

=GORILLA_PRODUCT(“SELLER1378”, “B03H39FJ32”, “Scent”)

=GORILLA_PRODUCT(“SELLER1378″, A2:A10,”Title”)

GORILLA_PRODUCT Attributes:

GORILLA_RANKHIST( ) Function

Description:

Get the daily historical BSR (Best Seller Rank) over any time period for a single or range of sku’s. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_RANKHIST(period, sku, [marketplace], [queryType], [start_date]. [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_RANKHIST(sellerID, period, sku, [marketplace], [queryType], [start_date]. [end_date])

period

Predefined periods and any custom date frames to get the rank history. See full list of predefined periods below.

sku

SKU or ASIN of the product. Can be a range like A2:A100 or an array of strings like {“SKU12345″,”ASIN12345”} or a string like “A734-FBE4-MDUS”.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

queryType

OPTIONAL – What to retrieve (defaults to “top”):

• top = Top Level category;
• all = All categories (only 1 SKU/ASIN allowed);
• child = Child category.

returnStyle

OPTIONAL – Return style (defaults to “rank”):

• rank = Rank Only;
• r_cat = Rank + Category (accepts array input);
• r_full= Rank + Category Path (accepts array input).

Matrix array inputs like A1:E10 is only accepted for when “rank” is used. Cannot use arrays for r_cat and r_full. 

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_RANKHIST(“last 30 days”, A2:A100)

Bulk returns the BSR over the preset “last 30 days” for all SKU’s from A2 to A100. No marketplace is specified so the default marketplace for your account is returned.

=GORILLA_RANKHIST(“custom”, A2:A5, “US”, “top”, “2018-06-01”, “2018-06-30”)

Bulk returns BSR from June 1 to June 30 for each SKU from A2 to A5. Also returns the top level category the SKU is located in. USA marketplace is requested.

=GORILLA_RANKHIST(“this month”, “B00YD545CC”, “JP”, “child”)

Returns the rankings for each day this month for the sku. Requesting Japan marketplace ranking and category will show the top level category as well as the deepest child category.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_RANKHIST(“SELLERID732”, “last 30 days”, A2:A100)

=GORILLA_RANKHIST(“SELLERID732”, “custom”, A2:A5, “US”, “top”, “2018-06-01”, “2018-06-30”)

=GORILLA_RANKHIST(“SELLERID732”, “this month”, “B00YD545CC”, “JP”, “child”)

GORILLA_RANKHIST Attributes

queryType Attributes:

• all – products are listed under multiple categories. Lists them all.
• top – the top level category you are used to seeing as a seller
• child – the lowest level category of the product 

returnStyle Attributes:

• r_cat – shows rank number and top level category
• rank – rank number only
• r_full – shows the rank and category path 

period Attributes:

GORILLA_RANKING( ) Function

Description:

Get Best Sellers Rank (BSR) for the broadest top level category or deepest child category. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_RANKING(sku, [marketplace], [queryType], [returnStyle])

for Gorilla AGENCY, the syntax is

GORILLA_RANKING(sellerID, sku, [marketplace], [queryType], [returnStyle])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

queryType

OPTIONAL – What to retrieve (defaults to “top”):

• top = Top Level category;
• all = All categories (only 1 SKU/ASIN allowed);
• child = Child category.

returnStyle

OPTIONAL – Return style (defaults to “rank”):

• rank = Rank Only;
• r_cat = Rank + Category (accepts array input);
• r_full= Rank + Category Path (accepts array input).

Matrix array inputs like A1:E10 is only accepted for when “rank” is used. Cannot use arrays for r_cat and r_full. 

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_RANKING(“B00YD545CC”, “US”, “top”, “r_cat”)

Returns BSR of the top category as well as the category name for unit B00YD545CC for the US marketplace.

=GORILLA_RANKING(“A2:A10”, , “top”, “rank”)

Supports array inputs. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Default marketplace is used as it is not set.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_RANKING(“SELLERA73J42”, “B00YD545CC”, “US”, “top”, “r_cat”)

=GORILLA_RANKING(“SELLERA73J42”, “A2:A10”, , “top”, “rank”)

GORILLA_RANKING Attributes

queryType Attributes:

• all – products are listed under multiple categories. Lists them all.
• top – the top level category you are used to seeing as a seller
• child – the lowest level category of the product 

returnStyle Attributes:

• r_cat – shows rank number and top level category
• rank – rank number only
• r_full – shows the rank and category path 

GORILLA_RATINGS( ) Function

Description:

Get the average review rating of a product. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_RATINGS(sku, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_RATINGS(sellerID, sku, [marketplace])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER. 

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_RATINGS(“B00YD545CC”, “CA”)

Returns the review rating for ASIN B00YD545CC for Canadian marketplace.

=GORILLA_RATINGS(A2:A10, ,)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. Default marketplace data is returned as no marketplace is set.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_RATINGS(“SELLERID38″, B00YD545CC”, “CA”)

=GORILLA_RATINGS(“SELLERID38”, A2:A10, ,)

GORILLA_REVIEW( ) Function

Description:

Get the full reviews and details of a product based on SKU or ASIN. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_REVIEW(sku, [marketplace], [count])

for Gorilla AGENCY, the syntax is

GORILLA_REVIEW(sellerID, sku, [marketplace], [count])

sku

SKU or ASIN of the product. Only one accepted.

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

count

OPTIONAL – Number of reviews to retrieve (default value is 5) or “ALL” to retrieve all reviews 

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_REVIEW(“B00YD545CC”, “US”, 5)

Returns the latest 5 reviews, title, name, link and rating for ASIN B00YD545CC selling in the USA marketplace.

=GORILLA_REVIEW(A2:A10, ,)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Default marketplace data is returned as no marketplace is set.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_REVIEW(“SELLER832”, “B00YD545CC”, “US”, 5)

=GORILLA_REVIEW(“SELLER832”, A2:A10, ,)

GORILLA_REVIEWCOUNT( ) Function

Description:

Get the number of reviews for a given product based on SKU or ASIN. Only works for single marketplaces at a time. Not “ALL”.

Syntax:

GORILLA_REVIEWCOUNT(sku, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_REVIEWCOUNT(sellerID, sku, [marketplace])

sku

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER. 

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_REVIEWCOUNT(“B00YD545CC”, “CA”)

Returns the number of reviews for ASIN B00YD545CC selling in the Canadian marketplace.

=GORILLA_REVIEWCOUNT(A2:A10, ,)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. Default marketplace data is returned as no marketplace is set.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_REVIEWCOUNT(“SELLER832J”, “B00YD545CC”, “CA”)

=GORILLA_REVIEWCOUNT(“SELLER832J”, A2:A10, ,)

GORILLA_SALESCOUNT( ) Function

Description:

Gets total number of sales for a product between any time period. Only period is required. Other attributes are optional.

Syntax:

GORILLA_SALESCOUNT(period, [marketplace], [sku], [status], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_SALESCOUNT(sellerID, period, [marketplace], [sku], [status], [start_date], [end_date])

period

Predefined period to get sales. See full list of predefined periods below.

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

sku

OPTIONAL – Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

status

OPTIONAL – Order Status. Valid values are:

• AllButCanceled(default)
• All
• PendingAvailability (JP only)
• Pending
• Unshipped
• PartiallyShipped
• Shipped
• InvoiceUnconfirmed
• Canceled
• Unfulfillable

start_date

OPTIONAL – Starting date to get sales from when period is custom.

end_date

OPTIONAL – Ending date to get sales from when period is custom. 

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

=GORILLA_SALESCOUNT(“Custom”, “US”, “B00YD545CC”, “Shipped”, “2018-01-01”, “2018-01-21”)

Gets total number of units sold for B00YD545CC that has been shipped in the US marketplace between Jan 1, 2018 and Jan 21, 2018.

=GORILLA_SALESCOUNT(“This Week”,”ALL”,A2:A10,”ALL”)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_SALESCOUNT(“This Month”, “ALL”, “IPHN3724”, “Canceled”)

Gets the total number of units for SKU IPHN3724 from all marketplaces that were canceled this month.

=GORILLA_SALESCOUNT(“Same Day Last Month”, “ALL”, “IPHN3724”, “ALL”)

Gets the total number of units for SKU IPHN3724 from all marketplaces that are sold and pending.

=GORILLA_SALESCOUNT(“This Year”)

 Gets the total number of units sold for all products, account across all marketplaces.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_SALESCOUNT(“SELLER37432”, “Custom”, “US”, “B00YD545CC”, “Shipped”, “2018-01-01”, “2018-01-21”)

=GORILLA_SALESCOUNT(“SELLER37432”, “This Week”,”ALL”,A2:A10,”ALL”)

=GORILLA_SALESCOUNT(“SELLER37432”, “This Month”, “ALL”, “IPHN3724”, “Canceled”)

=GORILLA_SALESCOUNT(“SELLER37432”, “Same Day Last Month”, “ALL”, “IPHN3724”, “ALL”)

=GORILLA_SALESCOUNT(“SELLER37432”, “This Year”)

GORILLA_SALESCOUNT Attributes

Period Attributes:

Status Attributes:

GORILLA_SALESTOTAL( ) Function

Description:

Get total sales dollar amount for any product for any specified time period. Only the period attribute is required. Other attributes are optional.

Syntax:

GORILLA_SALESTOTAL(period, [marketplace], [sku], [status], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_SALESTOTAL(sellerID, period, [marketplace], [sku], [status], [start_date], [end_date])

period

Predefined period to get sales. See full list of predefined periods below.

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

sku

OPTIONAL – Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

status

OPTIONAL – Order Status. Valid values below.

start_date

OPTIONAL – Starting date to get sales from when period is custom.

end_date

OPTIONAL – Ending date to get sales from when period is custom. 

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_SALESTOTAL(“Custom”, “US”, “B00YD545CC”, “Shipped”, “2018-01-01”, “2018-01-21”)

Returns total dollar in sales for unit B00YD545CC that has been shipped in the US marketplace between Jan 1, 2018 and Jan 21, 2018.

=GORILLA_SALESTOTAL(“This Week”,”ALL”,A2:A10,”ALL”)

Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_SALESTOTAL(“This Month”, “ALL”, “IPHN3724”, “Canceled”)

Gets the total dollar amount for SKU IPHN3724 from all marketplaces that were canceled this month.

=GORILLA_SALESTOTAL(“Same Day Last Month”, “ALL”, “IPHN3724”, “pending”)

Gets the total dollar in sales for SKU IPHN3724 from all marketplaces that are sold and pending.

=GORILLA_SALESTOTAL(“This Year”)

Gets the total dollar in sales for all products, across all marketplaces, so far year to date.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_SALESTOTAL(“SELLER382”, “Custom”, “US”, “B00YD545CC”, “Shipped”, “2018-01-01”, “2018-01-21”)

=GORILLA_SALESTOTAL(“SELLER382”, “This Week”,”ALL”,A2:A10,”ALL”)

=GORILLA_SALESTOTAL(“SELLER382”, “This Month”, “ALL”, “IPHN3724”, “Canceled”)

=GORILLA_SALESTOTAL(“SELLER382”, “Same Day Last Month”, “ALL”, “IPHN3724”, “pending”)

=GORILLA_SALESTOTAL(“SELLER382”, “This Year”)

GORILLA_SALESTOTAL Attributes

Period Attributes:

Status Attributes:

GORILLA_SKUASIN( ) Function

Description:

Convert ASIN to SKU and SKU to ASIN. Bulk convert compatible.

Syntax:

GORILLA_SKUASIN(SKU/ASIN, [direction])

for Gorilla AGENCY, the syntax is

GORILLA_SKUASIN(sellerID, SKU/ASIN, [direction])

sku

Product’s SKU/ASIN. Can be an array of strings like {“ASIN12345″,”ASIN67890”} or a string.

direction

OPTIONAL – Conversion type. If sku2asin (default), first parameter is interpreted as SKUs and ASINs will be returned. If asin2sku, first parameter is interpreted as ASINs.

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_SKUASIN(“IPHN3724”)

Displays the ASIN for SKU IPHN3724. As the direction is not set, the function assumes the value is a SKU and will return the ASIN. If you have a long list of SKU’s from a file, you can get the matching ASIN quickly with this function.

=GORILLA_SKUASIN(“B00YD545CC”, “sku2asin”)

When the direction of sku2asin is entered, it will convert from SKU to ASIN. If you have a long list of SKU’s from a file, you can get the matching ASIN quickly with this function.

=GORILLA_SKUASIN(D33:E39, “asin2sku”)

Return an array of SKU’s by entering a column, row or range of ASIN’s like this example.

=GORILLA_SKUASIN(D33:E39, “sku2asin”)

Return an array of ASIN’s by entering a column, row or range of ASIN’s like this example.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_SKUASIN(“SELLER832J”, “IPHN3724”)

=GORILLA_SKUASIN(“SELLER832J”, “B00YD545CC”, “sku2asin”)

=GORILLA_SKUASIN(“SELLER832J”, D33:E39, “asin2sku”)

=GORILLA_SKUASIN(“SELLER832J”, D33:E39, “sku2asin”)

GORILLA_SKUASIN Attributes 

• sku2asin
• asin2sku 

GORILLA_SKUASIN( ) Function

Description:

Convert single or bulk SKU or ASIN to FNSKU and vice versa.

Syntax:

GORILLA_SKUFNSKU(sku or asin, [direction])

for Gorilla AGENCY, the syntax is

GORILLA_SKUFNSKU(sellerID, sku or asin, [direction])

sku

Product’s SKU/ASIN. Can be an array of strings like {“ASIN12345″,”ASIN67890”} or a range like A2:A100 where cells 2 to 100 in column A would all have SKU’s or ASIN’s.

direction

OPTIONAL – Conversion type. If sku2fnsku (default), first parameter is interpreted as SKUs and FNSKUs will be returned. If fnsku2sku, first parameter is interpreted as FNSKUs.

Examples:

Use ranges in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_SKUFNSKU(“IPHN3724”)

Displays the FNSKU for SKU IPHN3724. As the direction is not set, the function assumes the value is a SKU and will return the FNSKU. If you have a long list of SKU’s from a file, you can get the matching FNSKU quickly with this function.

=GORILLA_SKUFNSKU(“B00YD545CC”, “sku2asin”)

When the direction of sku2fnsku is entered, it will convert from SKU to FNSKU. If you have a long list of SKU’s from a file, you can get the matching FNSKU quickly with this function.

=GORILLA_SKUASIN(D33:E39, “fnsku2sku”)

Return an array of SKU’s by entering a column, row or range of ASIN’s like this example.

=GORILLA_SKUASIN(D33:E39,”sku2fnsku”)

Return an array of FNSKU’s by entering a column, row or range of SKU’s like this example.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_SKUFNSKU(“SELLER832J”, “IPHN3724”)

=GORILLA_SKUFNSKU(“SELLER832J”, “B00YD545CC”, “sku2asin”)

=GORILLA_SKUASIN(“SELLER832J”, D33:E39, “fnsku2sku”)

=GORILLA_SKUASIN(“SELLER832J”, D33:E39,”sku2fnsku”)

GORILLA_SKUASIN Attributes 

• sku2fnsku
• fnsku2sku 

GORILLA_SKULIST( ) Function

Description:

Return a list of active and inactive SKU’s from your marketplace(s).

Syntax:

GORILLA_SKULIST([marketplace], [filter_sku])

for Gorilla AGENCY, the syntax is

GORILLA_SKULIST(sellerID, [marketplace], [filter_sku])

marketplace

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

filter_sku

OPTIONAL – Part of an SKU to filter result. The filter will act only at the start of the SKU. If there multiple SKU’s like 54145484, 5414345, 54145FD5, you can search for 5414* to list all SKU’s starting with 5414.

Examples:

Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.

=GORILLA_SKULIST()

If no attributes are entered, it will list all your current active and inactive SKU’s from all your marketplaces.

=GORILLA_SKULIST(“UK”,”IPHONE”)

Lists all SKU’s that start with the phrase “IPHONE” listed on the UK marketplace. You can enter any text string to use as a filter.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_SKULIST(“SELLER832J”)

=GORILLA_SKULIST(“SELLER832J”, “UK”, “IPHONE”)