GORILLA_RECONCILEREFUNDS() – Shows units purchased vs refunded

Sample Usage =GORILLA_RECONCILEREFUNDS(“TOY STORE”, “LAST 7 DAYS”) =GORILLA_RECONCILEREFUNDS(“TOY STORE”, “THIS YEAR”, A2:A10) =GORILLA_RECONCILEREFUNDS(“TOY STORE”, “THIS YEAR”, A2:A10, “UK”, “NO”) =GORILLA_RECONCILEREFUNDS(“TOY STORE”, “CUSTOM”, , , , “2022-09-03”, “2022-12-23”) Syntax description Description: Returns a table of all orders and compares the quantity of units purchased, shipped and refunded side by side to find discrepancies between purchased vs…

GORILLA_REFUNDSCOUNT() – Get total number of units refunded between any time period

Sample Usage =GORILLA_REFUNDSCOUNT(“TOY STORE”, “THIS YEAR”) =GORILLA_REFUNDSCOUNT(“TOY STORE”, “LAST YEAR”,”US”, A2:A34) =GORILLA_REFUNDSCOUNT(“TOY STORE”, “CUSTOM”, “FR”, A2:A34, “2020-01-01”, “2020-01-15”) =GORILLA_REFUNDSCOUNT(“TOY STORE”, “2020”, “US”, B7:B27) =GORILLA_REFUNDSCOUNT(“TOY STORE”, “2020Q1”, “US”, A1:A100) Syntax description Description: Gets total number of units refunded for a product between any time period. Only the period is required. Other attributes are optional. Syntax: GORILLA_REFUNDSCOUNT(Seller…

GORILLA_REFUNDSORDER() – Display orders that were refunded across any time period

Sample Usage =GORILLA_REFUNDSORDER(“TOY STORE”, “LAST 30 DAYS”) =GORILLA_REFUNDSORDER(“TOY STORE”, “THIS MONTH” ,”SKU111,SKU222,SKU333″, “DE”) =GORILLA_REFUNDSORDER(“TOY STORE”, “THIS MONTH” , A1:A34, “DE”) =GORILLA_REFUNDSORDER(“TOY STORE”, “CUSTOM”, A2:A34, “FR”, “ALL”, “2022-01-01”, “2022-01-15”) Syntax description Description: Gets the list of all orders that were refunded. Filter by SKU to track your refunded order IDs. This is a dump of the…

GORILLA_REFUNDSTOTAL() – Get total value of units refunded between any time period

Sample Usage =GORILLA_REFUNDSTOTAL(“TOY STORE”, “THIS YEAR”) =GORILLA_REFUNDSTOTAL(“TOY STORE”, “LAST YEAR”,”US”, A2:A34) =GORILLA_REFUNDSTOTAL(“TOY STORE”, “CUSTOM”, “FR”, A2:A34, “2020-01-01”, “2020-01-15”) =GORILLA_REFUNDSTOTAL(“TOY STORE”, “2020”, “US”, B7:B27) =GORILLA_REFUNDSTOTAL(“TOY STORE”, “2020Q1”, “US”, A1:A100) Syntax description Description: Gets total value in dollars of units refunded for a product between any time period. Only the period is required. Other attributes are optional….

GORILLA_REFUNDSPCT() – Get total value of units refunded between any time period

Sample Usage =GORILLA_REFUNDSPCT(“TOY STORE”, “THIS YEAR”) =GORILLA_REFUNDSPCT(“TOY STORE”, “LAST YEAR”,”US”, A2:A34) =GORILLA_REFUNDSPCT(“TOY STORE”, “THIS QUARTER”, “FR”) Syntax description Description: Get refund percentage between any period. Syntax: GORILLA_REFUNDSPCT(Seller ID, period, [marketplace], [sku], [mcf], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. period – REQUIREDPredefined period to get…