Overview

Yellow Dog and Gateway sync item and sales data as follows: Yellow Dog exports item data to a .csv file that is then consumed by Gateway, and Gateway posts sales data to Yellow Dog’s API.

Sync Approach

This integration contains four elements:

  • Yellow Dog’s GalaxyConsole sync application to export item data, installed on the Galaxy server.

  • Galaxy’s process to consume the item export file.

  • Galaxy’s process to post sales data to Yellow Dog’s Fetch API.

  • Yellow Dog’s Process Sales application to match sales to items in Yellow Dog, adjust on hands, and update sales reports.

Sync Frequency 

Item updates are normally synced once per day.

Sales data is posted to Yellow Dog’s API in real time, but sales processing is completed at most once per hour and at least once per day.

Configuration Options:

This integration can support 

  • multiple instances of Galaxy against a single instance of Yellow Dog

  • multiple Galaxy Revenue Centers per Yellow Dog Store for sales only

This integration will only export item data from a single Yellow Dog Store per Galaxy instance.

Requirements

Client

  • Galaxy ItemImport v7.8.15.9 or higher

  • Provide Yellow Dog access to the Gateway server to install Yellow Dog’s GalaxyConsole application to export item data

  • Provide lists of the following options from the POS:

    • Full AccountIDs

    • DiscountGroup

    • TaxFkeyFlag

    • AllowComp

    • FkeyFlag

The POS Partner

  • Add YD StoreIDs to Galaxy for location mapping

  • Complete setup required on the Galaxy side to post sales data to YD's Fetch API

  • Set up the item import process

Yellow Dog

  • Create an API user for Galaxy

  • Provide the API credentials to Galaxy

  • Provide the StoreIDs to Galaxy for mapping

Data Exchange

Sales Data from POS

Galaxy posts sales data to Yellow Dog’s Fetch API Transactions endpoint in real time. Yellow Dog’s Process Sales application must run in order for sales to match to items, decrement inventory, and appear in sales reports.

Galaxy’s ProductCode matches to Yellow Dog’s SKU, and Galaxy maps their Agencies to Yellow Dog StoreIDs

We pull in the following sales data:

Modifiers

Modifiers are provided in sales data, and are tied to the item they modify. 

Item Data from Yellow Dog

Yellow Dog exports item data to a .csv file that is then consumed by Gateway.

Items

The following item data is exported from Yellow Dog and consumed by Galaxy:

Gateway PLU (YD SKU) Max length is 20 characters.

Interface Codes 

The following interface codes are used in Yellow Dog’s item export. Note that the Gateway values are provided by the customer and manually added to their Yellow Dog database as part of installation.

Workflows- Where Performed

Accounting Export:

This integration can only support net sales in accounting exports.

Limitations

  • Galaxy’s sales post to Yellow Dog’s API is currently retail focused and all refunds are assumed to be processed as returns to inventory.

  • Voids are supported only for an entire check and not for individual lines within a check.

    • These full-check voids are posted to Yellow Dog's API as new checks with negative quantities, so they appear as returns.

  • The items.csv file gets overwritten every time the sync runs.

  • Only supports items from one store to get pushed to one instance of Galaxy.