Installation Guides
- Installation Guide Preamble
- MSSQL Customer Setup
- Omnivore
- Arryved
- Bbot Customer Setup
- Clover Customer Setup
- Digital Dining Customer Setup
- Focus Customer Setup
- Foodtronix Customer Setup
- Future Customer Setup
- GoTab Customer Setup
- Harbour Touch / Skytab Customer Setup
- Heartland Customer Setup
- Northstar Customer Setup
- Restaurant Manager Customer Setup
- SmartTab
- SpotOn
- Square Customer Setup
- Toast
- Touchbistro Customer Setup
Installation Guide Preamble
Welcome to our guide. This document is intended for BarTrack customers as well as their POS technicians. It specifies setup instructions for on-boarding a new customer with an existing POS integration we support. Please use the URL to this guide, it is always being updated.
About Integrations
The BarTrack system will work without point-of-sale integration, but in order to take full advantage of BarTrack, we have to build ways to collect reports and configuration data from the point-of-sale software. Integrating the POS allows us to check pour data against what was actually input into the POS, which provides our reporting with its pour vs sales analytics. This guide contains everything you need to know before setup of a BarTrack POS integration. It should answer most of the questions and any concerns you may have about the process, as well as provide your POS support tech with the details of our needs in the event we don’t have access to complete the setup.
Collected Data
We export and use the following pieces of information from POS reports for each Item:
- Order ID
-
Location ID (identification of terminal or handheld, or employee ID/name)
-
Timestamp sold
-
Name
- Price
- Tax
- Modifiers
- name, tax, price, quantity
-
Quantity
-
Category (Report Group)
- Subcategory
-
Adjusted price or discounted amount
-
Void
Supported Integrations
Here is our current list of supported integrations. Click any one of the links below to jump to the specific section for that integration.
Aloha
Arryved
Bbot
Brink
Cloud Connect
Clover
Digital Dining
Dinerware
Focus
Foodtronix
Future
GoTab
Harbour Touch
Heartland
Lavu
Lightspeed
Matre’D
Micros
MSSQL
Northstar
Omnivore
Positouch
Restaurant Manager
Revel
SmartTab
SpotOn
Square
Squirril
Toast
Touch Bistro
Upserve
Xpient
Integration Types
Local
Local integrations are those which run on legacy type POS systems which typically have a central back-office server where a manager would obtain reports. There is often no online access to these reports.
Cloud
Cloud integrations always have a some form of reporting online, usually through a web portal.
Omnivore
Omnivore is a 3rd party data provider that makes local data cloud-based for some local/legacy systems. It requires Windows 7 or higher and supports the following POS systems:
- Aloha TS, Aloha QS 12.3+
- ReadOnly Licensing: None required for previous days' data. Aloha Connect required for real-time.
- Brink
- Dinerware 3.3+
- Lightspeed
- Maitre'D 7.05.95+
- Currently only closed tickets reads are supported.
- Micros 3700 5.x
- Micros Simphony FE 1.6+
- Micros Simphony 2.9+, 18.x
- ReadOnly Licensing: Transaction Services License required.
- NCR Cloud Connect
- POSitouch 5.36+, 6.36+, QuickMenu 2.6.7.12+
- EMV payments not supported using MidniteExpress.
- Squirrel 8.x+ for reads, 10.2+ for writes, 11.x+
- XPIENT 3.x+
Further details can be found here upon logging in to the Omnivore portal:
https://panel.omnivore.io/docs/guides/features/compatibility
General Requirements
Local Integrations
This integration type requires the BarTrack software to be installed on the POS server. Some anti-virus and/or firewalls may need to be set up to allow the service to run in the background. Please allow a BarTrack support engineer access to the server for initial assessment.
Download our remote access software to get started.
Click Here to Download
Windows username/password with Administration security level (we prefer having an account made for BarTrack).
-
Windows 10 create user, see:
-
Windows 7 & 8 create user, see:
Cloud Integrations
Cloud integrations may have one of the following types of authorization credentials.
- Online portal username & password.
- Often you’ll invite/add our user by email address to provide access to the portal so that we won’t need your personal or admin username/password. We need read-only/view-only access to reports. We do not need access to other parts of the system, but if your software only offers admin without restrictions/roles then that will work. Please see the specific integration to determine which email address you should invite.
- API key and/or token
Omnivore Integrations
Best Practices
-
Open Items - NOT SUPPORTED. Those items that ask for a price can only be used in the following instances:
- If the open beer SKU represents a static volume, a dynamic beverage, and a dynamic price, it can be treated under general sales.
- However, If it’s a dynamic volume, dynamic beverage, dynamic price it cannot be captured by BarTrack reports.
-
Adding Items - Make sure all items are entered in the system properly before ordering.
-
Avoid adjusting pricing on the fly. Using zero-priced items like Open Items causes reporting inconsistencies.
-
It’s recommended that you categorize your items correctly or they will show as Uncategorized.
Caveats
-
Open items are NOT SUPPORTED and will cause problems when using with beer items.
-
Those items that ask for a price can only be used in the following instance:
If the open beer SKU represents a static volume, a dynamic beverage, and a dynamic price, it can be treated under general sales.-
However, if it’s a dynamic volume, dynamic beverage, dynamic price it cannot be captured by BarTrack reports.
-
Timestamps Not Available
When we are not able to obtain timestamps from your system, these are the things that will be affected:
-
Out-of-hours pours (e.g., when a monitored beverage is poured outside business hours)
-
AM vs. PM Breakdown
-
Pour vs. sale analysis -(keg breakdown - matching algorithm)
-
Matching (including over-/under-pour)
-
Sub-day reporting (the API already supports it, but we’re not delivering anything based on it yet)
-
“Rotation” (where data from tomorrow is pulled into today for the purposes of reporting, e.g., midnight to 2AM)
MSSQL Customer Setup
This requires the BarTrack Software to be installed on the POS server. Some anti-virus and/or firewalls may need to be set up to allow the service to run in the background. Please allow a BarTrack support engineer access to the server for initial assessment or have your IT department reach out to us if you prefer to oversee the setup.
Download our remote access software to get started.
Click Here to Download
Installation
Setup requirements
- Microsoft SQL Server Management Studio (often already installed)
- Administrator access to the database server.
Setup Instructions
-
-
Open Microsoft Server Configuration Manager
- Enable Named Pipes and TCP/IP
- Double-click TCP/IP. Under the Protocol tab, make sure that Enabled = Yes and Listen All = Yes
- Click the IP Addresses tab, and then…
- Find the IP entry that matches your IP address, or change the one closest to fit yours.
-
To find your IP address, open a command prompt by clicking the start menu and typing “cmd”. See the two screenshots below.
-
Active = Yes
-
Enabled = Yes
-
TCP Port = 1433 (usually the default port)
-
Click “Apply” and then “OK” a couple of times until you’re back to the SQL Manager screen, which you can then close.
- Check to make sure the service is LISTENING.
- Open SMMS
- Connect with Windows Authentication (no password needed).
- Right click on the Database object, select Properties.
- Click the security page, and make sure Server Authentication is set to “SQL Server and Windows Authentication mode”. Press OK.
- Right click on Logins and create a new user.
- Create the user with the following details, DON’T CLICK OK YET.
DO NOT ENFORCE PASSWORD POLICY.
- Select the Server Roles page.
- Select User Mapping page.
- Enable the user
- Test the user is able to login, and you can select from a table to read it’s contents.
-
Setup Summary
- This integration reads data from the local MSSQL database. BarTrack needs access to the MSSQL database with read permission, mapped to the Foodtronix database. This must be done with the admin user who created the Foodtronix database originally. Usually this would be a Windows administrator user.
- Alternatively, you may have your IT person create a BarTrack user & password in the MSSQL database with read only access to the Foodtronix db,mapped to the Foodtronix database. SQL and Windows authorization mode must be enabled in the database security properties. Follow the MSSQL Integration for further instruction.
Omnivore
Supported POS Software: https://www.olo.com/omnivoreapi
Omnivore Micros Symphony
Required Info
- Simphony version
- Is it hosted?
- Name of the Property to be integrated
- Number of Revenue Centers to be integrated, and their names
If your Simphony version is 2.x or if your Enterprise is on-premise, please skip this section and move to the next. To proceed with our integration into your Simphony system, we request login information for EMC. If you are using a hosted version of Simphony, could you help us get a read-only user set up with permission to view settings from the enterprise level? In order to log in we will need:
- Server URL
- User Name
- Company
- Password
We also require Transaction Services. Please use the following information to reach out to Oracle or your re-seller to request they install, configure, and test Transaction Services for your system if you haven't already:
- License: Guest Facing Transaction Services
- Configuration: Add a POSAPI Client
- CAL: Add the Transaction Services role to a host workstation and allow CAL to install the required files
- Testing: Use TSDemoClient to confirm Transaction Services is functioning correctly
- Results: Reply to Omnivore Support with the Employee ID and RVC number (#) used for testing
Arryved
Arryved Customer Setup
Cloud Integration
This integration requires that you create a user in the Arryved portal with “portal admin” enabled and “reporting” permissions using our specified email address.
Setup Instructions
- Click Employees on the right navigation menu.
- Click View Employees in the sub-menu of Employees.
- Add a new employee with portal admin privileges of “REPORTING” to the profile.
- Create the user with this email address:
btverify@gmail.com
- Enable Portal Admin check box and save the user.
Bbot Customer Setup
Cloud Integration
This integration requires access to their API which is granted by the Bbot team.
Setup Instructions
Please contact Bbot to inform them that you will be allowing BarTrack access to your data.
Clover Customer Setup
Cloud Integration
This integration requires two string keys you may get by following the steps below. Please provide these two keys to BarTrack once obtained.
Setup Instructions
Part 1 - API Key Creation
-
Enable two-factor authentication (requirement of creating a token).
-
Click the green Create New Token button.
-
Name the token BarTrack and select the following “READ” roles:
- Click Save.
- The dialog will close. Then click the eyeball icon to show the hidden token. Copy the key and save it somewhere safe.
Part 2 - Obtaining Merchant ID
Digital Dining Customer Setup
Local Integration
This requires the BarTrack Software to be installed on the POS server. Some anti-virus and/or firewalls may need to be set up to allow the service to run in the background. Please allow a BarTrack support engineer access to the server for initial assessment.
Download our remote access software to get started.
Click Here to Download
Focus Customer Setup
Cloud Integration
This integration is setup by Focus.
FocusLink will no longer be available at some point in the undetermined future. Shift4 payments purchased this company and is migrating and/or standardizing the data from customers to their Lighthouse platform.
Setup Instructions
Please have the customer contact their Focus reseller to have this set up, and give permission for BarTrack to access your data.
Subscription to FocusCloud and Installation of FocusLink agent is required.
Foodtronix Customer Setup
Local Integration
Setup Summary
- This integration reads data from the local MSSQL database. BarTrack needs access to the MSSQL database with read permission, mapped to the Foodtronix database. This must be done with the admin user who created the Foodtronix database originally. Usually this would be a Windows administrator user.
- Alternatively, you may have your IT person create a BarTrack user & password in the MSSQL database with read only access to the Foodtronix database, mapped to the Foodtronix database. SQL and Windows authorization mode must be enabled in the database security properties.
Please see MSSQL Customer Setup for further setup details.
Future Customer Setup
Local Integration
Setup Summary
- This integration reads data from the local MSSQL database. BarTrack needs access to the MSSQL database with read permission, mapped to the Future database. This must be done with the admin user who created the Future database originally. Usually this would be a Windows administrator user.
- Alternatively, you may have your IT person create a BarTrack user & password in the MSSQL database with read only access to the Future db,mapped to the Future database. SQL and Windows authorization mode must be enabled in the database security properties.
Please see MSSQL Customer Setup for further setup details.
GoTab Customer Setup
Cloud Integration
This integration requires access to their API which is granted by the GoTab team.
Setup Instructions
Please contact GoTab to inform them that you want the BarTrack integration.
We will need your location ID.
Harbour Touch / Skytab Customer Setup
- Click "Profile & Settings" on the left navigation menu toward the bottom.
- Create the bartrack user with the following email:
technology+yourbusinessnameherewithoutspaces@bartrack.beer
Do not use spaces or special characters
- Click “User Permissions” tab and remove all check marks except for reports.
- Click the “Locations” tab and select your location(s), and then “Create User” button.
Heartland Customer Setup
Cloud Integration
-
Create a new permission
Once logged into your Heartland portal as an admin, click the "permissions" link in the left navigation menu.
-
Save new permission
Create a new permission that looks like the following, and click the save icon.
-
Create a new user
Click the “Users” link on the left navigation menu and then click the NEW button.
-
Save user details
Fill out the user details.
- Make sure you set a location, and the permission you just defined by selecting Choose or Select a Permission.
Add the following user and click the save icon.
-
Await verification
An email will be sent to BarTrack for verification, please make sure we get this as soon as it’s sent.
Northstar Customer Setup
Cloud Integration
This integration requires access to their API which is granted by the Northstar team.
Setup Instructions
Please contact Northstar to inform them that you will be allowing BarTrack access to your data.
Restaurant Manager Customer Setup
Local Integration
This requires the BarTrack Software to be installed on the POS server. Some anti-virus and/or firewalls may need to be set up to allow the service to run in the background. Please allow a BarTrack support engineer access to the server for initial assessment.
Download our remote access software to get started.
Click Here to Download
Installation Requirements
- Password to Restaurant Manager (we prefer having an account made for BarTrack)
This password should give us access to creating report groups and custom reports and assigning a security level to BarTrack custom group
- Windows username/password with Administration security level (we prefer having an account made for BarTrack).
- Windows 10 create user, see:
- Windows 7 & 8 create user, see:
Best Practices
-
If third-party deliveries are discounted to 0, but not with a coupon because the tax is already paid at the third party. If you deal with these orders in a different way, WE NEED TO KNOW THIS.
-
We need to create a revenue center for this and initiate all orders of third-party type with this Revenue Center.
-
We add these discounts back into the price of the item since the price paid becomes 0, which is technically untrue.
-
Adding Items - Make sure all items are entered in the system properly before ordering.
-
Avoid adjusting pricing on the fly, or using zero priced items like Open Items cause reporting inconsistencies.
Technical Caveats (POS Dealer/Support Info)
SmartTab
SmartTab Customer Setup
Cloud Integration
- Open the staff area.
Once logged into your SmartTab portal as an admin, click the “staff” link in the left navigation menu.
- Create a Bartrack role
Create the “Roles” tab at the top of the main window. Create a “Bartrack” role by typing the name on the left input and then clicking the “Add Role” button.
Click the edit pencil icon on your new BarTrack role.
Select the following reports: Sales, Products, Inventory, Tabs. Save the settings by clicking the check mark. - Create a new user.
Click the “Users” tab at the top left of the main window. Fill out the details as shown.
Save the user.
SpotOn
SpotOn Customer Setup
Official Integration
Direct customer to this link to fill out a form that gets sent to SpotOn:
https://docs.google.com/forms/d/e/1FAIpQLScFIq2G1q753bJD-ckXfTB5Ifo0ftM1TZJIqptBF2KiI92_uw/viewform
POS Integrations team will receive an email from SpotOn. At this point, allow up to 24 business hours for data to start being available.
Unofficial Integration (not supported)
Invite our user to SpotOn via SpotOn Support.
-
Have the customer use the following template below to request access from SpotOn.
- SpotOn Support Email: restaurantpos@spoton.com
Hi Neighborhood Tap House Team,
In order to connect with Spot-On with BarTrack and gain access to your beverage reporting, we require a very small task from you. All we need is for you to send an email to Spot-On so they can give us the proper access we need to provide you with your BarTrack reporting. Failure to do this or changing the message can result in BarTrack having issues connecting with your point of sale system, so it is important that you copy and paste exactly what we say.
Please copy the following message and send it to SpotOn Support, and cc "xmlathropx@gmail.com":
--
Hello,
I need to add a new manager to my Restaurant Reporting. I will need you to give [xmlathropx@gmail.com] full access to my locations' restaurantreporting.spoton.com - please let me know when this is complete.
Thank you!
Square Customer Setup
The account owner needs to perform the steps outlined to generate an Access Token and Application ID. Make sure that production is toggled.
- Open the Developer Dashboard (https://developer.squareup.com/apps) and select an existing application (or create one - call it "BarTrack")
- Set the dashboard mode to Production for a production access token
- Copy the Access Token and Application ID in the Credentials section of the page
Documentation Reference link: https://developer.squareup.com/docs/build-basics/access-tokens
Toast
Toast Customer Setup
Cloud Integration
Touchbistro Customer Setup
- Click on the Staff link in the left-hand navigation menu upon logging in with an administrator account.
-
Invite us to your account with an Analyst role. Select the Venus dropdown and check all the boxes next to locations to enable our access to these.
- Click save. That's it, we'll get an invite email saying you've set us up, so we can complete the integration setup on our end.