Gilbarco Interface
Overview
Yellow Dog Inventory's 2-Way interface synchronizes data with Gilbarco. The integration pushes new and updated items to Gilbarco while pulling in sales and returns to Yellow Dog.
Sync Approach
The sync application will push a data file to the BOInbox shared folder and will pull transaction data from the shared folder BOOutbox.
Sync Frequency
Yellow Dog Inventory syncs to the Gilbarco Passport POS once every hour.
Requirements
POS Partner
The following settings must be updated in Gilbarco prior to running the Yellow Dog Inventory Sync application.
In the Management Interface, navigate to Set Up --> Store --> Back Office Interface -->XMLGateway Polling Options tab.
Interface Format must be NACS XML v3.3.
Enable XMLGateway File Polling must be checked.
Fill in Backoffice User Name (might be BackOffice).
Fill in Backoffice Password (might be BackOffice).
Fill in Directory Path to Pull XML Files From (might beC:\Passport\XMLGateway\BOInbox).
Fill in Directory Path to Push XML Files To (might beC:\Passport\XMLGateway\BOOutbox).
Yellow Dog will need access to the BOInbox and BOOutbox file locations to install our sync.
Yellow Dog
Yellow Dog Inventory must have the following information to fully interface with Gilbarco:
• A complete list of Revenue Center names and numbers that will contain retail inventory.
• Merchandise Codes and Descriptions
• Item Type Codes and Descriptions
• Item Type SubCodes and Descriptions. This may be empty.
• Payment System Product Codes and Descriptions
• Tax Strategy IDs and Descriptions
Data Exchange and Mapping
Sales Data
| Gilbarco Field Name | Yellow Dog Field |
|---|---|
| TransmissionHeader\StoreLocationID | Revenue Center |
| JournalReport\SaleEvent\EventEndDate | Check Closed Date |
| JournalReport\SaleEvent\EventEndTime | Check Closed Time |
| JournalReport\SaleEvent\TransactionID | Transaction Number |
| JournalReport\SaleEvent\CashierID | Employee Number |
| JournalReport\SaleEvent\TransactionDetailGroup\TransactionLine | Transaction Line Number |
| ItemLine\ItemCode\POS Code | SKU |
| ItemLine\Description | Item Description |
| ItemLine\SalesQuantity | Quantity |
| ItemLine\ActualSalesPrice | "ActualSalesPrice"/"SalesQuantity"= Item Retail |
| ItemLine\DIscount\DiscountAmount | Discount |
| ItemLine\Discount\DiscountReason | Discount Description |
| ItemLine\MerchandiseCode | Merchandise Code |
Additional Information
Limitations
1. Yellow Dog does not process fuel sales.
Other Notes
Pre-paid fuel transactions with inventory items on the same transaction will report as duplicate transactions in Yellow Dog. (5/21/24
While we are not aware of any license and/or labor fees required by Gilbarco, please contact your Gilbarco Representative to confirm this information.
