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

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

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

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