Overview

With our two-way integration, Yellow Dog uses Magento’s API to create new items, update item changes, update on hand counts, pull codes and process orders to update sales and reduce on hands.

Sync Approach

Yellow Dog uses SyncYDIWithMicroServices and Magento’s API to update the item properties and process orders.

Sync Frequency

Typically the sync is configured to run hourly.

Requirements

Client

TBD

POS Partner

TBD


Yellow Dog

The following are needed from Magento:

  • URL (main URL for the Customer’s Mageno Site)

  • Access Token

  • Store View Codes

  • Max number of Categories that will be assigned to a product

Responsbilities

Client

The client will need to determine if they want the following set up

  • Push Cost (Default Vendor Price in Yellow Dog)

  • Push On Hands (Options are No, Store only, Total on Hand All Stores)

The client will need to export all pre-existing items in Magento they want matched in Yellow Dog. There might be additional setup and configuration needed to match items. Please consult your Implementation Guide.

POS Partner

TBD

Yellow Dog

TBD

Data Exchange

Sales

The following fields are pulled into Yellow Dog from Magento:

Magento FieldYellow Dog Field
Order DateCheckClosed
Magento's Product IDItemNumber
SKUSKU
Product NameItem
Originial PriceItem Retail
Discount Amount (divided by quantity)Item Discount
"Microservice_MagentoSales"Source
Order IDTransaction Number
Refund or Cancelled Order DesignationReference

Items

The following item details are pushed to Magento:

Magento FieldYellow Dog Field
SKUSKU
Product NameWebItem.Title, else Item.Description
Short DescriptionWeb Properties Short Description
DescriptionWeb Properties Extended Descripton
PriceItem Retail
CostDefault Vendor Cost
LengthLength
WidthWidth
HeightHeight
WeightWeight
ImagesPictures
Image Roles
QuantityOn Hands - By Store or Total
Stock StatusWe set this to "In Stock" when On Hand > 0, and "Out of Stock" when On Hand < 0
Enable ProductOnce we have pushed an item to Magento, if it is ever made inactive/removed/unavailable/sendtoweb=false in YD, we disable it in Magento
SizeDimension 1
ColorDimesnion 2
Attribute SetMAgento Attribute Sets (Required)
CategoriesMagento Category [x]
Tax ClassMagento Tax Class
VisibilityMagento Visibility

Codes

The following are the codes pulled in from Magento’s API:

Magento FieldYellow Dog Field
Magento Attribute SetsVaries based on client
Magento Category [x]The number of Magento Category dropdowns is based on the API Sync Config detting
Magento Tax Class
MAgento Visibility

Limitations

  1. Multiple Magento instances against a single Yellow Dog Database is not currently supported.

  2. All returns will have the same CheckClosed date as the original sale

  3. All refunds are treated the same and will return the items to stock

  4. Magento does not provide line item detail for taxes on returns; our code does additional work to break this out that may result in rounding discrepancies in some cases

  5. We push attribute sets for item but we do not push attributes themselves except for Size and Color.

Implementation

  • Yellow Dog SKUs must match any pre-existing Magento SKUs

  • Dimension descriptions for sizes and colors in Yellow Dog must match exactly with the size and color descriptions in Magento.