Tips & Tricks: What settings needed to have my Items to update in Shopify?
In Version 370 of Yellow Dog updates were made to the Shopify Integration. In conjunction to these changes, there have been updates as to how Shopify items are configured in Yellow Dog.
Store Configuration
1. Yellow Dog stores require a Shopify Location ID set.
2. Sync Supports Shopify’s Multi-Location feature
a. push on hands to specific Shopify locations
b. Pull sales from specific Shopify locations
Yellow Dog Item Configuration -- Only Pushing On Hands Requirements
1. New items must have the Send to Web box checked to allow the sync to match the Shopify item and pull in the Shopify ID. (Items that existed at the time of the implementation will be matched by the Yellow Dog team)
2. Item must be available to the Web store
3. Item must be active
4. Item can not be removed
5. On Hand Adjustment in the last 180 days OR change to Web Item Properties in the last 7 days.
6. Item can not be POSBlocked
Sync Changes -- If pushing items
1. Ability to push Dimensions 4+ as tags
2. Ability to push Dimension 1,2, and/or 3 with items to Shopify.
3. Ability to match items Yellow Dog & Shopify items on different fields
a. SKU
b. Reference 1
c. Reference 2
d. Reference 3
e. Reference 4
4. Allow $0 Retail
a. Used if the site wants to be able to push in $0 retail prices.
5. Ability to Pull Shopify Codes (Collections) Sync Changes -- Sales Pull
1. Ability to pull Tender and Taxes
a. This data does not report anywhere in Yellow Dog. Used only for accounting integrations.
Sync Options:
1. Match Item Properties -- if pushing items
a. Used to assign item web properties (Tags, Types, etc) in Yellow Dog based on settings to matching items in Shopify.
b. This is meant to be used when items have been previously configured in Shopify and not in Yellow Dog.
Yellow Dog Item Configuration -- If pushing items
1. Images are now saved to the database vs cloud.
a. If switching to pushing items from Yellow Dog, Images need to be removed from Shopify BEFORE syncing. If you do not, the sync will create duplicate images and you won't know which one to delete.
2. Matrix Web Properties can now be Item Specific.
3. Web Placement can be set in the Matrix editor.
a. This allows the user to determine which item's image appears on the web page for the matrix.
Yellow Dog Item Web Properties Item Configuration -- if pushing items
1. Any items you want to push to Shopify will need to have the Send to Web option enabled in the Web Properties tab.
2. Product Types and Product Tags are now managed in Web Properties tab
a. Previously these were managed in Interfaces
b. Following an Upgrade and sync pull, use Match Item Properties to set these fields.
Yellow Dog Item Interfaces -- if pushing items
1. Shopify Collections are now set in AccountingOther - Shopify Collection 1-7.
a. Previously these were set as Generic Codes A-G
b. Following an Upgrade and sync pull, these settings must be set manually in Yellow Dog.
Related Articles
Yellow Dog/Shopify Integration Overview
This document will provide an overview of the Yellow Dog Shopify Integration Integration Approach This integration can be set up in 4 primary ways: 1Way - pull sales only 2Way – pull sales and push on hands 2Way – pull sales and push items and on ...Tips & Tricks: How do I update a large number of items at once?
Issue: Need to update the level/Vendor/Store assignment etc. of many items at once. Trick: This can be done via one of the many Right-Click Functions. Tip: Right-Click functions are dictated by permissions. If you cannot see the option, you are ...Tips & Tricks: Searching for Items
Finding your inventory item is easier than ever with the powerful search features on the Item Management \ Inventory Item screen. Tip 1: Use AND to match multiple terms Use AND to find items that include all the specified terms. Example: Steak AND ...Tips and Tricks: Removing Items with On-Hand Quantity (Decimal)
You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...How do I add tax to Shopify Items?
Yellow Dog has two methods of updating items in Shopify: The item gets created in Yellow Dog and pushed over to Shopify. The item gets created in Yellow Dog and in Shopify and just the on hand is updated when the sync runs. If you are pushing ...
Recent Articles
How To: Import Interfaces by Level using Balto
This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...How To: Update Par & Re-Order Points via the Balto Import Tool
This document will review how to update Par & Re-Order Points via the Balto import tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...How To: Update Items Store Availability via the Balto Import Tool
This article will review how to update items store availability with the Balto Import Tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...Yellow Dog/Jonas File Exchange Overview
This document will provide an overview of the Yellow Dog Jonas File Exchange Integration Integration Approach This is a 2Way integration – pull sales and push items • Sales – pulled from a file • Items – pushed to .csv file • Codes – Inserted into ...Yellow Dog/Jonas API Overview
This document will provide an overview of the Yellow Dog Jonas API Integration Integration Approach This can be set up as a 2Way – Items are pulled from us, and sales are pushed or 1Way sales are pushed. NOTE: Jonas controls the flow of sales and ...