How To: Update Items Store Availability via the Balto Import Tool

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 any way. 

Prerequisites 

  1. Items are required to exist in YD already
  2. Items cannot be marked as removed. 
  3. The stores must also exist in YD
  4. Yellow Dog user with access to mobile 

Required Fields: 

  1. Item SKU: The SKU of the item that will be configured
  2. Store Code: Code of the store to be affected; the store must exist in YD already
  3. Is Available: True/False, true if the item should be made available to the store, false if the item should be removed from the store

Optional Fields: 

  1. Bin: Add an entry to the bin field for the item at the indicated store
  2. Reorder Point/ Par Level: Sets reorder/par amounts for the indicated item at the selected store.
    1. If child sizes need to have their own reorder/par levels, they also need to be included in the file—this import does not keep the child size par in sync with the parent size par/reorder point
    2. Par level must be equal to or higher than the reorder point
  3. Is Non Restock: Updates the size behavior for this item in the indicated store. Stands need to be enabled in the database for this field to work. 
  4. Max Capacity: Set a maximum capacity for the item; must be equal to or higher than the par level for the item
  5. Tariff Code: Sets a value in the tariff code field for the item, typically used with E-Commerce integrations

Step-by-Step Instructions: 

  1. Access Balto; Client ID and a user with access to Mobile are required  
         

2. Download the import template file
       


3. Configure file; all required fields should contain data.  NOTE: Do not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited at all!           

4. Choose the Add File option in Balto  
   

5. Click Submit
  1. The file will be processed successfully, or will fail
  2. If the file fails, see the entries below the failure message to see why the file has failed. Fix the data set. 


  1. Once the file has been corrected, click Clear, remove the file, add the file again, and re-submit
6. Once the file has been processed successfully, check the YD client to ensure items are appearing in the POS item map as expected. 

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

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

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

    • How do I make Items Inactive or Removed?

      This video will demonstrate how to make items inactive and removed  Removing or Inactivating Items Removed Items are items that you don’t plan on reselling or reordering. These should be removed from the system when the on hand reaches 0. Note: an ...

    • Recent Articles

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

    • Email Invoice Processing – Error response received when processing unsupported file type

      Yellow Dog Inventory Troubleshooting: Email Invoice Processing – Error response received when processing unsupported file type Issue: User received the following unsuccessful processing response when sending an invoice for invoice staging: “The ...

    • Feature Overview: Retail Price Fields

      Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...