Foreup 2-Way Integration
Last Updated 10/26/2023
Overview
Our foreUp 2-way integration pulls sales data from ForeUp and pushes in new or changed items.
In this integration, Yellow Dog is the source of record for item creation and item updates.
Sync Approach
Our sync consists of 3 main elements that uses foreUp’s API to pull sales, pull codes and push items.
Sync Frequency
This interface can be scheduled to process sales and push items at a time and frequency of your choosing.
Requirements
Client
The client will need to match Course IDs to each location in Yellow Dog. The client will also need to authorize the Yellow Dog integration in the ForeUp App Store.
POS Partner
Course IDs, Tax Codes and Percentages for each location in Yellow dog must be provided.
Responsibilities
POS Partner
TBD
Client
Configure Item Tax Rate and GL Codes in the interfaces tab in order to push to those fields in foreUp.
Data Exchange
Pushing Item Data
| foreUP Field | Yellow Dog Field |
|---|---|
| UPC# (ItemNumber) | SKU |
| Unit Price | Retail Price |
| Name | Description |
| Department | Level 1 |
| Category | Level 2 |
| SubCategory | Level 3 |
| Quantity | Store on Hand |
| Unit Cost | Default Vendor Price |
| Unit Price Excludes Tax | Interface |
| Item Type | Hardcode Item Type |
| Reorder Level | Reorder Point |
| UPCs | UPCs |
| Active | Active/Inactive |
| Tax Rate | Interface |
| GL Code | GL Code |
Pulling Sales Data
| foreUP Field | Yellow Dog Field |
|---|---|
| SaleTime | CheckClosed |
| ID | Item Number |
| Attributes | SKU |
| Name | Item |
| UnitPrice | Item Retail |
| Discount Percent | DiscountDescription |
| Quantity | Quantity |
| EmployeeID | EmployeeNumber |
| SaleID | TransactionNumber |
| TerminalID | RegisterNumber |
System Codes
We get the following static code types when pulling codes from foreUp
foreUp unit Price includes Tax
foreUp unlimited
foreUp Tax
Additional Information
Limitations
Matrix items are treated as individual items as there is no item grouping in foreUp.
The ability to push items is limited to Retail products only. FB menu item pushing is not supported.
This integration does not support matching on pre-existing items. In order to push, items will need to be new.
To push GL Codes, the Item must have the Inventory Account assigned in interfaces.
To push Tax Rates, the Item must have the Tax Rate assigned in interfaces.
