GORILLA_REMOVALS() – Get FBA Recommended Removals Data
Sample Usage
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_REMOVALS($A$1, $A$5:$A$24)
=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01")=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01", "sellable-removal-quantity")=GORILLA_REMOVALS("TOY STORE", "B0811T2N2Z", "unsellable-quantity")Syntax Description
Description:
Get FBA Recommended Removals Data.
Syntax:
GORILLA_REMOVALS(sellerId, sku, [datapoint])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
sku – REQUIRED
SKU, ASIN or FNSKU to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or FKSKU123… If datapoint is not specified, only single value or a column of SKU’s can be provided, not a matrix.
datapoint – OPTIONAL
Return data for specific data points. Can be a range of values like A1:E1 where A1 to E1 consists of different datapoint values. Default is empty value for all data points.
Other Valid values are:
snapshot-date
sellable-quantity
unsellable-quantity
sellable-removal-quantity
sellable-365+-days
sellable-271-365-days
sellable-181-270-days
sellable-121-180-days
unsellable-61-90-days
unsellable-8-60-days
unsellable-0-7-days
header – OPTIONAL
Include the header line in the results.
Possible values: TRUE/FALSE.
Default: TRUE
Examples:
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_REMOVALS($A$1, $A$5:$A$24)
$A$1 being the Seller ID, $A$5:$A$24 being SKU, ASIN, or FNSKU will return removal data for all the datapoints.
=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01")This will return removal data for all the datapoints for the SKU ABC-XYZ-AMZ01.
=GORILLA_REMOVALS("TOY STORE", "ABC-XYZ-AMZ01", "sellable-removal-quantity")This will return sellable-removal-quantity datapoint for the SKU ABC-XYZ-AMZ01.
=GORILLA_REMOVALS("TOY STORE", "B0811T2N2Z", "unsellable-quantity")This will return unsellable-quantity datapoint for the ASIN B0811T2N2Z.