Article Contents
Introduction
When you import your sales data into WISK, it creates a POS Item in your venue for each item sold in your POS. For example, if you sell an item called “Grey Goose Single”, there is a corresponding POS Item created in WISK.
With those POS Items in your venue, the next step is to add the ingredients used every time the item is sold. This is called POS Item mapping or adding your recipes.
By mapping your POS Items, you can:
see your item costs
compare your sales to your usage/consumption
get real time stock estimates.
Before Mapping POS Items
Viewing POS Items
To view your POS Items on the WISK Web Portal:
Click “Sales” on the left-hand menu bar, then "POS Items"
You’ll then see a table of all your POS Items
Before you start mapping your POS Items, we recommend you take the following time-saving measures:
Archive any irrelevant items
Add serving sizes
Filter and sort your POS Items
Archiving POS Items
Depending on your POS, WISK may receive sales data for categories other than beverage. If this is the case, you can archive the POS Items of what you're not tracking.
When you archive a POS Item, it is excluded from the total sales value. For example, if WISK pulled $15000 worth of sales for both food and beverage in your venue, by archiving the food POS Items you’ll get the total beverage sales.
Otherwise, it would use the $15000 including food sales to calculate your beverage cost.
To archive POS Items:
Click the checkbox beside the items you want to archive (you can multi-select)
Click “Archive” on the pop-up menu that appears
Click “OK"
The selected POS Items are now archived.
Note: To restore archived POS Items, please see "Unarchiving POS Items".
Adding Serving Sizes
To help save time when adding recipes, you can create standard serving sizes. When you map a POS Item, you add the ingredient, and how much is used when the item is sold.
By having serving sizes, you select the amount of an ingredient used from a list, instead of typing in a custom amount each time.
For example, if your draft beer pints are 20oz, you can create a serving size for it.
To create a serving size:
Click "Actions" then “Serving Sizes”
On the window that appears, click “Add serving size”
Note: By default, a serving size of "One Unit" is already in your venue. This could be used for full items (wine, beer, etc.) You can click it to rename it.
In the "Title" field, enter a name for the serving size (for example, shot, small wine glass, etc.)
Enter a quantity, then click the drop-down menu to select the unit of measurement. Fluid Ounce is selected by default.
Note: You can learn more about the available units of measurement here.
After adding the measurement, click “Save” to create the serving size.
The Serving size is added and appears in your list of serving sizes.
Note: You can edit serving sizes by clicking on them. You can also rearrange the order of your serving sizes by dragging and dropping. The order they appear on this screen is the order they appear on the list when mapping your POS Items.
Important: If you change a serving size, the updated measurement applies to all POS Items it is used in. You can view a history of changes to a service size by clicking on the timeline tab when editing a serving size
Filtering and Sorting Tips
The number of unmapped items displays at the top of the POS Items page. Click the "Click here to update" button to filter the page to only show unmapped items.
If you have a large number of POS Items to map, there are a few tools you can use to prioritize mapping your top-sellers.
1) If you click the predefined filters drop-down menu, there is an option to show "Unmapped and Sold in the last 30 days".
2) There is also a reporting view called "Most Sold Last 30 Days". This sorts the POS Items from highest to lowest sales in the past 30 days so you can map the items with the highest impact first.
To apply the view:
Click "Main"
Click "Most Sold Last 30 Days"
The POS Items are now sorted from highest to lowest sales from the last 30 days
Mapping POS Items
Check POS Items / Modifiers
Every POS is different, and some of our integrations have options on how you want to import your data. This is important if you use a lot of modifiers.
With some integrations, modifiers can either be appended to the main item, or imported as a separate POS Item.
Before you begin, check that your POS Items have imported in a way that makes sense to you.
If a POS has options for customizing the data import, there will be instructions in its corresponding integration article:
Adding Ingredients
To map a POS Item:
Click the “Ingredients” column of a POS Item
A window opens and displays the POS Item’s Title, POS Code, and the menu price of the item. By adding the ingredients, you'll get the total cost and cost percentage of the POS Item
Click into the "Search for ingredient" field. Start typing the name of an ingredient, and it searches your venue's item list. Click a search result to select the item
Note: If there is no matching item, you can either create a new item or batch
Then select the serving size. This is the amount that is used when the item is sold. You can select from the Serving Sizes you've created, or enter a custom amount. Click “Serving Size” and select an option from the drop down menu
Note: You will only see serving sizes matching the measurement type of the chosen ingredient. For example you won't see serving sizes that use weight for a volume-based item.
If you select a preset Serving Size, the item is added to the recipe and saved automatically. If you select a custom size, you’ll enter the quantity, unit of measurement, and then click “Add”. For more information, please see "Custom Serving Sizes" below
Once an item is added, you’ll see the cost of the POS Item based on the cost per unit of the ingredients, the profit, and the cost/profit percentage
Note: A visual indicator also shows how each ingredient contributes to the overall cost percentage when there is more than one ingredient
Continue adding ingredients if needed. You can also add any additional costs. When finished, click X to close the window, or click the arrow buttons to move onto the next POS Item. There are also keyboard shortcuts to advance:
PC - Ctrl + Alt + Right Arrow = Next, Ctrl + Alt + Left Arrow = Previous
Mac - Cmd + Option + Right Arrow = Next, Cmd + Option + Left Arrow = Previous
Note: If you modify the price of an item in your POS, the price updates in WISK the next time it's sold.
Custom Serving Sizes
As part of the Vodka Martini POS Item above, we added 0.75oz of Dry Vermouth. We didn't create a serving size for this, so it must be entered as a custom amount.
To add an ingredient with a custom serving size:
Select your ingredient in the "Search for ingredient" field. The Serving Size is set to "Custom" by default
Type the quantity and select the unit of measurement
Click “Add”
The ingredient is added to the POS Item
Other Costs
Your POS Items may have ingredients that you choose not to inventory in WISK. For example, garnishes, syrups, etc.
If you want to add the cost of those ingredients you don’t track in WISK, you can add a flat value in the "Other costs" field.
This amount is added to the cost of the POS Item and recalculates the Profit and Cost Percentage.
Cost Alerts
To help monitor your costs, you can set alerts for when POS Items go above certain cost percentages.
To learn more, please see:
Other
Batched Cocktails
If your venue has premixed (batched) cocktails that you keep in inventory, please see:
Feature Cocktails & "Open" POS Items
It’s best if your POS Items are as specific as possible. If you have a generic “Feature Cocktail” or “Open Liquor” button, you won’t be able to map that POS Item with specific ingredients, because it'll always be different.
You’ll need to leave these items unmapped, and manually compare your consumption to sales of those items.
If there is a recurring drink that is often entered under an open category, you’ll want to create a button for it in your POS.