Overview
The integration with eGrowcery supports a 2-way integration in which Yellow Dog pulls sales files and pushes item files to eGrowcery via a FTP location.
Sync Approach
This sync uses an FTP location, provided by eGrowcery to push item files and pull sales.
Sync Frequency
eGrowcery only picks up the item file and populates the sales file once per day between 1 and 5 am so the sync will need to by configured to run during that time.
If the sync is run more than once int he same day, the existing file will be replaced with the latest.
Configuration
eGrowcery will need to be configured to look at the IsActive flag to determine which items are active/inactive.
If you will also be using another integration connected to the same store in Yellow Dog that is connected with eGrowcery please consult your Implementation Guide as additional settings may need to be enabled for weighted items.
Requirements
Client
The client will need to provide the eGrowcery store name and tax levels being used to Yellow Dog.
POS Partner
eGrowcery will need to provide the FTP location and credentials where they will post daily sales files and where Yellow Dog will populate the item file.
Yellow Dog
Yellow Dog will need to create a Working Folder for the sync.
Data Exchange and Mapping
Sales Data
Yellow Dog pulls in the following sales data from eGrowcery:
| eGrowcery Field | Yellow Dog Field |
|---|---|
| Header_1, IdNumber | Transaction Number |
| PLUs_1, LineNumber | Transaction Line Number |
| Header_8, OrderCompleted | Check Closed |
| PLUs_3, UPC | Item Number |
| PLUs_4, Description | Item |
| If PLUs_9 (TaxExtn)=0 then PLU_5 (Sell); if PLUs_9< > 0 then (PLU10-PLU9)/PLU6 (LineExtn - TaxExtn)/Quantity | Item Retail |
| PLUs_6, Quantity | Quantity |
| Finalizer_2, PaymentType | Tender |
Item Data
| eGrowcery Field | Yellow Dog Field |
|---|---|
| UPC | UPC1, else SKU |
| Product Name | Web Properties Title, else Item Description |
| Product Description | Web Properties Short Description, else Item Description |
| Sell Price | Item Retail 1 |
| Cost Price | Calculated Cost |
| Special Price | Web Properties Sale Price |
| Is Active | Web Properties Send to Web, Active/Inactive, Removed/Not Removed |
| Tax Level 1 | Interface - eGrowcery Tax Level1 |
| Tax Level 2 | Interface - eGrowcery Tax Level2 |
| Tax Level 3 | Interface - eGrowcery Tax Level3 |
| Tax Level 4 | Interface - eGrowcery Tax Level4 |
| Tax Level 5 | Interface - eGrowcery Tax Level5 |
| Dept No | Level 1 Code |
| Dept Name | Level 1 Description |
| Sub Dept No | Level 2 Code |
| Sub Dept Name | Level 2 Description |
| Location | Bin |
| Active Date | Item Created Date |
| Last Sold | Most Recent TPTransaction.CheckClosed Date, else Item Created Date |
| Special Start Date | Web Properties Sale From |
| Special End Date | Web Properties SaleTo |
| Is Weighted | Interface - eGrowcery Is Weighted |
| Is Alcohol | Interface - eGrowcery Is Alochol |
| Is Tobacco | Interface - eGrowcery Is Tobacco |
System Codes
Yellow Dog pulls in the following Codes that create interface options in the AccountingOther section of Yellow Dog:
IsAlcohol Y/N
IsTobacco Y/N
isWeighted Y/N
Tax Levels
Additional Information
Limitations
eGrowcery has a separate FTP per location for the same site so separate syncs will need to be configured per eGrowcery location.
The integration does not allow for the the ability to push on hands.
eGrowcery does not provide returns or discount data in the sales files provided to Yellow Dog and therefore are not supported.
Due to the way that Item Retail is calculated potential rounding issues for weighted items are possible due to the decimal places used to divide the extended line item price.
