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:
- 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.