Overview

The integration with Clover Sports is a 1Way integration in which Clover Sports posts sales data to Yellow Dog’s Webhook URL, and Yellow Dog processes that data to deplete inventory. 

NOTE:The original sales file method is no longer supported. If your store is still using this method, please contact support to be added to the upgrade calendar.

Sync Approach

The interface contains three main elements:

  • Clover Sports’ process to post sales data to Yellow Dog’s Webhook URL

  • Yellow Dog’s sync application to

    • pull location and item codes from Clover Sports API for mapping

    • pull sales into the Yellow Dog database, match those sales to items and decrement inventory

  • Yellow Dog’s ProcessSales application to update reports

Sync Frequency

CloverSports posts transactions to the webhook immediately, and the Yellow Dog sync application is scheduled to pull and process sales every 15-30 minutes 

Configuration

The integration supports the following configurations: 

  • Multiple instances of Clover Sports to a single Yellow Dog database but will require a separate sync set up for each instance

  • Multiple Clover Sports revenue centers to a single Yellow Dog Store

The integration does not support the following configurations:

  • Multiple Yellow Dog databases to a single instance of Clover Sports

Requirements

Client

  • Determine how sales will be matched to items

    • POS Item Mapping 

    • Match on SKU - Yellow Dog and Clover Sports SKUs must match

    • Match on Barcode - Yellow Dog UPC and Clover Sports SKU must match

  • Determine whether they want to see modifiers concatenated 

  • Confirm which locations in CloverSports should be mapped to which stores in Yellow Dog

POS Partner

  • Provide the API Key

  • Complete their portion of the setup process once Yellow Dog has provided the Webhook URL

Yellow Dog

  • Provide CloverSports the Webbook URL to complete their portion of the setup process 

Data Exchange

Sales Data

We pull in the following sales data as provided by Clover Sports: 

Yellow Dog Field Clover Sport Field
Revenue Center check.LocationId
TransactionNumber check.Id
TransactionLineNumber line.Uuid
CheckClosed check.CreatedAt
ItemNumber line.Item.Id
SKU line.Sku
Item line.Item.Name
ItemRetail (always positive) line.UnitPrice
ItemDiscount (always negative) line.DiscountAmount / line.Count
DiscountDescription line.DiscountName
Quantity line.Count
EmployeeNumber n/a
EmployeeName n/a
Tender n/a
Reference n/a
RegisterNumber n/a
RegisterName n/a
Order Status check.State
Order Number check.FriendlyId

Modifiers are supported with this integration

Workflows - Where performed

Workflows

Workflows Done in YD Done in POS
Create POS Item x x
Create Stand Item x x
Create Menu Item x x
Create Modifier x x
Modifier Assignment to Item x
Screen Placement for Item x
Discount Setup x
Discount Assignment to Item x
Tax Setup x
Tax Assignment x

YD Action & Result in POS

YD Action Result in POS
Item Creation None
Item Edit/Update None
SKU Edited None; but if matching sales on SKU a change to the SKU in YD will affect what POS Item sales are matched to which YD item
UPC Edited None; but if matching sales on UPC a change to the UPC in YD will affect what POS Item sales are matched to which YD item
Inactivated None
Removed None
Level Is Changed None
Item is configured to Push to POS None
Publish set to "No" None
POS Blocked None
Unchecked availability to one store/location None
No longer available to Any Store/Location None
Image added to item in YD None
Image removed from item in YD None
Item removed from Sales Channel None
On Hand changed in Yellow Dog None

POS Actions & Result in YD

POS Actions Result in YD
Item Returned The sync uses whatever line item quantity Clover Sport sends; i.e., even if Clover Sport marks a line as refunded, if the line still has a positive quantity (indicating a sale and not a return) the line in Yellow Dog will reflect the sale quantity and not a return quantity.
Item Voided The sales quantity will be set to 0 and will have no effect on the YD item's on hand
Previous Check Voided The sales quantity will be set to 0 and will have no effect on the YD item's on hand
Item created in POS, not in YD Sales will still be pulled in to YD, but will not match to any YD item
Item deleted in POS None
Item properties changed in POS, not in YD None
Item sold at POS but is Removed in YD Sales will match to the item and the item will be un-removed in YD because the on hand will be <> 0
Item sold at POS but is Inactive in YD Sales will match to the item
Menu item sold at POS Populates in YD POS Item Mapping
Menu item created at POS but not sold Populates in YD POS Item Mapping Unsold Items
Modifier created at POS but not sold Populates in YD POS Item Mapping Unsold Items
Modifier sold at POS Populates in YD POS Item Mapping
Image deleted at POS, not in YD None

Accounting Integration Ability from POS

Accounting Integration Ability from POS Supported Details
POS Sales - Itemized
POS Taxes
POS Tender Type
POS Discounts
Total Net Sales x (Retail*Quantity-Discounts)

Additional Information

Limitations

  1. Only new sales sync — no history: Because this integration works through a webhook, Yellow Dog can only pull in sales created in Clover Sports after the webhook connection is set up. Sales that happened before that point won't come over.

  2. Modifiers use a generated SKU, not a real code: Clover Sports doesn't provide a specific code for modifiers, so the sync creates one automatically by taking the modifier's name and removing all spaces.

  3. The sync uses whatever line item quantity Clover Sports sends; i.e., even if Clover Sports marks a line as refunded, if the line still has a positive quantity (indicating a sale and not a return) the line in Yellow Dog will reflect the sale quantity and not a return quantity.