Overview

Yellow Dog Inventory pulls sales data from SilverWare's API to reduce inventory based upon sales and the Silverware Sync pushes updated item data from Yellow Dog into .csv files. Those files are imported into SilverWare once SilverWare's import process is complete. 

Sync Approach

This interface contains two elements:

  • Yellow Dog’s sync application

  • Silverware’s import application

The Yellow Dog sync must be run on the SilverWare Server.

Sync Frequency

Our sync can run at any point and is set up to automatically run at the top of every business hour.

Configuration

This integration supports the ability to connect multiple SilverWare instance to a single Yellow Dog Database.

Newer versions of SilverWare also support the abililty to import mulitple barcodes. Please consult with your SilverWare rep to evaulate your version of their software supports this functionality.

This integration also supports a 1-Way integration for FB Clients.

  • With the one-way integration we also have the ability to pull daily totals of tax, gratuity, service charge, and tender per Revenue Center.

Requirements

Client

 .Net 4.6.2 must be installed on the SilverWare server(s) where this sync will run.

POS Partner

SilverWare must configure their server(s) to allow us to access the API.

SilverWare is responsible for configuring and scheduling their import process and providing access to the shared folder for our export file.

Silverware will need to provide the following:

  • Silverware Cost Centers

  • Starting Number Item range

  • API URL 

  • API Key 

  • Token for each Silverware Server.

  • Set up import process 

  • Provide access to the shared folder for our export file.

  • Export of any pre-existing items

  • Disable the feature in Silverware to prepend "YD" onto ItemNumbers

Yellow Dog

Yellow Dog will need to assign Silverware Cost to the correct Store(s) in Yellow Dog.

Responsibilities

Client

If using SilverWare 1-Way integration to pull in sales, the client will be responsible for mapping recipes and inventory items to items sold at the POS.

POS Partner

TBD

Yellow Dog

Yellow Dog will need to ensure that a starting number range is configured for Items.

Data Exchange and Mapping

Sales Data

Yellow Dog's sync with SilverWare pulls sales data from the local SilverWare API on each SilverWare server.

Silverware Field YD Field
ThirdPartyIDSilverware_{sale.CostCenterID}_{sale.Check.ID}
Converted{thirdPartyId}_{sale.ID}
Revenue CenterCost Center
sale.Check.NumberTransaction Number
sale.SequenceTransaction Line Number
sale.Check.DateClosedCheck Closed
item.Prices[0].InterfaceIdItem Number
item.Prices[0].InterfaceIDSKU
Item.DescriptionItem
sale.UnitPrice or (sale.NetAmount + sale.DiscountAmount / Quantity)Item Retail
sale.DiscountAmount \ QuantityItem Discount
sale.QntyQuantity
sale.UserId>employee?.InterfaceEmployee Number
employee?.AliasEmployee Name
sale.StationID>register?.InterfaceIDRegister Number
register?.NameRegister Name

Item Data

We export the following item properties to SilverWare via a .csv file that the SilverWare Import process consumes:

YDI Field SilverWare Field
UPC1, else SKU Barcode (If Multi-Barcode support in enabled, All UPCs and SKU will be exported and separated by a "|". If Multi-Barcode Support is not configured, only 1 UPC will be exported)
Description Name
ItemCost Cost (average cost of the item across all Yellow Dog stores)
ItemRetail Retail
CurrentOnHand On Hand (sum of an item's on hand across all Yellow Dog stores)
Generic CodeA Minor Class (Required)
ItemNumber InterfaceID (We prepend 'YD' to any items created in Yellow Dog)
Active Active/Inactive

All new items created in Yellow Dog and exported to SilverWare will have SilverWare Interfaces IDs prepended with "YD".

Newer versions of Silverware support multiple barcodes. Please reach out to Silverware to determine if an upgraded is needed in order to use this feature.

System Codes

Our sync pulls in a listing of all Minor Classes in SilverWare.

Additional Information

This sync supports multiple revenue center codes per Yellow Dog store.

This integration is compitable with YDI Version 372.

Limitations

  1. SilverWare does not support per store item settings; as a result, we export an item's average cost and a sum of the item's on hand across all stores in Yellow Dog, and all retail prices for an item must be consistent across all stores in Yellow Dog.

  2. Yellow Dog will push a UPC for each item if one is assigned; if there is not a UPC assigned to the item, Yellow Dog will push the SKU.

  3. SilverWare includes taxes in Unit retail so our sync calculates Item Retail using their (NetAmount - NetDiscounts) / Qty

  4. Cost Centers per instance are expected to be unique.

  5. 'Pull Daily Tax Gratuity And Payments’ checkbox in sync v2024.07.01.375 and higher is intended for one-way integrations ONLY.