Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account.

GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account.

Sample Usage

=GORILLA_FEETYPE()
=GORILLA_FEETYPE("US", "FBA", "Column", "No")

Syntax Description

GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account. 1

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

for Gorilla Agency, the syntax is

GORILLA_FEETYPE(sellerID, [marketplace], [filter], [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.

FILTER

OPTIONAL – enter a string to filter for a particular list of fees.

DIRECTION

OPTIONAL – Default is “column” if nothing is entered. It will return the list in a column. Use “row” to get the result in a horizontal row.

FULL_LIST

OPTIONAL – Default is “no” so that it only displays the fees associated with your account. To see the FULL list of fees that Amazon takes, enter “yes”. This will list transactions that are also not part of your account.

List of Fee types by Amazon

For the latest list, enter =GORILLA_FEETYPE(, , , “yes”).

For an explanation of each item, read the Amazon seller fees article.

Amazon Imaging fee
AmazonExclusivesFee
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
EPSOChargebackFee
FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation Charge
FBA Fee for cash on delivery
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 Liquidation 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
FBACustomerReturnWeightBasedFee
FBADeliveryServicesFee
FBAInboundDefectFee
FBAInternationalInboundFreightFee
FBAInternationalInboundFreightTaxAndDuty
FBALocalizationFee
FBAOverageFee
FBAPerUnitFulfillmentFee
FBATransportationFee
FBAWeightBasedFee
Fresh Inbound Transportation Fee
Get Paid Faster Fee
GetPaidFasterFee
Gift Wrap Charge-Back Fee
Gift Wrap Commission
GiftwrapChargeback
GiftwrapCommission
Global Inbound Transportation Fee
GlobalInboundTransportationDuty
GlobalInboundTransportationFreight
High-volume listing fee
JumpStartYourWebstoreFee
MFNDeliveryServiceFee
MFNPostageFee
Monthly subscription fee
OpaqueBaggingFee
PaidServicesFee
Per-item fees for Individual Sellers
Purchase of Rented Books
Referral Fees
Refund Administration Fee
Rental Book Service Fee
Rental Extensions
Review Enrollment Fee
RunLightningDealFee Principal
RunLightningDealFee Tax
SalesTaxCollectionFee
Shipping Charge-Back Fee
Shipping HB Fee
SSO Fulfillment Fee
TapingFee
Tax Calculation Services Fees
TechnologyFee
Unit Fulfillment Fee

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

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?