Overview

Skywire POS consumes the Yellow Dog API for a 2-way Integration. This integration allows Skywire POS to recieve new or changed items from, as well as post sales transactions to Yellow Dog. .

Sync Approach

Skywire POS pulls new and updated Retail Items from Yellow Dog and pushes transaction data to Yellow Dog.

The Integration consists of two elements:

  • Skywire’s processes to pull items and post sales.

  • Yellow Dog’s Process Sales Application to process transactions provided by Skywire in order to deplete inventory

Sync Frequency 

The push and pull of data is controlled by Pebble and can be configured to run every 15 minutes, every 4 hours, hourly or daily.

Yellow Dog’s Process Sales Application will be scheduled to run hourly by default.

Configuration

Yellow Dog will be the source of record for all items in Skywire. All items and updates will be created and maintained in Yellow Dog.

Multiple instances of Skywire to a single Yellow Dog database is supported, though this has not been tested.

Multiple Revenue Centers to one Yellow Dog store is not supported in this integration.

Requirements

POS Partner

Skywire is responsible for configuring and scheduling the integration.

Additionally they are responsible for populating all of the interface codes used in this integration and assisting the customer with assigning those interfaces appropriately in Yellow Dog.

Yellow Dog

Yellow Dog will need to provide the following detail to Skywire to provide API access:

  • Client ID

  • Username

  • Password

Yellow Dog Integrations Installation Team member will need to set up and schedule the Process Sales Application and ensure the generation of Descriptions and POS Description 1 in Yellow Dog is unique.

Responsibilities

Client

The client is responsible for

  • providing Profit Center External IDs to be used for revenue center mapping.

  • configuring required Item Interfaces in Yellow Dog and ensuring that all item configuration requirements are met in Yellow Dog for Pebble to pull items.

Data Exchange and Mapping

Sales Data

Skywire FieldYellow Dog Field
Order.Id+Check.CheckNumberThirdPartyID
Mapped using Check.RevenueCenter.ExternalIDStoreId
Order.HumanReadableOrderIDTransactionNumber
Product.SequenceNumberTransactionLineNumber
Check.LocalClosedDateTime converted to UTCCheckClosed
Product.ExternalIdItemNumber
n/aSKU
Product.NameItem
Product.MenuPriceItemRetail
Negative sum of Product.Discounts divided by the quantityItemDiscount
Comma Seperated list of discount namesDiscountDescription
Product.QuantityQuantity
Comma Seperated list of discount namesDiscountDescription
CheckOwner.ExternalIdEmployeeNumber
Comma Seperated list of discount namesDiscountDescription
CheckOwner.FirstName,CheckOwner.LastNameEmployeeName

Items Data

Skywire FieldYellow Dog Field
ExternalIdID
NameDescription
Short NamePOS Description 1
SKUSKU
BarcodesUPC
Parent External IDParentItem.id
Revenuecenter.ExternalIdStore Code
Store On HandQuantity
Default PriceRetail Price 1
CostVendor Price (when marked as Primary)
Menu Group IDInterfaces/PebbleMenuGroup 1-5
Product GroupsInterfaces/PebbleProductGroup 1-5
Printer GroupInterfaces/Pebble Printer Group
Service Charge GroupInterfaces/Pebble Service Groups
Tax GroupPebble Tax Group
Revenue TypeInterfaces/Pebble Revenue

Codes

Skywire populates interfaces codes needed for this integration through Yellow Dog’s API. Once these are populated, they can then be mapped to items in Yellow Dog.

  • Menu Group 1-5

  • Product Group 1-5

  • Tax Groups

  • Revenue Type

  • Printer Group

  • Service Charge Group

Accounting Export Ability:

N/A

Variations:

Matrix items are NOT supported at ALL, and parent child items CAN be supported but they MUST have different Descriptions in Yellow Dog. See limitations.

Modifiers:

Supported in sales data only; modifiers cannot be pushed from YD to Pebble. System Codes: See code mapping above.

Workflows and Actions

WorkflowYellow Dog InventorySkywire POS
Create POS Itemsx
Create Stand Itemsx
Create Menu Itemx
Modifer Creation x
Modifer Assignment to Items x
Screen Placement for Items x x
Discount Setupx
Discount Assignment to Item x
Tax Group Setupx
Tax Group Assignment x
Product Group Setupx
Product Group Assignment x
Revenue Type Setupx
Revenue Type Assignmentx

Additional Information

Limitations

  1. Product import requires special fields set up in Yellow Dog (6/25/24)

  2. Potential Rounding errors with discounts in sales (6/25/24)

  3. All products are individual in Skywire. They are not shared between revenue centers. However, Pebble has designed their import to work with YD's system. In the GET Items call, they expand the Stores property so that they can know which stores the YD item belongs to. They use this to add that one item to each of the matching RevenueCenters on Skywire’s side. So if there is a Pepsi that belongs to 3 different stores in YD, that Pepsi will be created 3 times in Skywire’s system (once per store) and assigned to the proper revenue center. (6/25/24)

  4. Items in a matrix CANNOT be imported into Pebble because all items in the matrix share the same description (name in Skywire) (6/25/24)

  5. Parent Child items CANNOT have the same description in Yellow Dog (Name in Skywire) (6/25/24)

  6. If Menu Group assigned in Yellow Dog is not already assigned to Product Group in Skywire assigned to the same item in YD, the Menu Group in Skywire will have to be assigned to the Product Group in Skywire (6/25/25)

  7. In order to pull vendor price from YD into the Cost field for the item in Pebble, Primary Vendor must be set on the vendor product that they want the vendor price pulled from. (6/25/24)

  8. SKUs ARE scannable as of v4.40.3 of Skywire’s POS system and higher only.
    SKUs are NOT scannable in earlier versions of Skywire, but SKUs can be used as a lookup at the POS even in those earlier versions. (8/20/24)