#Soda and Juice
We have Coke, Sprite, Ginger Ale, etc. Maybe we also have Juices in Orange, Pineapple, Cranberry. Depending on the Product, we might sell multiple Units (Portions), and in other cases, we have less Units (Portions) that we sell.
For example, we might sell Soda by the Can (355mL), Small Bottle (600mL), and larger Bottles of 1 L, 2 L, and 3 L, as well as using some for Drink Mixers (a short cocktail might use 60mL while a Tall cocktail might use 100mL). On the other hand, we might only sell Juices in small and large Glasses, and as a Drink Mixer, but not by the can, bottle or carton. So when you define the Products, you need to plan ahead and be aware of what you sell.
For this example, I will use Coke that is sold either by the Can, or as a mixer in a Cocktail. And I will concentrate on “Method 3” since it probably makes the most sense for this scenario.
##Product Definition
So we will only have a single Product Definition that looks like this:
Product: Coke
Portion: Can
##Order Tag Definition
Using Coke as a Cocktail Mixer should be defined as an Order Tag. We will use Order Tag Mappings in the Recipes - not in the Tag definitions - leave those blank. So you might have an Order Tag Group named Mixers Soda with Tags for different Sodas:
Order Tag Group: Mixers Soda
Tags:
Coke
Coke Light
Ginger Ale
Sprite
Club Soda
Tonic
Order Tag Group: Mixers Juice
Tags:
Orange Juice
Pineapple Juice
Cranberry Juice
Lime Juice
##Inventory Item Definition
Item: Coke
Base Unit: mL
Transaction Unit: Can, Multiplier: 355 (Can is the Reporting Unit)
Additional Unit: Pack 6, Multiplier: 6, Parent: Can
Additional Unit: Case, Multiplier: 24, Parent: Can
Again, we use mL as the smallest unit of measure because we will use this Item as a mixer, which is a fraction of a Can. If you don’t sell Coke as a Mixer, you could make your Base Unit the Can.
##Recipe Definitions (no Containers)
Recipe: Coke
Product: Coke
Portion: Can
Inventory Item: Coke, Multiplier:355, Unit: mL
That takes care of selling Coke by the Can. We can only use the Base Unit in Recipes, so we had to use 355 mL. The system will not let us choose Can as the Unit for the Inventory Item Recipe. But at least we defined the Item Transaction Unit as the Can, so our Reporting and Stock Counts will be based on the Can Unit, not the mL Unit.
Now let’s go back to the Rum Cocktail and make a modification… we don’t need to modify the Rum Shot or Rum Rocks Recipes since they don’t use Mixers, but the Short and Tall Cocktails need to be modified to include Mixers.
In this case (no Containers), we need to add each Soda a Juice to the Recipes, and map the Order Tag where applicable:
Recipe: Rum Drink.Cocktail Short
Product: Rum Drink
Portion: Cocktail Short
Inventory Item: Rum Drink, Multiplier: 60, Unit: mL
Inventory Item: Coke, Multiplier: 60, Unit: mL, Order Tag: Coke
Inventory Item: Ginger Ale, Multiplier: 60, Unit: mL, Order Tag: Ginger Ale
Inventory Item: Sprite, Multiplier: 60, Unit: mL, Order Tag: Sprite
Inventory Item: Orange Juice, Multiplier: 60, Unit: mL, Order Tag: Orange Juice
Inventory Item: Pineapple Juice, Multiplier: 60, Unit: mL, Order Tag: Pineapple Juice
Inventory Item: Cranberry Juice, Multiplier: 60, Unit: mL, Order Tag: Cranberry Juice
Recipe: Rum Drink.Cocktail Tall
Product: Rum Drink
Portion: Cocktail Tall
Inventory Item: Rum Drink, Multiplier: 60, Unit: mL
Inventory Item: Coke, Multiplier: 90, Unit: mL, Order Tag: Coke
Inventory Item: Ginger Ale, Multiplier: 90, Unit: mL, Order Tag: Ginger Ale
Inventory Item: Sprite, Multiplier: 90, Unit: mL, Order Tag: Sprite
Inventory Item: Orange Juice, Multiplier: 90, Unit: mL, Order Tag: Orange Juice
Inventory Item: Pineapple Juice, Multiplier: 90, Unit: mL, Order Tag: Pineapple Juice
Inventory Item: Cranberry Juice, Multiplier: 90, Unit: mL, Order Tag: Cranberry Juice
##Recipe Definitions (with Containers)
###Define Inventory Products for the Mixer Groups:
The Units in these Inventory Products will be referenced as a Portion in the corresponding Recipes.
Inventory Product: Soda Mixers
Unit: Short
Unit: Tall
Inventory Product: Juice Mixers
Unit: Short
Unit: Tall
###Define Recipes for the Inventory Product Containers
In this case (using Containers) we do our Order Tag Mappings in the Container Recipes. We will not use Order Tag Mappings in the “master” Recipes.
Recipe: Soda Mixers.Short
Product: Soda Mixers
Portion: Short (this is an Inventory Product “Container” Unit)
Inventory Item: Coke, Multiplier: 60, Unit: mL, Order Tag: Coke
Inventory Item: Rum Drink, Multiplier: 30, Unit: mL
Inventory Item: Coke, Multiplier: 60, Unit: mL, Order Tag: Coke
Inventory Item: Ginger Ale, Multiplier: 60, Unit: mL, Order Tag: Ginger Ale
Inventory Item: Sprite, Multiplier: 60, Unit: mL, Order Tag: Sprite
… add more Sodas to the list …
Recipe: Soda Mixers.Tall
Product: Soda Mixers
Portion: Tall (this is an Inventory Product “Container” Unit)
Inventory Item: Coke, Multiplier: 90, Unit: mL, Order Tag: Coke
Inventory Item: Ginger Ale, Multiplier: 90, Unit: mL, Order Tag: Ginger Ale
Inventory Item: Sprite, Multiplier: 90, Unit: mL, Order Tag: Sprite
… add more Sodas to the list …
Recipe: Juice Mixers.Short
Product: Juice Mixers
Portion: Short (this is an Inventory Product “Container” Unit)
Inventory Item: Orange Juice, Multiplier: 60, Unit: mL, Order Tag: Orange Juice
Inventory Item: Pineapple Juice, Multiplier: 60, Unit: mL, Order Tag: Pineapple Juice
Inventory Item: Cranberry Juice, Multiplier: 60, Unit: mL, Order Tag: Cranberry Juice
… add more Juices to the list …
Recipe: Juice Mixers.Tall
Product: Juice Mixers
Portion: Tall (this is an Inventory Product “Container” Unit)
Inventory Item: Orange Juice, Multiplier: 90, Unit: mL, Order Tag: Orange Juice
Inventory Item: Pineapple Juice, Multiplier: 90, Unit: mL, Order Tag: Pineapple Juice
Inventory Item: Cranberry Juice, Multiplier: 90, Unit: mL, Order Tag: Cranberry Juice
… add more Juices to the list …
###Modify the Rum Drink Recipes to use the Containers:
NOTE: the Order Tag Mappings are removed here in the “master” Recipes because we already mapped them in the Container Recipes.
Recipe: Rum Drink.Cocktail Short
Product: Rum Drink
Portion: Cocktail Short
Inventory Item: Rum Drink, Multiplier: 60, Unit: mL
Inventory Product: Soda Mixers, Multiplier: 1, Unit: Short
Inventory Product: Juice Mixers, Multiplier: 1, Unit: Short
Recipe: Rum Drink.Cocktail Tall
Product: Rum Drink
Portion: Cocktail Tall
Inventory Item: Rum Drink, Multiplier: 60, Unit: mL
Inventory Product: Soda Mixers, Multiplier: 1, Unit: Tall
Inventory Product: Juice Mixers, Multiplier: 1, Unit: Tall
Notice now our Rum Drink Recipes are much smaller and use only 3 “ingredients” which are a combination of 1 Inventory Item and 2 Inventory Products. Also, the Order Tags are removed - they were mapped instead within the Inventory Product “Container” Recipes.
The nice thing about using Containers is that when you add a new Soda Mixer or Juice Mixer, you edit the “Container” Recipes to include the new mixer, and leave the “master” Rum Drink Recipes untouched. This is especially useful when you have 3 types of Rum, 4 Types of Vodka, 2 Types of Whisky, etc. Without “Containers”, you would need to add a new Soda or Juice Mixer to 18 Recipes - Short and Tall for all types of Rum, Vodka, and Whisky, etc.
With Containers, you modify 2 Recipes: Juice Mixers Short and Juice Mixers Tall. The results (consumption) trickle through to the “master” Recipes automatically. For example, we now have Grapefruit Juice. Modify 2 Container Recipes to include the new Juice:
Recipe: Juice Mixers.Short
Product: Juice Mixers
Portion: Short (this is an Inventory Product “Container” Unit)
Inventory Item: Orange Juice, Multiplier: 60, Unit: mL, Order Tag: Orange Juice
Inventory Item: Pineapple Juice, Multiplier: 60, Unit: mL, Order Tag: Pineapple Juice
Inventory Item: Cranberry Juice, Multiplier: 60, Unit: mL, Order Tag: Cranberry Juice
Inventory Item: Grapefruit Juice, Multiplier: 60, Unit: mL, Order Tag: Grapefruit Juice
^^^ the last Juice is NEW ^^^
Recipe: Juice Mixers.Tall
Product: Juice Mixers
Portion: Tall (this is an Inventory Product “Container” Unit)
Inventory Item: Orange Juice, Multiplier: 90, Unit: mL, Order Tag: Orange Juice
Inventory Item: Pineapple Juice, Multiplier: 90, Unit: mL, Order Tag: Pineapple Juice
Inventory Item: Cranberry Juice, Multiplier: 90, Unit: mL, Order Tag: Cranberry Juice
Inventory Item: Grapefruit Juice, Multiplier: 90, Unit: mL, Order Tag: Grapefruit Juice
^^^ the last Juice is NEW ^^^
###Add a Vodka Recipe:
Recipe: Vodka Smirnoff.Shot
Product: Vodka Smirnoff
Portion: Shot
Inventory Item: Vodka Smirnoff, Multiplier: 30, Unit: mL
Recipe: Vodka Smirnoff.Rocks
Product: Vodka Smirnoff
Portion: Rocks
Inventory Item: Vodka Smirnoff, Multiplier: 90, Unit: mL
Recipe: Vodka Smirnoff.Cocktail Short
Product: Vodka Smirnoff
Portion: Cocktail Short
Inventory Item: Vodka Smirnoff, Multiplier: 60, Unit: mL
Inventory Product: Soda Mixers, Multiplier: 1, Unit: Short
Inventory Product: Juice Mixers, Multiplier: 1, Unit: Short
Recipe: Vodka Smirnoff.Cocktail Tall
Product: Vodka Smirnoff
Portion: Cocktail Tall
Inventory Item: Vodka Smirnoff, Multiplier: 60, Unit: mL
Inventory Product: Soda Mixers, Multiplier: 1, Unit: Tall
Inventory Product: Juice Mixers, Multiplier: 1, Unit: Tall
###Another Vodka:
Recipe: Vodka Skyy.Shot
Product: Vodka Skyy
Portion: Shot
Inventory Item: Vodka Skyy, Multiplier: 30, Unit: mL
Recipe: Vodka Skyy.Rocks
Product: Vodka Skyy
Portion: Rocks
Inventory Item: Vodka Skyy, Multiplier: 90, Unit: mL
Recipe: Vodka Skyy.Cocktail Short
Product: Vodka Skyy
Portion: Cocktail Short
Inventory Item: Vodka Skyy, Multiplier: 60, Unit: mL
Inventory Product: Soda Mixers, Multiplier: 1, Unit: Short
Inventory Product: Juice Mixers, Multiplier: 1, Unit: Short
Recipe: Vodka Skyy.Cocktail Tall
Product: Vodka Skyy
Portion: Cocktail Tall
Inventory Item: Vodka Skyy, Multiplier: 60, Unit: mL
Inventory Product: Soda Mixers, Multiplier: 1, Unit: Tall
Inventory Product: Juice Mixers, Multiplier: 1, Unit: Tall