Importing your sales data into WISK is the first step towards seeing your variance, the difference between what was sold, and what was actually poured. Variance is one of the most valuable features of WISK.
There are 2 ways to get your sales information into WISK:
- Integrating your POS
- Uploading your sales manually
Integrating your POS
WISK integrates with a number of POS systems. You can check out our list of POS Integrations here.
There are two ways to integrate your POS with WISK:
1. An automated daily email of sales/product mix in XLS or CSV format sent to firstname.lastname@example.org. At a minimum, the sales report needs to include the following information:
- POS Code - the unique identifier code for the item in your POS system (if your POS does not use identifier codes, WISK will use the Item Name in its place)
- Item Name - the name of the item in the POS
- Quantity Sold - the quantity sold of the item in the sales report period
- Net Sales - the total dollar value of the item sales
2. Direct API to pull sales data in real-time
To start the integration process, you’ll need to select your POS. This determines the integration method that is available to you. When you select your POS, the support team is notified and will send you instructions on how to complete the integration.
You can select your POS from the setup checklist in both the mobile app and web.
Manual Sales Upload
If your POS isn't on our list of integrations, you can manually upload your sales into WISK while we pursue the integration.
When you import your sales data, it creates a POS Item in your venue for each item sold. For example, if you sold an item in your POS called “Grey Goose Single”, there would be a corresponding item created in WISK. To view these POS Items on the WISK Web Portal:
- Click “Sales on the left-hand menu bar
- Click “POS Items”
For those POS Items, you add the ingredients that are used every time the item is sold.
Note: New POS Items will appear over time as you add new items for sale in your venue.
After mapping all of your current POS Items by adding your recipes, WISK compares how much you sold to how much you consumed when you complete an inventory count.
For each bottle in your venue, WISK tells you how much should’ve been used based on the sales of all POS Items it is an ingredient in.
In the example below, it shows that based on the sales and POS Item mapping, 11.2 bottles of Havana Club were sold, but 11.9 bottles were consumed (based on the inventory count).
Variance = Consumption - Sales
In this case, the variance is -0.7 bottles. In other words, you had a loss of 0.7 bottles.
Seeing your variance helps you spot any potential inventory issues, including over pouring or theft.
You can learn more about Variance in our “Understanding Variance” article that appears later in this section.