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 “Cheese Pizza”, 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:
get the cost of your menu items
get real time stock estimates
can set cost alerts.
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 see a table of all your POS Items
Before mapping your POS Items, we recommend you take the following time-saving measures:
Archive any irrelevant items
Add serving sizes (optional)
Filter and sort your POS Items
For the smoothest experience, we recommend setting up your batches before you start POS Mapping.
These may be called sub-recipes in your venue, and are a group of ingredients that you set up ahead of time to use in POS Mapping. For example, if you use the same sauce in multiple menu items, create a batch for it.
When mapping your POS Items, you add the sauce batch as an ingredient instead of adding the individual ingredients of the sauce to each POS Item.
This saves you time, and if you ever change the recipe of your sauce, you just update the batch and it applies to all POS Items. To learn more, please see:
Archiving POS Items
Depending on your POS, WISK may import sales data for categories other than food. If this is the case, archive the POS Items of anything you're not tracking. This could also include any text modifiers that don't affect the quantity of ingredients (For example, "Over Easy", "Rare").
When you archive a POS Item, if it has sales, those are excluded from the total imported sales value. For example, if WISK imported $15,000 worth of sales for both food and alcohol in your venue, by archiving the alcohol POS Items you’ll get the total food sales. For the sake of simplicity, lets say it's an even split of $7,500 for food, and $7,500 for alcohol.
This modified sales amount of just food ($7,500) is compared to your consumption to calculate your overall cost percentage.
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
The selected POS Items are now archived.
Note: To restore archived POS Items, please see "Unarchiving POS Items".
Adding Serving Sizes
To 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 entering a custom amount each time.
If you have common measurements of ingredients used in your menu items, this feature is useful. It all depends on your venue, and is optional.
For example, if you consistently use 8oz of protein in dishes, 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. You can click it to rename it.
In the "Title" field, enter a name for the serving size.
Enter a quantity, then click the drop-down menu to select the unit of measurement. Fluid Ounce is selected by default. In this example, we'll select 8 Dry Ounces.
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 POS Items.
If you change a serving size, the updated measurement applies to all POS Items it is used in.
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, use our preset view "Most Sold Last 30 Days". This sorts the POS Items from highest to lowest sales so you can map the items with the highest impact first.
To apply the view:
Click "Default" under View
Click "Most Sold Last 30 Days"
The POS Items are now sorted from highest to lowest sales from the last 30 days
For more tips to speed up POS mapping, please see the "POS Item Mapping Tips" section of this article.
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:
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. In this example, we'll start with the 10" Pizza Dough batch that was created in a previous article "WISK Restaurant - Creating Batches"
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 used when the item is sold. You can select from the Serving Sizes you've created, enter a custom amount, or create a new Serving Size. Click “Serving Size” and select an option from the drop down menu.
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 percentage
Continue adding ingredients if needed. You can also add any additional costs. When finished, either close the window, or click the arrow buttons to move onto the next POS Item.
Note: If you update the Price of the item in your POS, it updates in WISK the next time the item is sold and your sales data is imported.
Custom Serving Sizes
As part of the Cheese Pizza POS Item above, we added 6 fluid oz of Pizza Sauce. 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. In this example, we enter 6 Fluid Ounces.
The ingredient is added to the POS Item
Your POS Items may have ingredients that you choose not to inventory in WISK, such as garnishes 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.
With your POS Item mapped, you now know the cost of the menu item.
To help monitor your costs, you can set alerts for when POS Items go above certain cost percentages. Just enter a percentage in the "Cost Alert" field, and you'll receive an email notification if the cost percentage exceeds that amount.
To learn more, please see:
POS Item Mapping Tips
To save you time while mapping your POS Items, try out these tips.
Copy POS Item Mapping
If you have a lot of similar dishes that contain the same ingredients and amounts, you can copy the POS Mapping from one item to others.
In this example, we have our "Cheese Pizza" POS Item that is already mapped. We can copy these ingredients to our "Pepperoni Pizza" POS Item.
Tip: To find all your similar POS Items, use the search and enter a shared keyword
To copy the mapping from one POS Item to others:
Click the checkbox beside the unmapped POS Items. In this example we only have the one item but you can multi-select.
On the side menu that appears, click "Import ingredients from another POS Item".
In that window that opens, enter the Title or POS Code of the POS Item that you want to copy the ingredients from. In this example, we'll select "Cheese Pizza".
Click "OK" on the confirmation window.
The ingredients copy from the POS Item and import into the POS Items you selected. Click the "Ingredients" column of a POS Item to finish the mapping. In this example, we'll need to add pepperoni to the Pepperoni Pizza.
Add any missing ingredients, other costs, and cost alerts to the POS Items