Sales Vu 2-Way Integration
Last Updated 7/8/2022
Overview
With our Sales Vu integration we are able to pull sales data and push new or changed items using their API.
Sync Approach
Yellow Dog uses SyncwithMicrosServices to pull Sales Data and Push Items via Sales Vu’s API.
Sync Frequency
This interface can be scheduled to process sales and push items at a time and frequency of your choosing by default this will be set to hourly.
Requirements
Client
The Client will need to provide Yellow Dog with the following:
Sales VU store Ids to map to the store(s) in Yellow Dog
API key per SalesVU store Id
List of Categories that do not currently exist in SalesVu that will need to be created
List of Tax Brackets (Name and Percentage)
POS Partner
None at this time
Yellow Dog
For any images that need to be pushed over to SalesVU, Yellow Dog requires image URLs.
Responsibilities
Client
In order for items to push to Sales Vu the item must:
Have Publish=”Yes”
Available to the store
Active
Yellow Dog
Yellow Dog will need to set up the Auth API account.
Data Exchange and Mapping
Codes Pull
| SalesVu Field | Yellow Dog Field |
|---|---|
| Category | SalesVu Category (Interface) |
| Tax Bracket | SalesVu Tax Bracket) |
Sales Data
| SalesVu Field | Yellow Dog Field |
|---|---|
| OrderId | TransactionNumber |
| N/A | TransactionLineNumber |
| orderUpdatedAt | CheckClosed |
| N/A | ItemId |
| orderLine["product_id"] | Item |
| basePrice | ItemRetail |
| discountAmount | ItemDiscount |
| quantity | Quantity |
| orderLine["employee_id"] | EmployeeNumber |
| N/A | Reference (we populate "Deleted" when voided) |
| pos_id | RegisterNumber |
| N/A | ParentNumber |
Item Data
| SalesVu Field | Yellow Dog Field |
|---|---|
| Name | POS Description 1 |
| Description | Web Properties Short Description, else Item Description |
| Selling Price | Retail 1 |
| Price Type | "Fixed" |
| Category | Sales Vu Category (Interface) |
| Type | "Sellable" |
| Inventory Setting | "Track this item..." if either PushStoreOnHand or PushTotalOnHand is set to true; "Do not track this item..." if both of those settings are false |
| Unit | "Each" |
| Tax Bracket | SalesVu Tax Bracket |
| UPC Code | UPCs; 2-5 |
| SKU | UPC 1 |
| Image | The first Picture assigned to the item that has an Image URL |
| Cost Price | Default Vendor Price |
| Status | Active |
System Codes
Additional Information
This integration does not support mapping a single Yellow Dog store to multiple SalesVu since each store requires it’s own unique Sales Vu API key.
Limitations
Cost only updates in SalesVu is there is a positive adjustment
Changing the Inventory Unit in SalesVu will cause the integration to error
Discount Description and Tender are not available to be pulled from the SalesVu API
SalesVu can support up to 5 UPCs.
Images in the SalesVu interface may look distorted but when viewed using the Image URL appear as expected.
Other Notes
Yellow Dog Software will support the interface and will assist with any API issues.
SalesVU provides return qty as a positive amount, but a negative retail amount. Therefore this type of transaction in Yellow Dog will deplete inventory but retail will be negative.
