Club Caddie 1-Way Integration
Last Updated 3/6/2023
Overview
Yellow Dog's 1-way interface with Club Caddie pulls sales data to reduce inventory based on transactions.
Sync Approach
Yellow Dog Inventory will pull sales from a .csv file on a provided SFTP server using our Sales Sync application. The Yellow Dog Sales Sync application can be configured to run from anywhere that has access to the sales file exports.
Sync Frequency
Club Caddie will provide a daily export of sales data that Yellow Dog will then consume and process.
Requirements
POS Partner
Club Caddie will need to configure the sales file export and set up their export service.
Yellow Dog
Yellow Dog will provide a FTP location for Club Caddie to drop off files. Yellow Dog will schedule the Sales File Application.
Yellow Dog will configure the Revenue Center = ‘1’.
Responsibilities
Client
The Client will be responsible for mapping recipes and inventory items to items sold at the POS.
Data Exchange and Mapping
Sales Data
The following sales data is provided in the export from Club Caddie and will be mapped to the corresponding fields in Yellow Dog.
| Club Caddie Field | Yellow Dog Field |
|---|---|
| Item Number | Item Number |
| SKU | SKU |
| Item Description | Item Description |
| Quantity Sold | Quantity Sold |
| Unit Retail | Unit Retail |
| Unit Discount | Unit Discount |
| Check Closed | Check Closed |
| Transaction Number | Transaction Number |
| Line Number | Line Number |
| Revenue Center | Revenue Center |
| Discount Description | Discount Description |
| Register Name | Register Name |
| Register Number | Register Number |
| Employee Number | Employee Number |
| Employee Name | Employee Name |
Additional Information
Club Caddie operates on the basis of a single inventory location (Revenue Center) with multiple "Terminal Locations" (Registers)
Limitation
Club Caddie does not provide Tender in their sales export
Club Caddie only provides SKU in their export file when SKU has been set in Club Caddie
Unsold Items are not available for mapping
