Overview

Book4Time consumes the Yellow Dog API for a 2-way integration.  This integration allows Book4Time to receive new or changed items from as well as post sales transactions to the Yellow Dog Inventory system.

Download the Book4Time Setup Guide here.

Sync Approach

Book4Time pulls new items and item edits from Yellow Dog and pushes transaction data to Yellow Dog. The push and pull of data is broken up into two separate Book4Time services run on a user defined schedule. 

Sync Frequency 

The Push and Pull of data by Book4Time is scheduled to run once each per day, at a time determined during implementation. The sync can also be run manually. 

Requirements

Prerequisites

The minimum version of Yellow Dog Inventory must be v362 or higher. 

Book4Time will release a version containing this ability in July 2018.

Data Exchange

Book4Time controls the push of all data transmission via Yellow Dog’s API. 

  1. If transaction are not posted for any reason, Book4Time allows the end user to initiate a push of the missing transactions.

  2. Voids are not sent to Yellow Dog. Only returns.

  3. If there are multiple stores, the interface settings must be the same for each store.

Below are the corresponding data fields. 

Book4Time Field NameYellow Dog Field
Data TypeVendors (Vendor Maintenance)
Vendor NameVendor Description
Vendor NotesVendor Notes
Account NumberVendor Code
Data TypeProducts - Product Profile tab (Product Maintenance)
ClassGeneric Level A
SubClassGeneric Level B
Active SKUThis Item is Active
SKU TypeGeneric Code B
SKU NamePOSDescription 1
Extended DescriptionLong Description
SKU#SKU
Retail PriceDefault Retail
Unit CostDefault Vendor Price
BrandGeneric Code A
DepartmentGeneric Code C
Data TypeProducts - Location Default tab (Product Maintenance)
StockStore Available
Available at POSGeneric Code B
Current on HandStore on Hand
Data TypeProducts - UPC Codes tab (Product Maintenance)
UPC NumberUPCs
Data TypeVProducts - Product SKUs tab (Product Maintenance)
Vendor SKUVendor SKU
VendorVendor Code

 

 

Additional Information

Limitations

  1. There is a limit of 20 characters (alphanumeric) for the SKU.

  2. There is a limit of 30 characters (alphanumeric) for the UPC.

  3. SKU basically refers to the ItemID. The actual ItemID in Book4Time is similar to to the same in YDI.

  4. The transaction portion of the sync only pulls the last 24 hours or transactions.

  5. If transaction are not posted for any reason, Book4Time allows the end user to initiate a push of the missing transactions.

  6. Voids are not sent to Yellow Dog. Only returns.

  7. If there are multiple stores, you must use the same interface settings as Book4Time only respects one set of interface codes for an item.