Gorilla Sheets Functions

for Google Sheets 

Simple and easy to use formulas to use in Google Sheets

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
  • AU
  • FR
  • DE
  • IT
  • BR
  • IN
  • CN
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])

 

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

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

 

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

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

 

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. 

 

GORILLA_INVENTORY Attributes:

Status Attributes 

  • All
  • InStock
  • Inbound
  • Transfer 
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])

 

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

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

 

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 ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources. 

 

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

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

 

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

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

 

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

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

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

 

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. 

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

 

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. 

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

 

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

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

 

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

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

 

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. 

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

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

 

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.  

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

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

 

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

 

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

 

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.

About

Gorilla ROI provides tools for Amazon sellers to increase ROI, efficiency and save time. Focus on the important things – like growing the business.