Sample Usage
=GORILLA_FEETYPE()
=GORILLA_FEETYPE("US", "FBA", "Column", "No")
Syntax Description
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.
