The interface with Concept is a two-way integration via a file exchange using .csv files.
Yellow Dog Inventory will import sales and code data from Concept.
Yellow Dog Inventory will export new and changed item data to Concept.
This integration contains two elements:
- From Yellow Dog, a sync application which will
- Provide an output file of any new/changed items,
- Process sales files provided by Concept,
- Process code files provided by Concept.
- From Concept, an import/export process that will
- Process the item file produced by Yellow Dog's sync, which will add or edit those items in Concept,
- Generate a sales export file,
- Generate Concept code files.
Both the Yellow Dog and Concept sync applications can be run at any frequency, but will be scheduled to run hourly during business hours by default.
Yellow Dog will need the following for Concept:
A starting number range for new item numbers; note that Concept requires an 8-digit number.
All data on pre-existing Concept items, including Number, Family, Warehouse, Name, Search Group, Sales Price 1, Discount Condition, Tax, Unit, Observation, Control Stock, Situation, UPC, and Sale Group.
An agreed upon FTP location accessible by both sides will need to be created.
Yellow Dog's sync application requires can run from any location that can access the FTP folder, and has .Net 4.6.2 installed.
Concept is responsible for all setup, configuration, and scheduling of their import/export process.
Concept requires their API V.204.
Exporting Item Data
Yellow Dog exports the following item data to Concept:
|Concept Field Name||Yellow Dog Field|
|Number (8 Digits)||Item Number|
|Search Group||Concept Search Group|
|Sales Price 1||Retail 1|
|Discount Condition||Concept Discount|
|VAT Inc 1||Concept Tax|
|Quantity Stock||On Hand|
|Control Stock||Count/No Count status|
|Barcode (no limit)||UPCs, else SKU|
|Sale Group||Concept Sale Group|
Importing Sales Data
Yellow Dog imports the following sales data from Concept:
- Revenue Center
- Transaction Number
- Check Closed DateTime
- Employee ID
- Item Number
- Retail Price
Importing Code Data
Concept provides separate files with codes and descriptions for the following Concept settings:
- Warehouse (Revenue Center)
- Sales Group
- Search Group
Each of the two elements will be implemented separately by Yellow Dog and Concept.
Each side will support their portion of the interface.