Clover Sports - 1 Way Interface
Last Updated: 2/8/2024
Overview
The integration with Clover Sports (formerly Bypass) supports a 1-Way Integration using our CloverSportsConsole app.
Sync Approach
This interface contains two elements:
Clover Sports will provide a CSV file every 15 minutes to a shared FTP location. Yellow Dog’s CloverSportsConsole app will then pick up and process the file to pull in sales data.
After the CloverSportsConsole has ran, Yellow Dog’s Process Sales application will run to populate sales reports.
Sync Frequency
This integration supports a manual queue that will allow for sales to be processed manually on demand by the client or can be scheduled every fifteen minutes.
Configuration
This integration will support multiple instances to a single Yellow Dog database but will require a separate sync set up for each instance with a separate FTP configured.
Requirements
Client
The Client will need to provide the following:
Venue IDs
Locations IDs
Mapping of Locations IDs to YD St
The client will need to assist with the mapping of SKUs between both systems.
POS Partner
Clover Sports will be responsible for setting up the FTP location, providing the credentials, and setting up the file export for every 15 minutes to that location.
Yellow Dog
Yellow Dog will configure and schedule the console app along with our Process Sales application. Yellow Dog also requires a database version of 375 or higher.
Data Exchange
Sales Data
We pull in the following sales data:
| Yellow Dog Field | Clover Field |
|---|---|
| Revenue Center | Venue ID |
| Transaction Number | Order UD |
| Transaction Line Number | Line Item UUID |
| CheckClosed | OrderCreated |
| Item Number | Item ID (this is unique in Bypass) |
| SKU | SKU (this may NOT be unique in Bypass) |
| Item Description | Item Name |
| Item Retail | unit_price |
| Item Discount | Adjustment Amount where Adjustment Type = Discount |
| Discount Description | n/a |
| Quantity | Quantity |
| Employee Name | Order Taker ID |
| Employee Number | Order Taker Name |
| Register Number | Device |
| Check Discounts | Adjustment Amount where Adjustment Type = Discount |
| Modifiers | Modifier Name |
| Modifier Price | Modifier Cost |
| Modifier SKU | Modifier ID |
| Order Status | Order State |
| Order Number | Order Friendly ID |
Additional Information
Note: This integration should be able to support multiple instances of Clover Sports against a single Yellow Dog database, but this has not been tested.
Limitations
We are unable to use Tax or Tender data.
We have no way to pull in LocationIDs for mapping to Stores; those must be provided by the customer.
Unsold items are not supported; we have no way to pull them in.
Recipes and Items will not be able to be mapped until Menu Items are sold in the POS
All discounts are per check.
The Modifier ID provided in the file from Clover is not actually an ID for the modifier (8/18/2023)
We work around this by using Modifier Name with spaces removed and UPPERCASED to uniquely identify modifiers
To match sales to a modifier item in YD, this will need to be added as a UPC to the modifier in Yellow Dog
