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
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.