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 To: Update Par & Re-Order Points via the Balto Import Tool

      This document will review how to update Par & Re-Order Points via 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 ...

    • How To: Update Retail Prices using Balto

      Using the Balto to update Retail Prices streamlines bulk updates, saving time and reducing manual entry mistakes. All clients types can utilize Balto. Items are required to exist in YD already Items cannot be marked as removed. The stores must also ...

    • How To: Import Interfaces by Level using Balto

      This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...

    • Adding UPCs to Items with YD Mobile During Physical Inventory Counting

      If an item is not found after scanning the barcode, it is important to add the UPC to the item to ensure counts are completed correctly and future physicals run smoothly. Video: 1. Open and log in to YD Mobile. Do NOT close or log out of Count XL. 2. ...

    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...

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