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. . *
- 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:
- Navigate to System Setup and select Import Data:
- 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*
- Confirm the store(s) the updates will be imported for
- You will now see the data in your file populate.
- 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.
- Map all columns that you want to import.
- Select Import
- Confirm that you have checked all your column mapping
- 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.*
- Confirm your items are appearing with the appropriate updated fields. You may have to hit refresh data to see SKUs populate.
Related Articles
Feature Overview: Calculated Cost
Calculated cost in Yellow Dog Inventory is critically important because it serves as the foundation for financial accuracy and operational decision-making in inventory management. You’ll find the calculated cost of an item in many areas of Yellow ...How do I create Inventory Accounts(GL Codes) and assign them to items?
Creating inventory accounts and assigning them to items: **You will need permissions to access System Setup & Interfaces for this task. ** 1. 1. Navigate to Accounts under System Setup and select Inventory Accounts: 2. Select Create new Accounting ...FAQs: Why do inventory systems use calculated cost in reporting?
Q: Why do inventory systems use calculated cost in reporting? A: Inventory systems like Yellow Dog use calculated cost in reporting (determined by your selected calculated cost method) to simplify inventory valuation and reduce the impact of ...FAQs: FIFO Calculated Cost Method
The calculated cost method FIFO (First In, First Out) is one of the available calculated cost methods in Yellow Dog Inventory. It’s important to choose the best calculated cost method for your business to ensure accurate, consistent, and ...FAQs: Weighted Average Cost Calculated Cost Method
The calculated cost method Weighted Average Cost is one of the available calculated cost methods in Yellow Dog Inventory. It’s important to choose the best calculated cost method for your business to ensure accurate, consistent, and audit-compliant ...
Popular Articles
How To: Find Your Yellow Dog Inventory Version
Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...How do I use Par & Re-Order Points?
What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...Tips & Tricks: How do I download and install drivers for my Zebra Printer?
**As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...How To: Swap the On-Hand/Parent Size (Edit Base Unit)
When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...Food and Beverage Core Features User Manual
The Food & Beverage Core Functions User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory ...