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

    • 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 Retail Prices using the Balto Import Tool

      The Balto Import Tool lets users quickly bulk update items retail prices Before beginning, ensure the following: Items already exist in Yellow Dog (YD). Items are not marked as Removed. The store exists in YD. You have a Yellow Dog user account with ...

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

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

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

    • What are Bins and how can I use them?

      Bins are supplemental location markers. Unlike flags they do not have to be created prior to assigning them to items and are primarily used in in the stores tab to identify more precisely where an item is located. They can also be used in Physicals ...