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_FEETYPE("TOY STORE")
=GORILLA_FEETYPE("TOY STORE", "US", "GIFT" , "Column", "No", "Shipment")
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(Seller ID, [marketplace], [filter_fee], [direction], [full_list], [event])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
marketplace – OPTIONAL
Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc.
filter_fee – 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.
event – OPTIONAL
Return data for specific event type. Default is empty value for any event type. Other Valid values are: Shipment, Refund, GuaranteeClaim, Chargeback, CouponPayment, Adjustment, ServiceFee and Other.
List of Fee types by Amazon
For the latest list, enter =GORILLA_FEETYPE(“TOY STORE”,, , , “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: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_FEETYPE("TOY STORE")
If no attributes are entered, it will list all the line items categorized as fees related to the Amazon account.
=GORILLA_FEETYPE("TOY STORE", "US", "GIFT" , "Column", "No", "Shipment")
Lists all fee types for the US marketplace, searching for any fees that start with “GIFT”, and is associated with Shipping/Shipment, displayed in a column and only displaying the fees’ 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.