How do I import item updates/changes into Yellow Dog?

How do I import item updates/changes into Yellow Dog?

Yellow Dog provides the ability to import items into the database. Using this feature must be done with extreme caution. If mistakes are made during the import process, and development is required to rectify those mistakes, there will be a labor charge to clean them up. There are import templates attached at the bottom of this article. This permission is typically only given to admin permission users, and if you do not have permission to see Import Data please see your onsite admin for additional permissions


Prior to importing: 

  • Unique Identifier: When updating existing items, you can use the Yellow Dog SKU or UPC if the item has one assigned as the unique identifier. A member of the Yellow Dog team will have to update the unique identifier column in your database prior to the import. Note: Importing prior to having Yellow Dog make the necessary changes to the database could result in a development assisted clean up.  CLICK HERE to request that update be made. *Note: The Yellow Dog helpdesk requires at least 24 hours’ notice to complete this* 
  • Because you are updating existing items, the only required columns are unique identifier and the field(s) you want to update. i.e. if you are importing updated vendor prices, the only required columns would be unique identifier, and default vendor price. 
  • If the fields you are importing are to update Level, Vendor or Dimension confirm they have been created in the system prior to importing and that spelling and caps match verbatim what is in Yellow Dog and what is in your import sheet. 
  • Review your data! Take time to review the data you want to import prior to importing. Address anything that seems incorrect prior to importing. 

Column Mapping:

·         Code vs Description-when mapping the vendor/manufacturer and level fields you will have the option of using the name/description of the level or vendor or the code that has been assigned.

     

 

·         When mapping level and vendor/manufacturer fields, you will want to ensure that the option for Description or Code(identifier) that is the option that is chosen.



Importing: 

  1. Navigate to System Setup and select Import Data: 



  1. Navigate to the three black dots to the right of Import File to navigate to the file on your computer that you are importing. *Note: the file will not populate if it is open on your computer while you are trying to import*




  1. Confirm the store(s) the updates will be imported for 



  1. You will now see the data in your file populate. 




  1. Right-Click in the Column headers to map your columns to the corresponding fields in Yellow Dog. Please see the attached import field Key for a full list of all the fields that cat ban be imported. 




  1. Map all columns that you want to import. 



  1. Select Import



  1. Confirm that you have checked all your column mapping 




  1. Wait for your items to import. *Note: the larger the file, and the more fields you are importing the longer it will take to process the data.* 

 



  1. Confirm your items are appearing with the appropriate updated fields. You may have to hit refresh data to see SKUs populate. 





    • Related Articles

    • How do I import brand new item data into Yellow Dog?

      Yellow Dog provides the ability to import items into the database. Using this feature must be done with extreme caution. If mistakes are made during the import process, and development is required to rectify those mistakes, there will be a labor ...
    • How do I import new parent/child items?

      Yellow Dog provides the ability to import items into the database. Using this feature must be done with extreme caution. If mistakes are made during the import process, and development is required to rectify those mistakes, there will be a labor ...
    • How do I import a manual sales entry?

      **At the bottom you can download a template to use for importing sales** Navigate to Manual Sales within Item Management  Select Import Records in the bottom right:  Select the three black dots to the far right of Import File to select the sales file ...
    • Yellow Dog Inventory Glossary

      Yellow Dog Glossary General Terminology · Database – is an organized collection of structured information, or data, typically stored electronically in a computer system · Server - a computer program or device that provides a service to another ...
    • What are Item Lists?

       Item Lists In Yellow Dog you have the ability to create and save items into Item Lists. These are handy to create if there are items that are frequently ordered together, you need to keep a barcode/SKU sheet by the register for items without ...
    • Recent Articles

    • Yellow Dog/Roller Integration Overview

      This document will provide an overview of the Yellow Dog Roller Integration Integration Approach This integration can be set up as a 2Way - Pull sales & Push items or a 1Way - Pull sales Sales – Pulled from Roller Webhook Codes – Pull from Roller API ...
    • Yellow Dog/Revel Integration Overview

      This document will provide an overview of the Yellow Dog Revel Integration Integration Approach This can be set up as a 2Way – Push items and Pull Sales or a 1Way – Pull Sales Sales – Pull from Revel Webhook Codes – Pull from Revel API Items – Push ...
    • Concessions Event Checklist

      This article provides a high level overview of the steps required to successfully run an event in Yellow Dog Inventory. This is intended for Concession clients who use the Stand Sheets module to manage events. Event Checklist Before the Event ✔ Step ...
    • How To: Log Into Stand Dog

      This article explains how to log in to the Stand Dog app. It is for concession clients who use the Stand Sheets module in Yellow Dog Inventory to manage events. Why It Matters: Stand Operators need access to the Stand Dog app to enter count-ins and ...
    • FAQs: Updating the Default Vendor

      Q: Why can’t I update the default vendor on the F&B Details or Retail Details tab? A: The ability to change the primary vendor on the F&B Details or Retails Details tab of the Item Editor after an item is saved was removed. Q: How do I update the ...