Bottlecapps has a partnership with over 60 different point-of-sale systems that utilize a wide range of software suites to assist retailers with their in-store sales. The integration with each of these systems can be broadly categorized as follows:

On Premise Database:

This type of point-of-sale system usually has a designated server that houses all the data related to the products and various attributes associated with it. The most common database used for such systems is SQL Server. Bottlecapps requires you to download a remote login software such as TeamViewer to facilitate the integration with our webconsole. 

Once TeamViewer is installed, please proceed to providing the TeamViewer ID and Password to your Bottlecapps Onboarding Manager. Our Data Integrations team will then access the server remotely to install a “Mobile App Updater” that can be set to run as frequently as you would like. The recommended frequency is once every hour although this can be changed to run every 15 minutes or 30 minutes if needed.

The Mobile App Updater (MAU) connects to the database in the server and generates a file that is mapped to the Bottlecapps file specifications. This file is in CSV format and contains all the product attributes such as SKU, UPC, Product Name, Description, Retail Price, Sale Price, Tax rates, Categories and so on. The file is then sent to a specific folder within our server and processed within 10 minutes of the file being sent. This ensures accurate inventory information for your customers.

Cloud Based:

This type of point-of-sale system is a more modern version of the On Premise Database system. A cloud-based point-of-sale (POS) system enables businesses to process transactions and manage sales data using internet-connected devices. It stores information on remote servers, providing real-time access to sales data from anywhere, facilitating inventory management, analytics, and customer relationship management. Bottlecapps can connect to many of these systems using an API (Application Programming Interface) that many companies offer. This usually requires a set of authentication values like a Client ID and Client Secret Key that should always be maintained securely to prevent any unauthorized use. 

By reaching out to the service provider and receiving the keys, Bottlecapps will proceed to generate a file per the file standards and set up the data feed. 

An advantage of a cloud based point-of-sale system is the ability to allow order inserts. This prevents a need to manually input any online orders received through the app or website.

Mapping Tool:

The Bottlecapps Mapping Tool is used for a select few point-of-sale systems that are cloud-based, yet do not have an API (Application Programming Interface) that Bottlecapps can use to connect. If there is no API that we can use to connect to the system but the software allows an export of the data within the system, Bottlecapps can create a tool that converts the data within this exported report to the Bottlecapps file specifications to update the inventory. 

The Mapping Tool can work in 2 ways:

2. 
   
   The selected file will then be securely sent to the Bottlecapps server and processed within the next 15 minutes.

This process can be repeated as many times as needed to maintain accurate inventory information.

Flat File:

Bottlecapps webconsole has a wide range of features for stores that are not inventory controlled or do not use a retail point-of-sale system. The retailer can choose to create their own curated list of products to sell online, or use a flat inventory quantity for all the items they maintain on their own. 

The inventory can be maintained by logging in to liquorapps.com -> Prices & Inventories tab:

Select the items to be edited by clicking the Edit option right next to the item, and modify all the content to be edited. When done, hit the Update button and it will reflect the changes online immediately.