Overview

With our POSitouch interface, Yellow Dog Inventory pulls sales and code data from and pushes item data to POSitouch.

This two-way interface can be scheduled at a frequency and time of your choosing. However, based on the volume of data in POSitouch, we have seen the sync take significant time to generate the POSitouch dbfs. We highly recommend that this sync be run just once a day and/or during periods when operations are closed.

Requirements

Yellow Dog Requirements

Yellow Dog Inventory will need a specific item numbering range in POSitouch to populate all items. 

Yellow Dog Inventory will pull dbf files to gather a listing of all items currently in POSitouch along with specific codes which will include:

  • Revenue Centers
  • Major Categories
  • Minor Categories
  • Item Numbers
  • Item Tax Codes
  • Item Discount Codes
  • Item Price Levels

Back Office Setup Requirements

This interface will work with any version of POSitouch that produces the dbf files as detailed in POSIDBF dated 10/21/14.

The existing POSitouch items and modifiers may need to be reconfigured so that the proper item is listed in the sales information. Yellow Dog can review your setup prior to your acceptance of the proposal to identify what you and your POSitouch team will need to do to allow our inventory system to work properly.

The item range (number of items supported by your POSitouch System) and breakpoint (number which items are designed as ingredients) must be set appropriately. Please contact your POSitouch team for further information and assistance.

Customer will be responsible for adding any necessary codes, POS menu screens and buttons for new items created in Yellow Dog and pushed to POSitouch.

Servers

The Yellow Dog Sync program will need to be installed on a server that can access the folder where the POSitouch dbf files are populated.

Yellow Dog will need to have remote access to this server. We can provide access via our tool called TeamViewer or we can utilize your internal remote access methodology.

Data Exchange

Exporting Item Data

Our sync application, SyncYdiWithPOSitouch, generates an item file and launches POSitouch’s import utility, Indat.xml, to push items in to POSitouch.

We pass the following data to POSitouch:

POSitouch Field NameField DescriptionLengthYellow Dog EquivalentInterface Setup
Item NumberMenu Item Number5POS Item NumberAuto Generated
Item DescriptionDescription of Menu Item 5POS 1 DescriptionManually Entered
Major Category (Required)rMenu Item Major Category1NoneDropdown Selection
Minor Category (Required)Menu Item Minor Category2NoneDropdown Selection
Price 1Price (Currency, as 0.00)Retail 1Manually Entered
Price 2Price (Currency, as 0.00)Retail 2Manually Entered
Price 3Price (Currency, as 0.00)Retail 3Manually Entered
DiscountsString of 16 characters, either “Y” or “N”16NoneDropdown Selection
Tax EligibilityString of 4 characters, either “Y” or “No”4NoneManually Entered
BarcodeBarcode Field12UPC1 or SKU if no UPC1Manually Entered
Price 4Price (Currency, as 0.00)Retail 4Manually Entered
Price 5Price (Currency, as 0.00)Retail 5Manually Entered
Price 6Price (Currency, as 0.00)Retail 6Manually Entered
Price 7Price (Currency, as 0.00)Retail 7Manually Entered
Price 8Price (Currency, as 0.00)Retail 8Manually Entered
Price 9Price (Currency, as 0.00)Retail 9Manually Entered
Price 10Price (Currency, as 0.00)Retail 10Manually Entered
Extended DescriptionExtended Description10POS 2 DescriptionManually Entered
Food CostCost (Currency, as 0.00)CostAutomatically Calculated

Importing Sales Data

SyncYdiWithPOSitouch launches a utility in POSitouch that generates the sales data into .dbf files which we then read.

This sync can pull sales data up to 30 days back and will use the following dbfs for sales information:

  • CHKHDR.dbf
  • CHKITMS.dbf
  • MENUITEM.dbf
  • USERS.dbf

Importing Code Data

SyncYdiWithPOSitouch reads the following dbfs for code data:

  • MENUITEM.dbf
  • NAMES.dbf

Implementation

The implementation will begin once your POSitouch office has confirmed that it can accommodate all of the above prerequisites and requirements.

Additional Information

POSitouch Limitations

As stated in the overview above, the sync can run at any interval, but because it can take a considerable amount of time to generate the .dbf files, we recommend that it only be run once per day when operations are closed.

Running the sync when operations are closed is also important because the POSitouch back office may be open, but item and menu editors must be closed in order for the sync to run. If one of the POSitouch back office inventory programs (MENUW.EXE or INW.EXE) is open when SyncYdiWithPOSiTouch launches, the sync will close the back office editor in order to run.

The following are limitations to items in POSitouch:

  • POSitouch is limited to a total of 64,000 items.
  • POSitouch Item Numbers are limited to 5 digits.
  • In POSitouch, each item is allowed one UPC/Barcode only, up to 12 characters, in any format.
  • Check Digit must be 12.

After pushing new items and performing an Immediate System Change to POSitouch, new items can be scanned at the POS to be added to a check.  New items will not appear until the Immediate System Change has occurred.  End user will need to manually assign items to touchscreen and perform any setup related to a touchscreen.

Yellow Dog is able to push in modifiers, but they appear as regular items in POSitouch and must be set as modifiers/choices when configuring touchscreens. 

Items that are set to inactive or removed status in Yellow Dog will no longer have a barcode in POSitouch after the change is synced. As a result, the item will no longer be able to be scanned at the POS, but it will need to be manually removed from any touchscreens and then an Immediate System Change will have to be performed to prevent menu sales.

Though we pull discounts, we do not currently pull discount descriptions.

Support

Yellow Dog Software will support the interface. Any issues regarding the generation of the dbf will need to be handled by your POSitouch office/dealer.