Overview
The interface with Northstar supports a 1-Way integration.
Sync Approach
North Star provides a daily sales file that the Yellow Dog sync will process to deplete inventory.
The sync can be installed at any location with access to the sales file location.
Sync Frequency
The sync will be scheduled to run one time per day.
Requirements
Client
TBD
POS Partner
Additional interface and annual maintenance fees may apply. Confirm all costs with your Northstar Sales Rep before executing a Yellow Dog Agreement.
Yellow Dog
List of all Northstar Revenue Center IDs matched to the store(s) in Yellow Dog.
Responsibilities
Client
Confirm which Revenue Center IDs from Northstar should be mapped to which Yellow Dog Stores
Select and configure how sales will be matched to items in Yellow Dog. Available methods depend on item type.
Regular items — choose one:
Match by UPC: The UPC in Northstar must match the item's YD SKU or UPC, and the Northstar sales file export must include the UPC Code column.
POS Item Map
Modifiers — must use POS Item Map (UPC matching isn't available for modifiers).
POS Partner
Provide the list of Revenue Center IDs for the site
Complete process to export the sales file to the designated folder location
Provide the sales export file path
Confirm whether the sales export file for the site includes the UPC Code column
Yellow Dog
TBD
Data Exchange and Mapping
Importing Sales Data
The following fields are provided in the .csv from Northstar:
| Northstar Field | Yellow Dog Field |
|---|---|
| Sale Date | N/A |
| Close Check Date/Time | CheckClosed |
| Adjusted Check | TBD |
| Adjusted Date | TBD |
| Revenue Center ID | Revenue Center Code |
| Check Number | Transaction Number |
| Menu Item Unique ID | Item Number |
| Menu Item Unique Name | Item |
| UPC Code | UPC Code for the menu item |
| Sold Count | Quantity |
| Total Sales | Item Retail (Total Sales/Sold Count) |
| Discounted Sales | Item Discount= (Discounted Sales / Sales Count) - (Total Sale / Sold Count) |
| Pos Category | None |
| Pos Category ID | None |
| Pos Sub Category | None |
| Pos Sub Category ID | None |
| Modifier ID 1-10 | Item Number for Modifiers |
| Modifier 1-10 | Item for Modifiers |
Additional Information
The integration with Northstar supports multiple Revenue Center codes per store.
Limitations
Currently we do not process the adjusted check and adjusted date fields.
UPC Codes for modifiers are not provided/supported; POS Item Mapping is required for modifiers in order to match sales to YD items
Implementation
All the Northstar Revenue Center IDs will need to be assigned as Revenue Center Codes in Yellow Dog before running the sync.
