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

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

Prerequisites 

  1. Items are required to exist in YD already
  2. Items cannot be marked as removed. 
  3. 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. Reorder Point/ Par Level: Sets reorder/par amounts for the indicated item at the selected store.
    1. If Base unit and additional sizes need to have Par/Re-Order points assigned then just the parent can be included, as the par levels will flow to the additional sizes based on the assigned relationship. NOTE: Importing for just a child size will not update the par levels for the base unit. 
    2. Par level must be equal to or higher than the reorder point

Optional Fields: 

  1. 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
  2. Bin: Add an entry to the bin field for the item at the indicated store
  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; it 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. 
   

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

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

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

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

    • How to create Stand-alone Sessions in Count XL

      This document will guide users through creating a session in Stand-alone Mode for Count XL 1. Once device is powered on swipe up from the bottom to see all the apps installed on the device. Navigate to Count XL and tap to open. 2. When the ...

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