Gorilla Sheets Functions List

You can click the examples below to load the formula to your sheet and then edit the attributes.


MARKETPLACES Supported

Description:

Set your main marketplace with the attributes below. If you sell in multiple marketplaces and want to get the total data, use "ALL" for the marketplace attribute in the functions below.

ALL

MX (Mexico)

FR (France)

BR (Brazil)

US (USA)

ES (Spain)

DE (Germany)

IN (India) - NOT SUPPORTED

CA (Canada)

UK (United Kingdom)

IT (Italy)

AU (Australia)

JP (Japan)


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])

Examples:

=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])

Examples:

=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 formulas will start with the seller ID:  

=GORILLA_CATEGORY("SELLER ID", "B00YD545CC", "US", "all", "full")

=GORILLA_CATEGORY("SELLER ID", "B00YD545CC", "US", "all", "inner")

=GORILLA_CATEGORY("SELLER ID", "B00YD545CC", "US", "top", "full")

GORILLA_LOWESTOFFER Attributes

sku Attributes:

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

 

Marketplace Attributes:

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 Attributes:

OPTIONAL - What to retrieve (defaults to "top"):

 

returnStyle Attributes:

OPTIONAL - Return style (defaults to "full"):


GORILLA_CHARGETOTAL Function (NEW)

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("2019-04",,,"all",)

Simplest formula allowed to return all sales and charges for the month of April. The period is the same Only the [chargeType] variable has been entered. This will return an unsorted list of all the categories. For a more organized list, see the following examples.

=GORILLA_CHARGETOTAL("This Year","default",,"all", "shipment")

Returns all shipment related sales and charges 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_CHARGETOTAL("2019Q2","US","B038434K3","ALL", "refund")

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

=GORILLA_CHARGETOTAL("Last 30 Days","ALL",,"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",,"all", "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", "2019-04",,,"all",)

=GORILLA_CHARGETOTAL("SELLER384k3", "This Year","default",,"all", "shipment")

=GORILLA_CHARGETOTAL("SELLER384k3", "2019Q2","US","B038434K3","ALL", "refund")

=GORILLA_CHARGETOTAL("SELLER384k3", "Last 30 Days","ALL",,"ALL", "ADJUSTMENT")

=GORILLA_CHARGETOTAL("SELLER384k3", "2109Q1","DE",,"all", "OTHER")

GORILLA_CHARGETOTAL Attributes

Period Attribute:

Today

This month

Last 12 Months

Yesterday

This quarter

Last 7 Days Week Ago

Same day last week

This year

Last 7 Days Year Ago

Same day last month

This Year-to-Last-Month

Last 30 Days Month Ago

Same day last year

Last Week

Last 30 Days Year Ago

Last 7 Days

Last Month

Last Week Year Ago

Last 14 Days

Last Quarter

Last Month Year Ago

Last 30 Days

Last Year

YYYY-MM (change format to text)

This week

Last 60 Days

YYYYQ1… YYYYQ4

ChargeType Attribute:

To get the names of all chargetype in the spreadsheet, enter =gorilla_chargetype()

CODItemCharge

MarketplaceFacilitatorTax-Principal

CODItemTaxCharge

MarketplaceFacilitatorTax-Shipping

CODOrderCharge

PaymentMethodFee

CODOrderTaxCharge

PointsFee

CODShippingCharge

Principal

CODShippingTaxCharge

RestockingFee

CollectOnDeliveryRefund

ReturnShipping

CollectOnDeliveryRevenue

SAFE-TReimbursement

Discount

ShippingCharge

ExportCharge

ShippingTax

FreeReplacementReturnShipping

Tax

GenericDeduction

TaxDiscount

Giftwrap

TCS-CGST

GiftwrapTax

TCS-IGST

Goodwill

TCS-SGST

MarketplaceFacilitatorTax-Giftwrap

TCS-UTGST

MarketplaceFacilitatorTax-Other

Event Attribute:

  • Shipment
  • Refund
  • GuaranteeClaim
  • Chargeback
  • CouponPayment
  • Adjustment
  • Other

GORILLA_CHARGETYPE Function (NEW)

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])

Examples:

=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", "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 formulas will start with the seller ID:  

=GORILLA_FEETYPE("SELLER349d3")

=GORILLA_FEETYPE("SELLER349d3", "US", "Marketpl", "Column", "No")

Direction Attributes:

Full_list Attributes:


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])

Examples:

=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("SELLER ID", D2)

=GORILLA_FEESESTIMATE("SELLER ID", "A2:C10")

=GORILLA_FEESESTIMATE("SELLER ID", "738-JDUY-32F", "default", "fullwithheader")

GORILLA_FEESESTIMATE Attributes

returnStyle Attributes:


GORILLA_FEETOTAL Function (NEW)

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("2019-04",,,"all",)

Simplest formula allowed to return all sales and charges for the month of April. The period is the same Only the [chargeType] variable has been entered. This will return an unsorted list of all the categories. For a more organized list, see the following examples.

=GORILLA_FEETOTAL("This Year","default",,"all", "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","ALL", "refund")

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

=GORILLA_FEETOTAL("Last 30 Days","US",,"ALL", "ADJUSTMENT")

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("2109Q1","DE",,"all", "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", "ADJUSTMENT")

=GORILLA_FEETOTAL("SELLER384k3", "2109Q1","DE",,"all", "OTHER")

GORILLA_FEETOTAL Attributes

Period Attribute:

Today

This month

Last 12 Months

Yesterday

This quarter

Last 7 Days Week Ago

Same day last week

This year

Last 7 Days Year Ago

Same day last month

This Year-to-Last-Month

Last 30 Days Month Ago

Same day last year

Last Week

Last 30 Days Year Ago

Last 7 Days

Last Month

Last Week Year Ago

Last 14 Days

Last Quarter

Last Month Year Ago

Last 30 Days

Last Year

YYYY-MM (change format to text)

This week

Last 60 Days

YYYYQ1… YYYYQ4

FeeType Attribute:

To get the names of all chargetype in the spreadsheet, enter =gorilla_feetype()

Amazon Imaging fee

FBA Returns Processing Fee-Pick & Pack

Cash on Delivery Chargeback

FBA Returns Processing Fee-Weight Handling

Closing Fees

FBA Taping Fee

Commission

FBA transportation fee

Coupon clip fee

FBA Unplanned Prep Service Fees

Coupon redemption fee

FBA Weight Based Fee

Cross-Border Fulfillment Fee

Fresh Inbound Transportation Fee

Easy Ship Fee

Get Paid Faster Fee

EPSO Chargeback fee

Gift Wrap Charge-Back Fee

EPSO Cross-Border fee

Gift Wrap Commission

EPSO Payment Authorization fee

Global Inbound Transportation Fee

EPSO Payment Settle fee

High-volume listing fee

FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation Charge

Monthly subscription fee

FBA Fee for cash on delivery

Per-item fees for Individual Sellers

FBA Fulfillment Fees

Purchase of Rented Books

FBA Fulfillment Fees

Referral Fees

FBA Inbound Shipment Carton Level Info Fee

Refund Administration Fee

FBA Inbound Transportation Program Fee

Rental Book Service Fee

FBA Inventory Disposals

Rental Extensions

FBA Inventory Placement Service Fees

Review Enrollment Fee

FBA Inventory Removals

Shipping Charge-Back Fee

FBA Inventory Storage Fee

Shipping HB Fee

FBA Label Service Fee

SSO Fulfillment Fee

FBA Long-Term Storage Fees

Tax Calculation Services Fees

FBA Multi-Channel Fulfillment Weight Handling

Unit Fulfillment Fee

FBA Per Order Fulfillment Fee

FBA Prep Service Fees (Bubble Wrap)

FBA Prep Service Fees (Labeling)

FBA Prep Service Fees-Adult-Bagging (black or opaque)

FBA Returns Processing Fee-Order Handling

Event Attribute:

  • Shipment
  • Refund
  • GuaranteeClaim
  • Chargeback
  • CouponPayment
  • Adjustment
  • ServiceFee
  • Other


GORILLA_FEETYPE Function (NEW)

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])

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:

Full_list Attributes:


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])

Examples:

=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("SELLER ID", D2, "ALL", "instock")

=GORILLA_INVENTORY("SELLER ID", "B00YD545CC", "EU", "transfer")

=GORILLA_INVENTORY("SELLER ID", A2:A10, "ALL", "inbound")

GORILLA_INVENTORY Attributes


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])

Examples:

=GORILLA_MYPRICE(D2)

Uses the ASIN or SKU entered in cell D2 and shows 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_INVENTORY(A2:C10)

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

=GORILLA_MYPRICE("SELLER ID", D2)

=GORILLA_MYPRICE("SELLER ID", "B03H39FJ32", "US", "New")

=GORILLA_MYPRICE("SELLER ID", "B03H39FJ32", "US", "New", "mint", "ListingPrice")

=GORILLA_INVENTORY("SELLER ID", 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_MYPRICE Attributes

Condition Attributes:

SubCondition Attributes:

priceType 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])

Examples:

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

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

=GORILLA_LOWESTOFFER("SELLER ID",D2)

=GORILLA_LOWESTOFFER("SELLER ID", A2:C10)

=GORILLA_LOWESTOFFER("SELLER ID", "738-JDUY-32F", "default", "fullwithheader")

GORILLA_LOWESTOFFER Attributes

returnStyle Attributes:

priceType Attributes:


GORILLA_PRODUCT Function

Description:

Get product information for a SKU or ASIN.

Syntax:

GORILLA_PRODUCT(sku, attributes, [marketplace])

for Gorilla Agency, the syntax is

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

Examples:

=GORILLA_PRODUCT("IPHONE7382", "SmallImage_URL", "US")

This formula will pull the main small image of SKU IPHONE7382 in the US marketplace.

=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("SELLER ID", "IPHONE7382", "SmallImage_URL", "US")

=GORILLA_PRODUCT("SELLER ID", "B03H39FJ32", "Scent")

=GORILLA_PRODUCT("SELLER ID", A2:A10,"Title")

GORILLA_PRODUCT Attributes

Binding

Brand

IsAutographed

ItemDimensions

ItemDimensions_Weight

ItemDimensions_Width

ListPrice_Amount

ListPrice_CurrencyCode

Model

PackageDimensions

PackageDimensions_Weight

PackageDimensions_Width

ProductGroup

ProductTypeName

Size

SmallImage

SmallImage_Width

Studio

Color

IsAdultProduct

ItemDimensions_Height

ItemDimensions_Length

Label

ListPrice

Manufacturer

MaterialType

PackageDimensions_Height

PackageDimensions_Length

PackageQuantity

PartNumber

Publisher

Scent

SmallImage_Height

SmallImage_URL

Title


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])

 

 Examples:

=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("SELLER ID", "last 30 days", A2:A100)

=GORILLA_RANKHIST("SELLER ID", "custom", A2:A5, "US", "top", "2018-06-01", "2018-06-30")

=GORILLA_RANKHIST("SELLER ID", "this month", "B00YD545CC", "JP", "child") 

GORILLA_RANKHIST Attributes

Period Attribute:

Today

This month

Last 12 Months

Yesterday

This quarter

Last 7 Days Week Ago

Same day last week

This year

Last 7 Days Year Ago

Same day last month

This Year-to-Last-Month

Last 30 Days Month Ago

Same day last year

Last Week

Last 30 Days Year Ago

Last 7 Days

Last Month

Last Week Year Ago

Last 14 Days

Last Quarter

Last Month Year Ago

Last 30 Days

Last Year

YYYY-MM (change format to text)

This week

Last 60 Days

YYYYQ1… YYYYQ4

queryType Attribute:

top - the top level category you are used to seeing as a seller

all - products are listed under multiple categories. Lists them all.

child - the lowest level category of the product

returnStyle Attribute:

rank - rank number only

r_cat - shows rank number and top level category

r_full - shows the rank and category path


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])

Examples:

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

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("SELLER ID", "B00YD545CC", "US", "top", "r_cat")

=GORILLA_RANKING("SELLER ID", "A2:A10", , "top", "r_full")

 

GORILLA_RANKING Attributes

queryType Attribute:

top - the top level category you are used to seeing as a seller

all - products are listed under multiple categories. Lists them all.

child - the lowest level category of the product

returnStyle Attribute:

rank - rank number only

r_cat - shows rank number and top level category

r_full - shows the rank and category path


GORILLA_RATING Function

Description:

Get the product review rating. Only works for single marketplaces at a time. Not "ALL".

Syntax:

GORILLA_RATING(sku, [marketplace])

for Gorilla Agency, the syntax is

GORILLA_RATING(sellerID, sku, [marketplace])

Examples:

=GORILLA_RATING("B00YD545CC", "CA")

Returns the review rating for ASIN B00YD545CC for Canadian marketplace.

=GORILLA_INVENTORY(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_RATING("SELLER ID", "B00YD545CC", "CA")

=GORILLA_INVENTORY("SELLER ID", 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])

Examples:

=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("SELLER ID", "B00YD545CC", "CA")

=GORILLA_REVIEWCOUNT("SELLER ID", A2:A10, ,)   


GORILLA_SALESCOUNT Function

Description:

Gets total number of sales for a product for a specified 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])

Examples:

=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("SELLER ID", "Custom", "US", "B00YD545CC", "Shipped", "2018-01-01", "2018-01-21")

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

=GORILLA_SALESCOUNT("SELLER ID", "This Month", "ALL", "IPHN3724", "Canceled")

=GORILLA_SALESCOUNT("SELLER ID", "Same Day Last Month", "ALL", "IPHN3724", "ALL")

=GORILLA_SALESCOUNT("SELLER ID", "This Year")

GORILLA_SALESCOUNT Attributes

Period Attribute:

Today

This month

Last 12 Months

Yesterday

This quarter

Last 7 Days Week Ago

Same day last week

This year

Last 7 Days Year Ago

Same day last month

This Year-to-Last-Month

Last 30 Days Month Ago

Same day last year

Last Week

Last 30 Days Year Ago

Last 7 Days

Last Month

Last Week Year Ago

Last 14 Days

Last Quarter

Last Month Year Ago

Last 30 Days

Last Year

YYYY-MM (change format to text)

This week

Last 60 Days

YYYYQ1… YYYYQ4

Status Attribute:

All

PendingAvailability (JP marketplace only)

Pending

Unshipped

PartiallyShipped

Shipped

InvoiceUnconfirmed

Canceled

Unfulfillable


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])

Examples:

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

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("SELLER ID", "Custom", "US", "B00YD545CC", "Shipped", "2018-01-01", "2018-01-21")

=GORILLA_SALESTOTAL("SELLER ID", "This Week","ALL",A2:A10,"ALL")

=GORILLA_SALESTOTAL("SELLER ID", "This Month", "ALL", "IPHN3724", "Canceled")

=GORILLA_SALESTOTAL("SELLER ID", "Same Day Last Month", "ALL", "IPHN3724", "ALL")

=GORILLA_SALESTOTAL("SELLER ID", "This Year")

GORILLA_SALESTOTAL Attributes

Period Attribute:

Today

This month

Last 12 Months

Yesterday

This quarter

Last 7 Days Week Ago

Same day last week

This year

Last 7 Days Year Ago

Same day last month

This Year-to-Last-Month

Last 30 Days Month Ago

Same day last year

Last Week

Last 30 Days Year Ago

Last 7 Days

Last Month

Last Week Year Ago

Last 14 Days

Last Quarter

Last Month Year Ago

Last 30 Days

Last Year

YYYY-MM (change format to text)

This week

Last 60 Days

YYYYQ1… YYYYQ4

Status Attribute:

All

PendingAvailability (JP marketplace only)

Pending

Unshipped

PartiallyShipped

Shipped

InvoiceUnconfirmed

Canceled

Unfulfillable



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])

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

=GORILLA_SKULIST("SELLER ID", "UK","IPHONE")


GORILLA_SKUASIN Function

Description:

Convert ASIN to SKU and SKU to ASIN.

Syntax:

GORILLA_SKUASIN(SKU/ASIN, [direction])

for Gorilla Agency, the syntax is

GORILLA_SKUASIN("SELLER ID", SKU/ASIN, [direction])

Examples:

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

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

=GORILLA_SKUASIN(D33:E39, "asin2sku")

Return an array of SKU’s by entering a column, row or range of SKU’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("SELLER ID", "IPHN3724")

=GORILLA_SKUASIN("SELLER ID", "B00YD545CC", "asin2sku")

=GORILLA_SKUASIN("SELLER ID", D33:E39, "asin2sku")

=GORILLA_SKUASIN("SELLER ID", D33:E39,"sku2asin")


GORILLA_SKUFNSKU Function

Description:

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

Syntax:

GORILLA_SKUFNSKU(SKU/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.

GORILLA_SKUASIN Attributes

sku2fnsku

Fnsku2sku

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_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])

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("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("SELLER ID")
=GORILLA_SKULIST("SELLER ID", "UK","IPHONE")