We have so many sizes for each different specie for each sale and purchase. If I follow the procedure that you mentioned,  I would need to compute everything in microsoft excel first and then  type the amount one by one in quickbooks. 

I am open to purchasing a third party application. Do you have any recommendations? A fairly simple app that could manage multiple units computation would really do.