GORILLA_SKULIST() – Get the list of SKUs from your account

Sample Usage =GORILLA_SKULIST(“MY TOY STORE”) =GORILLA_SKULIST(“MY TOY STORE”, , , , “FBA”, “SKU_ASC”) =GORILLA_SKULIST(“MY TOY STORE”, , , “ALL”) =GORILLA_SKULIST($A$1, “UK”,”IPHONE”) =GORILLA_SKULIST($A$1, “US” , , “ACTIVE”, “FBM”) Syntax Description Description: Return a list of active and inactive SKUs from your marketplace(s). Syntax: GORILLA_SKULIST(Seller ID, [marketplace], [filter_sku], [status], [fulfillment], [sort]) Seller ID – REQUIREDEnter the seller…

GORILLA_SETTLEMENT() – Get the list of settlement IDs

Sample Usage =GORILLA_SETTLEMENT(“TOY STORE”, “LAST WEEK”) =GORILLA_SETTLEMENT(“TOY STORE”, “LAST MONTH”, “DEPOSIT”) =GORILLA_SETTLEMENT(“TOY STORE”, “CUSTOM”, , “2022-10-01”, “2022-11-10″) Syntax Description Description: Get the settlements data. SETTLEMENT is a dump of the Settlement IDs where the Settlements occurred. WARNING: For large sellers, do NOT use this function for a long time period, like “last year”. It will…

GORILLA_MANAGEORDER() – Get list of orders and order details for SKU or ASIN

Sample Usage =GORILLA_MANAGEORDER(“TOY STORE”, “last 7 days”) =GORILLA_MANAGEORDER(“TOY STORE”, “last month”, “U378-JEKD-423D”, “US”) =GORILLA_MANAGEORDER(“TOY STORE”, “last 30 days”,C49,”US”,”SHIPPED”) =GORILLA_MANAGEORDER(“TOY STORE”, “custom”, , “US”, “canceled”, “2020-09-01”, “2020-09-15”) Syntax Description Description: Get the detailed list of orders and the order details for a SKU or ASIN. ManageOrder is a dump of the order IDs where the sales…

GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account

Sample Usage =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 – REQUIREDEnter the seller ID or nickname you entered in…

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

Sample Usage =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 –…

GORILLA_ASINLIST() – Get list of ASINs from your marketplace

Sample Usage =GORILLA_ASINLIST(“MY TOY STORE”) =GORILLA_ASINLIST(“MY TOY STORE”, , , , “FBA”) =GORILLA_ASINLIST(“MY TOY STORE”, , , “ALL”) =GORILLA_ASINLIST(“MY TOY STORE”,”ALL”, “B43”) =GORILLA_ASINLIST(“MY TOY STORE”, “US” , , “INACTIVE”, “FBM”, “DATE_DESC”) Syntax description Description: Return a list of active and inactive ASINs from your marketplace(s). Syntax: GORILLA_ASINLIST(Seller ID, [marketplace], [filter_asin], [status], [fulfillment], [sort]) Seller ID…

GORILLA_BUYBOXOFFERS() – Get list of sellers competing for the buy box

Sample Usage =GORILLA_BUYBOXOFFERS(“TOY STORE”, “B00YD545CC”, “US”, “TRUE”) =GORILLA_BUYBOXOFFERS(“TOY STORE”, “B00YD545CC”, “DE”, “FALSE”) =GORILLA_BUYBOXOFFERS(“TOY STORE”, “B00YD545CC”) Syntax description Description: Get the list of all sellers and offerings on the listing and competing for the buy box. Does not pull information for SKUs that you do not sell. Only works for SKUs and ASINs in your inventory….