Google Sheets Functions

⌘K
  1. Home
  2. /
  3. Docs
  4. /
  5. Google Sheets Functions
  6. /
  7. 1.Seller Central Data/Fun...
  8. /
  9. GORILLA_CHARGETYPE() – Re...

GORILLA_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales

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_CHARGETYPE("TOY STORE")
=GORILLA_CHARGETYPE("TOY STORE", "US", "TAX", "Column", "No", "Shipment")

Syntax Description

CHARGETYPE Gorilla ROI

Description:

Returns a list of the line item names for all “charges” to your Amazon account when it is related to sales. Names include charges related to both income and expense.

Syntax:

GORILLA_CHARGETYPE(Seller ID, [marketplace], [filter], [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_charge – OPTIONAL
enter a string to filter for a particular list of charges.

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 charges associated with your account. To see the FULL list of charges 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 and Other.

List of Charge types by Amazon

For the latest list, enter =GORILLA_CHARGETYPE(“TOY SHOP”, , , , “yes”).

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

Amount given to the buyer to compensate for shipping the item back to Amazon
CanceledButPickedUpReimbursement
Charge that Amazon charges the buyer when returning a product
COD charge for an order
COD charge for an order item
COD refund
COD revenue
COMPENSATED_CLAWBACK
Compensation for return shipping when a buyer receives the wrong item and requests a free replacement
CRETURN_WRONG_ITEM
CS_ERROR_ITEMS
DebtPayment
DebtPaymentLevel2Failure
Export duty that is charged when Amazon ships an item to an international destination
FBA Liquidation
Fee collected for certain payment methods
FeeAdjustment
FREE_REPLACEMENT_REFUND_ITEMS
Generic bad debt deduction
Gift wrap charge
GiftWrap
GiftWrapTax
GoodWill (Amount given to a buyer as a gesture of)
INBOUND_CARRIER_DAMAGE
INCORRECT_FEES_ITEMS
Loan Advance
Loan Payment
LoanRefund
LostOrDamagedReimbursement
LowValueGoods-Other
LowValueGoods-Principal
LowValueGoods-Shipping
LowValueGoodsTax-Other
LowValueGoodsTax-Principal
LowValueGoodsTax-Shipping
MarketplaceFacilitatorTax-Other
MarketplaceFacilitatorTax-Principal
MarketplaceFacilitatorTax-RestockingFee
MarketplaceFacilitatorTax-Shipping
MarketplaceFacilitatorVAT-Principal
MarketplaceFacilitatorVAT-Shipping
MISSING_FROM_INBOUND
MISSING_FROM_INBOUND_CLAWBACK
MULTICHANNEL_ORDER_DAMAGED
MULTICHANNEL_ORDER_LOST
PAYMENT_RETRACTION_ITEMS
PointsAdjusted
PREPFEE_REFUND
Product Ads Payment Principal Charge
Product Ads Payment Principal Refund
Product Ads Payment Tax Charge
Product Ads Payment Tax Refund
Promo Rebate
Promotional discount for an order item
ReimbursementClawback
REMOVAL_ORDER_DAMAGED
REMOVAL_ORDER_LOST
REVERSAL_REIMBURSEMENT
SAFE-T claim amount for the item
SAFETReimbursementCharge
Selling price (Principal)
Shipping charge
Shipping charges for a COD order
SI_CRETURN_MERCHANT_REIMBURSEMENT
Tax amount deducted for promotional rebates
Tax Collected at Source for Central Goods and Services Tax
Tax Collected at Source for Integrated Goods and Services Tax
Tax Collected at Source for State Goods and Services Tax
Tax Collected at Source for Union Territories Goods and Services Tax
Tax collected by the seller
Tax collected by the seller on a COD Item Charge
Tax collected by the seller on a COD Order Charge
Tax collected by the seller on a COD Shipping Charge
Tax collected by the seller on a Gift wrap charge
Tax collected by the seller on a Shipping Charge
Tax withheld by Amazon on other miscellaneous charges
Tax withheld by Amazon on the Gift-wrap charge
Tax withheld by Amazon on the Principal
Tax withheld by Amazon on the Shipping Charge
Value of Amazon Points deducted from the refund if the buyer does not have enough Amazon Points
WAREHOUSE_DAMAGE
WAREHOUSE_DAMAGE_EXCEPTION
WAREHOUSE_LOST
WAREHOUSE_LOST_MANUAL

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_CHARGETYPE("TOY STORE")

If no attributes are entered, it will list all the line items categorized as charges related to the Amazon account.

=GORILLA_CHARGETYPE($A$1, "US", "TAX", "Column", "No", "Shipment")

Lists all charge types for the US marketplace, searching for any charges that start with “TAX”, and is associated with Shipping/Shipment, displayed in a column and only displaying the charges associated with the Amazon account. If “YES” is used, it will return all Amazon ChargeType names.

GET YOUR SPREADSHEETS

Enter your email for the full download package now.

GET THE EBOOK PACKAGE

Enter your email for the full download package now.