Hi @Chris_Holmquist
This should not be too difficult to set up.
I would start with another table that links to Inventory where you build up the packaged deals from the items listed in inventory.
If you have another Table to track your orders, when you sell either one apple or a bundle of apples and kiwis you can have them count and accommodate when updating the total inventory stock.
Hi @Chris_Holmquist
This should not be too difficult to set up.
I would start with another table that links to Inventory where you build up the packaged deals from the items listed in inventory.
If you have another Table to track your orders, when you sell either one apple or a bundle of apples and kiwis you can have them count and accommodate when updating the total inventory stock.
Hey @Vivid-Squid thanks for the idea!
So I’m brand new to Airtable. I guess I’m confused on do I have one table with the single items and then use a new table to create the combos and link those combos with the other inventory of singles?
Hey @Vivid-Squid thanks for the idea!
So I’m brand new to Airtable. I guess I’m confused on do I have one table with the single items and then use a new table to create the combos and link those combos with the other inventory of singles?
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.
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.
@Vivid-Squid thanks! I greatly appreciate it. I’ll look into the demo and see what you did!
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.
Hey @Vivid-Squid! One question so when I use your demo and place and order for apple and orange bundle at a quantity of 1 it will subtract 10 of each instead of the 5 it says in the bundle.