I need help with inventory management. What I’m trying to accomplish is using my current inventory of a product to create another product that will lower the inventory count of the products it takes to create the the new one.
For example let’s say we’re selling fruits
I have oranges, apples, bananas and kiwi that I sell all individually however I also want to offer them as a package deal so whenever I create that package the inventory of all the fruits involved lowers as well by the number it takes to make that.
More in-depth I want it to take X apples and X kiwi but those numbers may be different from each other.
Well, that’s one idea which took me down a rabbit hole.
I built a concept, but got a little wild with lookups and roll ups. However it does what you are asking. You can make a copy of the base to see what I did: Airtable - Demo copy copy
In the first table is Full Stock count and a formula of existing stock when either a product or bundle is ordered. The second table is the bundles of items from products and a break out of how many of each are in the bundle. The last table is orders, can order a single product or a bundle and list how many of each are ordered. The current stock on the first table only updates when then Sold box is checked.
I started with 50 of each Apple, Kiwi, Orange. I sold 20 individual Apples and 2 bundles of Apple and Kiwi that contain 5 of each fruit. So that would leave me with 20 apples, 40 kiwi and all 50 orange.
This might not be the most elegant way, and I dont think its very scalable but you can see some concepts.