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

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 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: Every item will need to have a unique identifier assigned in the spreadsheet. The identifier does not have to relevant to Yellow Dog. In this example we used YDTest001, YDTest002, YDTest003, etc   
  • Confirm your file is in a CSV format not an excel file
  • Confirm the levels/departments you want your items to be in have been created in Yellow Dog
  • Confirm the vendors that be assigning to your items have been created in Yellow Dog. (Spelling, upper/lowercase must 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 items 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. Once the import is complete Select Update Item SKUs in the bottom right. *Note: This feature is an additional permission to Import Data*



  1. Confirm your items are appearing in Yellow Dog with SKUs. You may have to hit refresh data to see SKUs populate. *Note: In some cases, maintenance will have to run over night for SKUs to populate*





    • Related Articles

    • 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 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 ...
    • New Feature! Item Attributes

      Item Attributes are user defined fields that are used to configure certain item properties that will be used in reporting, label making or in conjunction with Third Party Integrations. When configured under Common Setup, these attributes will be made ...
    • 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 ...
    • 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/Spot On(Appetize) Integration Overview

      The document will provide an overview of the Yellow Dog Spot On(Appetize) integration Integration Approach The integration between Yellow Dog and Spot On (Appetize) can be configured to be a 1Way (sales pull only) or 2Way (sales pull and item push) ...
    • Yellow Dog/InfoGenesis Integration Overview

      The document will provide an overview of the Yellow Dog InfoGenesis Integration Integration Approach This integration can be setup as a 1Way (Sales Pull Only) or a 2Way (Pull Sales & Push Items) Sales – pulled in from a .txt file provided by ...
    • 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 ...
    • Yellow Dog/Simpony2 w/Oracle Integration Overview

      This document will provide an overview of the Yellow Dog /Simphony 2Way integration Integration Approach The Yellow Dog/Simphony integration is a 2Way integration Sales – pulled in from files provided by Oracle once per day Codes – pulled from the ...
    • Yellow Dog/NCR Silver Integration Overview

      This document will provide an overview of the Yellow Dog/NCR Silver integration Integration Overview The Yellow Dog/NCR Silver integration is a 2Way integration Sales – Pulled from the NCR API Codes For reporting codes are pulled from the NCR API For ...