Overview

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.

Sync Approach

This integration contains two elements:

  1. 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.
  2. 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.

Sync Frequency

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.

Requirements

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.

Prerequisites

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.

Data Exchange

Exporting Item Data

Yellow Dog exports the following item data to Concept:

Concept Field NameYellow Dog Field
Number (8 Digits)Item Number
FamilyConcept Family
WarehouseRevenue Center
NameItem Description
Search GroupConcept Search Group
Sales Price 1Retail 1
Discount ConditionConcept Discount
VAT Inc 1Concept Tax
UnitConcept Unit
Quantity StockOn Hand
Control StockCount/No Count status
SituationActive/Inactive status
Barcode (no limit)UPCs, else SKU
Sale GroupConcept Sale Group

Importing Sales Data

Yellow Dog imports the following sales data from Concept:

  • Revenue Center
  • Transaction Number
  • Check Closed DateTime
  • Employee ID
  • Tender
  • Item Number
  • Quantity
  • Retail Price
  • Discount

Importing Code Data

Concept provides separate files with codes and descriptions for the following Concept settings:

  • Warehouse (Revenue Center)
  • Family
  • Sales Group
  • Search Group
  • Units
  • Color
  • Size
  • Tax 

Implementation

Each of the two elements will be implemented separately by Yellow Dog and Concept.

Additional Information

Support

Each side will support their portion of the interface.