I am trying to build an inventory system and there were no templates. What I want to do is sum all quantities of like inventory items in the Inventory Lots schema and show the total in the Inventory schema for each type. For example, if I have 4 lots of Snickers candy bars and 3 lots have 12 bars each and the other lot has 3, in the Inventory schema I want to display the 39 Snickers candy bars in the Snickers inventory.
BTW, if the answer requires js, keep in mind I am a total noob.
Thanks for the help in advance!