GORILLA_COSTCURRENT() – Get the current or latest product costs for any date

Sample Usage =GORILLA_COSTCURRENT(“TOY STORE”) =GORILLA_COSTCURRENT(“TOY STORE”, “2023-01”) =GORILLA_COSTCURRENT(“TOY STORE”, , A1:A100) =GORILLA_COSTCURRENT(“TOY STORE”, , A1:A100, “VALUES”) Syntax Description Description: Pull your latest product costs into Google Sheets Syntax: GORILLA_COSTCURRENT(Seller ID, [period], [sku], [output], [marketplace], [count], [sort], [date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined…

GORILLA_COSTDUMP() – Get the AVG, MIN, MAX, FIRST, LAST product costs for any period

Sample Usage =GORILLA_COSTDUMP(“TOY STORE”, “2023”) =GORILLA_COSTDUMP(“TOY STORE”, “2023”, A1:A100) =GORILLA_COSTDUMP(“TOY STORE”, “2023”, A1:A100, “AVG”) Example output screenshot Syntax Description Description: Get a dump of results as a changelog for the changes made to the product costs in Gorilla App Syntax: GORILLA_COSTDUMP(Seller ID, period, [sku], [aggregate], [marketplace], [count], [sort], [start_date], [end_date]) Seller ID – REQUIREDEnter the…

GORILLA_COGSTOTAL() – Display total COGS if COGS has been entered via your Gorilla ROI account

Sample Usage =GORILLA_COGSTOTAL(“TOY STORE”, “2023”) =GORILLA_COGSTOTAL(“TOY STORE”, “2023”, A1:A100) =GORILLA_COGSTOTAL(“TOY STORE”, “2023-12”, “IPHONE”, “TOTAL”) Syntax Description Description: Display total COGS if COGS has been entered via your Gorilla ROI account Syntax: GORILLA_COGSTOTAL(Seller ID, period, [sku], [output], [marketplace], [count], [sort], [start_date], [end_date], [status], [mcf]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in…