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], [inactive])

for Gorilla AGENCY, the syntax is

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

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*.

inactive

OPTIONAL - enter "include" or "exclude" to show or hide inactive, deleted, closed, suppressed products.

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( , , "INCLUDE")

This will list the entire list of SKUs in your account including all the deleted, inactive, closed, suppressed products.If no inputs are entered like GORILLA_SKULIST(), the default value is "EXCLUDE".

=GORILLA_ASINLIST("ALL", "B43")

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

=GORILLA_ASINLIST("US" , , "INCLUDE")

This will list all ASINs for the US marketplace only. Will also show closed, inactive, deleted, suppressed SKUs.

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

=GORILLA_ASINLIST("SELLER ID")

=GORILLA_ASINLIST("SELLER ID", , , "INCLUDE")

=GORILLA_ASINLIST("SELLER ID", "ALL", "B43")

=GORILLA_ASINLIST("SELLER ID", "US" , , "INCLUDE")

GORILLA_ASINSTATUS( ) Function

Description:

Returns the status of the ASIN whether it is active or inactive.

Syntax:

GORILLA_ASINSTATUS([marketplace], ASIN/SKU)

for Gorilla AGENCY, the syntax is

GORILLA_ASINLIST(sellerID, [marketplace], ASIN/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.

ASIN/SKU

REQUIRED - The ASINs or SKUs to get the status of.

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_ASINSTATUS("US", A2:B100)

This will return "active" or "inactive" for all the ASINs or SKUs listed from A2 to B100 for the US marketplace. The function supports 2D arrays such as a set of values in column A and column B.

=GORILLA_ASINSTATUS( , A1:A1000)

If the marketplace is left out, it will get the listing status of the ASIN/SKUs from the default marketplace associated with your account. Use ranges in your formula to get the results in bulk.

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

=GORILLA_ASINSTATUS("SELLER ID", "US", A2:B100)

=GORILLA_ASINSTATUS("SELLER ID", A1:A1000)

GORILLA_BUYBOXOFFERS( ) Function

Description:

Get the list of all sellers and offerings on the listing and competing for the buy box. Does not pull information for SKU's that you do not sell. Only works for SKU's and ASIN's in your inventory.

Syntax:

GORILLA_BUYBOXOFFERS(sku, [marketplace], [header])

for Gorilla AGENCY, the syntax is

GORILLA_BUYBOXOFFERS(sellerID, sku, [marketplace], [header])

sku

SKU or ASIN of the product. Unlike other functions, this one does NOT accept array inputs or ranges like {"SKU12345","ASIN12345"} or A1:A100.

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.

header

OPTIONAL - display header in the table of results

• TRUE = auto creates a header as the first row of results. Selected by default if no values are entered.
• FALSE = only shows the table of data. No headings or titles.

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_BUYBOXOFFERS("B00YD545CC", "US", "TRUE")

Returns all sellers for the listing in the US market along with details of the buy box. A header row is automatically generated.

=GORILLA_BUYBOXOFFERS("B00YD545CC", "DE", "FALSE")

Returns all sellers for the listing in the German market along with details of the buy box. A header row is not present. Only the data is displayed.

=GORILLA_BUYBOXOFFERS("B00YD545CC")

If only the SKU is entered, it will display data for all sellers in the default marketplace and include the header in the table.

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

=GORILLA_BUYBOXOFFERS("SELLERID837834", "B00YD545CC", "US", "TRUE")

=GORILLA_BUYBOXOFFERS("SELLERID837834", "B00YD545CC", "US", "FALSE")

=GORILLA_BUYBOXOFFERS("SELLERID837834", "B00YD545CC")

GORILLA_BUYBOXPRICE( ) Function

Description:

Get the current buy box price of the seller winning the buy box.

Syntax:

GORILLA_BUYBOXPRICE(sku, [marketplace], [condition], [returnStyle], [priceType])

for Gorilla AGENCY, the syntax is

GORILLA_BUYBOXPRICE(seller ID, sku, [marketplace], [condition], [returnStyle], [priceType])

sku

SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below. If a range of SKU is used in the formula, it will display the buy box price only.

marketplace

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

condition

OPTIONAL - Filter for new or used conditions

• NEW = only displays the prices for products that are being sold in NEW condition.
• USED = only displays the prices for products that are being sold as USED condition.

returnStyle

OPTIONAL - Displays the results in a table or as a list of prices.

• Default results show the price for the lowest price for each SKU/ASIN provided.
• FULL - loads all buy box data like price, fulfillment channel, offer count, listing price, suggested price, landed price.
• FULLWITHHEADER - shows the "full" data with a header row as the first row.

pricetype

OPTIONAL - Displays the results as either the following:

• LandedPrice - Displays the results based on the LandedPrice of the SKU that is entered in Seller Central
• ListingPrice - Displays the results based on the ListingPrice of the SKU that is entered in Seller Central
• ShippingPrice- Displays the results based on the ShippingPrice of the SKU that is entered in Seller Central

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_BUYBOXPRICE(A1:A1000, "US", "ANY", "PRICE")

Returns the lowest offered buy box prices only for all SKU's in A1:A1000. Pulls from the US marketing for any condition.

=GORILLA_BUYBOXPRICE("B00YD545CC", "DEFAULT", "NEW", "FULL")

Returns the buy box price for the ASIN in the default marketplace. Looking up NEW condition products only. Full results are displayed with no header in the table of results.

=GORILLA_BUYBOXPRICE("B00YD545CC")

If only the SKU is entered, it will display the price of the buy box only.

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

=GORILLA_BUYBOXPRICE("SELLERID837834", A1:A1000, "US", "ANY", "PRICE")

=GORILLA_BUYBOXPRICE("SELLERID837834", "B00YD545CC", "DEFAULT", "NEW", "FULL")

=GORILLA_BUYBOXPRICE("SELLERID837834", "B00YD545CC")

GORILLA_BUYBOXWINNER( ) Function

Description:

Returns "winner" or "loser" based on whether you are winning or losing the buy box.

Syntax:

GORILLA_BUYBOXWINNER(sku, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_BUYBOXWINNER(seller ID, sku, [marketplace])

sku

SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below. If a range of SKU is used in the formula, it will display the buy box price only.

marketplace

OPTIONAL - Marketplace filter. Use Default for the seller default. Other valid values are country codes US, DE, 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_BUYBOXWINNER(A1:A1000, "US")

Returns "winner" or "loser" for each of the SKU or ASIN listed. Results are for the US marketplace.

=GORILLA_BUYBOXWINNER("B00YD545CC")

Returns "winner" or "loser" for the ASIN B00YD545CC. The default marketplace is used as no marketplace is defined.

=GORILLA_BUYBOXWINNER(A1:A1000)

Returns "winner" or "loser" for each of the ASINs or SKUs listed from A1 to A1000.

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

=GORILLA_BUYBOXWINNER("SELLERID837834", A1:A1000, "US")

=GORILLA_BUYBOXWINNER("SELLERID837834", "B00YD545CC")

=GORILLA_BUYBOXWINNER("SELLERID837834", A1:A1000)

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("This Month", "FR", "B3XJJDD7")

=GORILLA_CHARGETOTAL("2020Q4", "UK", "B3XJJDD7")

Will return all charges assigned to the ASIN in the French and UK marketplace for the selected time period.

=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.

=GORILLA_CHARGETOTAL("2019Q1", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

=GORILLA_CHARGETOTAL("2019-05", "US", "B00YD545CC", "All")

To get monthly data, use the format YYYY-MM as the preset period.

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

=GORILLA_CHARGETOTAL("SELLER384k3", "This Month")

=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("SELLER37432", "2019Q1", "US", "B00YD545CC", "All"

=GORILLA_CHARGETOTAL("SELLER37432", "2019-05", "US", "B00YD545CC", "All")

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_CHARGETYPE()

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

=GORILLA_FEETYPE("US", "Marketplace", "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.
• FBAFees - Amazon's FBA fee for your item
• PerItemFee - the per item fee Amazon charges for your product
• ReferralFee - the referral fee amount based on the category of your product
• VariableClosingFee - the variable closing fee

For deeper understanding of all fees, please refer to the Ultimate Amazon Seller Fees Guide.

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.

=GORILLA_FEESESTIMATE("738-JDUY-32F", "US", "FBAFees")

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_FEESESTIMATE("SELLERID832", "738-JDUY-32F", "US", "FBAFees")

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_FEETOTAL("This Month", "FR", "B3XJJDD7")

=GORILLA_FEETOTAL("2020Q4", "UK", "B3XJJDD7")

Will return all charges assigned to the ASIN in the French and UK marketplace for the selected time period.

=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.

=GORILLA_FEETOTAL("2019Q1", "US", "B00YD545CC", "All")

=GORILLA_FEETOTAL("2019-05", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

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("SELLER37432", "2019Q1", "US", "B00YD545CC", "All")

=GORILLA_FEETOTAL("SELLER37432", "2019-05", "US", "B00YD545CC", "All")

GORILLA_FEETOTAL Attributes

Period Attribute:

GORILLA_FEETYPE( ) Function

Description:

Return a list of the line item names associated as fees with 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:

=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", "UK", "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", "UK", "transfer")

=GORILLA_INVENTORY("SELLER63DJ3", A2:A10, "ALL", "inbound")

What you will see when using this is how Amazon provides inventory numbers across marketplaces.

For example, if you have 100 units in Germany, it is technically available in DE, UK, ES, FR, IT.So Amazon enters your inventory as 100x5 = 500 inventory available.

So to get the number you want only for Germany, you have to enter the formula to be specific for the marketplace.

=GORILLA_INVENTORY(ASIN,"DE","inbound")

In any spreadsheet, try

=GORILLA_INVENTORY(ASIN123123,"DE","instock")

=GORILLA_INVENTORY(ASIN321321,"DE","inbound")

=GORILLA_INVENTORY(ASIN567856,"DE","transfer")

And you will see the numbers for each marketplace.

We use the API, not the reports and so we use the data Amazon provides us. You just have to use more detail in the formula to get what you need for UK marketplace.

GORILLA_INVENTORY Attributes:

Status Attributes 

• All
• InStock
• Inbound
• Transfer 

GORILLA_INVENTORYHIST( ) Function

Description:

Shows historical inventory levels of past dates. Works like GORILLA_INVENTORY. Only works on going forward basis. Historical data before using Gorilla ROI cannot be retrieved. 

Syntax:

GORILLA_INVENTORYHIST(period, sku, [marketplace], [status], [start date], [end date])

for Gorilla AGENCY, the syntax is

GORILLA_INVENTORYHIST(sellerID, period, sku, [marketplace], [status], [start date], [end date])

Examples:

=GORILLA_INVENTORYHIST("last 14 days", D2, "US", "instock")

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

=GORILLA_INVENTORYHIST("last 3 months", "B00YD545CC", "UK", "transfer")

Displays in a list, the transfer inventory for each day of the last 3 months for ASIN B00YD545CC from the UK marketplace.

=GORILLA_INVENTORYHIST("custom", A1:A10, "ALL", "inbound", "2019-12-01", "2019-12-12")

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 A1:A10 and returns all values at once. 

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

=GORILLA_INVENTORYHIST("SELLER ID", "last 14 days", D2, "US", "instock")

=GORILLA_INVENTORYHIST("SELLER ID", "last 3 months", "B00YD545CC", "UK", "transfer")

=GORILLA_INVENTORYHIST("SELLER ID", "custom", A1:A10, "ALL", "inbound", "2019-12-01", "2019-12-12)

GORILLA_INVENTORY 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_LOWESTPRICE( ) Function

Description:

Get the lowest price of the SKU or ASIN that's competing for the buy box. Only pulls a number if there is more than one seller on the listing.

Syntax:

GORILLA_LOWESTPRICE(sku, [marketplace], [condition], [returnStyle], [priceType])

for Gorilla AGENCY, the syntax is

GORILLA_LOWESTPRICE(sellerID, sku, [marketplace], [condition], [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.

condition 

OPTIONAL - Acts as a filter. Valid values are:

• New
• Used
• Collectible
• Refurbished

Club

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_LOWESTPRICE(D2)

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

=GORILLA_LOWESTPRICE("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_LOWESTPRICE("B03H39FJ32", "US", "New", "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_LOWESTPRICE(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_LOWESTPRICE("SELLER23HH", D2)

=GORILLA_LOWESTPRICE("SELLER23HH", "B03H39FJ32", "US", "New")

=GORILLA_LOWESTPRICE("SELLER23HH", "B03H39FJ32", "US", "New", "ListingPrice")

=GORILLA_LOWESTPRICE("SELLER23HH", A2:C10)

GORILLA_LOWESTPRICE Attributes 

GORILLA_LOWESTOFFER( ) Function

Description:

Get the lowest offered listing price from any seller.

Similar to lowestprice(), but it will load the lowest listing price even if there is only one 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_PROFITLOSS( ) Function

Description:

Gets the financial data to build a profit and loss statement for your Amazon FBA account or by SKU/ASIN.

Automatically generated a prebuilt table, or pull detailed profit and expense line items to build your own statements.

Syntax:

GORILLA_PROFITLOSS(period, [marketplace], [sku], [category], [details])

for Gorilla AGENCY, the syntax is

GORILLA_PROFITLOSS(sellerID, period, [marketplace], [sku], [category], [details])

period

REQUIRED - Predefined periods and any custom date frames to get the rank history. See full list of predefined periods 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.

sku

SKU or ASIN of the product. Only accepts ONE SKU or ASIN input. Does not work with multiple SKUs or ranges like other formulas.

category

OPTIONAL - specify the line item to get the total value for that single category

• Sales
• Discounts/Promotions
• Amazon Reimbursements
• Shipping Income
• Income-Other
• Amazon Lending
• COGS
• Amazon Fees
• AdvertisingTax

details

OPTIONAL - defaults to "no":

• Yes = Will list all the transactions associated with the category
• No = Will only show the total value of the category

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_PROFITLOSS("2020")

Will automatically generate a condensed and summarized profit and loss table in the form of:

• Sales - $xxx
• Discounts/Promotions - $xxx
• Amazon Reimbursements - $xxx
• Shipping Income - $xxx
• Income-Other - $xxx
• Amazon Lending - $xxx
• COGS - $xxx
• Amazon Fees - $xxx
• AdvertisingTax - $xxx

=GORILLA_PROFITLOSS("THIS YEAR", "US")

Will generate a table like the example above for the US marketplace profit and loss only.

=GORILLA_PROFITLOSS(A2,B2,"MYSKU")

Using cells A1 and B2 to point to the period and the marketplace. Creates the P&L based on the SKU "mysku". When a SKU is entered, not all transactions are available like storage costs as it is applied to your account and not the SKU.

=GORILLA_PROFITLOSS("THIS YEAR", "US", , "Income-Other")

Returns the total value only for the line item "Income-Other". You can specify a category to get single values rather than generate the full table each time.

=GORILLA_PROFITLOSS("LAST 30 DAYS", "FR", ,"Amazon fees", "YES")

List all the transactions that make up the category you specify. In this example, it will list all the expenses that are rolled up inside "Amazon Fees".

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

2020Q1, 2019Q4 etc

To get monthly data, use the format YYYY-MM as the preset period. 2020-04, 2021-07 etc

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

=GORILLA_PROFITLOSS(sellerID, "2020")

=GORILLA_PROFITLOSS(sellerID, "THIS YEAR", "US")

=GORILLA_PROFITLOSS(sellerID, A2,B2,"MYSKU")

=GORILLA_PROFITLOSS(sellerID, "THIS YEAR", "US", , "Income-Other")

=GORILLA_PROFITLOSS(sellerID, "LAST 30 DAYS", "FR", ,"Amazon fees", "YES")

GORILLA_PROFITLOSS Attributes

period Attributes:

category 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.

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.

=GORILLA_RANKHIST("2019Q1", "US", "B00YD545CC", "All")

=GORILLA_RANKHIST("2019-05", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

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("SELLER37432", "2019Q1", "US", "B00YD545CC", "All")

=GORILLA_RANKHIST("SELLER37432", "2019-05", "US", "B00YD545CC", "All")

GORILLA_RANKHIST Attributes

queryType Attributes:

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

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", "r_full")

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_REFUNDSCOUNT( ) Function

Description:

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

Syntax:

GORILLA_REFUNDSCOUNT(period, [marketplace], [sku], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_REFUNDSCOUNT(sellerID, period, [marketplace], [sku], [start_date], [end_date])

period

Predefined period to get refunded units. See full list of predefined periods 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.

sku

OPTIONAL – Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. If no SKUs are specified, it will load the total number across the account.

start_date

OPTIONAL – Starting date to get sales from when period is custom. To use custom dates, specify the period as "CUSTOM".

end_date

OPTIONAL – Ending date to get sales from when period is custom. To use custom dates, specify the period as "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_REFUNDSCOUNT("THIS YEAR")

Returns the total count of refunded units for this year. No SKUs are specified which will show the count across the entire account. E.g. if the result is 200, then it means that 200 units were refunded for "this year".

=GORILLA_REFUNDSCOUNT("LAST YEAR","US", A2:A34)

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:A34 and returns the count of the refunded units for each SKU/ASIN. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_REFUNDSCOUNT("CUSTOM", "FR", A2:A34, "2020-01-01", "2020-01-15")

Returns the total count of refunded units based on a custom date. The start date is 2020-01-01 and the end date is 2020-01-15. The SKU/ASIN is listed in A2 to A34. The marketplace is defined as France.

=GORILLA_REFUNDSCOUNT("2020", "US", B7:B27)

=GORILLA_REFUNDSCOUNT("2020Q1", "US", A1:A100)

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

=GORILLA_REFUNDSCOUNT("SELLERID38", "THIS YEAR")

=GORILLA_REFUNDSCOUNT("SELLERID38", "LAST YEAR","US", A2:A34)

=GORILLA_REFUNDSCOUNT("SELLERID38", "CUSTOM", "FR", A2:A34, "2020-01-01", "2020-01-15")

=GORILLA_REFUNDSCOUNT("SELLERID38", "2020", "US", B7:B27)

=GORILLA_REFUNDSCOUNT("SELLERID38", "2020Q3", "US", A1:A100)

GORILLA_REFUNDSCOUNT Attributes

Period Attributes:

GORILLA_REFUNDSTOTAL( ) Function

Description:

Gets total value in dollars of units refunded for a product between any time period. Only the period is required. Other attributes are optional.

Syntax:

GORILLA_REFUNDSTOTAL(period, [marketplace], [sku], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_REFUNDSTOTAL(sellerID, period, [marketplace], [sku], [start_date], [end_date])

period

Predefined period to get the refunds value. See full list of predefined periods 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.

sku

OPTIONAL – Any Seller SKU/ASIN to limit results. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string. If no SKUs are specified, it will load the total number across the account.

start_date

OPTIONAL – Starting date to get sales from when period is custom. To use custom dates, specify the period as "CUSTOM".

end_date

OPTIONAL – Ending date to get sales from when period is custom. To use custom dates, specify the period as "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_REFUNDSTOTAL("THIS YEAR")

Returns the total count of refunded units for this year. No SKUs are specified which will show the count across the entire account. E.g. if the result is 200, then it means that 200 units were refunded for "this year".

=GORILLA_REFUNDSTOTAL("LAST YEAR","US", A2:A34)

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:A34 and returns the count of the refunded units for each SKU/ASIN. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_REFUNDSTOTAL("CUSTOM", "FR", A2:A34, "2020-01-01", "2020-01-15")

Returns the total count of refunded units based on a custom date. The start date is 2020-01-01 and the end date is 2020-01-15. The SKU/ASIN is listed in A2 to A34. The marketplace is defined as France.

=GORILLA_REFUNDSTOTAL("2020", "US", B7:B27)

=GORILLA_REFUNDSTOTAL("2020Q1", "US", A1:A100)

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

=GORILLA_REFUNDSTOTAL("SELLERID38", "THIS YEAR")

=GORILLA_REFUNDSTOTAL("SELLERID38", "LAST YEAR","US", A2:A34)

=GORILLA_REFUNDSTOTAL("SELLERID38", "CUSTOM", "FR", A2:A34, "2020-01-01", "2020-01-15")

=GORILLA_REFUNDSTOTAL("SELLERID38", "2020", "US", B7:B27)

=GORILLA_REFUNDSTOTAL("SELLERID38", "2020Q3", "US", A1:A100)

GORILLA_REFUNDSTOTAL Attributes

Period Attributes:

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.

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 units sold for a product between any time period. Only period is required. Other attributes are optional.

Syntax:

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

for Gorilla AGENCY, the syntax is

GORILLA_SALESCOUNT(sellerID, period, [marketplace], [sku], [status], [mcf], [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

mcf

• OPTIONAL - Whether to display, include or exclude MCF orders.
• Exclude (default option is not specified)
• Include
• Only (only displays data for MCF orders. Does not show data for FBA.)

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", "Exclude", "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. Excludes MCF orders.

=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("2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("2019-05", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

=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.

=GORILLA_SALESCOUNT("2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("2019-05", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

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

=GORILLA_SALESCOUNT("SELLER37432", "Custom", "US", "B00YD545CC", "Include", "Shipped", "2018-01-01", "2018-01-21")

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

=GORILLA_SALESCOUNT("SELLER37432", "2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("SELLER37432", "2019-05", "US", "B00YD545CC", "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("SELLER37432", "2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("SELLER37432", "2019-05", "US", "B00YD545CC", "All")

GORILLA_SALESCOUNT Attributes

Period Attributes:

Status Attributes:

GORILLA_SALESCOUNTHIST( ) Function

Description:

The fastest way to get a daily count of historical sales between any two dates.

Syntax:

GORILLA_SALESCOUNTHIST([sku], [marketplace], [status], [mcf], [days], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_SALESCOUNTHIST(sellerID, [sku], [marketplace], [status], [mcf], [days], [start_date], [end_date])

sku

OPTIONAL - SKU or ASIN. Select or enter a range of values.

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 - Order Status. Valid values are:

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

mcf

• OPTIONAL - Whether to display, include or exclude MCF orders.
• Exclude (default option is not specified)
• Include
• Only (only displays data for MCF orders. Does not show data for FBA.)

days

OPTIONAL - By default, the last 30 days is pulled. Enter the number of days to display in the results.

start_date

OPTIONAL - Only works if "days" is left blank. Starting date to get sales between any two periods. Date format should be in YYYY-MM-DD.

end_date

OPTIONAL - Only works if "days" is left blank. End date to get sales between any two periods. Date format should be in YYYY-MM-DD.

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_SALESCOUNTHIST()

When no attributes are entered into the formula, it will create a table of the daily units sold over the last 30 days of the entire account.

=GORILLA_SALESCOUNTHIST("B00YD545CC")

Pulls in the daily units sold over the last 30 days of ASIN B00YD545CC into a table.

=GORILLA_SALESCOUNTHIST(A1:A20)

Pulls in the daily units sold over the last 30 days for the SKUs or ASINs listed in cell A1 to A20.

=GORILLA_SALESCOUNTHIST(A1:A10, "US", "ALL", "EXCLUDE", 60)

Returns a table of daily historical sales for all SKUs in cell A1 to A10, in the US marketplace only, the order status includes all, excludes MCF (Merchant Fulfilled) sales for the last 60 days.

=GORILLA_SALESCOUNTHIST(A1:A10, "DE", "Canceled", "EXCLUDE", , "2020-01-01", "2020-03-12")

Returns a table of daily historical sales for all SKUs in cell A1 to A10, in the German marketplace only, the order status is canceled, excludes MCF (Merchant Fulfilled) sales, between the two dates in the formula. The "days" field is blank so that the start and end date will activate. If days value is entered, then the start and end date won't work.

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

=GORILLA_SALESCOUNTHIST("SELLER37432")

=GORILLA_SALESCOUNTHIST("SELLER37432", "B00YD545CC")

=GORILLA_SALESCOUNTHIST("SELLER37432", A1:A20)

=GORILLA_SALESCOUNTHIST("SELLER37432", A1:A10, "US", "ALL", "EXCLUDE", 60)

=GORILLA_SALESCOUNTHIST("SELLER37432", A1:A10, "DE", "Canceled", "EXCLUDE", , "2020-01-01", "2020-03-12")

GORILLA_SALESCOUNTHIST Attributes

Status Attributes:

GORILLA_SALESTAX( ) Function

Description:

Get total sales and taxes collected by Amazon Marketplace Facilitator owed by the seller. Only the period attribute is required. Other attributes are optional.

Syntax:

GORILLA_SALESTAX(period, [marketplace], [grouping], [start_date], [end_date], [header])

for Gorilla AGENCY, the syntax is

GORILLA_SALESTAX(sellerID, period, [marketplace], [grouping], [start_date], [end_date], [header])

period

Predefined period to get sales or custom to specify dates. 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.

grouping

OPTIONAL – The grouping level for results. Select to group the totals by city or by state. Default is total by City.

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.

header

OPTIONAL – Include a header line in the results.

Possible values: TRUE/FALSE. Default: TRUE 

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_SALESTAX("LAST MONTH")

The easiest way to use this function. Define the period to get the total sales and taxes collected by city and state.

=GORILLA_SALESTAX("THIS MONTH", "UK", "STATE")

Loads the sales and the taxes collected for the period “this month” in the UK marketplace and the results are totaled by state.

=GORILLA_SALESTAX("CUSTOM", "UK", "CITY", "2020-01-01", "2020-01-15", "FALSE")

Get sales tax data over a custom period. The results are based on the UK marketplace with results totaled by city between Jan 1, 2020 and Jan 15, 2020.

The "FALSE" attribute means the header of the table is not generated.

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

=GORILLA_SALESTAX("SELLER382", "LAST MONTH")

=GORILLA_SALESTAX("SELLER382", "THIS MONTH", "UK", "STATE")

=GORILLA_SALESTAX("SELLER382", "CUSTOM", "UK", "CITY", "2020-01-01", "2020-01-15", "FALSE")

GORILLA_SALESTAX Attributes

Period 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], [mcf], [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.

mcf

OPTIONAL - Whether to display, include or exclude MCF orders.

• Exclude (default option is not specified)
• Include
• Only (only displays data for MCF orders. Does not show data for FBA.)

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", "Exclude", "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. Excludes MCF orders from the data.

=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.

=GORILLA_SALESTOTAL("2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALETOTAL("2019-05", "US", "B00YD545CC", "All")

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset .

To get monthly data, use the format YYYY-MM as the preset period.

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

=GORILLA_SALESTOTAL("SELLER382", "Custom", "US", "B00YD545CC", "Exclude", "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("SELLER37432", "2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESTOTAL("SELLER37432", "2019-05", "US", "B00YD545CC", "All")

GORILLA_SALESTOTAL Attributes

Period Attributes:

Status Attributes:

GORILLA_SALESTOTALHIST( ) Function

Description:

The fastest way to get a daily sales total of historical sales between any two dates.

Syntax:

GORILLA_SALESTOTALHIST([sku], [marketplace], [status], [mcf], [days], [start_date], [end_date])

for Gorilla AGENCY, the syntax is

GORILLA_SALESTOTALHIST(sellerID, [sku], [marketplace], [status], [mcf], [days], [start_date], [end_date])

sku

OPTIONAL – SKU or ASIN. Select or enter a range of values.

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)
• AllPendingAvailability (JP only)
• Pending
• Unshipped
• PartiallyShipped
• Shipped
• InvoiceUnconfirmed
• Canceled
• Unfulfillable

mcf

OPTIONAL - Whether to display, include or exclude MCF orders.

• Exclude (default option is not specified)
• Include
• Only (only displays data for MCF orders. Does not show data for FBA.)

days

OPTIONAL – By default, the last 30 days is pulled. Enter the number of days to display in the results.

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_SALESTOTALHIST()

When no attributes are entered into the formula, it will create a table of the daily sales figures over the last 30 days of the entire account.

=GORILLA_SALESTOTALHIST("B00YD545CC")

Pulls in the daily sales figures over the last 30 days of ASIN B00YD545CC into a table.

=GORILLA_SALESTOTALHIST(A1:A20)

Pulls in the daily sales figures over the last 30 days for the SKUs or ASINs listed in cell A1 to A20.

=GORILLA_SALESTOTALHIST(A1:A10, “US”, “ALL”, “EXCLUDE”, 60)

Returns a table of daily historical sales figures for all SKUs in cell A1 to A10, in the US marketplace only, the order status includes all, excludes MCF (Merchant Fulfilled) sales for the last 60 days.

=GORILLA_SALESTOTALHIST(A1:A10, “DE”, “Canceled”, “EXCLUDE”, , “2020-01-01”, “2020-03-12”)

Returns a table of daily historical sales for all SKUs in cell A1 to A10, in the German marketplace only, the order status is canceled, excludes MCF (Merchant Fulfilled) sales, between the two dates in the formula. The “days” field is blank so that the start and end date will activate. If days value is entered, then the start and end date won’t work.

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

=GORILLA_SALESTOTALHIST(“SELLER37432”)

=GORILLA_SALESTOTALHIST(“SELLER37432”, “B00YD545CC”)

=GORILLA_SALESTOTALHIST(“SELLER37432”, A1:A20)

=GORILLA_SALESTOTALHIST(“SELLER37432”, A1:A10, “US”, “ALL”, “EXCLUDE”, 60)

=GORILLA_SALESTOTALHIST(“SELLER37432”, A1:A10, “DE”, “Canceled”, “EXCLUDE”, , “2020-01-01”, “2020-03-12”)

GORILLA_SALESTOTALHIST 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", "asin2sku")

=GORILLA_SKUASIN("SELLER832J", D33:E39, "asin2sku")

=GORILLA_SKUASIN("SELLER832J", D33:E39, "sku2asin")

GORILLA_SKUASIN Attributes 

• sku2asin
• asin2sku 

GORILLA_SKUFNSKU( ) 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], [inactive])

for Gorilla AGENCY, the syntax is

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

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.

inactive

OPTIONAL - enter "include" or "exclude" to show or hide inactive, deleted, closed, suppressed products.

Examples:

=GORILLA_SKULIST()

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

=GORILLA_SKULIST( , , "INCLUDE")

This will list the entire list of SKUs in your account including all the deleted, inactive, closed, suppressed products.

If no inputs are entered like GORILLA_SKULIST(), the default value is "EXCLUDE".

=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.

=GORILLA_SKULIST("US" , , "INCLUDE")

This will list all SKUs for the US marketplace only. Will also show closed, inactive, deleted, suppressed SKUs.

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

=GORILLA_SKULIST("SELLER832J")

=GORILLA_SKULIST("SELLER832J", "UK", "IPHONE")

=GORILLA_SKULIST("SELLER832J", , , "INCLUDE")

=GORILLA_SKULIST("SELLER832J", "US" , , "INCLUDE")