Resort Suite Interface
Updated July 2020 - Spring 2020 ResortSuite provided an enhanced sales export.
Overview
Our ResortSuite integration is a 2-Way interface through which Yellow Dog imports sales data and exports new and changed items to ResortSuite.
Sync Approach
Yellow Dog Inventory imports sales data via daily export files, and exports new and changed items to a text file that ResortSuite consumes.
The sync will need to be ran from a location that has access to the shared import/export folders.
Sync Frequency
Our sync application will be scheduled to run based on Resort Suite’s daily import/export.
If the Detailed Sales export is enabled, the sync can be configured to run multiple times a day. Otherwise it will be run once before the Resort Suite process to generate our export, and then once after their process to consume their sales files.
Configuration
A list of Pre-existing items must be provided to Yellow Dog during implementation in order to match items.
Requirements
Client
In order to have a detail sales file provided, the Client will need to be on v 7.4.70 of Resort Suite.
Otherwise by default, only a summary file will be provided.
POS Partner
Resort Suite is responsible for installing and scheduling their import/export. Yellow Dog will coordinate with Resort Suite to determine the appropriate daily sync schedules.
Resort Suite will also need to provide the file path(s) to pickup and drop off files and is responsible properly configuring the sales export to be detailed when applicable.
Yellow Dog
To ensure a clean sync, Yellow Dog requires the following information from Resort Suite:
A list of all
Revenue Center Codes
Division Codes
Department Codes
Taxability Codes
Responsibilities
Client
Ensure SKUs and UPCs do not have leading zeros.
POS Partner
TBD
Yellow Dog
TBD
Data Exchange and Mapping
Sales Data
If using v 7.4.70, ResortSuite can be configured to produce transaction level detail.
Here are the fields provided in a detailed transaction sales file:
| Resort Suite Field Position | Yellow Dog Field |
|---|---|
| Type | Item Number |
| Revenue Center ID | Revenue Center Number |
| DateTime | Transaction Date/Time |
| Transaction ID | Transaction Number |
| Transaction Line ID | Transaction Line Number |
| Item ID | Item Number |
| Quantity | Quantity Sold |
| Unit Retail | Item Retail |
| Unit Discount | Item Discount |
Other versions of ResortSuite only have the ability to provide a summary sales file. This fixed length sales file is per Revenue Center per day and the processing time may take up to 15 minutes.
Here are the fields provided in a summary sales file:
| Resort Suite Field Position | Yellow Dog Field |
|---|---|
| 1 | Item Number |
| 10 | Revenue Center Number |
| 13 | Transaction Date MMDDYYYY |
| 19 | Transaction Quantity |
| 28 | Total Retail |
| 43 | NLU (Not Used by YD Sync) |
| 55 | SKU/UPC |
Item Data
Yellow Dog exports the following item details to a fixed length file that Resort Suite’s import process consumes once per day:
| Resort Suite Field | Yellow Dog Field |
|---|---|
| JDS UPC/Last 9 digits of primary UPC | SKU |
| Retail Price | Retail Price |
| Full Description | Description |
| Division | Major Group |
| Department | Family Group |
| Taxability Code or Alt_Dept ID | Menu Item Class |
| Average Cost | Calculated Cost |
If an item is made inactive or removed in Yellow Dog, the SLU and barcodes for the item are replaced with a zero, making the item unsellable in ResortSuite.
System Codes
TBD
Additional Information
Limitations
Resort Suite’s Summary sales export does not include transaction details such as check closed date time, transaction numbers or discounts. Because this data is not provided, Yellow Dog is unable to provide transaction level reporting on Resort Suite sales unless the Detailed sales are provided.
Our codes are limited to the fixed lengths of the item export fields accepted by Resort Suite.
The Resort Suite import tool can only import 10k items and errors out if there are more than that on the file.
Additional Notes
Previously, Yellow Dog Software worked with a consultant who can build a more detailed sales export from ResortSuite. We recommend using this consultant for installations where the detailed sales files cannot be provided.
