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.