POSitouch - 2 Way Interface
With our 2-Way interface with POSitouch 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. Based on the volume of data in POSitouch, the sync takes significant time to generate the POSitouch dbfs. We strongly recommend this sync be run just once per day and/or during periods when operations are closed.
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.
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.
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 Name||Field Description||Length||Yellow Dog Equivalent||Interface Setup|
|Item Number||Menu Item Number||5||POS Item Number||Auto Generated|
|Item Description||Description of Menu Item||5||POS 1 Description||Manually Entered|
|Major Category (Required)r||Menu Item Major Category||1||None||Dropdown Selection|
|Minor Category (Required)||Menu Item Minor Category||2||None||Dropdown Selection|
|Price 1||Price (Currency, as 0.00)||Retail 1||Manually Entered|
|Price 2||Price (Currency, as 0.00)||Retail 2||Manually Entered|
|Price 3||Price (Currency, as 0.00)||Retail 3||Manually Entered|
|Discounts||String of 16 characters, either “Y” or “N”||16||None||Dropdown Selection|
|Tax Eligibility||String of 4 characters, either “Y” or “No”||4||None||Manually Entered|
|Barcode||Barcode Field||12||UPC1 or SKU if no UPC1||Manually Entered|
|Price 4||Price (Currency, as 0.00)||Retail 4||Manually Entered|
|Price 5||Price (Currency, as 0.00)||Retail 5||Manually Entered|
|Price 6||Price (Currency, as 0.00)||Retail 6||Manually Entered|
|Price 7||Price (Currency, as 0.00)||Retail 7||Manually Entered|
|Price 8||Price (Currency, as 0.00)||Retail 8||Manually Entered|
|Price 9||Price (Currency, as 0.00)||Retail 9||Manually Entered|
|Price 10||Price (Currency, as 0.00)||Retail 10||Manually Entered|
|Extended Description||Extended Description||10||POS 2 Description||Manually Entered|
|Food Cost||Cost (Currency, as 0.00)||Cost||Automatically 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:
Importing Code Data
SyncYdiWithPOSitouch reads the following dbfs for code data:
The implementation will begin once your POSitouch office has confirmed that it can accommodate all of the above prerequisites and requirements.
- 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.
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.