Vendor Item Mapping

Objective

In order for the QSROnline Client to drive the most current pricing for your Countsheets and recipes, Vendor Items need to be linked to your Inventory Items. QSROnline calls the process “mapping”. Vendor Item Mapping is essential in tracking your food cost. This process is responsible for updating your recipes with the latest vendor item prices.

Locate Food Cost Configuration

e01

Select the Food Cost Configuration by clicking on the Hamburger Icon located on the Menu Bar (or select the Menu Icon > Food Cost > Food Cost Configuration).

Unmapped Vendor Items

e02

1. Select the Status Tab within the Food Cost Configuration.

2. Choose the Unmapped Vendor Items Tab.

3. Select the down arrow in the yellow column under QSRInventoryItemID.

 

Vendor Item Mapping

e03

1. The Vendor Item Information for the selected item. (Vendor Items Details will display in Blue)

2. Search for the correct Inventory Items associated with this Vendor Item. (Inventory Item Details will display in Red)

3. Create an equivalency between the Vendor Item and Inventory Item.

4. Verify the mapping is correct between the Vendor Item and Inventory Item.

5. Select Save.

Creating New Inventory Item

e04

1. Select the box with the Black Arrow next the the Vendor Name in the Unmapped Vendor Items Tab.

2. Select the New Inventory Item Button.

Creating Inventory Item ID and Description

e05

1. When creating a New Inventory Item from the Unmapped Vendor Items Tab under the Status Tab in the Food Cost Configuration, the Inventory Item ID and Description will auto-populate based off the Vendor Item Ref # and Description.

2. Once you’ve created a unique Inventory Item ID and Description for the new inventory item, click the Next button at the bottom of your screen.

Selecting the Department and Subdepartment

e06
1. Using the Department/Subdepartment drop-down menu, select the Department and coordinating Subdepartment that the new inventory item belongs to. In this case, Shiner belongs in the BAR Department and the BOTTLED BEER Subdepartment.

2. After selecting the Department and Subdepartment, click the Next button at the bottom of your screen.

Determining Units of Measure

e07

1. Your are now ready to enter your units of measurement for your new inventory item (Shiner). The * next to Main Unit of Measure means that this information is required. In this example, Shiner is ordered in cases, represented by CASE. The Main Unit of Measure, CASE, should be how the item is ordered from the vendor. Therefore, on the invoice received from the vendor, Shiner will be shown to have been ordered per case.

The following units of measure help in breaking down your food cost. The Second Unit of Measure used here is BTL, meaning that every case of Shiner contains 24 individual bottles.

2. The Show on Reports section allows users to select which unit of measure will be used to document usages within the food cost reports. For this example, the number of individual Shiner BTL \Pwill be counted by the Second Unit of Measure, which is each BTL\P used.

3.The Show on Countsheets section allows user to select which unit(s) of measure \Pwill be listed on countsheets for inventory counting purposes. For this example, both units of measure will be listed on the countsheets for more detailed, accurate inventory counts.

4. Once you’ve keyed in your units of measure and determined which units of measure will be shown on reports and countsheets, you are ready for the next step. Click on Next button at the bottom of the screen.

Selection Locations

e08

1. For this example, Shiner will be stored in the BAR location, as displayed by the check mark next to BAR.

2. Click the Next button to move to the next step for creating a new inventory item.

Selecting Countsheets

e09

1. Here, you will have the option of selecting which Countsheets the new inventory item will appear on. You have the option of showing the new item on your Shift Countsheet, Daily Countsheet, Weekly Countsheet, Monthly Countsheet, and Waste Tracker. For this example, Shiner will only display on Weekly, Monthly, and Waste Tracker.

2. Click the Next button at the bottom of the screen.

Reorder Levels

e10
The Reorder Levels do NOT need to be entered at this time. Please contact support if you have any questions regarding Reorder Levels.

1. Click the Next button at the bottom of the screen.

Is the Item Equivalent?

e011

1. This window is asking if the inventory item you’ve just created is the same product as another inventory item. Because Shiner is Shiner Bottled Beer in the inventory list, this inventory item is NOT equivalent to another item.

2. Click the Next button to move on to the next step.

Summary/Editing Window

e012

This is the final step in creating a new inventory item. Each step that you just completed is summarized in the window shown above. If you notice any errors, you can click on the Edit button next to the section needing corrections. Once you’ve reviewed the information in this screen and it appears to be correct, click the Finish button to complete the inventory item creation process.

Saving Mapping

e013

1. Once the Inventory Item is created, the Inventory Item ID will then populate in the Yellow QSRInventoryItemID.

2. In order to the save the mapping for the Inventory Item that was just created, select the Save button.  It is recommend to select Save after mapping at least 5 to 10 items.

*Please be sure to save before exiting the Food Cost Configuration or before switching between tabs.  

Viewing Mapped Vendor Items

e014

1. In order to view Vendor Items that have been mapped , you must select the Vendor Items Tab in the Food Cost Configuration.

2. Select the Vendor from the drop down menu.

3. Choose a Vendor Item within the vendor item list.

4. Select the button under Mapped to Inventory Item to view the existing mapping of the Vendor Item selected.

Unmapped Inventory Items

e015

1. Select the Status Tab within the Food Cost Configuration.

2. Click on the Unmapped Inventory Items tab.

Inventory items that are classified as “unmapped” have not been linked to a Vendor Item.  Therefore, these Inventory Items will not populate prices on Countsheets or in Recipes.

Note: Settting prices for the unmapped inventory items will drive prices on countsheets and in recipes.

*To delete Unmapped Inventory Items, please refer to the Deleting Unmapped Inventory Items portion of this guide.

Setting Initial Price for Unmapped Inventory Items

e016

1.  Select the Inventory Items tab in the Food Cost Configuration.

2.  Select the inventory item that needs a price set.

3.  Click the “Set Initial Price” button.

4.  Add the price.

5. Click OK

6. Click Save to save your item price.

Deleting Unmapped Inventory Items

e017

Deleting Unmapped Inventory Items must be done uner the Inventory Items Tab of the Food Cost Configuration.

1. Select the Inventory Items Tab.

2. Search for the Inventory Item you wish to delete by typing in the item’s name within the Filter by Description box.

3. Select the row of the Inventory Item that you wish to delete by choosing the box with the Black Arrow next the the QSRInventoryItemID. Then press the Delete key on your Keyboard. (This will not work for anyone using the QSROnline Client on an Apple Mac running Virtual Windows because the keyboard functions are different.)

4. The Delete Row pop up window will populate to confirm the Row Deletion.  Select Yes if you would like to delete the selected Inventory Item, or select No to cancel.

5. Click Save once you are done.

 

Updated on December 21, 2021

Related Articles