Overview

With our Shopify sync, Yellow Dog Inventory pulls sales data from and pushes on hand counts as well as new and changed item data to Shopify using Shopify's API. 

This sync can be scheduled to run at almost any interval, although by default, it will be run at the top of every hour during business hours.

Requirements

Yellow Dog Requirements

In order to use this sync to push item details, Yellow Dog requires a list of any current Shopify items and their details, including

  • SKUs
  • Titles
  • Descriptions (Short and Extended)
  • Product Types
  • Collections
  • Tags
  • Variants
  • Shipping Weights
  • Tax settings
  • Pictures

In order to use this sync to pull sales and push on hands only, Yellow Dog requires a list of any current Shopify items and their SKUs.

Back Office Setup Requirements

Shopify must be set up as detailed below:

Customers:

  1. Go to http://www.shopify.com/?ref=yellow-dog-software.
  2. Create a new account.
  3. Configure

YDI Implementation:

If starting from scratch:

  1. Go to https://app.shopify.com/services/partners.
  2. Log in.
  3. Click Dev Shops tab.
  4. Click "Create a new Dev Shop" in upper right-hand corner.
  5. Fill in information.
    • Spaces will be replaced by dashes in the URL (http://tiny-turtle-crystal-acres.myshopify.com). 

After store exists:

  1. Click Apps -> "private API keys" (at bottom)
  2. Click "Generate a new Private Key". Call it SyncYdiWithShopify.
  3. Launch SyncYdiWithShopify.exe.
  4. Configure SyncYdiWithShopify.exe.

Servers

The Shopify sync can be run from any location with access to the Shopify API and .Net 4.6.2 installed.

Data Exchange

SyncYdiWithShopify.exe is the scheduled application that syncs data between YDI and Shopify. 

Exporting Item Data

SyncYdiWithShopify can be used to push the following item details:

Shopify FieldYellow Dog Field
TitleMatrix Description, Web Properties Short Description, or Item Description
DescriptionWeb Properties Extended Description
Product TypeGeneric Level A
CollectionsGeneric Code A-G
TagsMatrix Notes or Item Notes
WeightShipping Weight
VendorVendor 1 Description
Product Variant OptionsDimensions 1-3
PriceItem Retail
SKUSKU
Barcode (limit 1)UPC1, else SKU
Tax OptionWeb Properties: Taxable
Inventory PolicyPush On Hands sync configuration
QuantityCurrent On Hand
PicturesImages (up to 3 per item)

Importing Sales Data

The following transaction data is pulled into Yellow Dog Inventory once the order has been fulfilled in Shopify:

  • created_at (date/time)
  • order_number (transaction number)
  • id (transaction line number)
  • sku
  • title (item description)
  • price (item retail)
  • quantity
  • discount_codes (discount description)
  • total_discounts (item discount)
  • taxes (as of sync v362, we are able to support multiple taxes per line item)
  • tenders (as of sync v362, we are able to support multiple tenders; the total of tender values per transaction will equal the total amount paid by the customer, including shipping, taxes, and discounts)
  • shipping charges (these appear as line item in Yellow Dog)

Importing Code Data

The following Shopify codes are pulled into Yellow Dog in order to populate our interface dropdowns, which can then be set per Store, Level, or Item:

  • Product Types
  • Collections

Additional Information

Troubleshooting

Please note that only fulfilled orders, or the fulfilled items from partially fulfilled orders will sync to Yellow Dog.