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

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

                                                                                                                                                                                                                                                                                                                                                         
The Balto Import Tool lets users quickly bulk update the stores a group of items is available to

Before you begin, ensure the following:

  1. All items already exist in Yellow Dog (YD).
  2. Items are not marked as removed.
  3. All referenced stores already exist in YD.
  4. You have a Yellow Dog user account with Mobile access.
Required Fields: 
  1. Item SKU: The SKU of the item to configure.
  2. Store Code: The target store’s code. The store must already exist in YD.
  3. Is Available: True to make the item available at the store, or False to remove it from the store.
Optional Fields: 
  1. Bin: Adds a bin assignment for the item at the specified store.
  2. Reorder Point/ Par Level: Sets reorder and par quantities for the item.
    1.  Child sizes requiring their own par or reorder levels must be listed individually. The import does not sync par levels between parent and child sizes.
    2. Par Level must be greater than or equal to the Reorder Point
  3. Is Non Restock: Updates the size behavior for this item at the store. Stands must be enabled in the database for this field to apply.. 
  4. Max Capacity: Sets a maximum capacity. This value must be greater than or equal to the Par Level.
  5. Tariff Code: Sets the item’s tariff code, typically used for e-commerce integrations.

 
  1. Access Balto; Navigate to 'Item-Stores', click Configure &  Download the import template file.
  2. Configure the file. Ensure all required fields are complete.

Warning
Do not edit column headers in the import template. You may remove unused columns, but the remaining headers must stay unchanged.

      3.  In Balto, choose “Add File.”
      4.  Click Submit.
  1.  If the file processes successfully, verify the results in your YD client.
  2.  If the file fails, review the error entries below the failure message to identify the issue.
     5.  Fix any errors, then:
  1.  Click Clear.
  2.  Remove the file.
  3. Add the corrected file again.
  4. Re-submit.
  6. After successful processing, confirm in YD that the items store availability has updated as expected 


      Figure1: Example of how a failed import will appear in Balto




    • Related Articles

    • How To: Import Interfaces by Level using the Balto Import Tool

      The Balto Import Tool lets users quickly bulk assign item interfaces to levels in Yellow Dog (YD). Before running an import, make sure: All levels already exist in YD. The stores exist in YD. A ClientID and a Yellow Dog user account with access to ...

    • How To: Update Par & Re-Order Points via the Balto Import Tool

      The Balto Import Tool lets users quickly and efficiently bulk-update par levels and reorder points for items across stores Before you begin, make sure the following are true: The items already exist in Yellow Dog (YD). The items are not marked as ...

    • Feature Overview: Balto Web App

      Balto is a web-based tool from Yellow Dog that makes it easier for clients to manage and update their Yellow Dog Inventory. It provides a secure way to import, create, and update data in bulk, saving time and reducing manual entry. You can access ...

    • How To: Locate an Item with EPC Location

      End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT EPC Location turns a blind floor search into a guided one: pick the item you need, then follow a live signal straight to its RFID tag. Use it whenever you know what you’re looking for but not ...

    • How To: Add UPCs to Items with YD Mobile During Physical Inventory Counting

      If a barcode scan does not return an item, you must add the UPC to ensure accurate counts and smooth future physical inventories. You can add UPCs in the main Yellow Dog client or directly in the YDMobile app. YDMobile installed on your handheld ...

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

    • Feature Overview: Par & Re-Order Points

      Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...

    • How To: Install the Zebra ZD411 Printer Driver

      End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT When you install the correct driver, Windows can communicate with your Zebra ZD411 printer so it prints labels and tags reliably from Yellow Dog Inventory. Without the driver, the ZD411 will not ...

    • FAQs: What are Bins?

      End user · Yellow Dog Inventory 2026 Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. The Bin field is free text, so you can use letters or numbers. You don’t need to create bins in ...

    • Food and Beverage User Manual

      The Food & Beverage 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 system. Download ...