Overview

GEMpos integrates with Yellow Dog’s Fetch API to pull store data for mapping to GEMpos stores, post interface codes, pull items, and post sales data.

Sync Approach

This integration involves 2 main elements:

  • GEMpos’ processes to get data from and post data to Yellow Dog’s Fetch API

    • To pull store data 

    • To post interface codes

    • To pull item data on an hourly basis

    • To post sales data daily

  • Yellow Dog’s ProcessSales application to match sales to items, adjust on hands, calculate costs, and update reports

Sync Frequency

GEMpos pulls item data from Yellow Dog’s Fetch API hourly, and also on demand.

GEMpos posts sales data to Yellow Dog’s Fetch API daily.

Yellow Dog processes sales after the daily sales post from GEMpos.

Configuration Options:

Multiple instances of GEMpos against a single Yellow Dog database are supported in this integration.

Multiple GEMpos locations against a single Yellow Dog store are NOT supported in this integration.

Pre-existing items in GEMpos are not innately supported by this integration; GEMpos will have to determine how to handle that on a case by case basis.

Requirements

Client:

  • Ensure that store mapping is correct

  • Ensure that items have been configured properly to be pulled in to GEMpos

Yellow Dog:

  • Provide the API User login and ClientID for the database to GEMpos

POS:

  • Assist customer as needed with mapping YD Stores to locations in GEMpos

  • Post interfaces to YD via thirdpartycodes endpoint

  • Provide instructions for customer on interface mapping

  • Setup and schedule process to pull item data from YD via items endpoint

  • Setup and schedule process to post sales data to YD via items endpoint

Data Exchange

Sales Data from POS

GEMpos posts sales once a day to Yellow Dog’s Fetch API.

  • If there are ever sales that were missed, GEMpos will need to post/re-post their sales data for the day(s) missing sales.

Yellow Dog Stores are mapped to GEMpos Stores/Locations in GEMpos.

Sales are mapped to Yellow Dog Items via Yellow Dog’s ItemID, which is pulled in by GEMpos.

GEMpos posts the following sales data to Yellow Dog’s Fetch API:

Modifiers are not supported for this integration as it is focused on Retail and not F&B.

Item Data from Yellow Dog 

GEMpos posts the following interface codes to Yellow Dog’s Fetch API:

Yellow Dog Item to POS Mapping is not used in this integration.

No known SKU or UPC Limitations.

GEMpos pulls the following Item Data from Yellow Dog’s Fetch API:


Workflows - Where Performed

Accounting Export : 

Supports Total Net Sales

Limitations

  • Pre-existing items in the POS is not innately supported; GEMpos says they can take this on a case by case basis but they don't have any specific plan or process in place

  • Currently GEMpos is pulling all item data each time they sync items and NOT relying on our lastUpdated

  • The GEMpos feature that allows different locatons to share pricing should not be used with a YD integration.

  • This integrations is focused on retail, not F&B, and therefore was not designed to work as a one-way integration.

  • Although GEMpos does have the ability to support priced modifiers, this integration will remain retail focused and not deal with modifiers.