I have a business where I sell oils and vinegars in bottles that are filled to order, let's just say small, medium, and large. I order the product in bulk containers and fill the bottles to order.
I'm looking for a way to track my inventory. My problem is that 1 bulk container from the vendor will fill 13 large bottles OR 26 medium bottles OR 46 small bottles OR any combination of those, depending on how customers order them.
I'd like to be able to manage how many bulk containers I have in stock, but let the store stay up to date on how many of each bottle size I can sell based on my inventory. Right now I just do some math and when I have 1 bulk container, I just add X small bottles, Y medium and Z large to my inventory, and when one gets low, I "borrow" from another size to replenish that size. That is, until I get a new bullk container and add more of each size. It's a headache to manage.
I haven't found an app yet that can handle this for me. Any thoughts?