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

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

  • You have a Yellow Dog user account with Mobile access.

Required Fields

  • Item SKU: SKU of the item to configure.

  • Store Code: Code of the store to update. The store must already exist in YD.

  • Reorder Point / Par Level: Reorder and par values for the item in the specified store.

    • If both the base unit and child sizes require par/reorder points, you only need to include the parent SKU. Par levels will flow down to child sizes based on their size relationships.

    • Note: Importing a child size alone will not update par levels for the base unit.

    • The par level must be equal to or greater than the reorder point.

Optional Fields

  • Is Available (True/False): Sets whether the item is available in the store.

  • Bin: Sets the bin location for the item in the store.

  • Is Non-Restock: Updates the item’s size behavior. (Requires Stands to be enabled in the database.)

  • Max Capacity: Maximum quantity allowed. Must be equal to or greater than the par level.

  • Tariff Code: Sets a 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 Par & Re-Order points have updated as expected 

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



    • Related Articles

    • 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: All items already exist in Yellow Dog (YD). Items are not marked as removed. All referenced stores already exist ...

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

    • 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: Update the Count XL application

      CountXL updates include new features and bug fixes. To ensure the best performance, update the app to the latest version before each use. A Google Play Store login <br> On your Android device, open the Google Play Store. You can ...

    • How To: Issue and Accept Transfers in YD Mobile

      End user · Yellow Dog Inventory 2026 WHY IT'S IMPORTANT Transfers move inventory items from one store to another. In YD Mobile, the sending store issues the transfer and the receiving store accepts it. Completing both halves keeps on-hand quantities ...

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