fbpx

Functions to Pull Amazon Data into Google Sheets 

Easy to use formulas to pull data from Amazon to Google Sheets

Haven’t joined Gorilla ROI?

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
  • US
  • CA
  • JP
  • MX
  • ES
  • UK 
  • INDIA – NOT SUPPORTED 
  • FR
  • DE
  • IT
  • BR 
  • CN
  • AU

Functions to pull Amazon FBA Data

For GORILLA AGENCY users: at the beginning of every formula, the seller ID must be added.

e.g. if the standard formula is =gorilla_asinlist(), agency users must ALWAYS enter =gorilla_asinlist(“sellerID”)

GORILLA_ASINLIST() – Get list of ASIN’s from your marketplace

GORILLA_ASINLIST( ) Function

Description:

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

 

Syntax:

GORILLA_ASINLIST([marketplace], [filter_sku])

for Gorilla AGENCY, the syntax is

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

marketplace

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

 

filter_asin

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

 

Examples:

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

 

=GORILLA_ASINLIST()

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

=GORILLA_ASINLIST(“ALL”,”B43″)

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

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

=GORILLA_ASINLIST(“SELLER ID)

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

GORILLA_CATEGORY() – Get categories product is listed under

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() – Get financials breakdown of the sales & charges 

GORILLA_CHARGETOTAL( ) Function

Description:

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

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


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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

Examples:

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

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


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

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


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

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


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

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


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

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


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

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


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

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

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

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

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

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

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

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

 

GORILLA_CHARGETOTAL Attributes

Period Attribute:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This week
  • Max
  • This month
  • This quarter
  • This year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM (set format as text)
  • YYYYQ1… YYYYQ4

ChargeType Attribute:

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

  • CODItemCharge
  • CODItemTaxCharge
  • CODOrderCharge
  • CODOrderTaxCharge
  • CODShippingCharge
  • CODShippingTaxCharge
  • CollectOnDeliveryRefund
  • CollectOnDeliveryRevenue
  • Discount
  • ExportCharge
  • FreeReplacementReturnShipping
  • GenericDeduction
  • Giftwrap
  • GiftwrapTax
  • Goodwill
  • MarketplaceFacilitatorTax-Giftwrap
  • MarketplaceFacilitatorTax-Other
  • MarketplaceFacilitatorTax-Principal
  • MarketplaceFacilitatorTax-Shipping
  • PaymentMethodFee
  • PointsFee
  • Principal
  • RestockingFee
  • ReturnShipping
  • SAFE-TReimbursement
  • ShippingCharge
  • ShippingTax
  • Tax
  • TaxDiscount
  • TCS-CGST
  • TCS-IGST
  • TCS-SGST
  • TCS-UTGST

Event Attribute

  • Shipment
  • Refund
  • GuaranteeClaim
  • Chargeback
  • CouponPayment
  • Adjustment
  • Other
GORILLA_CHARGETYPE() – Get a list of line item names for all charges

GORILLA_CHARGETYPE( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

sku

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

 

marketplace

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

 

queryType

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

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

 

returnStyle

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

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

 

Examples:

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

 

=GORILLA_CHARGETTYPE()

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

 

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

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

 

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

=GORILLA_FEETYPE(“SELLER349d3”)

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

Direction Attributes:

  • Column
  • Row

Full_list Attributes:

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

GORILLA_TYPE Attributes

Period Attribute:

Today

Yesterday

Same day last week

Same day last month

Same day last year

Last 7 Days

Last 14 Days

Last 30 Days

This week

This month

This quarter

This year

This Year-to-Last-Month

Last Week

Last Month

Last Quarter

Last Year

Last 60 Days

Last 12 Months

Last 7 Days Week Ago

Last 7 Days Year Ago

Last 30 Days Month Ago

Last 30 Days Year Ago

Last Week Year Ago

Last Month Year Ago

YYYY-MM (change format to text)

YYYYQ1… YYYYQ4

ChargeType Attribute:

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

CODItemCharge

CODItemTaxCharge

CODOrderCharge

CODOrderTaxCharge

CODShippingCharge

CODShippingTaxCharge

CollectOnDeliveryRefund

CollectOnDeliveryRevenue

Discount

ExportCharge

FreeReplacementReturnShipping

GenericDeduction

Giftwrap

GiftwrapTax

Goodwill

MarketplaceFacilitatorTax-Giftwrap

MarketplaceFacilitatorTax-Other

MarketplaceFacilitatorTax-Principal

MarketplaceFacilitatorTax-Shipping

PaymentMethodFee

PointsFee

Principal

RestockingFee

ReturnShipping

SAFE-TReimbursement

ShippingCharge

ShippingTax

Tax

TaxDiscount

TCS-CGST

TCS-IGST

TCS-SGST

TCS-UTGST

Event Attribute:

  • Shipment
  • Refund
  • GuaranteeClaim
  • Chargeback
  • CouponPayment
  • Adjustment
  • Other
GORILLA_FEESESTIMATE() – Get estimated fees for product

GORILLA_FEESESTIMATE( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

sku

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

 

marketplace

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

 

returnStyle

OPTIONAL:

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

 

Examples:

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

 

=GORILLA_FEESESTIMATE(D2)

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

 

=GORILLA_FEESESTIMATE(A2:C10)

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

 

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

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

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

=GORILLA_FEESESTIMATE(“SELLERID832”, D2)

=GORILLA_FEESESTIMATE(“SELLERID832”, A2:C10)

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

GORILLA_FEETOTAL() – Get financials breakdown of all fees related to product sales 

GORILLA_FEETOTAL( ) Function

Description:

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

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

 

Examples:

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

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


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

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


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

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


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

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


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

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

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

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

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

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

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

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

GORILLA_FEETOTAL Attributes

Period Attribute:

Today

Yesterday

Same day last week

Same day last month

Same day last year

Last 7 Days

Last 14 Days

Last 30 Days

This week

Max

This month

This quarter

This year

This Year-to-Last-Month

Last Week

Last Month

Last Quarter

Last Year

Last 60 Days

Last 12 Months

Last 7 Days Week Ago

Last 7 Days Year Ago

Last 30 Days Month Ago

Last 30 Days Year Ago

Last Week Year Ago

Last Month Year Ago

YYYY-MM (change format to text)

YYYYQ1… YYYYQ4

FeeType Attribute:

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

Amazon Imaging fee

Cash on Delivery Chargeback

Closing Fees

Commission

Coupon clip fee

Coupon redemption fee

Cross-Border Fulfillment Fee

Easy Ship Fee

EPSO Chargeback fee

EPSO Cross-Border fee

EPSO Payment Authorization fee

EPSO Payment Settle fee

FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation Charge

FBA Fee for cash on delivery

FBA Fulfillment Fees

FBA Fulfillment Fees

FBA Inbound Shipment Carton Level Info Fee

FBA Inbound Transportation Program Fee

FBA Inventory Disposals

FBA Inventory Placement Service Fees

FBA Inventory Removals

FBA Inventory Storage Fee

FBA Label Service Fee

FBA Long-Term Storage Fees

FBA Multi-Channel Fulfillment Weight Handling

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

FBA Returns Processing Fee-Pick & Pack

FBA Returns Processing Fee-Weight Handling

FBA Taping Fee

FBA transportation fee

FBA Unplanned Prep Service Fees

FBA Weight Based Fee

Fresh Inbound Transportation Fee

Get Paid Faster Fee

Gift Wrap Charge-Back Fee

Gift Wrap Commission

Global Inbound Transportation Fee

High-volume listing fee

Monthly subscription fee

Per-item fees for Individual Sellers

Purchase of Rented Books

Referral Fees

Refund Administration Fee

Rental Book Service Fee

Rental Extensions

Review Enrollment Fee

Shipping Charge-Back Fee

Shipping HB Fee

SSO Fulfillment Fee

Tax Calculation Services Fees

Unit Fulfillment Fee

Event Attribute:

  • Shipment
  • Refund
  • GuaranteeClaim
  • Chargeback
  • CouponPayment
  • Adjustment
  • ServiceFee
  • Other
GORILLA_FEETYPE() – Get list of line item names associated as fees with Amazon 

GORILLA_FEETYPE( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

sku

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

 

marketplace

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

 

returnStyle

OPTIONAL:

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

 

Examples:

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

 

=GORILLA_FEETYPE()

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


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

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

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

=GORILLA_FEETYPE(“SELLER349d3”)

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

Direction Attributes:

  • Column
  • Row

Full_list Attributes:

  • No – only shows fees related to the account
  • Yes – shows all fee names
GORILLA_INVENTORY() – Get quantity and status of inventory

GORILLA_INVENTORY( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

sku

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

 

marketplace

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

 

status

OPTIONAL – Supply status. Valid values are:

  • All
  • InStock
  • Inbound
  • Transfer

 

Examples:

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

 

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

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

 

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

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

 

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

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

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

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

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

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

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 100×5 = 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 EU marketplace.

GORILLA_INVENTORY Attributes:

Status Attributes 

  • All
  • InStock
  • Inbound
  • Transfer 
GORILLA_INVENTORYHIST() – Shows historical inventory levels of past dates

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() – Get lowest seller price for the SKU or ASIN

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 

Condition Attributes:

  • New
  • Used
  • Collectible
  • Refurbished
  • Club

SubCondition Attributes:

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

priceType Attributes:

  • LandedPrice
  • ListingPrice
  • ShippingPrice
  • RegularPrice 

 

GORILLA_LOWESTOFFER() – Get the lowest offered listing price from any seller

GORILLA_LOWESTOFFER( ) Function

Description:

Get the lowest offered listing price from any seller.

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

sku

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

 

marketplace

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

 

returnStyle 

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

  • Full 
  • Fullwithheader 

 

priceType

OPTIONAL – Value to return. Valid values are: 

  • LandedPrice
  • ListingPrice
  • ShippingPrice
  • RegularPrice

 

Examples:

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

 

=GORILLA_LOWESTOFFER(D2)

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

 

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

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

 

=GORILLA_LOWESTOFFER(A2:C10)

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

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

=GORILLA_LOWESTOFFER(“SELLER3729”, D2)

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

=GORILLA_LOWESTOFFER(“SELLER3729”, A2:C10)

 

GORILLA_LOWESTOFFER Attributes

 

returnStyle Attributes:

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

 

priceType Attributes:

  • LandedPrice
  • ListingPrice
  • ShippingPrice
  • RegularPrice 
GORILLA_PRODUCT() – Get product info such as title, image, weight

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:

  • Binding
  • IsAutographed
  • ItemDimensions_Weight
  • ListPrice_Amount
  • Model
  • PackageDimensions_Weight
  • ProductGroup
  • Size
  • SmallImage_Width
  • Brand
  • ItemDimensions
  • ItemDimensions_Width
  • ListPrice_CurrencyCode
  • PackageDimensions
  • PackageDimensions_Width
  • ProductTypeName
  • SmallImage
  • Studio
  • Color
  • ItemDimensions_Height
  • Label
  • Manufacturer
  • PackageDimensions_Height
  • PackageQuantity
  • Publisher
  • SmallImage_Height
  • Title
  • IsAdultProduct
  • ItemDimensions_Length
  • ListPrice
  • MaterialType
  • PackageDimensions_Length
  • PartNumber
  • Scent
  • SmallImage_URL
GORILLA_RANKHIST() – Get historical BSR for products

GORILLA_RANKHIST( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

period

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

 

sku

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

 

marketplace

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

 

queryType

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

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

 

returnStyle

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

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

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

 

Examples:

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

 

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

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

 

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

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

 

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

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

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

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

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

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

GORILLA_RANKHIST Attributes

queryType Attributes:

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

returnStyle Attributes:

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

period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This week
  • This month
  • This quarter
  • This year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
GORILLA_RANKING() – Get BSR for products

GORILLA_RANKING( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

sku

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

 

marketplace

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

 

queryType

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

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

 

returnStyle

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

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

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

 

Examples:

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

 

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

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

 

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

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

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

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

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

GORILLA_RANKING Attributes

queryType Attributes:

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

returnStyle Attributes:

  • r_cat – shows rank number and top level category
  • rank – rank number only
  • r_full – shows the rank and category path 
GORILLA_RATINGS() – Get average review rating for product

GORILLA_RATINGS( ) Function

Description:

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

 

Syntax:

GORILLA_RATINGS(sku, [marketplace])

for Gorilla AGENCY, the syntax is

GORILLA_RATINGS(sellerID, sku, [marketplace])

sku

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

 

marketplace

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

 

Examples:

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

 

=GORILLA_RATINGS(“B00YD545CC”, “CA”)

Returns the review rating for ASIN B00YD545CC for Canadian marketplace.

 

=GORILLA_RATINGS(A2:A10, ,)

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

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

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

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

GORILLA_REVIEW() – Get full review details of a product

GORILLA_REVIEW( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

sku

SKU or ASIN of the product. Only one accepted.

 

marketplace

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

 

count

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

  

Examples:

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

 

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

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

 

=GORILLA_REVIEW(A2:A10, ,)

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

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

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

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

GORILLA_REVIEWCOUNT() – Get number of reviews of a product

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() – Get total number of sales between any time period

GORILLA_SALESCOUNT( ) Function

Description:

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

 

Syntax:

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


for Gorilla AGENCY, the syntax is

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

period

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

 

marketplace

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

 

sku

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

 

status

OPTIONAL – Order Status. Valid values are:

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

 

start_date

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

 

end_date

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

 

Examples:

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

 

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

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

 

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

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

 

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

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

 

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

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

 

=GORILLA_SALESCOUNT(“This Year”)

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

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

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

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

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

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

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

GORILLA_SALESCOUNT Attributes

Period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • MAX

Status Attributes:

  • AllButCanceled (default)
  • All
  • Unshipped
  • InvoiceUnconfirmed
  • PendingAvailability (JP marketplace only) 
  • Pending
  • Canceled
  • Shipped
  • Unfulfillable
  • PartiallyShipped 
GORILLA_SALESTOTAL() – Get total sales dollar amount between any time period

GORILLA_SALESTOTAL( ) Function

Description:

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

 

Syntax:

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

for Gorilla AGENCY, the syntax is

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

period

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

 

marketplace

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

 

sku

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

 

status

OPTIONAL – Order Status. Valid values below.

 

start_date

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

 

end_date

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

 

Examples:

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

 

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

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

 

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

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

 

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

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

 

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

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

 

=GORILLA_SALESTOTAL(“This Year”)

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

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

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

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

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

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

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

GORILLA_SALESTOTAL Attributes

Period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • MAX

Status Attributes:

  • All
  • Unshipped
  • InvoiceUnconfirmed
  • PendingAvailability (JP marketplace only)
  • PartiallyShipped 
  • Pending
  • Canceled
  • Shipped
  • Unfulfillable 
GORILLA_SKUASIN() – Convert SKU or ASIN to SKU and SKU to ASIN

GORILLA_SKUASIN( ) Function

Description:

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

 

Syntax:

GORILLA_SKUASIN(SKU/ASIN, [direction])

 

for Gorilla AGENCY, the syntax is

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

sku

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

 

direction

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

 

Examples:

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

 

=GORILLA_SKUASIN(“IPHN3724”)

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

 

=GORILLA_SKUASIN(“B00YD545CC”, “sku2asin”)

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

 

=GORILLA_SKUASIN(D33:E39, “asin2sku”)

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

 

=GORILLA_SKUASIN(D33:E39, “sku2asin”)

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

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

=GORILLA_SKUASIN(“SELLER832J”, “IPHN3724”)

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

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

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

GORILLA_SKUASIN Attributes 

  • sku2asin
  • asin2sku 
GORILLA_SKUFNSKU() – Convert SKU or ASIN to FNSKU and vice versa

GORILLA_SKUASIN( ) Function

Description:

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

 

Syntax:

GORILLA_SKUFNSKU(sku or asin, [direction])

for Gorilla AGENCY, the syntax is

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

sku

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

 

direction

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

 

Examples:

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

 

=GORILLA_SKUFNSKU(“IPHN3724”)

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

 

=GORILLA_SKUFNSKU(“B00YD545CC”, “sku2asin”)

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

 

=GORILLA_SKUASIN(D33:E39, “fnsku2sku”)

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

 

=GORILLA_SKUASIN(D33:E39,”sku2fnsku”)

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

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

=GORILLA_SKUFNSKU(“SELLER832J”, “IPHN3724”)

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

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

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

GORILLA_SKUASIN Attributes 

  • sku2fnsku
  • fnsku2sku 
GORILLA_SKULIST() Get a list of SKU’s from your marketplace

GORILLA_SKULIST( ) Function

Description:

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

 

Syntax:

GORILLA_SKULIST([marketplace], [filter_sku])

for Gorilla AGENCY, the syntax is

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

marketplace

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

 

filter_sku

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

 

Examples:

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

 

=GORILLA_SKULIST()

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

 

=GORILLA_SKULIST(“UK”,”IPHONE”)

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

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

=GORILLA_SKULIST(“SELLER832J”)

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

Fulfilled By Merchant (FBM) Functions – Not Supported

Fulfilled By Merchant (FBM) – Not Supported

FBM related data is limited to sales orders only.

Other detailed data like inventory, units sold, total sales is not supported. Amazon does not provide an API to import the data for FBM sales.

 

Only FBA data and functions are available at this time. 

Not a member of Gorilla ROI?

Functions Coming Soon

The following list of functions are not available yet.

These are on our roadmap and will be released as soon as development is complete.

 

In progress:

Agency access (complete)- get data from multiple accounts in the same marketplace. e.g. 10 US seller accounts etc.

Cost and fee breakdown – complete

Accounting feature that will generate a report like a financial statement – complete

  • Advertising and PPC data – in progress
  • Add-in for Microsoft Excel